8000 bug(fe): should check the column in `distinct on` for aggregation query · Issue #19177 · risingwavelabs/risingwave · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
bug(fe): should check the column in distinct on for aggregation query #19177
Open
@st1page

Description

@st1page

reproduce

create table t(a int, b int);
explain select distinct on(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;
                                   ^

Metadata

Metadata

Assignees

Labels

A-aggArea: Aggregate.type/bugType: Bug. Only for issues.

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    0