Bug #10650 Bit literal case sensitivity
Submitted: 16 May 2005 2:13 Modified: 23 Jun 2005 20:33
Reporter: Peter Gulutzan
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:5.0.6-beta-debug OS:Linux (SUSE 9.2)
Assigned to: Ramil Kalimullin Target Version:

[16 May 2005 2:13] Peter Gulutzan 
Description:
When I use a hex literal I can say either x or X, for example X'10'.
When I use a bit literal I can only say b, for example b'10'.
I suggest that it is a bug that I cannot say B'10'.
But I acknowledge that the MySQL documentation doesn't guarantee case insensitivity here.

How to repeat:
mysql> select X'10';
+-------+
| X'10' |
+-------+
|      |
+-------+
1 row in set (0.00 sec)

mysql> select b'10';
+-------+
| b'10' |
+-------+
|      |
+-------+
1 row in set (0.00 sec)

mysql> select B'10';
ERROR 1054 (42S22): Unknown column 'B' in 'field list'
[16 May 2005 2:32] Miguel Solorzano 
Thank you for the bug report.
[16 Jun 2005 10:26] Ramil Kalimullin 
fixed in 5.0.8
[16 Jun 2005 17:12] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/26065
[23 Jun 2005 20:33] Mike Hillyer 
Documented in 5.0.8 changelog.