Bug #51676 Server crashes on SELECT, ORDER BY on 'utf8mb4' column
Submitted: 3 Mar 2010 8:31 Modified: 10 Mar 2010 9:05
Reporter: Nidhi Shrotriya Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Charsets Severity:S3 (Non-critical)
Version:5.5.3-m3 OS:Any
Assigned to: CPU Architecture:Any

[3 Mar 2010 8:31] Nidhi Shrotriya
Description:
mysql> SELECT *  FROM t4_upg_utf8mb4;

+------------+------+

| subject    | p    |

+------------+------+

| 

How to repeat:
SET NAMES utf8mb4; 
drop table if exists t4_upg_utf8mb4; 
CREATE TABLE t4_upg_utf8mb4 ( 
  subject varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci, 
  p varchar(15) character set utf8mb4 
) DEFAULT CHARSET=latin1; 
# Insert 4 byte characters 
INSERT INTO t4_upg_utf8mb4(subject) VALUES(0xF0909080); # 4byte character 
INSERT INTO t4_upg_utf8mb4(subject) VALUES(0x616263F0909080646566); # mix of 3 byte & 4 byte 
SHOW CREATE TABLE t4_upg_utf8mb4; 
SELECT *  FROM t4_upg_utf8mb4;
SELECT hex(subject), length(subject), char_length(subject), octet_length(subject) FROM t4_upg_utf8mb4 ORDER BY 1; 
SELECT subject FROM t4_upg_utf8mb4 ORDER BY 1;
[4 Mar 2010 11:07] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/102276
[4 Mar 2010 12:10] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/102296
[6 Mar 2010 10:29] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100306102742-yw9zzgw9ac5r65m5) (version source revid:bar@mysql.com-20100304132546-mg01i2tr3lbdx0n6) (merge vers: 6.0.14-alpha) (pib:16)
[6 Mar 2010 10:31] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100306102638-qna09hbjb5gm940h) (version source revid:bar@mysql.com-20100304120230-x1cz1jvfdvp0fpzt) (pib:16)
[6 Mar 2010 10:52] Bugs System
Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:bar@mysql.com-20100304120230-x1cz1jvfdvp0fpzt) (merge vers: 5.5.99-m3) (pib:16)