Bug #8034 '~~' , 'YY' and 'yy'
Submitted: 20 Jan 2005 9:50 Modified: 20 Jan 2005 10:25
Reporter: Minor Hsu Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version: OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[20 Jan 2005 9:50] Minor Hsu 
Description:
-- MySQL dump 9.11
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version       4.0.20

--
-- Table structure for table `test`
--

CREATE TABLE test (
  c char(20) default NULL,
  KEY idxc (c)
) TYPE=MyISAM;

--
-- Dumping data for table `test`
--

INSERT INTO test VALUES ('~~');
INSERT INTO test VALUES ('yy');
INSERT INTO test VALUES ('YY');

mysql> select * from test where c ='~~';
+------+
| c    |
+------+
| ~~   |
| yy   |
| YY   |
+------+
3 rows in set (0.00 sec)

How to repeat:
-- MySQL dump 9.11
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version       4.0.20

--
-- Table structure for table `test`
--

CREATE TABLE test (
  c char(20) default NULL,
  KEY idxc (c)
) TYPE=MyISAM;

--
-- Dumping data for table `test`
--

INSERT INTO test VALUES ('~~');
INSERT INTO test VALUES ('yy');
INSERT INTO test VALUES ('YY');

mysql> select * from test where c ='~~';
+------+
| c    |
+------+
| ~~   |
| yy   |
| YY   |
+------+
3 rows in set (0.00 sec)
[20 Jan 2005 10:25] MySQL Verification Team 
I wasn't able to repeat with 4.0.23 on Slackware.

mysql> CREATE TABLE test (
    ->   c char(20) default NULL,
    ->   KEY idxc (c)
    -> ) TYPE=MyISAM;
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO test VALUES ('~~');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO test VALUES ('yy');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO test VALUES ('YY');
Query OK, 1 row affected (0.00 sec)

mysql> select * from test where c ='~~';
+------+
| c    |
+------+
| ~~   |
+------+
1 row in set (0.02 sec)

mysql> select version();
+------------------+
| version()        |
+------------------+
| 4.0.23-debug-log |
+------------------+
1 row in set (0.00 sec)