New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

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

Jump to bottom

support subquery in aggregate syntax #7857

Open

jycor opened this issue May 13, 2024 · 0 comments

Labels

correctness good repro

Contributor

jycor commented May 13, 2024

This parses in MySQL, but throws syntax error in dolt.

mysql> create table t (i int);
Query OK, 0 rows affected (0.0241 sec)

mysql> insert into t values (1);
Query OK, 0 rows affected (0.0141 sec)

mysql> select i, i = any(select 1) from t;
+---+--------------------+
| i | i = some(select 1) |
+---+--------------------+
| 1 |                  1 |
+---+--------------------+
1 row in set (0.0006 sec)

jycor added good repro correctness labels

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment