Bug #10650 Bit literal case sensitivity

• Submitted: 16 May 2005 0:13
• Modified: 23 Jun 2005 18:33
• Reporter: Peter Gulutzan
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.6-beta-debug
• OS: Linux (SUSE 9.2)
• Assigned to: Ramil Kalimullin
• CPU Architecture: Any

[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] MySQL Verification Team

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.