Bug #99263 select plus mysql version hint not report result

• Submitted: 15 Apr 2020 9:11
• Modified: 16 Apr 2020 7:41
• Reporter: jackson xu
• Status: Can't repeat
• Category: MySQL Server: Document Store: MySQL Shell
• Severity: S3 (Non-critical)
• Version: 8.0.19
• OS: MacOS
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[15 Apr 2020 9:11] jackson xu

Description:
In SQL Mode
/*!50508 select * from information_schema.files where tablespace_name='innodb_temporary'*/

this sql  result return "ERROR: 1065: Query was empty"

but ,
/*!50508 select * from information_schema.files where tablespace_name='innodb_temporary'*/\G

this sql  return nomal result 

How to repeat:
In SQL Mode
/*!50508 select * from information_schema.files where tablespace_name='innodb_temporary'*/

this sql  result return "ERROR: 1065: Query was empty"

but ,
/*!50508 select * from information_schema.files where tablespace_name='innodb_temporary'*/\G

this sql  return nomal result 

Suggested fix:
to fix it.

[15 Apr 2020 23:01] MySQL Verification Team

MySQL Shell on MAC OSX

Attachment: 99263.png (image/png, text), 621.29 KiB.

[15 Apr 2020 23:04] MySQL Verification Team

Thank you for the bug report. Please see prior attached screenshot.

[16 Apr 2020 6:55] jackson xu

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

[16 Apr 2020 6:56] jackson xu

MySQL Shell on MAC OSX

Attachment: sql.jpg (image/jpeg, text), 457.61 KiB.

[16 Apr 2020 7:41] jackson xu

MySQL  localhost:33060+ ssl  SQL > /*!50508 select * from information_schema.files where tablespace_name='innodb_temporary'*/
 MySQL  localhost:33060+ ssl  SQL > \G
Unknown command: '\G'