Debian Codegraph @

mysql-test/suite/engines/funcs/r/sq_all.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 c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2);
13 c1
14 SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2);
15 c1
16 SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2);
17 c1
18 SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2);
19 c1
20 SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2);
21 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 c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2);
34 c1
35 SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2);
36 c1
37 SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2);
38 c1
39 SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2);
40 c1
41 SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2);
42 c1
43 DROP TABLE t1;
44 DROP TABLE t2;
45 CREATE TABLE t1 (c1 INT, c2 BINARY(100));
46 INSERT INTO t1 VALUES (null,null);
47 INSERT INTO t1 VALUES (1,'');
48 INSERT INTO t1 VALUES (2,'abcde');
49 INSERT INTO t1 VALUES (100,'abcdefghij');
50 CREATE TABLE t2 (c1 INT);
51 INSERT INTO t2 VALUES (null);
52 INSERT INTO t2 VALUES (2);
53 INSERT INTO t2 VALUES (100);
54 SELECT c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2);
55 c1
56 SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2);
57 c1
58 SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2);
59 c1
60 SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2);
61 c1
62 SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2);
63 c1
64 DROP TABLE t1;
65 DROP TABLE t2;
66 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
67 INSERT INTO t1 VALUES (null,null);
68 INSERT INTO t1 VALUES (1,'');
69 INSERT INTO t1 VALUES (2,'abcde');
70 INSERT INTO t1 VALUES (100,'abcdefghij');
71 CREATE TABLE t2 (c1 INT);
72 INSERT INTO t2 VALUES (null);
73 INSERT INTO t2 VALUES (2);
74 INSERT INTO t2 VALUES (100);
75 SELECT c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2);
76 c1
77 SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2);
78 c1
79 SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2);
80 c1
81 SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2);
82 c1
83 SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2);
84 c1
85 DROP TABLE t1;
86 DROP TABLE t2;