Debian Codegraph @

mysql-test/suite/maria/distinct.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a INT, b INT) ENGINE=Aria;
3 INSERT t1 VALUES (3,2004),(2,2006),(1,2007),(3,2008),(2,2005),(2,2001);
4 SELECT GROUP_CONCAT(a) FROM t1 GROUP BY b;
5 GROUP_CONCAT(a)
6 2
7 3
8 2
9 2
10 1
11 3
12 SELECT DISTINCT GROUP_CONCAT(a) FROM t1 GROUP BY b;
13 GROUP_CONCAT(a)
14 2
15 3
16 1
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 MD5( b );
21 MAX( a )
22 2
23 7
24 6
25 DROP TABLE t1;