~maria-captains/maria/5.2

« back to all changes in this revision

Viewing changes to mysql-test/suite/maria/r/distinct.result

  • 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:
15
15
3
16
16
1
17
17
DROP TABLE t1;
18
 
CREATE TABLE t1 (a INT, b VARCHAR(1)) ENGINE=MyISAM;
19
 
INSERT INTO t1 VALUES (7,'q'),(2,NULL),(7,'g'),(6,'x');
20
 
SELECT DISTINCT MAX( a ) FROM t1 GROUP BY b ORDER BY DES_DECRYPT( b );
21
 
MAX( a )
22
 
2
23
 
7
24
 
6
25
 
DROP TABLE t1;