Hello guys After update to 7 0 0 database crashing after sim

Question

Hello guys After update to 7 0 0 database crashing after simple query like `SELECT FROM history P4v WHERE devid = LLLAHFZHYA LATEST ON ts PARTITION BY address` Details in thread

Bartosz · Answer

Here is my log ```2023 02 25T13 10 27 479419Z I i q g SqlCompiler plan q=`select choose devid address value value decimal created at ts from select devid address value value decimal created at ts from history P4v where devid = LLLAHFZHYA latest on ts partition by address ` fd=2220 2023 02 25T13 10 27 490227Z I i q c h p JsonQueryProcessorState 2220 execute new skip 0 stop 1000 2023 02 25T13 10 27 490353Z C i q c h p JsonQueryProcessorState 2220 Uh oh Error java lang NullPointerException at io questdb griffin engine table AbstractDataFrameRecordCursor getSymbolTable AbstractDataFrameRecordCursor java 76 at io questdb griffin engine table AbstractDataFrameRecordCursor getSymbolTable AbstractDataFrameRecordCursor java 37 at io questdb griffin engine functions columns SymbolColumn init SymbolColumn java 91 at io questdb griffin engine functions eq EqSymStrFunctionFactory$ConstSymIntCheckFunc init EqSymStrFunctionFactory java 165 at io questdb griffin engine table LatestByAllFilteredRecordCursor of LatestByAllFilteredRecordCursor java 74 at io questdb griffin engine table AbstractTreeSetRecordCursorFactory getCursorInstance AbstractTreeSetRecordCursorFactory java 61 at io questdb griffin engine table AbstractDataFrameRecordCursorFactory getCursor AbstractDataFrameRecordCursorFactory java 57 at io questdb griffin engine table LatestByAllFilteredRecordCursorFactory getCursor LatestByAllFilteredRecordCursorFactory java 42 at io questdb cutlass http processors JsonQueryProcessorState of JsonQueryProcessorState java 814 at io questdb cutlass http processors JsonQueryProcessorState of JsonQueryProcessorState java 800 at io questdb cutlass http processors JsonQueryProcessor executeSelect JsonQueryProcessor java 546 at io questdb cutlass http processors JsonQueryProcessor executeNewSelect JsonQueryProcessor java 532 at io questdb cutlass http processors JsonQueryProcessor compileQuery JsonQueryProcessor java 421 at io questdb cutlass http processors JsonQueryProcessor execute0 JsonQueryProcessor java 184 at io questdb cutlass http processors JsonQueryProcessor onRequestComplete JsonQueryProcessor java 234 at io questdb cutlass http HttpConnectionContext handleClientRecv HttpConnectionContext java 600 at io questdb cutlass http HttpConnectionContext handleClientOperation HttpConnectionContext java 203 at io questdb cutlass http HttpServer$1 lambda$$0 HttpServer java 86 at io questdb network AbstractIODispatcher processIOQueue AbstractIODispatcher java 178 at io questdb cutlass http HttpServer$1 run HttpServer java 101 at io questdb mp Worker run Worker java 118 2023 02 25T13 10 27 490553Z I i q c h HttpConnectionContext kicked out fd=2220 2023 02 25T13 10 27 490565Z I http server scheduling disconnect fd=2220 reason=5 2023 02 25T13 10 27 490679Z I http server disconnected ip=127 0 0 1 fd=2220 src=queue ```

Bartosz · Answer

Database schema ```CREATE TABLE history P4v devid SYMBOL address SHORT value SHORT value decimal BYTE created at DATE ts TIMESTAMP timestamp ts PARTITION BY DAY ```

Bartosz · Answer

Sample data

Matt · Answer

Try this ``` SELECT FROM history P4v WHERE devid = LLLAHFZHYA LATEST ON ts PARTITION BY address` ```

Matt · Answer

Seems like a bug to me but if adding the parens is all you need as a workaround then you ll be OK

Matt · Answer

But these give distinctly different results So that workaround may not be ideal

Nicolas Hourcard · Answer

Hi < Bartosz> thanks for reporting this would you be able to open an issue on GH as well we will look into this

Bartosz · Answer

< Nicolas Hourcard> ready

Bartosz · Answer

< Matt> thank you for your answer but i m busy with workaround over 2 days so your sugestion is already tested slightly smiling face