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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
# name: test/sql/optimizer/test_rowid_pushdown.test
# group: [optimizer]
statement ok
PRAGMA enable_verification
statement ok
CREATE TABLE t1 AS SELECT i + 100 as x FROM range(250000) AS t(i);
query I
SELECT * FROM t1 where rowid = 6;
----
106
query II
EXPLAIN SELECT * FROM t1 where rowid = 6;
----
physical_plan <REGEX>:.*Filters: rowid=6.*
query I
SELECT * FROM t1 where rowid = 200000;
----
200100
query II
EXPLAIN SELECT * FROM t1 where rowid = 200000;
----
physical_plan <REGEX>:.*Filters: rowid=200000.*
query I
SELECT * FROM t1 where rowid IN (SELECT rowid FROM t1 ORDER BY rowid DESC LIMIT 10) ORDER BY rowid;
----
250090
250091
250092
250093
250094
250095
250096
250097
250098
250099
# IN filter
query I
SELECT * FROM t1 where rowid IN (6, 9) ORDER BY ALL;
----
106
109
query II
EXPLAIN SELECT * FROM t1 where rowid IN (6, 9);
----
physical_plan <REGEX>:.*Filters:.*rowid.*IN.*(6.*9).*
# OR clause
query I
SELECT * FROM t1 where rowid = 6 OR rowid = 9 ORDER BY ALL;
----
106
109
query II
EXPLAIN SELECT * FROM t1 where rowid = 6 OR rowid = 9 ORDER BY ALL;
----
physical_plan <REGEX>:.*Filters:.*rowid.*6.*rowid.*9.*
|
