Siddharth Agarwal

### To reproduce 1. `create table y ( x int, ts timestamp) timestamp(ts)` 2. `create table y1 ( x int, ts timestamp) timestamp(ts)` 3. `create table y2 ( x int,...

Flaky Test ServerMainFlushQueryCacheTest.testFlushQueryCache

2

### To reproduce Build : https://dev.azure.com/questdb/questdb/_build/results?buildId=93730&view=logs&s=b1ea3234-5a2e-5e99-b54b-09a630ee02b3&j=d09f5293-c9fd-59aa-4afb-b3372a468ff9 ``` 2024-06-15T21:10:33.967644Z E i.q.t.TestListener ***** Test Failed *****io.questdb.test.PropServerConfigurationTest.testImportWorkRootCantBeTheSameAsOtherInstanceDirectories2 duration_ms=0 : org.junit.AssumptionViolatedException: got: , expected: is at org.junit.Assume.assumeThat(Assume.java:106) at org.junit.Assume.assumeTrue(Assume.java:50) at io.questdb.test.PropServerConfigurationTest.testImportWorkRootCantBeTheSameAsOtherInstanceDirectories2(PropServerConfigurationTest.java:695) at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)...

Flaky Test TableNameRegistryTest.testConcurrentCreateDropRemove

1

### To reproduce testConcurrentCreateDropRemove(io.questdb.test.cairo.TableNameRegistryTest) Time elapsed: 3.013 sec

ISSUE#5647 - LIMIT and ORDER BY pushdown in ASOF queries

1

This issue will resolve #5647 For a query like ``` trades ASOF JOIN order_book order by trades.price desc LIMIT 5 ``` It will create a query model which will look...