~maria-captains/maria/5.2

« back to all changes in this revision

Viewing changes to mysql-test/suite/maria/t/distinct.test

  • Committer: Sergei Golubchik
  • Date: 2014-02-13 07:25:33 UTC
  • mfrom: (2643.137.75 5.1)
  • Revision ID: sergii@pisem.net-20140213072533-gkbllmcu4qkp9024
5.1 merge

Show diffs side-by-side

added added

removed removed

Lines of Context:
19
19
SELECT DISTINCT GROUP_CONCAT(a) FROM t1 GROUP BY b;
20
20
DROP TABLE t1;
21
21
 
22
 
CREATE TABLE t1 (a INT, b VARCHAR(1)) ENGINE=MyISAM;
23
 
INSERT INTO t1 VALUES (7,'q'),(2,NULL),(7,'g'),(6,'x');
24
 
SELECT DISTINCT MAX( a ) FROM t1 GROUP BY b ORDER BY DES_DECRYPT( b );
25
 
DROP TABLE t1;