MySQL Forums
Forum List  »  MySQL Workbench

Re: The workbench shows the following error "select is not valid at this position ..."
Posted by: Mike Lischke
Date: September 26, 2018 01:49AM

Hi Catherine,

what you see is a parser (grammar) bug. I fixed it and this fix will be in a future release of MySQL Workbench. In the meantime you can easily work around it by adding a second pair of parentheses, like:

Select title
From Movie
Where year<=All((Select year
From Movie));

Regards,

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/5.7/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: The workbench shows the following error "select is not valid at this position ..."
205
September 26, 2018 01:49AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.