-
Notifications
You must be signed in to change notification settings - Fork 1.5k
Closed
Labels
BugIncorrect or unexpected behaviorIncorrect or unexpected behaviorPerformancePerformance improvementsPerformance improvementsSQLIssues or changes relating to SQL executionIssues or changes relating to SQL execution
Description
Describe the bug
This query executes on the demo box in around 100ms:
select symbol, count()
from trades
group by symbol;
but this query executes 10s (100x more!)
select symbol as s, count()
from trades
group by s;
Both queries are functionally equivalent and should result in the same query plan. Apparently, that's not the case.
I reckon aliasing disables an optimization.
Environment
- QuestDB version: 6.5.3
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
BugIncorrect or unexpected behaviorIncorrect or unexpected behaviorPerformancePerformance improvementsPerformance improvementsSQLIssues or changes relating to SQL executionIssues or changes relating to SQL execution