OSDN -- 開發和下載開源軟體
繁體中文翻譯狀態 translation status for zh-tw
  • R/O
  • HTTP
  • SSH
  • HTTPS
Fork

提交

標籤
無標籤

Frequently used words (click to add to your profile)

javac++androidlinuxc#windowsobjective-ccocoa誰得qtpythonphprubygameguibathyscaphec計画中(planning stage)翻訳omegatframeworktwitterdomtestvb.netdirectxゲームエンジンbtronarduinopreviewer

Commit MetaInfo

修訂4b35543b7e4acdc4c97e888a96d98b3cf3522574 (tree)
時間2014-12-01 12:44:36
作者Kyotaro Horiguchi <horiguchi.kyotaro@lab....>
CommiterKyotaro Horiguchi

Log Message

Fixed regression tests to avoid test failure for 9.1.

A test item added in ut-common at 1.3.5 failed for 9.1 because the
error message differs from later versions. Moved it to
version-specific tests.

Change Summary

差異

--- a/expected/ut-9.1.out
+++ b/expected/ut-9.1.out
@@ -9108,3 +9108,22 @@ SELECT relid::regclass FROM dbms_stats.relation_stats_locked
91089108 s1.st0
91099109 (14 rows)
91109110
9111+-- No.15 error description. -- abnormal case.
9112+RESET SESSION AUTHORIZATION;
9113+CREATE TABLE s0.st4 (a int, b text);
9114+CREATE VIEW s0.vst4 AS select * FROM s0.st4;
9115+GRANT SELECT ON s0.vst4 TO regular_user;
9116+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
9117+/* reconnection needed to flush cache */
9118+\c - regular_user
9119+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
9120+ERROR: permission denied for schema dbms_stats
9121+LINE 1: SELECT * FROM dbms_stats.column_stats_locked WHERE stareli...
9122+ ^
9123+DETAIL: dbms_stats could not access the object as the role "regular_user".
9124+HINT: Check your settings of pg_dbms_stats.
9125+QUERY: SELECT * FROM dbms_stats.column_stats_locked WHERE starelid = $1 AND staattnum = $2 AND stainherit = $3
9126+\c - super_user
9127+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
9128+DROP TABLE s0.st4 CASCADE;
9129+NOTICE: drop cascades to view s0.vst4
--- a/expected/ut-9.2.out
+++ b/expected/ut-9.2.out
@@ -9651,3 +9651,22 @@ SELECT relid::regclass FROM dbms_stats.relation_stats_locked
96519651 s1.st0
96529652 (15 rows)
96539653
9654+-- No.15 error description. -- abnormal case.
9655+RESET SESSION AUTHORIZATION;
9656+CREATE TABLE s0.st4 (a int, b text);
9657+CREATE VIEW s0.vst4 AS select * FROM s0.st4;
9658+GRANT SELECT ON s0.vst4 TO regular_user;
9659+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
9660+/* reconnection needed to flush cache */
9661+\c - regular_user
9662+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
9663+ERROR: permission denied for schema dbms_stats
9664+LINE 1: SELECT * FROM dbms_stats.column_stats_locked WHERE stareli...
9665+ ^
9666+DETAIL: dbms_stats could not access the object as the role "regular_user".
9667+HINT: Check your settings of pg_dbms_stats.
9668+QUERY: SELECT * FROM dbms_stats.column_stats_locked WHERE starelid = $1 AND staattnum = $2 AND stainherit = $3
9669+\c - super_user
9670+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
9671+DROP TABLE s0.st4 CASCADE;
9672+NOTICE: drop cascades to view s0.vst4
--- a/expected/ut-9.3.out
+++ b/expected/ut-9.3.out
@@ -10113,3 +10113,22 @@ SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1011310113 s1.st0
1011410114 (16 rows)
1011510115
10116+-- No.15 error description. -- abnormal case.
10117+RESET SESSION AUTHORIZATION;
10118+CREATE TABLE s0.st4 (a int, b text);
10119+CREATE VIEW s0.vst4 AS select * FROM s0.st4;
10120+GRANT SELECT ON s0.vst4 TO regular_user;
10121+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
10122+/* reconnection needed to flush cache */
10123+\c - regular_user
10124+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
10125+ERROR: permission denied for schema dbms_stats
10126+LINE 1: SELECT * FROM dbms_stats.column_stats_locked WHERE stareli...
10127+ ^
10128+DETAIL: dbms_stats could not access the object as the role "regular_user".
10129+HINT: Check your settings of pg_dbms_stats.
10130+QUERY: SELECT * FROM dbms_stats.column_stats_locked WHERE starelid = $1 AND staattnum = $2 AND stainherit = $3
10131+\c - super_user
10132+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
10133+DROP TABLE s0.st4 CASCADE;
10134+NOTICE: drop cascades to view s0.vst4
--- a/expected/ut-9.4.out
+++ b/expected/ut-9.4.out
@@ -10111,3 +10111,22 @@ SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1011110111 s1.st0
1011210112 (16 rows)
1011310113
10114+-- No.15 error description. -- abnormal case.
10115+RESET SESSION AUTHORIZATION;
10116+CREATE TABLE s0.st4 (a int, b text);
10117+CREATE VIEW s0.vst4 AS select * FROM s0.st4;
10118+GRANT SELECT ON s0.vst4 TO regular_user;
10119+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
10120+/* reconnection needed to flush cache */
10121+\c - regular_user
10122+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
10123+ERROR: permission denied for schema dbms_stats
10124+LINE 1: SELECT * FROM dbms_stats.column_stats_locked WHERE stareli...
10125+ ^
10126+DETAIL: dbms_stats could not access the object as the role "regular_user".
10127+HINT: Check your settings of pg_dbms_stats.
10128+QUERY: SELECT * FROM dbms_stats.column_stats_locked WHERE starelid = $1 AND staattnum = $2 AND stainherit = $3
10129+\c - super_user
10130+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
10131+DROP TABLE s0.st4 CASCADE;
10132+NOTICE: drop cascades to view s0.vst4
--- a/expected/ut-common.out
+++ b/expected/ut-common.out
@@ -2739,20 +2739,6 @@ EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
27392739 Filter: (a = 1)
27402740 (2 rows)
27412741
2742-/*
2743- * No.20-2 error description. -- abnormal case.
2744- */
2745-RESET SESSION AUTHORIZATION;
2746-ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
2747-/* reconnection needed to flush cache */
2748-\c - regular_user
2749-EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
2750-ERROR: permission denied for schema dbms_stats
2751-LINE 1: ...elpages, reltuples, curpages, relallvisible FROM dbms_stats...
2752- ^
2753-DETAIL: dbms_stats could not access the object as the role "regular_user".
2754-HINT: Check your settings of pg_dbms_stats.
2755-QUERY: SELECT relpages, reltuples, curpages, relallvisible FROM dbms_stats.relation_stats_locked WHERE relid = $1
27562742 \c - super_user
27572743 ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
27582744 SELECT dbms_stats.unlock('s0.st4');
--- a/input/ut_imp_exp-9.2.source
+++ b/input/ut_imp_exp-9.2.source
@@ -52,6 +52,8 @@ COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
5252 SELECT * FROM work_v;
5353 TRUNCATE dbms_stats.work;
5454 \! rm doc/export_plain_stats-9.2.sql.sample_test
55+-- No.16-1-3-1 Actual import test
56+select dbms_stats.import_database_stats('@abs_srcdir@/export_stats.dmp');
5557 -- No.16-1-4
5658 \! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
5759 \i doc/export_plain_stats-9.2.sql.sample_test
--- a/input/ut_imp_exp-9.3.source
+++ b/input/ut_imp_exp-9.3.source
@@ -52,6 +52,8 @@ COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
5252 SELECT * FROM work_v;
5353 TRUNCATE dbms_stats.work;
5454 \! rm doc/export_plain_stats-9.3.sql.sample_test
55+-- No.16-1-3-1 Actual import test
56+select dbms_stats.import_database_stats('@abs_srcdir@/export_stats.dmp');
5557 -- No.16-1-4
5658 \! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
5759 \i doc/export_plain_stats-9.3.sql.sample_test
--- a/output/ut_imp_exp-9.2.source
+++ b/output/ut_imp_exp-9.2.source
@@ -347,6 +347,13 @@ SELECT * FROM work_v;
347347
348348 TRUNCATE dbms_stats.work;
349349 \! rm doc/export_plain_stats-9.2.sql.sample_test
350+-- No.16-1-3-1 Actual import test
351+select dbms_stats.import_database_stats('@abs_srcdir@/export_stats.dmp');
352+ import_database_stats
353+-----------------------
354+
355+(1 row)
356+
350357 -- No.16-1-4
351358 \! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
352359 \i doc/export_plain_stats-9.2.sql.sample_test
@@ -1144,8 +1151,8 @@ SELECT * FROM work_v;
11441151 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------------+------------+------------------------+------------+------------
11451152 public | pt0 | 0 | 0 | 0 | 0 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
11461153 public | pt0_idx | 2 | 0 | 0 | 2 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
1147- public | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2} | (null) | (null)
1148- public | st0 | 1 | 2 | 1 | 1 | name | pg_catalog | bpchar | 9 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {"test "} | (null) | (null)
1154+ public | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2} | (null) | (null) | (null) | (null)
1155+ public | st0 | 1 | 2 | 1 | 1 | name | pg_catalog | bpchar | 9 | f | 0 | 6 | -0.5 | 1 | 3 | 0 | 0 | 0 | 1054 | 1058 | 0 | 0 | 0 | {1} | {1} | (null) | (null) | (null) | {"test "} | (null) | (null) | (null) | (null)
11491156 public | st0_idx | 2 | 2 | 0 | 2 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
11501157 public | st1 | 45 | 10000 | 45 | 45 | str | pg_catalog | text | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {1,0,2} | (null) | (null)
11511158 public | st1 | 45 | 10000 | 45 | 45 | val | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,0,2} | (null) | (null)
@@ -1164,8 +1171,8 @@ SELECT * FROM work_v;
11641171 s0 | st2 | 1 | 3 | 1 | 1 | txt | pg_catalog | text | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {1,comment,test} | (null) | (null)
11651172 s0 | st2_idx | 2 | 3 | 0 | 2 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
11661173 s0 | st3 | 0 | 0 | 0 | 0 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
1167- s1 | st0 | 1 | 4 | 1 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2,3,4} | (null) | (null)
1168- s1 | st0 | 1 | 4 | 1 | 1 | num | pg_catalog | int4 | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {15,25,35,45} | (null) | (null)
1174+ s1 | st0 | 1 | 4 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2,3,4} | (null) | (null) | (null) | (null)
1175+ s1 | st0 | 1 | 4 | 1 | 1 | num | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {15,25,35,45} | (null) | (null) | (null) | (null)
11691176 (24 rows)
11701177
11711178 TRUNCATE dbms_stats.work;
@@ -1332,16 +1339,16 @@ TO STDOUT
13321339 COMMIT;
13331340 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
13341341 SELECT * FROM work_v;
1335- nspname | relname | relpages | reltuples | relallvisible | curpages | attname | nspname_of_typename | typname | atttypmod | stainherit | stanullfrac | stawidth | stadistinct | stakind1 | stakind2 | stakind3 | stakind4 | stakind5 | staop1 | staop2 | staop3 | staop4 | staop5 | stanumbers1 | stanumbers2 | stanumbers3 | stanumbers4 | stanumbers5 | stavalues1 | stavalues2 | stavalues3 | stavalues4 | stavalues5
1336----------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------------+------------+---------------+------------+------------
1337- public | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2} | (null) | (null)
1338- public | st0 | 1 | 2 | 1 | 1 | name | pg_catalog | bpchar | 9 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {"test "} | (null) | (null)
1339- s0 | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2} | (null) | (null) | (null) | (null)
1340- s0 | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | t | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2,4,5,6} | (null) | (null) | (null) | (null)
1341- s0 | st0 | 1 | 2 | 1 | 1 | num | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {10,20} | (null) | (null) | (null) | (null)
1342- s0 | st0 | 1 | 2 | 1 | 1 | num | pg_catalog | int4 | -1 | t | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {10,20,40,50,60} | (null) | (null) | (null) | (null)
1343- s1 | st0 | 1 | 4 | 1 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2,3,4} | (null) | (null)
1344- s1 | st0 | 1 | 4 | 1 | 1 | num | pg_catalog | int4 | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {15,25,35,45} | (null) | (null)
1342+ nspname | relname | relpages | reltuples | relallvisible | curpages | attname | nspname_of_typename | typname | atttypmod | stainherit | stanullfrac | stawidth | stadistinct | stakind1 | stakind2 | stakind3 | stakind4 | stakind5 | staop1 | staop2 | staop3 | staop4 | staop5 | stanumbers1 | stanumbers2 | stanumbers3 | stanumbers4 | stanumbers5 | stavalues1 | stavalues2 | stavalues3 | stavalues4 | stavalues5
1343+---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------------+------------+------------+------------+------------
1344+ public | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2} | (null) | (null) | (null) | (null)
1345+ public | st0 | 1 | 2 | 1 | 1 | name | pg_catalog | bpchar | 9 | f | 0 | 6 | -0.5 | 1 | 3 | 0 | 0 | 0 | 1054 | 1058 | 0 | 0 | 0 | {1} | {1} | (null) | (null) | (null) | {"test "} | (null) | (null) | (null) | (null)
1346+ s0 | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2} | (null) | (null) | (null) | (null)
1347+ s0 | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | t | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2,4,5,6} | (null) | (null) | (null) | (null)
1348+ s0 | st0 | 1 | 2 | 1 | 1 | num | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {10,20} | (null) | (null) | (null) | (null)
1349+ s0 | st0 | 1 | 2 | 1 | 1 | num | pg_catalog | int4 | -1 | t | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {10,20,40,50,60} | (null) | (null) | (null) | (null)
1350+ s1 | st0 | 1 | 4 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2,3,4} | (null) | (null) | (null) | (null)
1351+ s1 | st0 | 1 | 4 | 1 | 1 | num | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {15,25,35,45} | (null) | (null) | (null) | (null)
13451352 (8 rows)
13461353
13471354 \! rm doc/export_effective_stats-9.2.sql.sample_test
--- a/output/ut_imp_exp-9.3.source
+++ b/output/ut_imp_exp-9.3.source
@@ -354,6 +354,13 @@ SELECT * FROM work_v;
354354
355355 TRUNCATE dbms_stats.work;
356356 \! rm doc/export_plain_stats-9.3.sql.sample_test
357+-- No.16-1-3-1 Actual import test
358+select dbms_stats.import_database_stats('@abs_srcdir@/export_stats.dmp');
359+ import_database_stats
360+-----------------------
361+
362+(1 row)
363+
357364 -- No.16-1-4
358365 \! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
359366 \i doc/export_plain_stats-9.3.sql.sample_test
@@ -1240,8 +1247,8 @@ SELECT * FROM work_v;
12401247 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------------+------------+------------------------+------------+------------
12411248 public | pt0 | 0 | 0 | 0 | 0 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
12421249 public | pt0_idx | 2 | 0 | 0 | 2 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
1243- public | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2} | (null) | (null)
1244- public | st0 | 1 | 2 | 1 | 1 | name | pg_catalog | bpchar | 9 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {"test "} | (null) | (null)
1250+ public | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2} | (null) | (null) | (null) | (null)
1251+ public | st0 | 1 | 2 | 1 | 1 | name | pg_catalog | bpchar | 9 | f | 0 | 6 | -0.5 | 1 | 3 | 0 | 0 | 0 | 1054 | 1058 | 0 | 0 | 0 | {1} | {1} | (null) | (null) | (null) | {"test "} | (null) | (null) | (null) | (null)
12451252 public | st0_idx | 2 | 2 | 0 | 2 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
12461253 public | st1 | 45 | 10000 | 45 | 45 | str | pg_catalog | text | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {1,0,2} | (null) | (null)
12471254 public | st1 | 45 | 10000 | 45 | 45 | val | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,0,2} | (null) | (null)
@@ -1263,8 +1270,8 @@ SELECT * FROM work_v;
12631270 s0 | st2 | 1 | 3 | 1 | 1 | txt | pg_catalog | text | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {1,comment,test} | (null) | (null)
12641271 s0 | st2_idx | 2 | 3 | 0 | 2 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
12651272 s0 | st3 | 0 | 0 | 0 | 0 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
1266- s1 | st0 | 1 | 4 | 1 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2,3,4} | (null) | (null)
1267- s1 | st0 | 1 | 4 | 1 | 1 | num | pg_catalog | int4 | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {15,25,35,45} | (null) | (null)
1273+ s1 | st0 | 1 | 4 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2,3,4} | (null) | (null) | (null) | (null)
1274+ s1 | st0 | 1 | 4 | 1 | 1 | num | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {15,25,35,45} | (null) | (null) | (null) | (null)
12681275 (27 rows)
12691276
12701277 TRUNCATE dbms_stats.work;
@@ -1434,16 +1441,16 @@ TO STDOUT
14341441 COMMIT;
14351442 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
14361443 SELECT * FROM work_v;
1437- nspname | relname | relpages | reltuples | relallvisible | curpages | attname | nspname_of_typename | typname | atttypmod | stainherit | stanullfrac | stawidth | stadistinct | stakind1 | stakind2 | stakind3 | stakind4 | stakind5 | staop1 | staop2 | staop3 | staop4 | staop5 | stanumbers1 | stanumbers2 | stanumbers3 | stanumbers4 | stanumbers5 | stavalues1 | stavalues2 | stavalues3 | stavalues4 | stavalues5
1438----------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------------+------------+---------------+------------+------------
1439- public | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2} | (null) | (null)
1440- public | st0 | 1 | 2 | 1 | 1 | name | pg_catalog | bpchar | 9 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {"test "} | (null) | (null)
1441- s0 | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2} | (null) | (null) | (null) | (null)
1442- s0 | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | t | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2,4,5,6} | (null) | (null) | (null) | (null)
1443- s0 | st0 | 1 | 2 | 1 | 1 | num | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {10,20} | (null) | (null) | (null) | (null)
1444- s0 | st0 | 1 | 2 | 1 | 1 | num | pg_catalog | int4 | -1 | t | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {10,20,40,50,60} | (null) | (null) | (null) | (null)
1445- s1 | st0 | 1 | 4 | 1 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2,3,4} | (null) | (null)
1446- s1 | st0 | 1 | 4 | 1 | 1 | num | pg_catalog | int4 | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {15,25,35,45} | (null) | (null)
1444+ nspname | relname | relpages | reltuples | relallvisible | curpages | attname | nspname_of_typename | typname | atttypmod | stainherit | stanullfrac | stawidth | stadistinct | stakind1 | stakind2 | stakind3 | stakind4 | stakind5 | staop1 | staop2 | staop3 | staop4 | staop5 | stanumbers1 | stanumbers2 | stanumbers3 | stanumbers4 | stanumbers5 | stavalues1 | stavalues2 | stavalues3 | stavalues4 | stavalues5
1445+---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------------+------------+------------+------------+------------
1446+ public | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2} | (null) | (null) | (null) | (null)
1447+ public | st0 | 1 | 2 | 1 | 1 | name | pg_catalog | bpchar | 9 | f | 0 | 6 | -0.5 | 1 | 3 | 0 | 0 | 0 | 1054 | 1058 | 0 | 0 | 0 | {1} | {1} | (null) | (null) | (null) | {"test "} | (null) | (null) | (null) | (null)
1448+ s0 | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2} | (null) | (null) | (null) | (null)
1449+ s0 | st0 | 1 | 2 | 1 | 1 | id | pg_catalog | int4 | -1 | t | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2,4,5,6} | (null) | (null) | (null) | (null)
1450+ s0 | st0 | 1 | 2 | 1 | 1 | num | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {10,20} | (null) | (null) | (null) | (null)
1451+ s0 | st0 | 1 | 2 | 1 | 1 | num | pg_catalog | int4 | -1 | t | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {10,20,40,50,60} | (null) | (null) | (null) | (null)
1452+ s1 | st0 | 1 | 4 | 1 | 1 | id | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {1,2,3,4} | (null) | (null) | (null) | (null)
1453+ s1 | st0 | 1 | 4 | 1 | 1 | num | pg_catalog | int4 | -1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | (null) | {1} | (null) | (null) | (null) | {15,25,35,45} | (null) | (null) | (null) | (null)
14471454 (8 rows)
14481455
14491456 \! rm doc/export_effective_stats-9.3.sql.sample_test
--- a/sql/ut-9.1.sql
+++ b/sql/ut-9.1.sql
@@ -2575,3 +2575,19 @@ SELECT starelid, attname, stainherit FROM columns_locked_v c;
25752575 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
25762576 GROUP BY relid
25772577 ORDER BY relid;
2578+
2579+-- No.15 error description. -- abnormal case.
2580+RESET SESSION AUTHORIZATION;
2581+CREATE TABLE s0.st4 (a int, b text);
2582+CREATE VIEW s0.vst4 AS select * FROM s0.st4;
2583+GRANT SELECT ON s0.vst4 TO regular_user;
2584+
2585+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
2586+/* reconnection needed to flush cache */
2587+\c - regular_user
2588+
2589+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
2590+
2591+\c - super_user
2592+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
2593+DROP TABLE s0.st4 CASCADE;
--- a/sql/ut-9.2.sql
+++ b/sql/ut-9.2.sql
@@ -2738,3 +2738,19 @@ SELECT starelid, attname, stainherit FROM columns_locked_v c;
27382738 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
27392739 GROUP BY relid
27402740 ORDER BY relid;
2741+
2742+-- No.15 error description. -- abnormal case.
2743+RESET SESSION AUTHORIZATION;
2744+CREATE TABLE s0.st4 (a int, b text);
2745+CREATE VIEW s0.vst4 AS select * FROM s0.st4;
2746+GRANT SELECT ON s0.vst4 TO regular_user;
2747+
2748+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
2749+/* reconnection needed to flush cache */
2750+\c - regular_user
2751+
2752+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
2753+
2754+\c - super_user
2755+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
2756+DROP TABLE s0.st4 CASCADE;
--- a/sql/ut-9.3.sql
+++ b/sql/ut-9.3.sql
@@ -2733,3 +2733,19 @@ SELECT starelid, attname, stainherit FROM columns_locked_v c;
27332733 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
27342734 GROUP BY relid
27352735 ORDER BY relid;
2736+
2737+-- No.15 error description. -- abnormal case.
2738+RESET SESSION AUTHORIZATION;
2739+CREATE TABLE s0.st4 (a int, b text);
2740+CREATE VIEW s0.vst4 AS select * FROM s0.st4;
2741+GRANT SELECT ON s0.vst4 TO regular_user;
2742+
2743+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
2744+/* reconnection needed to flush cache */
2745+\c - regular_user
2746+
2747+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
2748+
2749+\c - super_user
2750+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
2751+DROP TABLE s0.st4 CASCADE;
--- a/sql/ut-9.4.sql
+++ b/sql/ut-9.4.sql
@@ -2733,3 +2733,19 @@ SELECT starelid, attname, stainherit FROM columns_locked_v c;
27332733 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
27342734 GROUP BY relid
27352735 ORDER BY relid;
2736+
2737+-- No.15 error description. -- abnormal case.
2738+RESET SESSION AUTHORIZATION;
2739+CREATE TABLE s0.st4 (a int, b text);
2740+CREATE VIEW s0.vst4 AS select * FROM s0.st4;
2741+GRANT SELECT ON s0.vst4 TO regular_user;
2742+
2743+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
2744+/* reconnection needed to flush cache */
2745+\c - regular_user
2746+
2747+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
2748+
2749+\c - super_user
2750+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
2751+DROP TABLE s0.st4 CASCADE;
--- a/sql/ut-common.sql
+++ b/sql/ut-common.sql
@@ -1163,17 +1163,6 @@ EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
11631163
11641164 SET pg_dbms_stats.use_locked_stats TO off;
11651165 EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
1166-
1167-/*
1168- * No.20-2 error description. -- abnormal case.
1169- */
1170-RESET SESSION AUTHORIZATION;
1171-ALTER TABLE dbms_stats.relation_stats_locked OWNER TO regular_user;
1172-/* reconnection needed to flush cache */
1173-\c - regular_user
1174-
1175-EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
1176-
11771166 \c - super_user
11781167 ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
11791168