Skip to content

AssertionError at FilteredRecordCursorFactory.java #6762

@YuanchengJiang

Description

@YuanchengJiang

To reproduce

SELECT 
    T1.event, 
    T1.origin, 
    CASE WHEN T1.event > 50 THEN 'High' ELSE 'Low' END 
FROM telemetry T1 
INNER JOIN telemetry T2 ON T1.created < T2.created 
WHERE (cast(T1.origin as SYMBOL)) IS NULL AND NOW() = NOW() 
ORDER BY (cast(T1.origin as SYMBOL)) NOT IN ('{}') 
LIMIT NULL;
2026-02-09T13:46:03.161178Z C i.q.c.h.p.JsonQueryProcessorState [1093069874965] internal error [ex=java.lang.AssertionError
	at io.questdb.griffin.engine.table.FilteredRecordCursorFactory.<init>(FilteredRecordCursorFactory.java:44)
	at io.questdb.griffin.SqlCodeGenerator.generateJoins(SqlCodeGenerator.java:4194)
	at io.questdb.griffin.SqlCodeGenerator.generateSelect(SqlCodeGenerator.java:5344)
	at io.questdb.griffin.SqlCodeGenerator.generateQuery0(SqlCodeGenerator.java:4839)
	at io.questdb.griffin.SqlCodeGenerator.generateQuery(SqlCodeGenerator.java:4814)
	at io.questdb.griffin.SqlCodeGenerator.generateSubQuery(SqlCodeGenerator.java:6851)
	at io.questdb.griffin.SqlCodeGenerator.generateSelectChoose(SqlCodeGenerator.java:5358)
	at io.questdb.griffin.SqlCodeGenerator.generateSelect(SqlCodeGenerator.java:5335)
	at io.questdb.griffin.SqlCodeGenerator.generateQuery0(SqlCodeGenerator.java:4839)
	at io.questdb.griffin.SqlCodeGenerator.generateQuery(SqlCodeGenerator.java:4814)
	at io.questdb.griffin.SqlCodeGenerator.generateSubQuery(SqlCodeGenerator.java:6851)
	at io.questdb.griffin.SqlCodeGenerator.generateSelectVirtual(SqlCodeGenerator.java:5991)
	at io.questdb.griffin.SqlCodeGenerator.generateSelect(SqlCodeGenerator.java:5337)
	at io.questdb.griffin.SqlCodeGenerator.generateQuery0(SqlCodeGenerator.java:4839)
	at io.questdb.griffin.SqlCodeGenerator.generateQuery(SqlCodeGenerator.java:4814)
	at io.questdb.griffin.SqlCodeGenerator.generateSubQuery(SqlCodeGenerator.java:6851)
	at io.questdb.griffin.SqlCodeGenerator.generateSelectChoose(SqlCodeGenerator.java:5358)
	at io.questdb.griffin.SqlCodeGenerator.generateSelect(SqlCodeGenerator.java:5335)
	at io.questdb.griffin.SqlCodeGenerator.generateQuery0(SqlCodeGenerator.java:4839)
	at io.questdb.griffin.SqlCodeGenerator.generateQuery(SqlCodeGenerator.java:4814)
	at io.questdb.griffin.SqlCodeGenerator.generate(SqlCodeGenerator.java:682)
	at io.questdb.griffin.SqlCompilerImpl.generateSelectOneShot(SqlCompilerImpl.java:4862)
	at io.questdb.griffin.SqlCompilerImpl.generateSelectWithRetries(SqlCompilerImpl.java:545)
	at io.questdb.griffin.SqlCompilerImpl.compileUsingModel(SqlCompilerImpl.java:3473)
	at io.questdb.griffin.SqlCompilerImpl.compileInner(SqlCompilerImpl.java:2830)
	at io.questdb.griffin.SqlCompilerImpl.compile(SqlCompilerImpl.java:414)
	at io.questdb.cairo.pool.SqlCompilerPool$C.compile(SqlCompilerPool.java:145)
	at io.questdb.cutlass.http.processors.JsonQueryProcessor.compileAndExecuteQuery(JsonQueryProcessor.java:493)
	at io.questdb.cutlass.http.processors.JsonQueryProcessor.execute0(JsonQueryProcessor.java:219)
	at io.questdb.cutlass.http.processors.JsonQueryProcessor.onRequestComplete(JsonQueryProcessor.java:309)
	at io.questdb.cutlass.http.HttpConnectionContext.handleClientRecv(HttpConnectionContext.java:985)
	at io.questdb.cutlass.http.HttpConnectionContext.handleClientOperation(HttpConnectionContext.java:323)
	at io.questdb.cutlass.http.HttpServer.handleClientOperation(HttpServer.java:350)
	at io.questdb.cutlass.http.HttpServer$1.lambda$$0(HttpServer.java:114)
	at io.questdb.network.AbstractIODispatcher.processIOQueue(AbstractIODispatcher.java:224)
	at io.questdb.cutlass.http.HttpServer$1.run(HttpServer.java:118)
	at io.questdb.mp.Worker.run(Worker.java:152)

QuestDB version:

nightly

OS, in case of Docker specify Docker and the Host OS:

ubuntu

File System, in case of Docker specify Host File System:

ext4

Full Name:

Yuancheng Jiang

Affiliation:

National University of Singapore

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

  • Yes, I have

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugIncorrect or unexpected behaviorSQLIssues or changes relating to SQL execution

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions