dble
dble copied to clipboard
expect return "syntax error" message when executing sql like 'select *,select ... from...'
-
dble version:5.6.29-dble-9.9.9.9-c51d005-20180927104851
-
steps:
step1. query in dble
mysql> select *, select 3 from a_test order by id;
ERROR 1242 (HY000): Subquery returns more than 1 row
step2 query in mysql
mysql> select *, select 3 from a_test order by id;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select 3 from a_test order by id' at line 1
-
expect result:
error message return from step1 should like the error message return from step 2 /label ~BUG
purpose: select *, (select 3) from a_test order by id;
the same reason with #718