dble icon indicating copy to clipboard operation
dble copied to clipboard

expect return "syntax error" message when executing sql like 'select *,select ... from...'

Open yexiaoli88 opened this issue 6 years ago • 2 comments

  • 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

yexiaoli88 avatar Sep 28 '18 05:09 yexiaoli88

purpose: select *, (select 3) from a_test order by id;

irene-coming avatar Sep 28 '18 05:09 irene-coming

the same reason with #718

yanhuqing666 avatar Sep 28 '18 05:09 yanhuqing666