2
DROP TABLE IF EXISTS t1;
5
DROP TABLE IF EXISTS t2;
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 > SOME (SELECT c1 FROM t2);
17
SELECT c1 FROM t1 WHERE c1 >= SOME (SELECT c1 FROM t2);
18
SELECT c1 FROM t1 WHERE c1 = SOME (SELECT c1 FROM t2);
19
SELECT c1 FROM t1 WHERE c1 <= SOME (SELECT c1 FROM t2);
20
SELECT c1 FROM t1 WHERE c1 <> SOME (SELECT c1 FROM 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 > SOME (SELECT c1 FROM t2);
33
SELECT c1 FROM t1 WHERE c1 >= SOME (SELECT c1 FROM t2);
34
SELECT c1 FROM t1 WHERE c1 = SOME (SELECT c1 FROM t2);
35
SELECT c1 FROM t1 WHERE c1 <= SOME (SELECT c1 FROM t2);
36
SELECT c1 FROM t1 WHERE c1 <> SOME (SELECT c1 FROM 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 > SOME (SELECT c1 FROM t2);
49
SELECT c1 FROM t1 WHERE c1 >= SOME (SELECT c1 FROM t2);
50
SELECT c1 FROM t1 WHERE c1 = SOME (SELECT c1 FROM t2);
51
SELECT c1 FROM t1 WHERE c1 <= SOME (SELECT c1 FROM t2);
52
SELECT c1 FROM t1 WHERE c1 <> SOME (SELECT c1 FROM 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 > SOME (SELECT c1 FROM t2);
65
SELECT c1 FROM t1 WHERE c1 >= SOME (SELECT c1 FROM t2);
66
SELECT c1 FROM t1 WHERE c1 = SOME (SELECT c1 FROM t2);
67
SELECT c1 FROM t1 WHERE c1 <= SOME (SELECT c1 FROM t2);
68
SELECT c1 FROM t1 WHERE c1 <> SOME (SELECT c1 FROM t2);