Debian Codegraph @

mysql-test/suite/engines/funcs/r/sq_some.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 > SOME (SELECT c1 FROM t2);
13 c1
14 100
15 SELECT c1 FROM t1 WHERE c1 >= SOME (SELECT c1 FROM t2);
16 c1
17 2
18 100
19 SELECT c1 FROM t1 WHERE c1 = SOME (SELECT c1 FROM t2);
20 c1
21 2
22 100
23 SELECT c1 FROM t1 WHERE c1 <= SOME (SELECT c1 FROM t2);
24 c1
25 1
26 2
27 100
28 SELECT c1 FROM t1 WHERE c1 <> SOME (SELECT c1 FROM t2);
29 c1
30 1
31 2
32 100
33 DROP TABLE t1;
34 DROP TABLE t2;
35 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
36 INSERT INTO t1 VALUES (null,null);
37 INSERT INTO t1 VALUES (1,'');
38 INSERT INTO t1 VALUES (2,'abcde');
39 INSERT INTO t1 VALUES (100,'abcdefghij');
40 CREATE TABLE t2 (c1 INT);
41 INSERT INTO t2 VALUES (null);
42 INSERT INTO t2 VALUES (2);
43 INSERT INTO t2 VALUES (100);
44 SELECT c1 FROM t1 WHERE c1 > SOME (SELECT c1 FROM t2);
45 c1
46 100
47 SELECT c1 FROM t1 WHERE c1 >= SOME (SELECT c1 FROM t2);
48 c1
49 2
50 100
51 SELECT c1 FROM t1 WHERE c1 = SOME (SELECT c1 FROM t2);
52 c1
53 2
54 100
55 SELECT c1 FROM t1 WHERE c1 <= SOME (SELECT c1 FROM t2);
56 c1
57 1
58 2
59 100
60 SELECT c1 FROM t1 WHERE c1 <> SOME (SELECT c1 FROM t2);
61 c1
62 1
63 2
64 100
65 DROP TABLE t1;
66 DROP TABLE t2;
67 CREATE TABLE t1 (c1 INT, c2 BINARY(100));
68 INSERT INTO t1 VALUES (null,null);
69 INSERT INTO t1 VALUES (1,'');
70 INSERT INTO t1 VALUES (2,'abcde');
71 INSERT INTO t1 VALUES (100,'abcdefghij');
72 CREATE TABLE t2 (c1 INT);
73 INSERT INTO t2 VALUES (null);
74 INSERT INTO t2 VALUES (2);
75 INSERT INTO t2 VALUES (100);
76 SELECT c1 FROM t1 WHERE c1 > SOME (SELECT c1 FROM t2);
77 c1
78 100
79 SELECT c1 FROM t1 WHERE c1 >= SOME (SELECT c1 FROM t2);
80 c1
81 2
82 100
83 SELECT c1 FROM t1 WHERE c1 = SOME (SELECT c1 FROM t2);
84 c1
85 2
86 100
87 SELECT c1 FROM t1 WHERE c1 <= SOME (SELECT c1 FROM t2);
88 c1
89 1
90 2
91 100
92 SELECT c1 FROM t1 WHERE c1 <> SOME (SELECT c1 FROM t2);
93 c1
94 1
95 2
96 100
97 DROP TABLE t1;
98 DROP TABLE t2;
99 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
100 INSERT INTO t1 VALUES (null,null);
101 INSERT INTO t1 VALUES (1,'');
102 INSERT INTO t1 VALUES (2,'abcde');
103 INSERT INTO t1 VALUES (100,'abcdefghij');
104 CREATE TABLE t2 (c1 INT);
105 INSERT INTO t2 VALUES (null);
106 INSERT INTO t2 VALUES (2);
107 INSERT INTO t2 VALUES (100);
108 SELECT c1 FROM t1 WHERE c1 > SOME (SELECT c1 FROM t2);
109 c1
110 100
111 SELECT c1 FROM t1 WHERE c1 >= SOME (SELECT c1 FROM t2);
112 c1
113 2
114 100
115 SELECT c1 FROM t1 WHERE c1 = SOME (SELECT c1 FROM t2);
116 c1
117 2
118 100
119 SELECT c1 FROM t1 WHERE c1 <= SOME (SELECT c1 FROM t2);
120 c1
121 1
122 2
123 100
124 SELECT c1 FROM t1 WHERE c1 <> SOME (SELECT c1 FROM t2);
125 c1
126 1
127 2
128 100
129 DROP TABLE t1;
130 DROP TABLE t2;