Skip to content

Error on adding distinct column alias #2980

@ideoma

Description

@ideoma

Describe the bug

No response

To reproduce

  1. Run
select distinct event as dev from telemetry
  1. Observe server exception
2023-02-09T15:17:18.906658Z C i.q.c.h.p.JsonQueryProcessorState [27] Uh-oh. Error!
io.questdb.cairo.sql.InvalidColumnException
	at io.questdb.cairo.sql.InvalidColumnException.<clinit>(InvalidColumnException.java:28)
	at io.questdb.cairo.sql.RecordMetadata.getColumnIndex(RecordMetadata.java:60)
	at io.questdb.griffin.SqlCodeGenerator.generateSelectDistinct(SqlCodeGenerator.java:3051)
	at io.questdb.griffin.SqlCodeGenerator.generateSelect(SqlCodeGenerator.java:2685)
	at io.questdb.griffin.SqlCodeGenerator.generateQuery0(SqlCodeGenerator.java:2288)
	at io.questdb.griffin.SqlCodeGenerator.generateQuery(SqlCodeGenerator.java:2275)
	at io.questdb.griffin.SqlCodeGenerator.generate(SqlCodeGenerator.java:187)
	at io.questdb.griffin.SqlCompiler.generate(SqlCompiler.java:2622)
	at io.questdb.griffin.SqlCompiler.compileUsingModel(SqlCompiler.java:1292)
	at io.questdb.griffin.SqlCompiler.compileInner(SqlCompiler.java:1241)
	at io.questdb.griffin.SqlCompiler.compile(SqlCompiler.java:266)
	at io.questdb.cutlass.http.processors.JsonQueryProcessor.compileQuery(JsonQueryProcessor.java:419)
	at io.questdb.cutlass.http.processors.JsonQueryProcessor.execute0(JsonQueryProcessor.java:186)
	at io.questdb.cutlass.http.processors.JsonQueryProcessor.onRequestComplete(JsonQueryProcessor.java:236)
	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)

Expected Behavior

No response

Environment

- **QuestDB version**: 7.0.0

Additional context

No response

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions