修订版 | 58d0999225fc9ad081868b1463ea648080e73535 (tree) |
---|---|
时间 | 2018-06-18 17:16:42 |
作者 | Kyotaro Horiguchi <horiguchi.kyotaro@lab....> |
Commiter | Kyotaro Horiguchi |
Move a test item because of a change of an error message
One error messages has been changed replacing the word 'relation' with
'table' and this hits the ut-common test case. Moved the test case
into ut-<version> files.
@@ -10054,3 +10054,69 @@ QUERY: SELECT * FROM dbms_stats.column_stats_locked WHERE starelid = $1 AN | ||
10054 | 10054 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
10055 | 10055 | DROP TABLE s0.st4 CASCADE; |
10056 | 10056 | NOTICE: drop cascades to view s0.vst4 |
10057 | +/* | |
10058 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
10059 | + */ | |
10060 | +SELECT CURRENT_USER; | |
10061 | + current_user | |
10062 | +-------------- | |
10063 | + super_user | |
10064 | +(1 row) | |
10065 | + | |
10066 | +CREATE TABLE s0.st4 (a int, b text); | |
10067 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
10068 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
10069 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
10070 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
10071 | +ANALYZE s0.st4; | |
10072 | +SELECT dbms_stats.lock('s0.st4'); | |
10073 | + lock | |
10074 | +-------- | |
10075 | + s0.st4 | |
10076 | +(1 row) | |
10077 | + | |
10078 | +DELETE FROM s0.st4; | |
10079 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
10080 | +ANALYZE s0.st4; | |
10081 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10082 | + QUERY PLAN | |
10083 | +--------------------------------- | |
10084 | + Index Scan using i_st4_a on st4 | |
10085 | + Index Cond: (a = 1) | |
10086 | +(2 rows) | |
10087 | + | |
10088 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10089 | + QUERY PLAN | |
10090 | +--------------------------------- | |
10091 | + Index Scan using i_st4_a on st4 | |
10092 | + Index Cond: (a = 1) | |
10093 | +(2 rows) | |
10094 | + | |
10095 | +SET SESSION AUTHORIZATION regular_user; | |
10096 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10097 | +ERROR: permission denied for relation st4 | |
10098 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10099 | + QUERY PLAN | |
10100 | +--------------------------------- | |
10101 | + Index Scan using i_st4_a on st4 | |
10102 | + Index Cond: (a = 1) | |
10103 | +(2 rows) | |
10104 | + | |
10105 | +SET pg_dbms_stats.use_locked_stats TO off; | |
10106 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10107 | + QUERY PLAN | |
10108 | +------------------- | |
10109 | + Seq Scan on st4 | |
10110 | + Filter: (a = 1) | |
10111 | +(2 rows) | |
10112 | + | |
10113 | +\c - super_user | |
10114 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
10115 | +SELECT dbms_stats.unlock('s0.st4'); | |
10116 | + unlock | |
10117 | +-------- | |
10118 | + s0.st4 | |
10119 | +(1 row) | |
10120 | + | |
10121 | +DROP TABLE s0.st4 CASCADE; | |
10122 | +NOTICE: drop cascades to view s0.vst4 |
@@ -10054,3 +10054,69 @@ QUERY: SELECT * FROM dbms_stats.column_stats_locked WHERE starelid = $1 AN | ||
10054 | 10054 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
10055 | 10055 | DROP TABLE s0.st4 CASCADE; |
10056 | 10056 | NOTICE: drop cascades to view s0.vst4 |
10057 | +/* | |
10058 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
10059 | + */ | |
10060 | +SELECT CURRENT_USER; | |
10061 | + current_user | |
10062 | +-------------- | |
10063 | + super_user | |
10064 | +(1 row) | |
10065 | + | |
10066 | +CREATE TABLE s0.st4 (a int, b text); | |
10067 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
10068 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
10069 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
10070 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
10071 | +ANALYZE s0.st4; | |
10072 | +SELECT dbms_stats.lock('s0.st4'); | |
10073 | + lock | |
10074 | +-------- | |
10075 | + s0.st4 | |
10076 | +(1 row) | |
10077 | + | |
10078 | +DELETE FROM s0.st4; | |
10079 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
10080 | +ANALYZE s0.st4; | |
10081 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10082 | + QUERY PLAN | |
10083 | +--------------------------------- | |
10084 | + Index Scan using i_st4_a on st4 | |
10085 | + Index Cond: (a = 1) | |
10086 | +(2 rows) | |
10087 | + | |
10088 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10089 | + QUERY PLAN | |
10090 | +--------------------------------- | |
10091 | + Index Scan using i_st4_a on st4 | |
10092 | + Index Cond: (a = 1) | |
10093 | +(2 rows) | |
10094 | + | |
10095 | +SET SESSION AUTHORIZATION regular_user; | |
10096 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10097 | +ERROR: permission denied for table st4 | |
10098 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10099 | + QUERY PLAN | |
10100 | +--------------------------------- | |
10101 | + Index Scan using i_st4_a on st4 | |
10102 | + Index Cond: (a = 1) | |
10103 | +(2 rows) | |
10104 | + | |
10105 | +SET pg_dbms_stats.use_locked_stats TO off; | |
10106 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10107 | + QUERY PLAN | |
10108 | +------------------- | |
10109 | + Seq Scan on st4 | |
10110 | + Filter: (a = 1) | |
10111 | +(2 rows) | |
10112 | + | |
10113 | +\c - super_user | |
10114 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
10115 | +SELECT dbms_stats.unlock('s0.st4'); | |
10116 | + unlock | |
10117 | +-------- | |
10118 | + s0.st4 | |
10119 | +(1 row) | |
10120 | + | |
10121 | +DROP TABLE s0.st4 CASCADE; | |
10122 | +NOTICE: drop cascades to view s0.vst4 |
@@ -10226,3 +10226,69 @@ QUERY: SELECT * FROM dbms_stats.column_stats_locked WHERE starelid = $1 AN | ||
10226 | 10226 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
10227 | 10227 | DROP TABLE s0.st4 CASCADE; |
10228 | 10228 | NOTICE: drop cascades to view s0.vst4 |
10229 | +/* | |
10230 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
10231 | + */ | |
10232 | +SELECT CURRENT_USER; | |
10233 | + current_user | |
10234 | +-------------- | |
10235 | + super_user | |
10236 | +(1 row) | |
10237 | + | |
10238 | +CREATE TABLE s0.st4 (a int, b text); | |
10239 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
10240 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
10241 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
10242 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
10243 | +ANALYZE s0.st4; | |
10244 | +SELECT dbms_stats.lock('s0.st4'); | |
10245 | + lock | |
10246 | +-------- | |
10247 | + s0.st4 | |
10248 | +(1 row) | |
10249 | + | |
10250 | +DELETE FROM s0.st4; | |
10251 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
10252 | +ANALYZE s0.st4; | |
10253 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10254 | + QUERY PLAN | |
10255 | +--------------------------------- | |
10256 | + Index Scan using i_st4_a on st4 | |
10257 | + Index Cond: (a = 1) | |
10258 | +(2 rows) | |
10259 | + | |
10260 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10261 | + QUERY PLAN | |
10262 | +--------------------------------- | |
10263 | + Index Scan using i_st4_a on st4 | |
10264 | + Index Cond: (a = 1) | |
10265 | +(2 rows) | |
10266 | + | |
10267 | +SET SESSION AUTHORIZATION regular_user; | |
10268 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10269 | +ERROR: permission denied for relation st4 | |
10270 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10271 | + QUERY PLAN | |
10272 | +--------------------------------- | |
10273 | + Index Scan using i_st4_a on st4 | |
10274 | + Index Cond: (a = 1) | |
10275 | +(2 rows) | |
10276 | + | |
10277 | +SET pg_dbms_stats.use_locked_stats TO off; | |
10278 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10279 | + QUERY PLAN | |
10280 | +------------------- | |
10281 | + Seq Scan on st4 | |
10282 | + Filter: (a = 1) | |
10283 | +(2 rows) | |
10284 | + | |
10285 | +\c - super_user | |
10286 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
10287 | +SELECT dbms_stats.unlock('s0.st4'); | |
10288 | + unlock | |
10289 | +-------- | |
10290 | + s0.st4 | |
10291 | +(1 row) | |
10292 | + | |
10293 | +DROP TABLE s0.st4 CASCADE; | |
10294 | +NOTICE: drop cascades to view s0.vst4 |
@@ -10224,3 +10224,69 @@ QUERY: SELECT * FROM dbms_stats.column_stats_locked WHERE starelid = $1 AN | ||
10224 | 10224 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
10225 | 10225 | DROP TABLE s0.st4 CASCADE; |
10226 | 10226 | NOTICE: drop cascades to view s0.vst4 |
10227 | +/* | |
10228 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
10229 | + */ | |
10230 | +SELECT CURRENT_USER; | |
10231 | + current_user | |
10232 | +-------------- | |
10233 | + super_user | |
10234 | +(1 row) | |
10235 | + | |
10236 | +CREATE TABLE s0.st4 (a int, b text); | |
10237 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
10238 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
10239 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
10240 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
10241 | +ANALYZE s0.st4; | |
10242 | +SELECT dbms_stats.lock('s0.st4'); | |
10243 | + lock | |
10244 | +-------- | |
10245 | + s0.st4 | |
10246 | +(1 row) | |
10247 | + | |
10248 | +DELETE FROM s0.st4; | |
10249 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
10250 | +ANALYZE s0.st4; | |
10251 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10252 | + QUERY PLAN | |
10253 | +--------------------------------- | |
10254 | + Index Scan using i_st4_a on st4 | |
10255 | + Index Cond: (a = 1) | |
10256 | +(2 rows) | |
10257 | + | |
10258 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10259 | + QUERY PLAN | |
10260 | +--------------------------------- | |
10261 | + Index Scan using i_st4_a on st4 | |
10262 | + Index Cond: (a = 1) | |
10263 | +(2 rows) | |
10264 | + | |
10265 | +SET SESSION AUTHORIZATION regular_user; | |
10266 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10267 | +ERROR: permission denied for relation st4 | |
10268 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10269 | + QUERY PLAN | |
10270 | +--------------------------------- | |
10271 | + Index Scan using i_st4_a on st4 | |
10272 | + Index Cond: (a = 1) | |
10273 | +(2 rows) | |
10274 | + | |
10275 | +SET pg_dbms_stats.use_locked_stats TO off; | |
10276 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10277 | + QUERY PLAN | |
10278 | +------------------- | |
10279 | + Seq Scan on st4 | |
10280 | + Filter: (a = 1) | |
10281 | +(2 rows) | |
10282 | + | |
10283 | +\c - super_user | |
10284 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
10285 | +SELECT dbms_stats.unlock('s0.st4'); | |
10286 | + unlock | |
10287 | +-------- | |
10288 | + s0.st4 | |
10289 | +(1 row) | |
10290 | + | |
10291 | +DROP TABLE s0.st4 CASCADE; | |
10292 | +NOTICE: drop cascades to view s0.vst4 |
@@ -10225,3 +10225,69 @@ QUERY: SELECT * FROM dbms_stats.column_stats_locked WHERE starelid = $1 AN | ||
10225 | 10225 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
10226 | 10226 | DROP TABLE s0.st4 CASCADE; |
10227 | 10227 | NOTICE: drop cascades to view s0.vst4 |
10228 | +/* | |
10229 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
10230 | + */ | |
10231 | +SELECT CURRENT_USER; | |
10232 | + current_user | |
10233 | +-------------- | |
10234 | + super_user | |
10235 | +(1 row) | |
10236 | + | |
10237 | +CREATE TABLE s0.st4 (a int, b text); | |
10238 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
10239 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
10240 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
10241 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
10242 | +ANALYZE s0.st4; | |
10243 | +SELECT dbms_stats.lock('s0.st4'); | |
10244 | + lock | |
10245 | +-------- | |
10246 | + s0.st4 | |
10247 | +(1 row) | |
10248 | + | |
10249 | +DELETE FROM s0.st4; | |
10250 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
10251 | +ANALYZE s0.st4; | |
10252 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10253 | + QUERY PLAN | |
10254 | +--------------------------------- | |
10255 | + Index Scan using i_st4_a on st4 | |
10256 | + Index Cond: (a = 1) | |
10257 | +(2 rows) | |
10258 | + | |
10259 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10260 | + QUERY PLAN | |
10261 | +--------------------------------- | |
10262 | + Index Scan using i_st4_a on st4 | |
10263 | + Index Cond: (a = 1) | |
10264 | +(2 rows) | |
10265 | + | |
10266 | +SET SESSION AUTHORIZATION regular_user; | |
10267 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10268 | +ERROR: permission denied for relation st4 | |
10269 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10270 | + QUERY PLAN | |
10271 | +--------------------------------- | |
10272 | + Index Scan using i_st4_a on st4 | |
10273 | + Index Cond: (a = 1) | |
10274 | +(2 rows) | |
10275 | + | |
10276 | +SET pg_dbms_stats.use_locked_stats TO off; | |
10277 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10278 | + QUERY PLAN | |
10279 | +------------------- | |
10280 | + Seq Scan on st4 | |
10281 | + Filter: (a = 1) | |
10282 | +(2 rows) | |
10283 | + | |
10284 | +\c - super_user | |
10285 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
10286 | +SELECT dbms_stats.unlock('s0.st4'); | |
10287 | + unlock | |
10288 | +-------- | |
10289 | + s0.st4 | |
10290 | +(1 row) | |
10291 | + | |
10292 | +DROP TABLE s0.st4 CASCADE; | |
10293 | +NOTICE: drop cascades to view s0.vst4 |
@@ -10054,3 +10054,69 @@ QUERY: SELECT * FROM dbms_stats.column_stats_locked WHERE starelid = $1 AN | ||
10054 | 10054 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
10055 | 10055 | DROP TABLE s0.st4 CASCADE; |
10056 | 10056 | NOTICE: drop cascades to view s0.vst4 |
10057 | +/* | |
10058 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
10059 | + */ | |
10060 | +SELECT CURRENT_USER; | |
10061 | + current_user | |
10062 | +-------------- | |
10063 | + super_user | |
10064 | +(1 row) | |
10065 | + | |
10066 | +CREATE TABLE s0.st4 (a int, b text); | |
10067 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
10068 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
10069 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
10070 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
10071 | +ANALYZE s0.st4; | |
10072 | +SELECT dbms_stats.lock('s0.st4'); | |
10073 | + lock | |
10074 | +-------- | |
10075 | + s0.st4 | |
10076 | +(1 row) | |
10077 | + | |
10078 | +DELETE FROM s0.st4; | |
10079 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
10080 | +ANALYZE s0.st4; | |
10081 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10082 | + QUERY PLAN | |
10083 | +--------------------------------- | |
10084 | + Index Scan using i_st4_a on st4 | |
10085 | + Index Cond: (a = 1) | |
10086 | +(2 rows) | |
10087 | + | |
10088 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10089 | + QUERY PLAN | |
10090 | +--------------------------------- | |
10091 | + Index Scan using i_st4_a on st4 | |
10092 | + Index Cond: (a = 1) | |
10093 | +(2 rows) | |
10094 | + | |
10095 | +SET SESSION AUTHORIZATION regular_user; | |
10096 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
10097 | +ERROR: permission denied for relation st4 | |
10098 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10099 | + QUERY PLAN | |
10100 | +--------------------------------- | |
10101 | + Index Scan using i_st4_a on st4 | |
10102 | + Index Cond: (a = 1) | |
10103 | +(2 rows) | |
10104 | + | |
10105 | +SET pg_dbms_stats.use_locked_stats TO off; | |
10106 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
10107 | + QUERY PLAN | |
10108 | +------------------- | |
10109 | + Seq Scan on st4 | |
10110 | + Filter: (a = 1) | |
10111 | +(2 rows) | |
10112 | + | |
10113 | +\c - super_user | |
10114 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
10115 | +SELECT dbms_stats.unlock('s0.st4'); | |
10116 | + unlock | |
10117 | +-------- | |
10118 | + s0.st4 | |
10119 | +(1 row) | |
10120 | + | |
10121 | +DROP TABLE s0.st4 CASCADE; | |
10122 | +NOTICE: drop cascades to view s0.vst4 |
@@ -2747,72 +2747,7 @@ ERROR: permission denied for schema dbms_stats | ||
2747 | 2747 | LINE 1: SELECT count(*) FROM dbms_stats.stats WHERE false; |
2748 | 2748 | ^ |
2749 | 2749 | RESET SESSION AUTHORIZATION; |
2750 | -/* | |
2751 | - * No.20-1 confirm change at 1.3.5. | |
2752 | - */ | |
2753 | -SELECT CURRENT_USER; | |
2754 | - current_user | |
2755 | --------------- | |
2756 | - super_user | |
2757 | -(1 row) | |
2758 | - | |
2759 | -CREATE TABLE s0.st4 (a int, b text); | |
2760 | -CREATE INDEX i_st4_a on s0.st4 (a); | |
2761 | -CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
2762 | -GRANT SELECT ON s0.vst4 TO regular_user; | |
2763 | -INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
2764 | -ANALYZE s0.st4; | |
2765 | -SELECT dbms_stats.lock('s0.st4'); | |
2766 | - lock | |
2767 | --------- | |
2768 | - s0.st4 | |
2769 | -(1 row) | |
2770 | - | |
2771 | -DELETE FROM s0.st4; | |
2772 | -INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
2773 | -ANALYZE s0.st4; | |
2774 | -EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2775 | - QUERY PLAN | |
2776 | ---------------------------------- | |
2777 | - Index Scan using i_st4_a on st4 | |
2778 | - Index Cond: (a = 1) | |
2779 | -(2 rows) | |
2780 | - | |
2781 | -EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2782 | - QUERY PLAN | |
2783 | ---------------------------------- | |
2784 | - Index Scan using i_st4_a on st4 | |
2785 | - Index Cond: (a = 1) | |
2786 | -(2 rows) | |
2787 | - | |
2788 | -SET SESSION AUTHORIZATION regular_user; | |
2789 | -EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2790 | -ERROR: permission denied for relation st4 | |
2791 | -EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2792 | - QUERY PLAN | |
2793 | ---------------------------------- | |
2794 | - Index Scan using i_st4_a on st4 | |
2795 | - Index Cond: (a = 1) | |
2796 | -(2 rows) | |
2797 | - | |
2798 | -SET pg_dbms_stats.use_locked_stats TO off; | |
2799 | -EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2800 | - QUERY PLAN | |
2801 | -------------------- | |
2802 | - Seq Scan on st4 | |
2803 | - Filter: (a = 1) | |
2804 | -(2 rows) | |
2805 | - | |
2806 | -\c - super_user | |
2807 | -ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
2808 | -SELECT dbms_stats.unlock('s0.st4'); | |
2809 | - unlock | |
2810 | --------- | |
2811 | - s0.st4 | |
2812 | -(1 row) | |
2813 | - | |
2814 | -DROP TABLE s0.st4 CASCADE; | |
2815 | -NOTICE: drop cascades to view s0.vst4 | |
2750 | +-- No.20 has been moved out to ut-xx.sql | |
2816 | 2751 | /* |
2817 | 2752 | * No.21 anyarray stuff |
2818 | 2753 | */ |
@@ -2796,3 +2796,34 @@ EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | ||
2796 | 2796 | \c - super_user |
2797 | 2797 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
2798 | 2798 | DROP TABLE s0.st4 CASCADE; |
2799 | + | |
2800 | +/* | |
2801 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
2802 | + */ | |
2803 | +SELECT CURRENT_USER; | |
2804 | +CREATE TABLE s0.st4 (a int, b text); | |
2805 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
2806 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
2807 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
2808 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
2809 | +ANALYZE s0.st4; | |
2810 | +SELECT dbms_stats.lock('s0.st4'); | |
2811 | +DELETE FROM s0.st4; | |
2812 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
2813 | +ANALYZE s0.st4; | |
2814 | + | |
2815 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2816 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2817 | + | |
2818 | +SET SESSION AUTHORIZATION regular_user; | |
2819 | + | |
2820 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2821 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2822 | + | |
2823 | +SET pg_dbms_stats.use_locked_stats TO off; | |
2824 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2825 | +\c - super_user | |
2826 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
2827 | + | |
2828 | +SELECT dbms_stats.unlock('s0.st4'); | |
2829 | +DROP TABLE s0.st4 CASCADE; |
@@ -2796,3 +2796,34 @@ EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | ||
2796 | 2796 | \c - super_user |
2797 | 2797 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
2798 | 2798 | DROP TABLE s0.st4 CASCADE; |
2799 | + | |
2800 | +/* | |
2801 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
2802 | + */ | |
2803 | +SELECT CURRENT_USER; | |
2804 | +CREATE TABLE s0.st4 (a int, b text); | |
2805 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
2806 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
2807 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
2808 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
2809 | +ANALYZE s0.st4; | |
2810 | +SELECT dbms_stats.lock('s0.st4'); | |
2811 | +DELETE FROM s0.st4; | |
2812 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
2813 | +ANALYZE s0.st4; | |
2814 | + | |
2815 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2816 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2817 | + | |
2818 | +SET SESSION AUTHORIZATION regular_user; | |
2819 | + | |
2820 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2821 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2822 | + | |
2823 | +SET pg_dbms_stats.use_locked_stats TO off; | |
2824 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2825 | +\c - super_user | |
2826 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
2827 | + | |
2828 | +SELECT dbms_stats.unlock('s0.st4'); | |
2829 | +DROP TABLE s0.st4 CASCADE; |
@@ -2796,3 +2796,34 @@ EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | ||
2796 | 2796 | \c - super_user |
2797 | 2797 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
2798 | 2798 | DROP TABLE s0.st4 CASCADE; |
2799 | + | |
2800 | +/* | |
2801 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
2802 | + */ | |
2803 | +SELECT CURRENT_USER; | |
2804 | +CREATE TABLE s0.st4 (a int, b text); | |
2805 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
2806 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
2807 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
2808 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
2809 | +ANALYZE s0.st4; | |
2810 | +SELECT dbms_stats.lock('s0.st4'); | |
2811 | +DELETE FROM s0.st4; | |
2812 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
2813 | +ANALYZE s0.st4; | |
2814 | + | |
2815 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2816 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2817 | + | |
2818 | +SET SESSION AUTHORIZATION regular_user; | |
2819 | + | |
2820 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2821 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2822 | + | |
2823 | +SET pg_dbms_stats.use_locked_stats TO off; | |
2824 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2825 | +\c - super_user | |
2826 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
2827 | + | |
2828 | +SELECT dbms_stats.unlock('s0.st4'); | |
2829 | +DROP TABLE s0.st4 CASCADE; |
@@ -2796,3 +2796,34 @@ EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | ||
2796 | 2796 | \c - super_user |
2797 | 2797 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
2798 | 2798 | DROP TABLE s0.st4 CASCADE; |
2799 | + | |
2800 | +/* | |
2801 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
2802 | + */ | |
2803 | +SELECT CURRENT_USER; | |
2804 | +CREATE TABLE s0.st4 (a int, b text); | |
2805 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
2806 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
2807 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
2808 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
2809 | +ANALYZE s0.st4; | |
2810 | +SELECT dbms_stats.lock('s0.st4'); | |
2811 | +DELETE FROM s0.st4; | |
2812 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
2813 | +ANALYZE s0.st4; | |
2814 | + | |
2815 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2816 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2817 | + | |
2818 | +SET SESSION AUTHORIZATION regular_user; | |
2819 | + | |
2820 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2821 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2822 | + | |
2823 | +SET pg_dbms_stats.use_locked_stats TO off; | |
2824 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2825 | +\c - super_user | |
2826 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
2827 | + | |
2828 | +SELECT dbms_stats.unlock('s0.st4'); | |
2829 | +DROP TABLE s0.st4 CASCADE; |
@@ -2796,3 +2796,34 @@ EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | ||
2796 | 2796 | \c - super_user |
2797 | 2797 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
2798 | 2798 | DROP TABLE s0.st4 CASCADE; |
2799 | + | |
2800 | +/* | |
2801 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
2802 | + */ | |
2803 | +SELECT CURRENT_USER; | |
2804 | +CREATE TABLE s0.st4 (a int, b text); | |
2805 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
2806 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
2807 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
2808 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
2809 | +ANALYZE s0.st4; | |
2810 | +SELECT dbms_stats.lock('s0.st4'); | |
2811 | +DELETE FROM s0.st4; | |
2812 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
2813 | +ANALYZE s0.st4; | |
2814 | + | |
2815 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2816 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2817 | + | |
2818 | +SET SESSION AUTHORIZATION regular_user; | |
2819 | + | |
2820 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2821 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2822 | + | |
2823 | +SET pg_dbms_stats.use_locked_stats TO off; | |
2824 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2825 | +\c - super_user | |
2826 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
2827 | + | |
2828 | +SELECT dbms_stats.unlock('s0.st4'); | |
2829 | +DROP TABLE s0.st4 CASCADE; |
@@ -2796,3 +2796,34 @@ EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | ||
2796 | 2796 | \c - super_user |
2797 | 2797 | ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; |
2798 | 2798 | DROP TABLE s0.st4 CASCADE; |
2799 | + | |
2800 | +/* | |
2801 | + * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11 | |
2802 | + */ | |
2803 | +SELECT CURRENT_USER; | |
2804 | +CREATE TABLE s0.st4 (a int, b text); | |
2805 | +CREATE INDEX i_st4_a on s0.st4 (a); | |
2806 | +CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
2807 | +GRANT SELECT ON s0.vst4 TO regular_user; | |
2808 | +INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
2809 | +ANALYZE s0.st4; | |
2810 | +SELECT dbms_stats.lock('s0.st4'); | |
2811 | +DELETE FROM s0.st4; | |
2812 | +INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
2813 | +ANALYZE s0.st4; | |
2814 | + | |
2815 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2816 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2817 | + | |
2818 | +SET SESSION AUTHORIZATION regular_user; | |
2819 | + | |
2820 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
2821 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2822 | + | |
2823 | +SET pg_dbms_stats.use_locked_stats TO off; | |
2824 | +EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
2825 | +\c - super_user | |
2826 | +ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
2827 | + | |
2828 | +SELECT dbms_stats.unlock('s0.st4'); | |
2829 | +DROP TABLE s0.st4 CASCADE; |
@@ -1163,36 +1163,7 @@ SELECT count(*) FROM dbms_stats.column_stats_locked WHERE false; | ||
1163 | 1163 | SELECT count(*) FROM dbms_stats.stats WHERE false; |
1164 | 1164 | RESET SESSION AUTHORIZATION; |
1165 | 1165 | |
1166 | -/* | |
1167 | - * No.20-1 confirm change at 1.3.5. | |
1168 | - */ | |
1169 | -SELECT CURRENT_USER; | |
1170 | -CREATE TABLE s0.st4 (a int, b text); | |
1171 | -CREATE INDEX i_st4_a on s0.st4 (a); | |
1172 | -CREATE VIEW s0.vst4 AS select * FROM s0.st4; | |
1173 | -GRANT SELECT ON s0.vst4 TO regular_user; | |
1174 | -INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a); | |
1175 | -ANALYZE s0.st4; | |
1176 | -SELECT dbms_stats.lock('s0.st4'); | |
1177 | -DELETE FROM s0.st4; | |
1178 | -INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a); | |
1179 | -ANALYZE s0.st4; | |
1180 | - | |
1181 | -EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
1182 | -EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
1183 | - | |
1184 | -SET SESSION AUTHORIZATION regular_user; | |
1185 | - | |
1186 | -EXPLAIN (COSTS OFF) SELECT * FROM s0.st4 WHERE a = 1; | |
1187 | -EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
1188 | - | |
1189 | -SET pg_dbms_stats.use_locked_stats TO off; | |
1190 | -EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1; | |
1191 | -\c - super_user | |
1192 | -ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user; | |
1193 | - | |
1194 | -SELECT dbms_stats.unlock('s0.st4'); | |
1195 | -DROP TABLE s0.st4 CASCADE; | |
1166 | +-- No.20 has been moved out to ut-xx.sql | |
1196 | 1167 | |
1197 | 1168 | /* |
1198 | 1169 | * No.21 anyarray stuff |