Bolek Ziobrowski

### Describe the bug min(int) and min(long) return null if input contains only max values and nulls . ### To reproduce ```sql create table testl( l long ); insert into...

### Describe the bug sum() and avg() aggregates work for date and timestamp types only if : - there is no group by key - there is exactly one key...

slow limit -N queries without order by ts queries

3

### Describe the bug Looks like in latest release queries that use limit -N without explicit order by issued against tables with designated timestamp traverse partitions from first to last...

Column resolution fails in complex join conditions

1

### Describe the bug If query contains a with clause qdb sometimes fails to resolve columns in complex expressions . Column is properly resolved if it's accessed directly , not...

### Describe the bug When (inner or outer) joining tables using equality operator like ```sql select * from tabA join tabB on expr1 = expr2 ``` expressions are ignored and...

Web console doesn't always highlight correct error position

1

### Describe the bug For some SQLs web console doesn't mark proper error position returned by backend . ### To reproduce 1. Open web console 2. Execute `select * from...

Update O3 documentation

1

We've to update O3 documentation and explicitly state that we DON'T support O3 for non-partitioned tables . If O3 doesn't make sense for such tables then maybe we should force...

**Bug description:** Site search doesn't find all term usages, making documenation less useful . For example searching for http.min.enabled yields no results but it should return https://questdb.io/docs/reference/configuration/ at least ....

fix(sql): reduce memory utilization of cursor factories

1

This PR pushes most native memory allocations from factories to cursors . Instead of being kept all the time (e.g. when factory is in cache), they're released on cursor.close() and...

Escape mechanism doesn't work in like/ilike functions

14

### Describe the bug Like and ilike functions don't recognize default escape character '\\' nor allow using a different one via ESCAPE clause . ### To reproduce ```sql SELECT '\quest'...