Debian Codegraph @

mysql-test/suite/engines/funcs/r/fu_aggregate_max_subquery.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 VARCHAR(10), c2 VARCHAR(10), c3 TINYINT);
3 INSERT INTO t1 VALUES ('a','b',0), ('a','b',1), ('a','b',2), ('a','b',3), ('a','b',4), ('a','b',5), ('a','b',6), ('a','b',7), ('a','b',8), ('a','b',9);
4 SELECT c1,c2,c3 FROM t1 ORDER BY c3 DESC LIMIT 1;
5 c1 c2 c3
6 a b 9
7 SELECT c1,MAX(c3) FROM t1 GROUP BY c1;
8 c1 MAX(c3)
9 a 9
10 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(c3) FROM t1);
11 c1 c2 c3
12 a b 9
13 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(t11.c3) FROM t1 AS t11 WHERE t1.c1 = t11.c1);
14 c1 c2 c3
15 a b 9
16 DROP TABLE t1;
17 CREATE TABLE t1(c1 VARCHAR(10), c2 VARCHAR(10), c3 SMALLINT);
18 INSERT INTO t1 VALUES ('a','b',0), ('a','b',1), ('a','b',2), ('a','b',3), ('a','b',4), ('a','b',5), ('a','b',6), ('a','b',7), ('a','b',8), ('a','b',9);
19 SELECT c1,c2,c3 FROM t1 ORDER BY c3 DESC LIMIT 1;
20 c1 c2 c3
21 a b 9
22 SELECT c1,MAX(c3) FROM t1 GROUP BY c1;
23 c1 MAX(c3)
24 a 9
25 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(c3) FROM t1);
26 c1 c2 c3
27 a b 9
28 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(t11.c3) FROM t1 AS t11 WHERE t1.c1 = t11.c1);
29 c1 c2 c3
30 a b 9
31 DROP TABLE t1;
32 CREATE TABLE t1(c1 VARCHAR(10), c2 VARCHAR(10), c3 MEDIUMINT);
33 INSERT INTO t1 VALUES ('a','b',0), ('a','b',1), ('a','b',2), ('a','b',3), ('a','b',4), ('a','b',5), ('a','b',6), ('a','b',7), ('a','b',8), ('a','b',9);
34 SELECT c1,c2,c3 FROM t1 ORDER BY c3 DESC LIMIT 1;
35 c1 c2 c3
36 a b 9
37 SELECT c1,MAX(c3) FROM t1 GROUP BY c1;
38 c1 MAX(c3)
39 a 9
40 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(c3) FROM t1);
41 c1 c2 c3
42 a b 9
43 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(t11.c3) FROM t1 AS t11 WHERE t1.c1 = t11.c1);
44 c1 c2 c3
45 a b 9
46 DROP TABLE t1;
47 CREATE TABLE t1(c1 VARCHAR(10), c2 VARCHAR(10), c3 INT);
48 INSERT INTO t1 VALUES ('a','b',0), ('a','b',1), ('a','b',2), ('a','b',3), ('a','b',4), ('a','b',5), ('a','b',6), ('a','b',7), ('a','b',8), ('a','b',9);
49 SELECT c1,c2,c3 FROM t1 ORDER BY c3 DESC LIMIT 1;
50 c1 c2 c3
51 a b 9
52 SELECT c1,MAX(c3) FROM t1 GROUP BY c1;
53 c1 MAX(c3)
54 a 9
55 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(c3) FROM t1);
56 c1 c2 c3
57 a b 9
58 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(t11.c3) FROM t1 AS t11 WHERE t1.c1 = t11.c1);
59 c1 c2 c3
60 a b 9
61 DROP TABLE t1;
62 CREATE TABLE t1(c1 VARCHAR(10), c2 VARCHAR(10), c3 INTEGER);
63 INSERT INTO t1 VALUES ('a','b',0), ('a','b',1), ('a','b',2), ('a','b',3), ('a','b',4), ('a','b',5), ('a','b',6), ('a','b',7), ('a','b',8), ('a','b',9);
64 SELECT c1,c2,c3 FROM t1 ORDER BY c3 DESC LIMIT 1;
65 c1 c2 c3
66 a b 9
67 SELECT c1,MAX(c3) FROM t1 GROUP BY c1;
68 c1 MAX(c3)
69 a 9
70 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(c3) FROM t1);
71 c1 c2 c3
72 a b 9
73 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(t11.c3) FROM t1 AS t11 WHERE t1.c1 = t11.c1);
74 c1 c2 c3
75 a b 9
76 DROP TABLE t1;
77 CREATE TABLE t1(c1 VARCHAR(10), c2 VARCHAR(10), c3 BIGINT);
78 INSERT INTO t1 VALUES ('a','b',0), ('a','b',1), ('a','b',2), ('a','b',3), ('a','b',4), ('a','b',5), ('a','b',6), ('a','b',7), ('a','b',8), ('a','b',9);
79 SELECT c1,c2,c3 FROM t1 ORDER BY c3 DESC LIMIT 1;
80 c1 c2 c3
81 a b 9
82 SELECT c1,MAX(c3) FROM t1 GROUP BY c1;
83 c1 MAX(c3)
84 a 9
85 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(c3) FROM t1);
86 c1 c2 c3
87 a b 9
88 SELECT c1,c2,c3 FROM t1 WHERE c3=(SELECT MAX(t11.c3) FROM t1 AS t11 WHERE t1.c1 = t11.c1);
89 c1 c2 c3
90 a b 9
91 DROP TABLE t1;