Bug #9470 'LIKE' comparison works strange

• Submitted: 30 Mar 2005 0:07
• Modified: 30 Mar 2005 0:31
• Reporter: A B
• Status: Can't repeat
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 4.1.10a-max-nt
• OS: Windows (Win2003srv)
• CPU Architecture: Any

[30 Mar 2005 0:07] A B

Description:
mysql> SELECT id,align FROM fighters WHERE id = 1036469834 AND align LIKE '1%';
+------------+-------+
| id         | align |
+------------+-------+
| 1036469834 | 1.9   |
+------------+-------+
1 row in set (0.00 sec)

mysql> SELECT id, align FROM fighters WHERE align LIKE '1%';
Empty set (0.00 sec)

mysql>

How to repeat:
Just create table like
id int(10) unsigned
align char(50)

and add 2-3 rows like

1051109165, '0'
1029297211, '1.7'
1039686168, '3'
1025246311, '3.091'
1063033088, '7'

[30 Mar 2005 0:15] A B

Oh, sorry...

mysql> \s
--------------
C:\usr\sbin\mysql\bin\mysql.exe  Ver 14.7 Distrib 4.1.10a, for Win95/Win98 (i32)

Connection id:          2
Current database:       ***
Current user:           ***@***
SSL:                    Not in use
Using delimiter:        ;
Server version:         4.1.10a-nt-max
Protocol version:       10
Connection:             mysql.*** via TCP/IP
Server characterset:    latin1
Db     characterset:    cp1251
Client characterset:    cp1251
Conn.  characterset:    latin1
TCP port:               3306
Uptime:                 1 min 17 sec

Threads: 1  Questions: 80  Slow queries: 0  Opens: 13  Flush tables: 1  Open tables: 7  Queries per second avg: 1.039
--------------

mysql>

[30 Mar 2005 0:26] Jorge del Conde

mysql> SELECT id, align FROM fighters WHERE align LIKE '1%';
+------------+-------+
| id         | align |
+------------+-------+
| 1029297211 | 1.7   |
+------------+-------+
1 row in set (0.00 sec)

[30 Mar 2005 0:30] Jorge del Conde

Tested w/4.1.11