Alex Pelagenko

SQL: push UNION result filters into each part

2

### Is your feature request related to a problem? Union used to push filters into the sub queries but it was abandoned in 6.4.2 because the tables can have different...

Postger copatibility - DBeaver schema query fails

1

### Describe the bug _No response_ ### To reproduce ``` SELECT t.oid,t.*,c.relkind,format_type(nullif(t.typbasetype, 0), t.typtypmod) as base_type_name, d.description FROM pg_catalog.pg_type t LEFT OUTER JOIN pg_catalog.pg_type et ON et.oid=t.typelem LEFT OUTER JOIN...

Flaky test testVectorSumAvgDoubleRndColumnWithNullsParallel

1

### Describe the bug ``` java.lang.AssertionError: expected: but was: ``` ### To reproduce Reproducible on OSX ARM and x64 ### Environment ```markdown - **QuestDB version**: 6.3 ```

feat(core): make DB more stable by checking OS file and map limits on startup and SELECTs

1

Inspired by https://github.com/questdb/rfc/discussions/63 On Linux check `vm.max_map_count` and open file limit on process startup. If below configured counts fail to start ``` # Switch to enable / disable checks against...

feat(core): more efficient allocation strategy to reduce RAM pressure

9

This allows to set maximum RSS Memory Limit in QuestDB. Limit is also set automatically by default to prevent oversized off-heap allocations killing the process. ``` # Max memory limit...

SQL: `select * trades` should be parse error

12

### Describe the bug _No response_ ### To reproduce 1. go to (demo)[https://demo.questdb.io/] 2. query `select * trades`. Note of missing `FROM` keyword One row with 1 returned ### Expected...

SQL: Join Column Type Mismatch

21

### Describe the bug When 2 tables joined on INT and LONG columns error shown that there is join column mismatch ### To reproduce ``` select x, y from long_sequence(100)...

### Describe the bug Equals function for geohash and string may return TRUE on rows where string cannot be converted to geohash ### To reproduce ``` create table s as...

### Is your feature request related to a problem? Sometime it's useful to see the difference between the event timestamp and the timestamp it is got written in QuestDB. To...

feat(core): support new WAL-based method of writing data to tables

5

WAL tables will not be production ready after this PR. This is a first cut of functionality, the solved list: - a job which can apply WAL data to tables...