Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit2379107

Browse files
author
Artur Zakirov
committed
Tests fixed
1 parent250ae46 commit2379107

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
DELETEFROM test_rum;
3535

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

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp