1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
$t1 = SELECT * FROM AS_TABLE([
<|k: 1, v: 1|>,
<|k: 2, v: 2|>,
<|k: 3, v: 3|>,
<|k: 4, v: 4|>,
<|k: 5, v: 5|>,
]);
$t2 = SELECT * FROM AS_TABLE([
<|k: 6, v: 6|>,
<|k: 7, v: 7|>,
<|k: 8, v: 8|>,
<|k: 9, v: 9|>,
<|k: 10, v: 10|>,
]);
$t3 = SELECT * FROM AS_TABLE([
<|k: 11, v: 11|>,
<|k: 12, v: 12|>,
<|k: 13, v: 13|>,
<|k: 14, v: 14|>,
<|k: 15, v: 15|>,
]);
SELECT
1 IN ( SELECT k FROM $t1 ),
1 IN (( SELECT k FROM $t1 )),
1 IN (((SELECT k FROM $t1))),
1 IN ( SELECT k FROM $t1 UNION SELECT k FROM $t2 ),
6 IN ( SELECT k FROM $t1 UNION SELECT k FROM $t2 ),
1 IN ( SELECT k FROM $t1 UNION (SELECT k FROM $t2)),
6 IN ( SELECT k FROM $t1 UNION (SELECT k FROM $t2)),
1 IN ((SELECT k FROM $t1) UNION SELECT k FROM $t2 ),
6 IN ((SELECT k FROM $t1) UNION SELECT k FROM $t2 ),
1 IN ((SELECT k FROM $t1) UNION (SELECT k FROM $t2)),
6 IN ((SELECT k FROM $t1) UNION (SELECT k FROM $t2)),
1 IN (SELECT k FROM $t1 UNION SELECT k FROM $t2 UNION SELECT k FROM $t3),
6 IN (SELECT k FROM $t1 UNION SELECT k FROM $t2 UNION SELECT k FROM $t3),
11 IN (SELECT k FROM $t1 UNION SELECT k FROM $t2 UNION SELECT k FROM $t3),
;
|
