Debian Codegraph @

mysql-test/suite/engines/funcs/t/sq_all.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 c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2);
17 SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2);
18 SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2);
19 SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2);
20 SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2);
21 DROP TABLE t1;
22 DROP TABLE t2;
23 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
24 INSERT INTO t1 VALUES (null,null);
25 INSERT INTO t1 VALUES (1,'');
26 INSERT INTO t1 VALUES (2,'abcde');
27 INSERT INTO t1 VALUES (100,'abcdefghij');
28 CREATE TABLE t2 (c1 INT);
29 INSERT INTO t2 VALUES (null);
30 INSERT INTO t2 VALUES (2);
31 INSERT INTO t2 VALUES (100);
32 SELECT c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2);
33 SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2);
34 SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2);
35 SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2);
36 SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2);
37 DROP TABLE t1;
38 DROP TABLE t2;
39 CREATE TABLE t1 (c1 INT, c2 BINARY(100));
40 INSERT INTO t1 VALUES (null,null);
41 INSERT INTO t1 VALUES (1,'');
42 INSERT INTO t1 VALUES (2,'abcde');
43 INSERT INTO t1 VALUES (100,'abcdefghij');
44 CREATE TABLE t2 (c1 INT);
45 INSERT INTO t2 VALUES (null);
46 INSERT INTO t2 VALUES (2);
47 INSERT INTO t2 VALUES (100);
48 SELECT c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2);
49 SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2);
50 SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2);
51 SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2);
52 SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2);
53 DROP TABLE t1;
54 DROP TABLE t2;
55 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
56 INSERT INTO t1 VALUES (null,null);
57 INSERT INTO t1 VALUES (1,'');
58 INSERT INTO t1 VALUES (2,'abcde');
59 INSERT INTO t1 VALUES (100,'abcdefghij');
60 CREATE TABLE t2 (c1 INT);
61 INSERT INTO t2 VALUES (null);
62 INSERT INTO t2 VALUES (2);
63 INSERT INTO t2 VALUES (100);
64 SELECT c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2);
65 SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2);
66 SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2);
67 SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2);
68 SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2);
69 DROP TABLE t1;
70 DROP TABLE t2;
71