Bug #9470 'LIKE' comparison works strange

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'

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>

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

Tested w/4.1.11