Bug #4250 like not correct working?!
Submitted: 22 Jun 2004 16:05 Modified: 23 Jun 2004 2:33
Reporter: Evgeni Nk Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:4.1.1a OS:Linux (linux (rh 7.2))
Assigned to: Matthew Lord CPU Architecture:Any

[22 Jun 2004 16:05] Evgeni Nk
Description:
like  not correct working  :((
see How to repeat: 

How to repeat:
DROP TABLE IF EXISTS `testlike`;
Query OK, 0 rows affected, 1 warning (0,00 sec)
mysql> CREATE TABLE `testlike` (
    ->   `id` int(3) unsigned NOT NULL auto_increment,
    ->   `name` varchar(100) default NULL,
    ->   PRIMARY KEY  (`id`)
    -> ) TYPE=MyISAM DEFAULT CHARSET=cp1251;
Query OK, 0 rows affected (0,05 sec)
mysql> INSERT INTO `testlike` (`id`, `name`) VALUES("1", "mysql / forever");    Query OK, 1 row affected (0,00 sec)
mysql> select * from testlike where name like "%for%";
+----+-----------------+
| id | name            |
+----+-----------------+
|  1 | mysql / forever |
+----+-----------------+
1 row in set (0,00 sec)
mysql> select * from testlike where name like "%fore%";
+----+-----------------+
| id | name            |
+----+-----------------+
|  1 | mysql / forever |
+----+-----------------+
1 row in set (0,00 sec)
mysql> select * from testlike where name like "%forev%";
Empty set (0,00 sec)
mysql> select * from testlike where name like "%foreve%";
Empty set (0,00 sec)

mysql> select * from testlike where name like "%forever%";
Empty set (0,00 sec)

mysql> select * from testlike where name like "% forever%";
+----+-----------------+
| id | name            |
+----+-----------------+
|  1 | mysql / forever |
+----+-----------------+
1 row in set (0,00 sec)
show variables;
...
version                         | 4.1.1-alpha-standard-log 
...
character_set_server            | cp1251                                    |
| character_set_system            | utf8                                      |
| character_set_database          | cp1251                                    |
| character_set_client            | cp1251                                    |
| character_set_connection        | cp1251                                    |
| character-sets-dir              | /usr/share/mysql/charsets/                |
| character_set_results           | cp1251                                    |
| collation_connection            | cp1251_general_ci                         |
| collation_database              | cp1251_general_ci                         |
| collation_server                | cp1251_general_ci    

Suggested fix:
:(
[23 Jun 2004 2:32] Matthew Lord
Hi Evgeni,

I was unable to reproduce this in 4.1.2.  There have been *many* charset relateed fixes since 4.1.1.

Please upgrade to 4.1.2 when you can and please let us know if it continues to happen for you so we
can try to get to the bottom of it.

Best Regards