Skip to content

Commit 2379107

Browse files
author
Artur Zakirov
committed
Tests fixed
1 parent 250ae46 commit 2379107

File tree

6 files changed

+1917683
-0
lines changed

6 files changed

+1917683
-0
lines changed

‎expected/rum.out

Lines changed: 18 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -83,3 +83,21 @@ SELECT count(*) from test_rum;
8383
0
8484
(1 row)
8585

86+
CREATE TABLE tst (i int4, t tsvector);
87+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(1,100000) i;
88+
CREATE INDEX tstidx ON tst USING rum (t rum_tsvector_ops);
89+
DELETE FROM tst WHERE i = 1;
90+
VACUUM tst;
91+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(10001,11000) i;
92+
DELETE FROM tst WHERE i = 2;
93+
VACUUM tst;
94+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(11001,12000) i;
95+
DELETE FROM tst WHERE i = 3;
96+
VACUUM tst;
97+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(12001,13000) i;
98+
DELETE FROM tst WHERE i = 4;
99+
VACUUM tst;
100+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(13001,14000) i;
101+
DELETE FROM tst WHERE i = 5;
102+
VACUUM tst;
103+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(14001,15000) i;

‎results/rum.out

Lines changed: 103 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,103 @@
1+
CREATE EXTENSION rum;
2+
CREATE TABLE test_rum( t text, a tsvector );
3+
CREATE TRIGGER tsvectorupdate
4+
BEFORE UPDATE OR INSERT ON test_rum
5+
FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('a', 'pg_catalog.english', 't');
6+
CREATE INDEX rumidx ON test_rum USING rum (a rum_tsvector_ops);
7+
\copy test_rum(t) from 'data/rum.data';
8+
SET enable_seqscan=off;
9+
SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'ever|wrote');
10+
count
11+
-------
12+
2
13+
(1 row)
14+
15+
SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'have&wish');
16+
count
17+
-------
18+
1
19+
(1 row)
20+
21+
SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'knew&brain');
22+
count
23+
-------
24+
0
25+
(1 row)
26+
27+
SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'among');
28+
count
29+
-------
30+
1
31+
(1 row)
32+
33+
SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'structure&ancient');
34+
count
35+
-------
36+
1
37+
(1 row)
38+
39+
SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', '(complimentary|sight)&(sending|heart)');
40+
count
41+
-------
42+
2
43+
(1 row)
44+
45+
INSERT INTO test_rum (t) VALUES ('foo bar foo the over foo qq bar');
46+
INSERT INTO test_rum (t) VALUES ('345 qwerty copyright');
47+
INSERT INTO test_rum (t) VALUES ('345 qwerty');
48+
INSERT INTO test_rum (t) VALUES ('A fat cat has just eaten a rat.');
49+
SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'bar');
50+
count
51+
-------
52+
1
53+
(1 row)
54+
55+
SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'qwerty&345');
56+
count
57+
-------
58+
2
59+
(1 row)
60+
61+
SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', '345');
62+
count
63+
-------
64+
2
65+
(1 row)
66+
67+
SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'rat');
68+
count
69+
-------
70+
1
71+
(1 row)
72+
73+
SELECT a FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'bar') ORDER BY a;
74+
a
75+
------------------------------
76+
'bar':2,8 'foo':1,3,6 'qq':7
77+
(1 row)
78+
79+
DELETE FROM test_rum;
80+
SELECT count(*) from test_rum;
81+
count
82+
-------
83+
0
84+
(1 row)
85+
86+
CREATE TABLE tst (i int4, t tsvector);
87+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(1,100000) i;
88+
CREATE INDEX tstidx ON tst USING rum (t rum_tsvector_ops);
89+
DELETE FROM tst WHERE i = 1;
90+
VACUUM tst;
91+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(10001,11000) i;
92+
DELETE FROM tst WHERE i = 2;
93+
VACUUM tst;
94+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(11001,12000) i;
95+
DELETE FROM tst WHERE i = 3;
96+
VACUUM tst;
97+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(12001,13000) i;
98+
DELETE FROM tst WHERE i = 4;
99+
VACUUM tst;
100+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(13001,14000) i;
101+
DELETE FROM tst WHERE i = 5;
102+
VACUUM tst;
103+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(14001,15000) i;

‎sql/rum.sql

Lines changed: 24 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -34,3 +34,27 @@ SELECT a FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'bar') ORDER
3434
DELETE FROM test_rum;
3535

3636
SELECT count(*) from test_rum;
37+
38+
CREATE TABLE tst (i int4, t tsvector);
39+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(1,100000) i;
40+
CREATE INDEX tstidx ON tst USING rum (t rum_tsvector_ops);
41+
42+
DELETE FROM tst WHERE i = 1;
43+
VACUUM tst;
44+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(10001,11000) i;
45+
46+
DELETE FROM tst WHERE i = 2;
47+
VACUUM tst;
48+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(11001,12000) i;
49+
50+
DELETE FROM tst WHERE i = 3;
51+
VACUUM tst;
52+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(12001,13000) i;
53+
54+
DELETE FROM tst WHERE i = 4;
55+
VACUUM tst;
56+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(13001,14000) i;
57+
58+
DELETE FROM tst WHERE i = 5;
59+
VACUUM tst;
60+
INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(14001,15000) i;

0 commit comments

Comments
 (0)