~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109

« back to all changes in this revision

Viewing changes to mysql-test/t/ctype_utf8.test

  • Committer: Clint Byrum
  • Date: 2012-02-15 01:24:19 UTC
  • mto: This revision was merged to the branch mainline in revision 10.
  • Revision ID: clint@ubuntu.com-20120215012419-upaezkp5ynk787ki
Import upstream version 5.5.20

Show diffs side-by-side

added added

removed removed

Lines of Context:
1562
1562
EXPLAIN EXTENDED SELECT 'abcdÁÂÃÄÅ', _latin1'abcdÁÂÃÄÅ', _utf8'abcdÁÂÃÄÅ';
1563
1563
 
1564
1564
--echo #
 
1565
--echo # Bug#11750518 41090: ORDER BY TRUNCATES GROUP_CONCAT RESULT
 
1566
--echo #
 
1567
 
 
1568
SET NAMES utf8;
 
1569
SELECT id, CHAR_LENGTH(GROUP_CONCAT(body)) AS l
 
1570
FROM (SELECT 'a' AS id, REPEAT('foo bar', 100) AS body
 
1571
UNION ALL
 
1572
SELECT 'a' AS id, REPEAT('bla bla', 100) AS body) t1
 
1573
GROUP BY id
 
1574
ORDER BY l DESC;
 
1575
 
 
1576
--echo #
1565
1577
--echo # End of 5.5 tests
1566
1578
--echo #