We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
@knz hit this issue: select * from t where a = (select max(a) from t) returns pq: aggregate functions are not allowed in WHERE
select * from t where a = (select max(a) from t)
pq: aggregate functions are not allowed in WHERE
I believe it is just a faulty check in groupBy, where we check n.Where which is the expression before subqueries were expanded.
groupBy
n.Where
The text was updated successfully, but these errors were encountered:
While looking at #4036
Sorry, something went wrong.
sql: allow subquery with aggregate in WHERE
bb0cf8f
Fixes cockroachdb#4672.
RaduBerinde
No branches or pull requests
@knz hit this issue:
select * from t where a = (select max(a) from t)
returnspq: aggregate functions are not allowed in WHERE
I believe it is just a faulty check in
groupBy
, where we checkn.Where
which is the expression before subqueries were expanded.The text was updated successfully, but these errors were encountered: