questdb

questdb copied to clipboard

### To reproduce Continuation of #4825 This query ```sql WITH first_selection as ( SELECT pair, first(rate) AS open, last(rate) AS close, min(rate) AS low, max(rate) AS high, sum(volume_a) AS base_volume,...

puzpuzpuz

Pg query fails with global RSS memory limit exceeded

1

### To reproduce 1. Download QuestDB latest 2. Install on ubuntu Ubuntu 24.04 LTS with 32gb of memory. 3. Create a table with 400 rows - 100 symbols and 300...

superichmann

### To reproduce If you try to execute a query where the `LATEST ON` timestamp parameter is in brackets, the parser goes crazy. For example, the query below does not...

javier

npgsql bind timestamp parameter parsing error

1

### To reproduce 1. Download QDB Latest 2. Run QDB 3. Create Table - run this on QDB ``` CREATE TABLE 'qdbug' ( timestamp TIMESTAMP, lags INT, 'table' SYMBOL capacity...

superichmann

Postgres VALUES syntax for temporary tables with hardcoded values

1

### Is your feature request related to a problem? I have a query in which I would like to use a temporary table with hardcoded values. Currently, I do this...

peeterburger

ORDER BY in timestamp_sequence() doubles distance between timestamps

3

### To reproduce 1. Go to https://demo.questdb.io/ 2. Paste the following query ```SQL select timestamp_sequence('2022-01-01', 1000000L) as ts from long_sequence(5) order by ts ``` 3. Run the query ### QuestDB...

peeterburger

SAMPLE ... FROM ... TO in demo example throws "expected single letter qualifier"

2

### To reproduce 1. Go to https://questdb.io/docs/reference/sql/sample-by/#from-to 2. Click on "Demo this query" 3. Select and run the query Alternatively, click on https://demo.questdb.io/?query=SELECT%20pickup_datetime%20as%20t%2C%20count%0AFROM%20trips%0ASAMPLE%20BY%201d%20FROM%20%272008-12-28%27%20TO%20%272009-01-05%27%20FILL(NULL)&executeQuery=true ### QuestDB version: 8.1.0 ### OS, in...

peeterburger

Float columns change inserted data for some numbers

1

### To reproduce When inserting certain numbers into a float column, the number saves inaccurately. ```sql CREATE TABLE IF NOT EXISTS test ( A FLOAT, B DOUBLE ); INSERT INTO...

oz-brg

Closes: https://github.com/questdb/questdb/issues/4905 If you upload a CSV such as this: ``` a,b,c 1,a,2 ``` With schema: `(a LONG, b SYMBOL, c LONG)` You instead get a table with schema: `(f0...

nwoolmer

### To reproduce Take this CSV: ``` "a","b","c" 1,"a",2 ``` Upload via web console. Set schema: Observe result: ~EDIT: After further investigation, schema doesn't seem to be sent with the...

nwoolmer