Bug #10650 Bit literal case sensitivity
Submitted: 16 May 2005 0:13 Modified: 23 Jun 2005 18:33
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.6-beta-debug OS:Linux (SUSE 9.2)
Assigned to: Ramil Kalimullin

[16 May 2005 0: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 0:32] Miguel Solorzano
Thank you for the bug report.
[16 Jun 2005 8:26] Ramil Kalimullin
fixed in 5.0.8
[16 Jun 2005 15: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 18:33] Mike Hillyer
Documented in 5.0.8 changelog.