Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 DROP TABLE IF EXISTS t2;
3 CREATE TABLE t1 (c1 INT, c2 CHAR(100));
4 INSERT INTO t1 VALUES (null,null);
5 INSERT INTO t1 VALUES (1,'');
6 INSERT INTO t1 VALUES (2,'abcde');
7 INSERT INTO t1 VALUES (100,'abcdefghij');
8 CREATE TABLE t2 (c1 INT);
9 INSERT INTO t2 VALUES (null);
10 INSERT INTO t2 VALUES (2);
11 INSERT INTO t2 VALUES (100);
12 SELECT (SELECT AVG(c1) FROM t1);
13 (SELECT AVG(c1) FROM t1)
14 34.3333
15 SELECT (SELECT MIN(c1) FROM t2) FROM t1;
16 (SELECT MIN(c1) FROM t2)
17 2
18 2
19 2
20 2
21 SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
22 UPPER((SELECT c2 FROM t1 WHERE c1=2))
23 ABCDE
24 ABCDE
25 ABCDE
26 SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
27 c1
28 100
29 SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
30 t1.c1 = t.c1);
31 c1
32 DROP TABLE t1;
33 DROP TABLE t2;
34 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
35 INSERT INTO t1 VALUES (null,null);
36 INSERT INTO t1 VALUES (1,'');
37 INSERT INTO t1 VALUES (2,'abcde');
38 INSERT INTO t1 VALUES (100,'abcdefghij');
39 CREATE TABLE t2 (c1 INT);
40 INSERT INTO t2 VALUES (null);
41 INSERT INTO t2 VALUES (2);
42 INSERT INTO t2 VALUES (100);
43 SELECT (SELECT AVG(c1) FROM t1);
44 (SELECT AVG(c1) FROM t1)
45 34.3333
46 SELECT (SELECT MIN(c1) FROM t2) FROM t1;
47 (SELECT MIN(c1) FROM t2)
48 2
49 2
50 2
51 2
52 SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
53 UPPER((SELECT c2 FROM t1 WHERE c1=2))
54 ABCDE
55 ABCDE
56 ABCDE
57 SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
58 c1
59 100
60 SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
61 t1.c1 = t.c1);
62 c1
63 DROP TABLE t1;
64 DROP TABLE t2;
65 CREATE TABLE t1 (c1 INT, c2 BINARY(100));
66 INSERT INTO t1 VALUES (null,null);
67 INSERT INTO t1 VALUES (1,'');
68 INSERT INTO t1 VALUES (2,'abcde');
69 INSERT INTO t1 VALUES (100,'abcdefghij');
70 CREATE TABLE t2 (c1 INT);
71 INSERT INTO t2 VALUES (null);
72 INSERT INTO t2 VALUES (2);
73 INSERT INTO t2 VALUES (100);
74 SELECT (SELECT AVG(c1) FROM t1);
75 (SELECT AVG(c1) FROM t1)
76 34.3333
77 SELECT (SELECT MIN(c1) FROM t2) FROM t1;
78 (SELECT MIN(c1) FROM t2)
79 2
80 2
81 2
82 2
83 SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
84 UPPER((SELECT c2 FROM t1 WHERE c1=2))
85 abcde
86 abcde
87 abcde
88 SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
89 c1
90 100
91 SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
92 t1.c1 = t.c1);
93 c1
94 DROP TABLE t1;
95 DROP TABLE t2;
96 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
97 INSERT INTO t1 VALUES (null,null);
98 INSERT INTO t1 VALUES (1,'');
99 INSERT INTO t1 VALUES (2,'abcde');
100 INSERT INTO t1 VALUES (100,'abcdefghij');
101 CREATE TABLE t2 (c1 INT);
102 INSERT INTO t2 VALUES (null);
103 INSERT INTO t2 VALUES (2);
104 INSERT INTO t2 VALUES (100);
105 SELECT (SELECT AVG(c1) FROM t1);
106 (SELECT AVG(c1) FROM t1)
107 34.3333
108 SELECT (SELECT MIN(c1) FROM t2) FROM t1;
109 (SELECT MIN(c1) FROM t2)
110 2
111 2
112 2
113 2
114 SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
115 UPPER((SELECT c2 FROM t1 WHERE c1=2))
116 abcde
117 abcde
118 abcde
119 SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
120 c1
121 100
122 SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
123 t1.c1 = t.c1);
124 c1
125 DROP TABLE t1;
126 DROP TABLE t2;