Jaromir Hamala

another failure, Linux-other. Logs: https://gist.github.com/jerrinot/0c892b1edd9c7e397a65f3cd7ce5594a

@Sibsankar01 Why are you copying an existing issue? This issue is a carbon copy of an already [existing issue](https://github.com/questdb/questdb/issues/4591), down to the timestamps in the log snippet: The already existing...

there is another similar-looking problem, likely it has the same root cause: ``` trips WHERE rate_code_id = ( SELECT rate_code_id FROM trips ORDER BY pickup_datetime DESC LIMIT 1 )::symbol ```...

Hi @InJoDave, are you still interested in tackling this issue? If so I have some tips for you: The [`rewriteJsonExtractCast()` function](https://github.com/questdb/questdb/blob/47306daafe49a1a9f05aacf0f93caa85fce6f053/core/src/main/java/io/questdb/griffin/SqlParser.java#L3531) has a potential null pointer exception when handling certain...

hi @krlmlr, pretending QuestDB is Redshift is an excellent idea, thanks for that! I'll give it a try later today and will post my update here.

Some additional thoughts/ideas: When starting QuestDB, during the recovery process, it could check if the next transaction can be applied. If not, it could provide hints on what to do,...

an unrelated failure, fixed by https://github.com/questdb/questdb/pull/5758

grammar PR: https://github.com/questdb/sql-grammar/pull/47

@bluestreak01: about year units: we would need to adjust for leap years. for each master row. instead of using the same constant for all rows as we do now. do...

@bluestreak01 TOLERANCE does not support months either. For the same reason. See supported units: https://github.com/questdb/questdb/blob/87117b6611cb0cd8ecdbb049606c21b5c23c79d0/core/src/main/java/io/questdb/griffin/SqlCodeGenerator.java#L771-L794 (=no month and no year) I took the list of units from [SAMPLE BY](https://github.com/questdb/questdb/blob/4c031694c5041b4ff805defb5d5bc57a8271e7ba/core/src/main/java/io/questdb/griffin/engine/groupby/TimestampSamplerFactory.java#L90-L123), but...