You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
createtablet(a int, b int);
explain select distincton(a,b) count(*) from t;
output
dev=> create table t(a int, b int);
CREATE_TABLE
dev=> explain select distinct on(a,b) count(*) from t;
ERROR: Panicked when handling the request: insert at index 1 exceeds fixbitset size 1
expected
postgres=# create table t(a int, b int);
explain select distinct on(a,b) count(*) from t;
CREATE TABLE
ERROR: column "t.a" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: explain select distinct on(a,b) count(*) from t;
^
The text was updated successfully, but these errors were encountered:
reproduce
output
expected
The text was updated successfully, but these errors were encountered: