Jaromir Hamala

Another failure: https://dev.azure.com/questdb/questdb/_build/results?buildId=9232&view=ms.vss-test-web.build-test-results-tab&runId=60856&resultId=102146&paneView=debug Interestingly enough there are the same _actual_ values as observed by @ideoma: ``` java.lang.AssertionError: expected: but was: ``` This was on OSX x64

hello @jttmtv, this looks like a good entry point: https://github.com/questdb/questdb/blob/8442ddb97dc0be09e29dea40892ffdadc8b2705d/core/src/main/java/io/questdb/griffin/SqlCompiler.java#L2575 it seems the magic is happening here: https://github.com/questdb/questdb/blob/6eca37b8f27bb1d51efc6cd8e68199ef2bd57b82/core/src/main/java/io/questdb/griffin/engine/table/TableListRecordCursorFactory.java#L97-L110 and last but not least: The `ShowTablesTest` will help you to get...

fwiw: this is a possible workaround `select * from all_tables order by table;` or simply `all_tables order by table;`

~Please don't merge it yet, there is allocation going on due to auto-boxing. thanks to Vlad for spotting it!~ edit: boxing is gone.

@puzpuzpuz I agree with everything you wrote! I will change the format to return tuples and later send a separate PR to enable metrics by default.

@puzpuzpuz can you please re-check?

I can see weather0 and weather1 writers are returned to the pool: ``` 2022-07-22T10:45:21.4523986Z 2022-07-22T10:45:21.385137Z I i.q.c.l.t.LineTcpMeasurementScheduler releasing writer, its been idle since 2022-07-22T10:45:21.016000Z[tableName=weather0] 2022-07-22T10:45:21.4525173Z 2022-07-22T10:45:21.385150Z I i.q.c.p.WriterPool [table=`weather2`, thread=3548]...

another test failure: https://dev.azure.com/questdb/questdb/_build/results?buildId=9873&view=ms.vss-test-web.build-test-results-tab&runId=77124&resultId=100667&paneView=debug

Sorry, there is a typo. The key is supposed to be -1. It's failing with that.

Do you think it should throw an exception when you try to insert noValueKey? Seems like easy to make a mistake to me and hard to diagnose. It'd cost one...