Error 500 on CROSS JOIN query #6256
Description
To reproduce
CREATE TABLE tango (ts TIMESTAMP);
SELECT ts + x
FROM tango CROSS JOIN (SELECT x FROM long_sequence(1))
ORDER BY x;i.q.g.e.QueryProgress err [id=-1, sql=`SELECT ts + x
FROM tango CROSS JOIN (SELECT x FROM long_sequence(1))
ORDER BY x`, principal=admin, cache=false, jit=true, time=1193000, exception=
java.lang.NullPointerException: Cannot invoke "io.questdb.griffin.model.QueryModel.getAliasToColumnMap()" because "innerVirtualModel" is null
at io.questdb.griffin.SqlOptimiser.doReplaceLiteral0(SqlOptimiser.java:1861)
at io.questdb.griffin.SqlOptimiser.doReplaceLiteral(SqlOptimiser.java:1809)
at io.questdb.griffin.SqlOptimiser.replaceLiteral(SqlOptimiser.java:4128)
at io.questdb.griffin.SqlOptimiser.emitLiterals(SqlOptimiser.java:2075)
at io.questdb.griffin.SqlOptimiser.rewriteOrderBy(SqlOptimiser.java:4798)
at io.questdb.griffin.SqlOptimiser.optimise(SqlOptimiser.java:7159)
at io.questdb.griffin.SqlCompilerImpl.compileExecutionModel0(SqlCompilerImpl.java:2408)
at io.questdb.griffin.SqlCompilerImpl.compileExecutionModel(SqlCompilerImpl.java:2396)
at io.questdb.griffin.SqlCompilerImpl.compileUsingModel(SqlCompilerImpl.java:3111)
at io.questdb.griffin.SqlCompilerImpl.compileInner(SqlCompilerImpl.java:2498)
at io.questdb.griffin.SqlCompilerImpl.compile(SqlCompilerImpl.java:356)
at io.questdb.cairo.pool.SqlCompilerPool$C.compile(SqlCompilerPool.java:141)
at io.questdb.cutlass.http.processors.JsonQueryProcessor.compileAndExecuteQuery(JsonQueryProcessor.java:504)
at io.questdb.cutlass.http.processors.JsonQueryProcessor.execute0(JsonQueryProcessor.java:215)
at io.questdb.cutlass.http.processors.JsonQueryProcessor.onRequestComplete(JsonQueryProcessor.java:292)
at io.questdb.cutlass.http.HttpConnectionContext.handleClientRecv(HttpConnectionContext.java:907)
at io.questdb.cutlass.http.HttpConnectionContext.handleClientOperation(HttpConnectionContext.java:307)
at io.questdb.cutlass.http.HttpServer.handleClientOperation(HttpServer.java:342)
at io.questdb.cutlass.http.HttpServer$1.lambda$$0(HttpServer.java:129)
at io.questdb.network.AbstractIODispatcher.processIOQueue(AbstractIODispatcher.java:220)
at io.questdb.cutlass.http.HttpServer$1.run(HttpServer.java:133)
at io.questdb.mp.Worker.run(Worker.java:152)
]
QuestDB version:
master