I find very interesting bug in MySQL 3.23.54 in sorting.

How to repeat: CREATE TABLE t TEXT1 VARCHAR(50) NOT NULL, TEXT2 VARCHAR(50) NOT NULL; ALTER TABLE t ADD INDEX TEXT1 (TEXT1); ALTER TABLE t ADD INDEX TEXT2 (TEXT2); INSERT INTO t SET TEXT1='31. some text', TEXT2='32. SOME TEXT'; INSERT INTO t SET TEXT1='A some text', TEXT2='A SOME TEXT'; INSERT INTO t SET TEXT1='4. some texts', TEXT2='4. SOME TEXTS'; INSERT INTO t SET TEXT1='3. some texts', TEXT2='3. SOME TEXTS'; INSERT INTO t SET TEXT1='The some text', TEXT2='THE SOME TEXT';

TEXT2 contain upper case of TEXT1 for every rows. Now I can get result of 1st character from TEXT2 grouped by this character and sorteb by this character. I write query: SELECT SUBSTRING(TEXT2,1,1) AS c FROM t GROUP BY c ORDER BY c; and result is very curious 4 3 A T

How to resolve: I don't know :-)