Skip to content

Commit d0be593

Browse files
ildusildus
committed
Add btree tests
1 parent 3bc7e0a commit d0be593

File tree

3 files changed

+67
-10
lines changed

3 files changed

+67
-10
lines changed

‎expected/search.out‎

Lines changed: 49 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -58,10 +58,57 @@ SELECT count(*) FROM test_tsvector2 WHERE a @@ '!no_such_lexeme';
5858
-------
5959
508
6060
(1 row)
61-
CREATE INDEX wowidx ON test_tsvector2 USING gin (a);
6261
SET enable_seqscan=OFF;
62+
CREATE INDEX wowidx ON test_tsvector2 USING btree(a);
63+
SELECT count(*) FROM test_tsvector2 WHERE a > 'lq d7 i4 7w y0 qt gw ch o6 eo';
64+
count
65+
-------
66+
499
67+
(1 row)
68+
69+
SELECT count(*) FROM test_tsvector2 WHERE a < 'lq d7 i4 7w y0 qt gw ch o6 eo';
70+
count
71+
-------
72+
8
73+
(1 row)
74+
75+
SELECT count(*) FROM test_tsvector2 WHERE a >= 'lq d7 i4 7w y0 qt gw ch o6 eo';
76+
count
77+
-------
78+
500
79+
(1 row)
80+
81+
SELECT count(*) FROM test_tsvector2 WHERE a <= 'lq d7 i4 7w y0 qt gw ch o6 eo';
82+
count
83+
-------
84+
9
85+
(1 row)
86+
87+
SELECT count(*) FROM test_tsvector2 WHERE a = 'lq d7 i4 7w y0 qt gw ch o6 eo';
88+
count
89+
-------
90+
1
91+
(1 row)
92+
93+
SELECT count(*) FROM test_tsvector2 WHERE a <> 'lq d7 i4 7w y0 qt gw ch o6 eo';
94+
count
95+
-------
96+
507
97+
(1 row)
98+
99+
EXPLAIN (COSTS OFF) SELECT count(*) FROM test_tsvector2 WHERE a <> 'lq d7 i4 7w y0 qt gw ch o6 eo';
100+
QUERY PLAN
101+
-----------------------------------------------------------------------------------------------------------
102+
Aggregate
103+
-> Bitmap Heap Scan on test_tsvector2
104+
Filter: (a <> '''7w'' ''ch'' ''d7'' ''eo'' ''gw'' ''i4'' ''lq'' ''o6'' ''qt'' ''y0'''::tsvector2)
105+
-> Bitmap Index Scan on wowidx
106+
(4 rows)
107+
108+
DROP INDEX wowidx;
109+
CREATE INDEX wowidx ON test_tsvector2 USING gin (a);
63110
-- GIN only supports bitmapscan, so no need to test plain indexscan
64-
explain (costs off) SELECT count(*) FROM test_tsvector2 WHERE a @@ 'wr|qh';
111+
EXPLAIN (COSTS OFF) SELECT count(*) FROM test_tsvector2 WHERE a @@ 'wr|qh';
65112
QUERY PLAN
66113
-------------------------------------------------------------
67114
Aggregate

‎init.sql‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -293,11 +293,11 @@ CREATE OPERATOR FAMILY tsvector2_ops USING gin;
293293
-- btree support
294294
CREATE OPERATOR CLASS bt_tsvector2_ops DEFAULT
295295
FOR TYPE tsvector2 USING btree FAMILY tsvector2_ops AS
296-
OPERATOR 1 <,
297-
OPERATOR 2 <=,
298-
OPERATOR 3 =,
299-
OPERATOR 4 >=,
300-
OPERATOR 5 >,
296+
OPERATOR 1 < (tsvector2, tsvector2),
297+
OPERATOR 2 <= (tsvector2, tsvector2),
298+
OPERATOR 3 = (tsvector2, tsvector2),
299+
OPERATOR 4 >= (tsvector2, tsvector2),
300+
OPERATOR 5 > (tsvector2, tsvector2),
301301
FUNCTION 1 tsvector2_cmp(tsvector2, tsvector2);
302302

303303
-- gin support

‎sql/search.sql‎

Lines changed: 13 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -51,12 +51,22 @@ RESET enable_bitmapscan;
5151

5252
DROP INDEX wowidx;
5353

54-
CREATE INDEX wowidx ON test_tsvector2 USING gin (a);
55-
5654
SET enable_seqscan=OFF;
55+
56+
CREATE INDEX wowidx ON test_tsvector2 USING btree(a);
57+
SELECT count(*) FROM test_tsvector2 WHERE a > 'lq d7 i4 7w y0 qt gw ch o6 eo';
58+
SELECT count(*) FROM test_tsvector2 WHERE a < 'lq d7 i4 7w y0 qt gw ch o6 eo';
59+
SELECT count(*) FROM test_tsvector2 WHERE a >= 'lq d7 i4 7w y0 qt gw ch o6 eo';
60+
SELECT count(*) FROM test_tsvector2 WHERE a <= 'lq d7 i4 7w y0 qt gw ch o6 eo';
61+
SELECT count(*) FROM test_tsvector2 WHERE a = 'lq d7 i4 7w y0 qt gw ch o6 eo';
62+
SELECT count(*) FROM test_tsvector2 WHERE a <> 'lq d7 i4 7w y0 qt gw ch o6 eo';
63+
EXPLAIN (COSTS OFF) SELECT count(*) FROM test_tsvector2 WHERE a <> 'lq d7 i4 7w y0 qt gw ch o6 eo';
64+
DROP INDEX wowidx;
65+
66+
CREATE INDEX wowidx ON test_tsvector2 USING gin (a);
5767
-- GIN only supports bitmapscan, so no need to test plain indexscan
5868

59-
explain (costs off) SELECT count(*) FROM test_tsvector2 WHERE a @@ 'wr|qh';
69+
EXPLAIN (COSTS OFF) SELECT count(*) FROM test_tsvector2 WHERE a @@ 'wr|qh';
6070

6171
SELECT count(*) FROM test_tsvector2 WHERE a @@ 'wr|qh';
6272
SELECT count(*) FROM test_tsvector2 WHERE a @@ 'wr&qh';

0 commit comments

Comments
 (0)