Debian Codegraph @

mysql-test/suite/engines/funcs/t/sq_scalar.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 --disable_warnings
5 DROP TABLE IF EXISTS t2;
6 --enable_warnings
7 CREATE TABLE t1 (c1 INT, c2 CHAR(100));
8 INSERT INTO t1 VALUES (null,null);
9 INSERT INTO t1 VALUES (1,'');
10 INSERT INTO t1 VALUES (2,'abcde');
11 INSERT INTO t1 VALUES (100,'abcdefghij');
12 CREATE TABLE t2 (c1 INT);
13 INSERT INTO t2 VALUES (null);
14 INSERT INTO t2 VALUES (2);
15 INSERT INTO t2 VALUES (100);
16 SELECT (SELECT AVG(c1) FROM t1);
17 SELECT (SELECT MIN(c1) FROM t2) FROM t1;
18 SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
19 SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
20 SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
21 t1.c1 = t.c1);
22 DROP TABLE t1;
23 DROP TABLE t2;
24 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
25 INSERT INTO t1 VALUES (null,null);
26 INSERT INTO t1 VALUES (1,'');
27 INSERT INTO t1 VALUES (2,'abcde');
28 INSERT INTO t1 VALUES (100,'abcdefghij');
29 CREATE TABLE t2 (c1 INT);
30 INSERT INTO t2 VALUES (null);
31 INSERT INTO t2 VALUES (2);
32 INSERT INTO t2 VALUES (100);
33 SELECT (SELECT AVG(c1) FROM t1);
34 SELECT (SELECT MIN(c1) FROM t2) FROM t1;
35 SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
36 SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
37 SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
38 t1.c1 = t.c1);
39 DROP TABLE t1;
40 DROP TABLE t2;
41 CREATE TABLE t1 (c1 INT, c2 BINARY(100));
42 INSERT INTO t1 VALUES (null,null);
43 INSERT INTO t1 VALUES (1,'');
44 INSERT INTO t1 VALUES (2,'abcde');
45 INSERT INTO t1 VALUES (100,'abcdefghij');
46 CREATE TABLE t2 (c1 INT);
47 INSERT INTO t2 VALUES (null);
48 INSERT INTO t2 VALUES (2);
49 INSERT INTO t2 VALUES (100);
50 SELECT (SELECT AVG(c1) FROM t1);
51 SELECT (SELECT MIN(c1) FROM t2) FROM t1;
52 SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
53 SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
54 SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
55 t1.c1 = t.c1);
56 DROP TABLE t1;
57 DROP TABLE t2;
58 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
59 INSERT INTO t1 VALUES (null,null);
60 INSERT INTO t1 VALUES (1,'');
61 INSERT INTO t1 VALUES (2,'abcde');
62 INSERT INTO t1 VALUES (100,'abcdefghij');
63 CREATE TABLE t2 (c1 INT);
64 INSERT INTO t2 VALUES (null);
65 INSERT INTO t2 VALUES (2);
66 INSERT INTO t2 VALUES (100);
67 SELECT (SELECT AVG(c1) FROM t1);
68 SELECT (SELECT MIN(c1) FROM t2) FROM t1;
69 SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
70 SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
71 SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
72 t1.c1 = t.c1);
73 DROP TABLE t1;
74 DROP TABLE t2;
75