Bug #70533 explain for connection syntax error if connection_id > 2147483647
Submitted: 5 Oct 2013 18:30 Modified: 12 Nov 2013 2:08
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Parser Severity:S4 (Feature request)
Version:5.7.3 OS:Any
Assigned to: CPU Architecture:Any

[5 Oct 2013 18:30] Shane Bester 
Description:
output:

mysql> explain for connection 2147483648;
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 '2147483648' at line 1
mysql> explain for connection 2147483647;
Query OK, 0 rows affected (0.00 sec)

How to repeat:
explain for connection 2147483648;
explain for connection 2147483647;

Suggested fix:
the syntax should support a bigint unsigned number.
[11 Oct 2013 16:39] Hartmut Holzgraefe 
... and could definitely do better than just saying "Syntax error" for values that are indeed invalid/out of range ...
[12 Nov 2013 2:08] Paul DuBois 
Posted by developer:
 
Noted in 5.7.3 changelog.

For EXPLAIN FOR CONNECTION connection_id, the parser did not permit 
connection_id values larger than the maximum signed BIGINT value. The
maximum unsigned value now is permitted.