aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndrew Dunstan <andrew@dunslane.net>2014-03-23 20:18:06 -0400
committerAndrew Dunstan <andrew@dunslane.net>2014-03-23 20:18:06 -0400
commitab22b149c60a10b842e3ec7fe3eb3b0b66c6611a (patch)
tree4dd154ad3326670024e35e12207b2681c9c8b32a
parentca07cd59b24e00e428ed26716754244cec7f56b7 (diff)
downloadpostgresql-ab22b149c60a10b842e3ec7fe3eb3b0b66c6611a.tar.gz
postgresql-ab22b149c60a10b842e3ec7fe3eb3b0b66c6611a.zip
Do jsonb regression test input in the conventional way.
This should make the buildfarm happier.
-rw-r--r--src/test/regress/expected/create_table.out3
-rw-r--r--src/test/regress/expected/jsonb.out2
-rw-r--r--src/test/regress/expected/jsonb_1.out2
-rw-r--r--src/test/regress/expected/sanity_check.out1
-rw-r--r--src/test/regress/input/copy.source2
-rw-r--r--src/test/regress/output/copy.source1
-rw-r--r--src/test/regress/output/misc.source3
-rw-r--r--src/test/regress/sql/create_table.sql4
-rw-r--r--src/test/regress/sql/jsonb.sql3
9 files changed, 13 insertions, 8 deletions
diff --git a/src/test/regress/expected/create_table.out b/src/test/regress/expected/create_table.out
index ade60c0258a..167d02d039e 100644
--- a/src/test/regress/expected/create_table.out
+++ b/src/test/regress/expected/create_table.out
@@ -196,6 +196,9 @@ CREATE TABLE array_index_op_test (
i int4[],
t text[]
);
+CREATE TABLE testjsonb (
+ j jsonb
+);
CREATE TABLE IF NOT EXISTS test_tsvector(
t text,
a tsvector
diff --git a/src/test/regress/expected/jsonb.out b/src/test/regress/expected/jsonb.out
index e25483d2f53..f368530a193 100644
--- a/src/test/regress/expected/jsonb.out
+++ b/src/test/regress/expected/jsonb.out
@@ -457,8 +457,6 @@ SELECT '{"x":"y"}'::jsonb <> '{"x":"z"}'::jsonb;
t
(1 row)
-CREATE TABLE testjsonb (j jsonb);
-\copy testjsonb FROM 'data/jsonb.data'
-- containment
SELECT jsonb_contains('{"a":"b", "b":1, "c":null}', '{"a":"b"}');
jsonb_contains
diff --git a/src/test/regress/expected/jsonb_1.out b/src/test/regress/expected/jsonb_1.out
index 06af5c8252a..856c55af717 100644
--- a/src/test/regress/expected/jsonb_1.out
+++ b/src/test/regress/expected/jsonb_1.out
@@ -457,8 +457,6 @@ SELECT '{"x":"y"}'::jsonb <> '{"x":"z"}'::jsonb;
t
(1 row)
-CREATE TABLE testjsonb (j jsonb);
-\copy testjsonb FROM 'data/jsonb.data'
-- containment
SELECT jsonb_contains('{"a":"b", "b":1, "c":null}', '{"a":"b"}');
jsonb_contains
diff --git a/src/test/regress/expected/sanity_check.out b/src/test/regress/expected/sanity_check.out
index a62a3e3ebc6..111d24ca6b8 100644
--- a/src/test/regress/expected/sanity_check.out
+++ b/src/test/regress/expected/sanity_check.out
@@ -160,6 +160,7 @@ test_range_excl|t
test_range_gist|t
test_range_spgist|t
test_tsvector|f
+testjsonb|f
text_tbl|f
time_tbl|f
timestamp_tbl|f
diff --git a/src/test/regress/input/copy.source b/src/test/regress/input/copy.source
index 80f911fea85..cb13606d141 100644
--- a/src/test/regress/input/copy.source
+++ b/src/test/regress/input/copy.source
@@ -41,6 +41,8 @@ COPY hash_f8_heap FROM '@abs_srcdir@/data/hash.data';
COPY test_tsvector FROM '@abs_srcdir@/data/tsearch.data';
+COPY testjsonb FROM '@abs_srcdir@/data/jsonb.data';
+
-- the data in this file has a lot of duplicates in the index key
-- fields, leading to long bucket chains and lots of table expansion.
-- this is therefore a stress test of the bucket overflow code (unlike
diff --git a/src/test/regress/output/copy.source b/src/test/regress/output/copy.source
index e8951c5b739..b7e372d61b4 100644
--- a/src/test/regress/output/copy.source
+++ b/src/test/regress/output/copy.source
@@ -22,6 +22,7 @@ COPY hash_name_heap FROM '@abs_srcdir@/data/hash.data';
COPY hash_txt_heap FROM '@abs_srcdir@/data/hash.data';
COPY hash_f8_heap FROM '@abs_srcdir@/data/hash.data';
COPY test_tsvector FROM '@abs_srcdir@/data/tsearch.data';
+COPY testjsonb FROM '@abs_srcdir@/data/jsonb.data';
-- the data in this file has a lot of duplicates in the index key
-- fields, leading to long bucket chains and lots of table expansion.
-- this is therefore a stress test of the bucket overflow code (unlike
diff --git a/src/test/regress/output/misc.source b/src/test/regress/output/misc.source
index e194f7ed5cd..7015bfda2c2 100644
--- a/src/test/regress/output/misc.source
+++ b/src/test/regress/output/misc.source
@@ -680,6 +680,7 @@ SELECT user_relns() AS user_relns
test_range_gist
test_range_spgist
test_tsvector
+ testjsonb
text_tbl
time_tbl
timestamp_tbl
@@ -697,7 +698,7 @@ SELECT user_relns() AS user_relns
tvvmv
varchar_tbl
xacttest
-(119 rows)
+(120 rows)
SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer')));
name
diff --git a/src/test/regress/sql/create_table.sql b/src/test/regress/sql/create_table.sql
index a050e8b6d1a..8eb246b817e 100644
--- a/src/test/regress/sql/create_table.sql
+++ b/src/test/regress/sql/create_table.sql
@@ -232,6 +232,10 @@ CREATE TABLE array_index_op_test (
t text[]
);
+CREATE TABLE testjsonb (
+ j jsonb
+);
+
CREATE TABLE IF NOT EXISTS test_tsvector(
t text,
a tsvector
diff --git a/src/test/regress/sql/jsonb.sql b/src/test/regress/sql/jsonb.sql
index 1ef49138bb8..e460b1bb2a7 100644
--- a/src/test/regress/sql/jsonb.sql
+++ b/src/test/regress/sql/jsonb.sql
@@ -115,9 +115,6 @@ SELECT '{"x":"y"}'::jsonb = '{"x":"z"}'::jsonb;
SELECT '{"x":"y"}'::jsonb <> '{"x":"y"}'::jsonb;
SELECT '{"x":"y"}'::jsonb <> '{"x":"z"}'::jsonb;
-CREATE TABLE testjsonb (j jsonb);
-\copy testjsonb FROM 'data/jsonb.data'
-
-- containment
SELECT jsonb_contains('{"a":"b", "b":1, "c":null}', '{"a":"b"}');
SELECT jsonb_contains('{"a":"b", "b":1, "c":null}', '{"a":"b", "c":null}');