2 messages in com.mysql.lists.bugsWrong procesing character @ on LIKE c...
FromSent OnAttachments
Jaro...@pvt.cz17 Apr 2001 03:09 
Michael Widenius17 Apr 2001 05:38 
Subject:Wrong procesing character @ on LIKE clausule at ISAM table
From:Michael Widenius (mon@mysql.com)
Date:04/17/2001 05:38:45 AM
List:com.mysql.lists.bugs

Hi!

"Jaroslav" == Jaroslav Brtek <Jaro@pvt.cz> writes:

Jaroslav> Hi, Jaroslav> a bug occured with using char '@' in LIKE clausule on SELECT command
for Jaroslav> ISAM table Jaroslav> on both Machine 1 and Machine 2.

Jaroslav> Machine 1 : Jaroslav> Server version MySQL: 3.23.32 Jaroslav> Operating systems : Jaroslav> Linux version 2.2.15-2.5.0 (ro@porky.devel.redhat.com) (gcc
version Jaroslav> egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)) #1 Sat Feb 5
00:28:02 EST Jaroslav> 2000

Jaroslav> Machine 2 : Jaroslav> Server version MySQL: 3.23.32-log Jaroslav> Operating systems : Jaroslav> Linux version 2.2.17pre6 (ro@www.katedrala.cz) (gcc version
2.95.2 Jaroslav> 20000220 (Debian GNU/Linux)) #2 SMP Wed Sep 20 10:31:42 CEST 2000

Jaroslav> *********** SCRIPT BEGIN - WITH PRIMARY KEY ************* Jaroslav> CREATE TABLE c_users ( Jaroslav> room varchar(30) NOT NULL default '', Jaroslav> PRIMARY KEY (room) Jaroslav> ) TYPE=ISAM PACK_KEYS=1; Jaroslav> INSERT INTO c_users VALUES ('K@tedrala'); Jaroslav> #THIS SELECT OK : Jaroslav> SELECT room FROM c_users WHERE room LIKE 'K@tedrala'; Jaroslav> INSERT INTO c_users VALUES ('Server'); Jaroslav> #THE SAME SELECT NOW FAILED : Jaroslav> SELECT room FROM c_users WHERE room LIKE 'K@tedrala'; Jaroslav> *********** SCRIPT END *************

I just tested this with the upcoming MySQL 3.23.37:

mysql> CREATE TABLE c_users ( -> room varchar(30) NOT NULL default '', -> PRIMARY KEY (room) -> ) TYPE=ISAM PACK_KEYS=1; Query OK, 0 rows affected (0.24 sec)

mysql> INSERT INTO c_users VALUES ('K@tedrala'); Query OK, 1 row affected (0.02 sec)

mysql> #THIS SELECT OK : mysql> SELECT room FROM c_users WHERE room LIKE 'K@tedrala'; +-----------+ | room | +-----------+ | K@tedrala | +-----------+ 1 row in set (0.04 sec)

mysql> INSERT INTO c_users VALUES ('Server'); Query OK, 1 row affected (0.03 sec)

mysql> #THE SAME SELECT NOW FAILED : mysql> SELECT room FROM c_users WHERE room LIKE 'K@tedrala'; +-----------+ | room | +-----------+ | K@tedrala | +-----------+ 1 row in set (0.02 sec)

Please check if an upgrade will solve this problem for you!

Regards, Monty