summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/tsearch.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/tsearch.sql')
-rw-r--r--src/test/regress/sql/tsearch.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/src/test/regress/sql/tsearch.sql b/src/test/regress/sql/tsearch.sql
index d929210998..0fa8ac4682 100644
--- a/src/test/regress/sql/tsearch.sql
+++ b/src/test/regress/sql/tsearch.sql
@@ -1,3 +1,6 @@
+-- directory paths are passed to us in environment variables
+\getenv abs_srcdir PG_ABS_SRCDIR
+
--
-- Sanity checks for text search catalogs
--
@@ -39,6 +42,17 @@ RIGHT JOIN pg_ts_config_map AS m
WHERE
tt.cfgid IS NULL OR tt.tokid IS NULL;
+-- Load some test data
+CREATE TABLE test_tsvector(
+ t text,
+ a tsvector
+);
+
+\set filename :abs_srcdir '/data/tsearch.data'
+COPY test_tsvector FROM :'filename';
+
+ANALYZE test_tsvector;
+
-- test basic text search behavior without indexes, then with
SELECT count(*) FROM test_tsvector WHERE a @@ 'wr|qh';