Move a test item because of a change of an error message

[pgdbmsstats/pg_dbms_stats.git] / expected / ut-9.3.out

diff --git a/expected/ut-9.3.out b/expected/ut-9.3.out
index 6ea66ce..d25c962 100644 (file)
--- a/expected/ut-9.3.out
+++ b/expected/ut-9.3.out
@@ -10226,3 +10226,69 @@ QUERY:  SELECT *   FROM dbms_stats.column_stats_locked WHERE starelid = $1    AN
 ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
 DROP TABLE s0.st4 CASCADE;
 NOTICE:  drop cascades to view s0.vst4
+/*
+ * No.20-1 confirm change at 1.3.5. Moved from ut-common.sql at 1.3.11
+ */
+SELECT CURRENT_USER;
+ current_user 
+--------------
+ super_user
+(1 row)
+
+CREATE TABLE s0.st4 (a int, b text);
+CREATE INDEX i_st4_a on s0.st4 (a);
+CREATE VIEW s0.vst4 AS select * FROM s0.st4;
+GRANT SELECT ON s0.vst4 TO regular_user;
+INSERT INTO s0.st4 (SELECT a, a::text FROM generate_series(0, 999) a);
+ANALYZE s0.st4;
+SELECT dbms_stats.lock('s0.st4');
+  lock  
+--------
+ s0.st4
+(1 row)
+
+DELETE FROM s0.st4;
+INSERT INTO s0.st4 (SELECT 1, a::text FROM generate_series(0, 999) a);
+ANALYZE s0.st4;
+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
+           QUERY PLAN            
+---------------------------------
+ Index Scan using i_st4_a on st4
+   Index Cond: (a = 1)
+(2 rows)
+
+EXPLAIN (COSTS OFF) SELECT * FROM s0.st4  WHERE a = 1;
+           QUERY PLAN            
+---------------------------------
+ Index Scan using i_st4_a on st4
+   Index Cond: (a = 1)
+(2 rows)
+
+SET SESSION AUTHORIZATION regular_user;
+EXPLAIN (COSTS OFF) SELECT * FROM s0.st4  WHERE a = 1;
+ERROR:  permission denied for relation st4
+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
+           QUERY PLAN            
+---------------------------------
+ Index Scan using i_st4_a on st4
+   Index Cond: (a = 1)
+(2 rows)
+
+SET pg_dbms_stats.use_locked_stats TO off;
+EXPLAIN (COSTS OFF) SELECT * FROM s0.vst4 WHERE a = 1;
+    QUERY PLAN     
+-------------------
+ Seq Scan on st4
+   Filter: (a = 1)
+(2 rows)
+
+\c - super_user
+ALTER TABLE dbms_stats.relation_stats_locked OWNER TO super_user;
+SELECT dbms_stats.unlock('s0.st4');
+ unlock 
+--------
+ s0.st4
+(1 row)
+
+DROP TABLE s0.st4 CASCADE;
+NOTICE:  drop cascades to view s0.vst4