questdb/questdb issues and pull requests

#5171 - perf(sql): introduce fast paths for parallel keyed group by

Pull Request - State: open - Opened by puzpuzpuz 2 days ago - 1 comment
Labels: SQL, DO NOT MERGE, Performance

#5170 - fix(sql): fix comparison error of `rowsLow` and `RowsHigh` in window function range frame.

Pull Request - State: open - Opened by kafka1991 3 days ago

#5169 - Could not mmap and subsequent crash on simple query

Issue - State: open - Opened by peterklingelhofer 3 days ago - 1 comment

#5168 - fix(core): fix metadata queries returning stale data in tables() and table_columns() functions after table drop concurrent with column add

Pull Request - State: closed - Opened by ideoma 4 days ago - 1 comment
Labels: Bug, Core

#5167 - Support scalarFunction over windowFunction.

Issue - State: open - Opened by kafka1991 4 days ago - 1 comment
Labels: New feature

#5166 - fix(sql): breaking change 💥 - `dateadd(AIN)` will now error if provided invalid constant period or stride

Pull Request - State: open - Opened by nwoolmer 4 days ago - 3 comments
Labels: SQL

#5165 - Flaky DedupTest.dedup/varchar_dedup.test

Issue - State: open - Opened by puzpuzpuz 4 days ago
Labels: Schrödinger's bug

#5164 - CASE cannot find columns with timestamp conditions

Issue - State: open - Opened by javier 5 days ago

#5163 - chore(core): increase min WAL apply worker pool size to 2

Pull Request - State: closed - Opened by puzpuzpuz 5 days ago - 1 comment

#5162 - fix(pgwire): sending wide records over a smaller send buffer

Pull Request - State: open - Opened by eugenels 5 days ago

#5161 - fix(sql): cross join queries not cancelling when circuit breaker is invoked

Pull Request - State: closed - Opened by nwoolmer 6 days ago - 1 comment
Labels: Bug, SQL

#5160 - chore(core): fix code not executing as expected with asserts disabled

Pull Request - State: closed - Opened by ideoma 6 days ago - 1 comment

#5159 - chore(sql): two-phase execution of `create table` and `drop` SQLs

Pull Request - State: open - Opened by bluestreak01 7 days ago - 1 comment

#5158 - test(core): fix fuzz drop partition test to not fail when running with drop/recreate fuzz step in parallel

Pull Request - State: closed - Opened by ideoma 7 days ago

#5157 - feat(sql): add timezone-aware variant of dateadd

Pull Request - State: open - Opened by abant07 7 days ago - 2 comments
Labels: SQL

#5156 - feat(sql): Add common hash functions such as md5, sha1 and sha256

Pull Request - State: open - Opened by mliezun 7 days ago - 3 comments

#5155 - Add quoted spread

Issue - State: closed - Opened by alexandrebrilhante 8 days ago - 3 comments
Labels: New feature

#5154 - chore(core): fix partition drop failures found by fuzz tests

Pull Request - State: closed - Opened by ideoma 8 days ago - 1 comment

#5153 - feat(sql): add count(*), count(D), count(Ø), count(K) window function.

Pull Request - State: open - Opened by kafka1991 8 days ago
Labels: Enhancement, SQL

#5152 - perf(sql): introduce fast path for ordered and limited queries over single long column

Pull Request - State: open - Opened by puzpuzpuz 11 days ago - 2 comments
Labels: SQL, Performance

#5151 - java.lang.NullPointerException Cannot read field "writer" because "e" is null

Issue - State: open - Opened by simplyrahul1 11 days ago - 5 comments
Labels: Bug, ILP

#5150 - Incorrect results returned from group by query with 32-bit key

Issue - State: open - Opened by puzpuzpuz 11 days ago
Labels: Bug, SQL

#5149 - test(core): partially disabled `Files.testIsDirOrSoftLinkDir` test on Windows

Pull Request - State: closed - Opened by bluestreak01 11 days ago

#5148 - perf(sql): improve performance of queries with negative limits and existing order by clauses

Pull Request - State: open - Opened by nwoolmer 12 days ago - 4 comments
Labels: SQL, Performance

#5147 - Redash support

Issue - State: open - Opened by nwoolmer 12 days ago
Labels: New feature, Postgres Wire, Compatibility

#5146 - Support for AWS Graviton instances

Issue - State: open - Opened by matyasberry 12 days ago - 3 comments
Labels: New feature

#5145 - Support for unsigned data types

Issue - State: open - Opened by jmont-dev 12 days ago
Labels: New feature

#5144 - fix(core): fix table disappear after restart if created with the naming collisions

Pull Request - State: closed - Opened by ideoma 13 days ago - 1 comment

#5143 - fix(sql): add better error message when sample by fill type is mismatched

Pull Request - State: open - Opened by nwoolmer 13 days ago - 3 comments
Labels: Bug, SQL

#5142 - chore(core): fix cookie parse to process attributes in case-insensitive way

Pull Request - State: closed - Opened by bluestreak01 13 days ago - 1 comment

#5141 - Index files stay on disk after the index was dropped

Issue - State: open - Opened by puzpuzpuz 14 days ago
Labels: Bug, Core

#5140 - feat(sql): add FORCE DROP partition SQL syntax, useful to unblock suspended WAL tables

Pull Request - State: closed - Opened by ideoma 14 days ago - 4 comments

#5139 - perf(sql): speed up negative limit queries with a wildcard

Pull Request - State: closed - Opened by nwoolmer 14 days ago - 1 comment
Labels: SQL, Performance

#5138 - optimising negative limit queries with existing order by clauses

Issue - State: open - Opened by nwoolmer 14 days ago
Labels: SQL, Performance, Friction

#5137 - chore(core): fix mixup of 401 and 403

Pull Request - State: closed - Opened by glasstiger 14 days ago - 4 comments

#5136 - chore(core): fixed Files.isDirOrSoftLinkDir behaviour to not list directory

Pull Request - State: closed - Opened by amunra 14 days ago - 2 comments

#5135 - perf(sql): use faster hash table in window functions

Pull Request - State: closed - Opened by puzpuzpuz 15 days ago - 3 comments
Labels: SQL, Performance

#5134 - fix(ilp): Java ILP client supports timestamps up to 9999-12-31 23:59:59.999999

Pull Request - State: closed - Opened by jerrinot 15 days ago - 1 comment
Labels: Bug, ILP

#5133 - chore(sql): add index support for parquet partitions

Pull Request - State: open - Opened by puzpuzpuz 15 days ago

#5132 - fix(core): fix drop partition SQL not removing the expected partition data and in some rare circumstances leading to a data loss

Pull Request - State: closed - Opened by mtopolnik 15 days ago - 1 comment
Labels: Enhancement, Core

#5131 - Adding index to a column prevents filtering with that column if other non-indexed queries are present in the query

Issue - State: open - Opened by megakoresh 15 days ago - 2 comments

#5130 - Separate HTTP settings for ILP over HTTP

Issue - State: closed - Opened by ntippman 18 days ago - 3 comments

#5129 - Connection to superset failed

Issue - State: open - Opened by Kiwami-Zhang 18 days ago - 1 comment

#5128 - feat(sql): support for `_` in SQL integer constants and human-friendly configuration values for time intervals in `server.conf`

Pull Request - State: closed - Opened by bluestreak01 18 days ago - 1 comment

#5127 - perf(core): optimize StringSink buffer reuse - garbage elimination

Pull Request - State: closed - Opened by jerrinot 19 days ago - 1 comment
Labels: Performance

#5126 - fix(sql): ensure replicas pick up table-level DDLs in their metadata caches

Pull Request - State: closed - Opened by glasstiger 19 days ago - 1 comment

#5125 - feat(sql): introduce volume-weighted average price function `vwap(price, volume)`

Pull Request - State: closed - Opened by nwoolmer 19 days ago - 1 comment
Labels: SQL

#5124 - docker-compose issue with inserting data into WAL tables

Issue - State: open - Opened by nwoolmer 19 days ago - 1 comment

#5123 - float type column cannot be updated

Issue - State: closed - Opened by superichmann 19 days ago - 1 comment
Labels: SQL

#5122 - Windows distributions should use .zip instead of .tar.gz

Issue - State: open - Opened by jerrinot 19 days ago
Labels: Enhancement, Compatibility, Friction

#5121 - [bug] dateadd does not fail when passed an invalid period unit

Issue - State: open - Opened by javier 19 days ago
Labels: SQL, Friction, Bug 0

#5120 - feat(sql): implement deduplication for Parquet partitions

Pull Request - State: open - Opened by eugenels 19 days ago

#5119 - fix(core): fix http client handling of cookies

Pull Request - State: closed - Opened by bluestreak01 19 days ago - 1 comment
Labels: tandem

#5118 - feat(sql): introduce latency configuration to ensure small batch commit visibility is upheld

Pull Request - State: closed - Opened by bluestreak01 20 days ago - 1 comment
Labels: SQL, Core

#5117 - Support dots in column name

Issue - State: open - Opened by Kronos3 20 days ago - 3 comments
Labels: New feature, ILP, Core

#5116 - unsafe memory access in async filter during filtered update query

Issue - State: open - Opened by nwoolmer 21 days ago
Labels: Bug, SQL

#5115 - perf(core): replace unconditional txn sync with a conditional one. 10x improvement of ingress perf for small transactions

Pull Request - State: closed - Opened by bluestreak01 21 days ago - 1 comment
Labels: Performance, Postgres Wire, ILP

#5114 - Add an optional timezone parameter to `dateadd`.

Issue - State: open - Opened by peter-facko 21 days ago - 5 comments
Labels: New feature, SQL

#5113 - fix(sql): fix rewrite `sample by` to `group by` same column names' bug.

Pull Request - State: open - Opened by kafka1991 21 days ago
Labels: Bug, SQL

#5112 - chore(sql): revise places where table-level DDLs are applied to the metadata cache

Pull Request - State: closed - Opened by nwoolmer 22 days ago - 1 comment
Labels: SQL, tandem

#5111 - fix(sql): BREAKING 💥 - align common column names across multiple catalogue views

Pull Request - State: open - Opened by bluestreak01 22 days ago - 2 comments
Labels: SQL

#5110 - chore(sql): simplify group-by SQL assembly

Pull Request - State: closed - Opened by bluestreak01 24 days ago - 1 comment
Labels: SQL

#5109 - fix(sql): fix incorrect error message out of `table_storage` function when selecting non-existing column

Pull Request - State: closed - Opened by bluestreak01 25 days ago - 1 comment

#5108 - feat(http): make healthcheck endpoint responsive on high CPU load

Pull Request - State: closed - Opened by ideoma 25 days ago - 1 comment

#5107 - Still cannot start on FreeBSD

Issue - State: open - Opened by Peter2121 25 days ago - 5 comments
Labels: Won't fix

#5106 - fix(sql): cap `string_agg()` memory use to the "strFunctionMaxBufferLength" value

Pull Request - State: closed - Opened by bluestreak01 25 days ago - 1 comment
Labels: SQL

#5105 - Last column is dropped when query includes an inline addition and a sample by.

Issue - State: open - Opened by jiteshvassa 26 days ago - 3 comments
Labels: Bug

#5104 - build: 8.1.4

Pull Request - State: closed - Opened by bluestreak01 27 days ago

#5103 - ci(build): fix ci release pipeline draft url parsing

Pull Request - State: closed - Opened by ideoma 27 days ago - 1 comment

#5102 - Added timezone variant to fix #5041

Pull Request - State: closed - Opened by santpandey 27 days ago - 1 comment

#5101 - chore(ui): bump web console

Pull Request - State: closed - Opened by bluestreak01 27 days ago - 1 comment

#5100 - test(core): fix fuzz test setup / by zero exception

Pull Request - State: closed - Opened by jerrinot 27 days ago

#5099 - fix(pgwire): fix a spurios errors after table schema change

Pull Request - State: closed - Opened by jerrinot 27 days ago - 1 comment

#5098 - A function returning symbol integer representation.

Issue - State: closed - Opened by peter-facko 27 days ago - 5 comments
Labels: New feature, SQL

#5097 - fix(sql): avoid returning symbol indexes when performing arithmetic on symbols

Pull Request - State: closed - Opened by nwoolmer 27 days ago - 1 comment
Labels: Bug, SQL, DO NOT MERGE

#5096 - Casting SYMBOL to INT doesn't work, returns NULL.

Issue - State: open - Opened by peter-facko 27 days ago - 4 comments
Labels: Bug

#5095 - test(core): fix fuzz test setup / by zero exception

Pull Request - State: closed - Opened by ideoma 27 days ago

#5094 - Fix for OOM logging is badly formatted #4806

Pull Request - State: closed - Opened by shubh07sx 27 days ago - 4 comments

#5093 - fix(core): fix rare crash on read binary and other var length column types

Pull Request - State: closed - Opened by ideoma 28 days ago - 1 comment
Labels: Bug, Core

#5092 - chore(sql): more precise version of regr_slope

Pull Request - State: closed - Opened by nwoolmer 28 days ago - 6 comments
Labels: SQL

#5091 - fix(core): fix checkpoint backward compatibility with snapshot semantics

Pull Request - State: closed - Opened by ideoma 28 days ago - 1 comment

#5090 - fix(core): fix rare failure to restore from checkpoint, triggered by indexed column being created while checkpoint in progress

Pull Request - State: closed - Opened by bluestreak01 28 days ago - 1 comment
Labels: Bug, Core

GitHub / questdb/questdb issues and pull requests