Skip to content
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.

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

Parser cannot deal with some array expression #5643

Closed
leiysky opened this issue May 28, 2022 · 1 comment · Fixed by #5654
Closed

Parser cannot deal with some array expression #5643

leiysky opened this issue May 28, 2022 · 1 comment · Fixed by #5654
Labels
A-planner Area: planner/optimizer C-bug Category: something isn't working

Comments

@leiysky
Copy link
Contributor

leiysky commented May 28, 2022

MySQL [(none)]> select [[1, 2, 3],[3]];
ERROR 1105 (HY000): Code: 1005, displayText = error:
  --> SQL:1:22
  |
1 | select [[1, 2, 3],[3]]
  | ------ -             ^ expected `]`, `IS`, `NOT`, `IN`, `BETWEEN`, `+`, or 46 more ...
  | |      |
  | |      while parsing `[...]`
  | |      while parsing expression
  | while parsing `SELECT ...`

.
MySQL [(none)]> select [[1, 2, 3],[1, 2]];
+---------------------+
| [[1, 2, 3], [1, 2]] |
+---------------------+
| [[1, 2, 3], [1, 2]] |
+---------------------+
1 row in set (0.035 sec)


MySQL [(none)]> select [[1, 2, 3],[1, 2, 3]];
+------------------------+
| [[1, 2, 3], [1, 2, 3]] |
+------------------------+
| [[1, 2, 3], [1, 2, 3]] |
+------------------------+
1 row in set (0.032 sec)
@leiysky leiysky added C-bug Category: something isn't working A-planner Area: planner/optimizer labels May 28, 2022
@leiysky
Copy link
Contributor Author

leiysky commented May 28, 2022

cc @andylokandy

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-planner Area: planner/optimizer C-bug Category: something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant