Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

NullPointerException: Cannot invoke "io.questdb.cairo.sql.SymbolTable.valueOf(int)" because "this.symbolTable" is null #3935

Closed
YuanchengJiang opened this issue Nov 9, 2023 · 0 comments · Fixed by #3939
Assignees
Labels
Bug Incorrect or unexpected behavior SQL Issues or changes relating to SQL execution

Comments

@YuanchengJiang
Copy link

Describe the bug

java.lang.NullPointerException: Cannot invoke "io.questdb.cairo.sql.SymbolTable.valueOf(int)" because "this.symbolTable" is null
	at io.questdb.griffin.engine.functions.columns.SymbolColumn.getSymbol(SymbolColumn.java:72)
	at io.questdb.griffin.engine.functions.SymbolFunction.getStr(SymbolFunction.java:156)
	at io.questdb.griffin.engine.functions.regex.AbstractLikeStrFunctionFactory$ConstLikeStrFunction.getBool(AbstractLikeStrFunctionFactory.java:438)
	at io.questdb.cairo.sql.VirtualRecord.getBool(VirtualRecord.java:61)
	at io.questdb.cairo.map.FastMap$BaseKey.put(FastMap.java:482)
	at io.questdb.griffin.engine.functions.window.AvgDoubleWindowFunctionFactory$AvgOverPartitionFunction.pass1(AvgDoubleWindowFunctionFactory.java:357)
	at io.questdb.griffin.engine.window.CachedWindowRecordCursorFactory$CachedWindowRecordCursor.buildRecordChain(CachedWindowRecordCursorFactory.java:380)
	at io.questdb.griffin.engine.window.CachedWindowRecordCursorFactory$CachedWindowRecordCursor.hasNext(CachedWindowRecordCursorFactory.java:303)
	at io.questdb.cutlass.pgwire.PGConnectionContext.sendCursor0(PGConnectionContext.java:2710)
	at io.questdb.cutlass.pgwire.PGConnectionContext.sendCursor(PGConnectionContext.java:2701)
	at io.questdb.cutlass.pgwire.PGConnectionContext$PGConnectionBatchCallback.postCompile(PGConnectionContext.java:2988)
	at io.questdb.griffin.SqlCompilerImpl.compileBatch(SqlCompilerImpl.java:296)
	at io.questdb.cairo.pool.SqlCompilerPool$C.compileBatch(SqlCompilerPool.java:103)
	at io.questdb.cutlass.pgwire.PGConnectionContext.processQuery(PGConnectionContext.java:2491)
	at io.questdb.cutlass.pgwire.PGConnectionContext.parse(PGConnectionContext.java:1910)
	at io.questdb.cutlass.pgwire.PGConnectionContext.handleClientOperation(PGConnectionContext.java:519)
	at io.questdb.cutlass.pgwire.PGWireServer$1.lambda$$0(PGWireServer.java:79)
	at io.questdb.network.AbstractIODispatcher.processIOQueue(AbstractIODispatcher.java:199)
	at io.questdb.cutlass.pgwire.PGWireServer$1.run(PGWireServer.java:109)
	at io.questdb.mp.Worker.run(Worker.java:148)

To reproduce

create table test (c_0 symbol, c_1 int);
insert into test values('aaa', 1);
SELECT avg(c_1) OVER(PARTITION BY c_0 LIKE 'aaa') FROM test;

Expected Behavior

No response

Environment

- **QuestDB version**: 7.3.4
- **OS**:
- **Browser**:

Additional context

No response

@puzpuzpuz puzpuzpuz added Bug Incorrect or unexpected behavior SQL Issues or changes relating to SQL execution labels Nov 9, 2023
@puzpuzpuz puzpuzpuz self-assigned this Nov 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Incorrect or unexpected behavior SQL Issues or changes relating to SQL execution
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants