Bug #99303 semicolon in second line with version hint in select statement can not work
Submitted: 20 Apr 2020 0:54 Modified: 4 Jun 2020 10:00
Reporter: jackson xu Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Document Store: MySQL Shell Severity:S3 (Non-critical)
Version:8.0.19 OS:MacOS
Assigned to: CPU Architecture:Any

[20 Apr 2020 0:54] jackson xu 
Description:
when  semicolon and select statement in line ,it is normal;
when semicolon in the second line , it throw error  "ERROR: 1065 (42000): Query was empty"

eg：
 MySQL  localhost:3306 ssl  SQL > /*!50508 select * from information_schema.files where tablespace_name='innodb_temporary'*/
 MySQL  localhost:3306 ssl  SQL > ;
ERROR: 1065 (42000): Query was empty

How to repeat:
 SQL > /*!50508 select * from information_schema.files where tablespace_name='innodb_temporary'*/
 MySQL  localhost:3306 ssl  SQL > ;

Suggested fix:
yes
[20 Apr 2020 1:20] jackson xu 
mysqlsh output file

Attachment: sql.jpg (image/jpeg, text), 457.61 KiB.
[20 Apr 2020 1:42] jackson xu 
change os type to Mac OS X
[20 Apr 2020 4:45] MySQL Verification Team 
Hello jackson xu,

Thank you for the report and feedback.

regards,
Umesh
[2 Jun 2020 12:24] Konrad Olesinski 
Posted by developer:
 
Fixed with commit:

commit b6927102e7278d5910730ad04cba59f4ffc4b117
Author: Konrad Olesinski <konrad.olesinski@oracle.com>
Date:   Wed May 20 17:05:03 2020 +0200

    Bug#31175790 USING SOURCE COMMAND IN SHELL FAILS WITH SQL SYNTAX ERROR
    
    Refactored and simplified context switching in Shell_sql. Context will
    only be switched inside interactive handle_command callback when one
    of the source commands is launched.
    
    Change-Id: I5f3fcf66bd22020057b22e8153052c009fe5325a
[4 Jun 2020 10:00] Margaret Fisher 
Posted by developer:
 
Added bug number to entry for Bug#31175790 and closed off.