CodeGen error on GROUP BY or PARTITION BY boolean expression #4939

big-andy-coates · 2020-03-30T19:50:33Z

The ksqlDB syntax allows boolean expressions in GROUP BY and PARTITION BY clauses:

SELECT * FROM FOO PARTITION BY A AND B;
SELECT * FROM FOO PARTITION BY NOT B;
SELECT COUNT(1) FROM FOO GROUP BY A OR C;

However, though these parse they result in exceptions during code generation.

fixes: confluentinc#4939 Change to SQL syntax to not allow GROUP BY and PARTITION BY on boolean expressions. Only value expressions will be allowed.

…4940) fixes: #4939 Change to SQL syntax to not allow GROUP BY and PARTITION BY on boolean expressions. Only value expressions will be allowed. Co-authored-by: Andy Coates <[email protected]>

big-andy-coates added the bug label Mar 30, 2020

big-andy-coates self-assigned this Mar 30, 2020

big-andy-coates mentioned this issue Mar 30, 2020

fix: do not allow GROUP BY and PARTITION BY on boolean expressions #4940

Merged

2 tasks

big-andy-coates closed this as completed in #4940 Mar 30, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

CodeGen error on GROUP BY or PARTITION BY boolean expression #4939

CodeGen error on GROUP BY or PARTITION BY boolean expression #4939

big-andy-coates commented Mar 30, 2020 •

edited

Loading

CodeGen error on GROUP BY or PARTITION BY boolean expression #4939

CodeGen error on GROUP BY or PARTITION BY boolean expression #4939

Comments

big-andy-coates commented Mar 30, 2020 • edited Loading

big-andy-coates commented Mar 30, 2020 •

edited

Loading