Commit: 3557b1cc33ee9240632875aaedbbe49117e3bd31 - pg_dbms_stats (git)

Commit MetaInfo

• Revision: 3557b1cc33ee9240632875aaedbbe49117e3bd31 (tree)
• Time: 2014-12-01 11:13:51
• Author: Kyotaro Horiguchi <horiguchi.kyotaro@lab....>
• Commiter: Kyotaro Horiguchi

Log Message

Fix target version of 9.4 regtests, which was no harm.

Change Summary

• modified: input/ut_imp_exp-9.4.source
• modified: output/ut_imp_exp-9.4.source

Incremental Difference

--- a/input/ut_imp_exp-9.4.source
+++ b/input/ut_imp_exp-9.4.source
@@ -1,7 +1,7 @@
 \pset null '(null)'
 CREATE TABLE s0.st3();
 /*
- * No.16-1 export_plain_stats-9.3.sql.sample
+ * No.16-1 export_plain_stats-9.4.sql.sample
  */
 -- No.16-1-1
 ANALYZE;
@@ -34,90 +34,92 @@ UPDATE dbms_stats.column_stats_locked SET
     stavalues3 = stavalues1,
     stavalues4 = stavalues4,
     stavalues5 = stavalues5;
-\i doc/export_plain_stats-9.3.sql.sample
+\i doc/export_plain_stats-9.4.sql.sample
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
 -- No.16-1-2
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-3
-\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
+-- No.16-1-3-1 Actual import test
+select dbms_stats.import_database_stats('@abs_srcdir@/export_stats.dmp');
 -- No.16-1-4
-\! 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
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-5
-\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-6
-\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-7
-\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-8
-\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-9
-\! sed '/ORDER/i\\ AND c.relname = '"\'smv0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'smv0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-10
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-11
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-12
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 
 /*
- * No.16-2 export_effective_stats-9.3.sql.sample
+ * No.16-2 export_effective_stats-9.4.sql.sample
  */
 -- No.16-2-1
 VACUUM ANALYZE;
@@ -136,86 +138,86 @@ UPDATE dbms_stats.column_stats_locked
         NULL, NULL, NULL, NULL, NULL,
         NULL, NULL, NULL, NULL, NULL)
  WHERE starelid = 's0.st0'::regclass;
-\i doc/export_effective_stats-9.3.sql.sample
+\i doc/export_effective_stats-9.4.sql.sample
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
 TRUNCATE dbms_stats.work;
 -- No.16-2-2
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-3
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-4
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-5
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-6
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-7
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-8
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-9
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'smv0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'smv0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-10
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-11
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-12
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
 SELECT * FROM work_v;
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 
 /*

--- a/output/ut_imp_exp-9.4.source
+++ b/output/ut_imp_exp-9.4.source
@@ -1,7 +1,7 @@
 \pset null '(null)'
 CREATE TABLE s0.st3();
 /*
- * No.16-1 export_plain_stats-9.3.sql.sample
+ * No.16-1 export_plain_stats-9.4.sql.sample
  */
 -- No.16-1-1
 ANALYZE;
@@ -55,7 +55,7 @@ UPDATE dbms_stats.column_stats_locked SET
     stavalues3 = stavalues1,
     stavalues4 = stavalues4,
     stavalues5 = stavalues5;
-\i doc/export_plain_stats-9.3.sql.sample
+\i doc/export_plain_stats-9.4.sql.sample
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -163,8 +163,8 @@ SELECT * FROM work_v;
 
 TRUNCATE dbms_stats.work;
 -- No.16-1-2
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -261,10 +261,10 @@ SELECT * FROM work_v;
 (16 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-3
-\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -353,10 +353,17 @@ SELECT * FROM work_v;
 (8 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
+-- No.16-1-3-1 Actual import test
+select dbms_stats.import_database_stats('@abs_srcdir@/export_stats.dmp');
+ import_database_stats 
+-----------------------
+ 
+(1 row)
+
 -- No.16-1-4
-\! 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
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -437,10 +444,10 @@ SELECT * FROM work_v;
 (0 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-5
-\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -523,10 +530,10 @@ SELECT * FROM work_v;
 (2 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-6
-\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -607,10 +614,10 @@ SELECT * FROM work_v;
 (0 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-7
-\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -691,10 +698,10 @@ SELECT * FROM work_v;
 (0 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-8
-\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -776,10 +783,10 @@ SELECT * FROM work_v;
 (1 row)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-9
-\! sed '/ORDER/i\\ AND c.relname = '"\'smv0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'smv0\'" doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -863,10 +870,10 @@ SELECT * FROM work_v;
 (3 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-10
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -953,10 +960,10 @@ SELECT * FROM work_v;
 (6 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-11
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1041,10 +1048,10 @@ SELECT * FROM work_v;
 (4 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 -- No.16-1-12
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
-\i doc/export_plain_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' doc/export_plain_stats-9.4.sql.sample > doc/export_plain_stats-9.4.sql.sample_test
+\i doc/export_plain_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1125,9 +1132,9 @@ SELECT * FROM work_v;
 (0 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm doc/export_plain_stats-9.3.sql.sample_test
+\! rm doc/export_plain_stats-9.4.sql.sample_test
 /*
- * No.16-2 export_effective_stats-9.3.sql.sample
+ * No.16-2 export_effective_stats-9.4.sql.sample
  */
 -- No.16-2-1
 VACUUM ANALYZE;
@@ -1167,7 +1174,7 @@ UPDATE dbms_stats.column_stats_locked
         NULL, NULL, NULL, NULL, NULL,
         NULL, NULL, NULL, NULL, NULL)
  WHERE starelid = 's0.st0'::regclass;
-\i doc/export_effective_stats-9.3.sql.sample
+\i doc/export_effective_stats-9.4.sql.sample
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1269,8 +1276,8 @@ SELECT * FROM work_v;
 
 TRUNCATE dbms_stats.work;
 -- No.16-2-2
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1360,11 +1367,11 @@ SELECT * FROM work_v;
  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)
 (16 rows)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-3
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1446,11 +1453,11 @@ SELECT * FROM work_v;
  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)
 (8 rows)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-4
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1524,11 +1531,11 @@ SELECT * FROM work_v;
 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
 (0 rows)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-5
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1604,11 +1611,11 @@ SELECT * FROM work_v;
  s0      | 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)
 (2 rows)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-6
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1682,11 +1689,11 @@ SELECT * FROM work_v;
 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
 (0 rows)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-7
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1760,11 +1767,11 @@ SELECT * FROM work_v;
 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
 (0 rows)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-8
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1839,11 +1846,11 @@ SELECT * FROM work_v;
  s0      | sft0    |        1 |        10 |             0 |        0 | 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,5,6,7,8,9,10} | (null)     | (null)
 (1 row)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-9
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'smv0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'smv0\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1920,11 +1927,11 @@ SELECT * FROM work_v;
  s0      | smv0    |        1 |         2 |             1 |        1 | txt     | pg_catalog          | text    |        -1 | f          |          -3 |       -3 |          -3 |        2 |        3 |        4 |        1 |        5 |     22 |     23 |     24 |     21 |     25 | {-3,22}     | {-3,23}     | {-3,24}     | {-3,21}     | {-3,25}     | (null)     | (null)     | {1,test}   | (null)     | (null)
 (3 rows)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-10
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -2004,11 +2011,11 @@ SELECT * FROM work_v;
  s0      | st2     |        1 |         3 |             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}                | (null)     | (null)
 (6 rows)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-11
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -2086,11 +2093,11 @@ SELECT * FROM work_v;
  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)
 (4 rows)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-12
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
-\i doc/export_effective_stats-9.3.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' doc/export_effective_stats-9.4.sql.sample > doc/export_effective_stats-9.4.sql.sample_test
+\i doc/export_effective_stats-9.4.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -2164,7 +2171,7 @@ SELECT * FROM work_v;
 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
 (0 rows)
 
-\! rm doc/export_effective_stats-9.3.sql.sample_test
+\! rm doc/export_effective_stats-9.4.sql.sample_test
 TRUNCATE dbms_stats.work;
 /*
  * Stab function dbms_stats.import