1.3.1

[pgdbmsstats/pg_dbms_stats.git] / output / ut_imp_exp-9.1.source

diff --git a/output/ut_imp_exp-9.1.source b/output/ut_imp_exp-9.1.source
index 26f270b..391fe8d 100644 (file)
--- a/output/ut_imp_exp-9.1.source
+++ b/output/ut_imp_exp-9.1.source
@@ -1,7 +1,7 @@
 \pset null '(null)'
 CREATE TABLE s0.st3();
 /*
- * No.16-1 export_plain_stats.sql.sample
+ * No.16-1 export_plain_stats-9.1.sql.sample
  */
 -- No.16-1-1
 ANALYZE;
@@ -49,7 +49,7 @@ UPDATE dbms_stats._column_stats_locked SET
     stavalues2 = stavalues2,
     stavalues3 = stavalues1,
     stavalues4 = stavalues4;
-\i export_plain_stats.sql.sample
+\i export_plain_stats-9.1.sql.sample
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -148,8 +148,8 @@ SELECT * FROM work_v;
 
 TRUNCATE dbms_stats.work;
 -- No.16-1-2
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" export_plain_stats.sql.sample > export_plain_stats.sql.sample_test
-\i export_plain_stats.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
+\i export_plain_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -237,10 +237,10 @@ SELECT * FROM work_v;
 (12 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm export_plain_stats.sql.sample_test
+\! rm export_plain_stats-9.1.sql.sample_test
 -- No.16-1-3
-\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" export_plain_stats.sql.sample > export_plain_stats.sql.sample_test
-\i export_plain_stats.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
+\i export_plain_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -324,10 +324,10 @@ SELECT * FROM work_v;
 (8 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm export_plain_stats.sql.sample_test
+\! rm export_plain_stats-9.1.sql.sample_test
 -- No.16-1-4
-\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" export_plain_stats.sql.sample > export_plain_stats.sql.sample_test
-\i export_plain_stats.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
+\i export_plain_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -403,10 +403,10 @@ SELECT * FROM work_v;
 (0 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm export_plain_stats.sql.sample_test
+\! rm export_plain_stats-9.1.sql.sample_test
 -- No.16-1-5
-\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" export_plain_stats.sql.sample > export_plain_stats.sql.sample_test
-\i export_plain_stats.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
+\i export_plain_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -484,10 +484,10 @@ SELECT * FROM work_v;
 (2 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm export_plain_stats.sql.sample_test
+\! rm export_plain_stats-9.1.sql.sample_test
 -- No.16-1-6
-\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" export_plain_stats.sql.sample > export_plain_stats.sql.sample_test
-\i export_plain_stats.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
+\i export_plain_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -563,10 +563,10 @@ SELECT * FROM work_v;
 (0 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm export_plain_stats.sql.sample_test
+\! rm export_plain_stats-9.1.sql.sample_test
 -- No.16-1-7
-\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" export_plain_stats.sql.sample > export_plain_stats.sql.sample_test
-\i export_plain_stats.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
+\i export_plain_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -642,10 +642,10 @@ SELECT * FROM work_v;
 (0 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm export_plain_stats.sql.sample_test
+\! rm export_plain_stats-9.1.sql.sample_test
 -- No.16-1-8
-\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" export_plain_stats.sql.sample > export_plain_stats.sql.sample_test
-\i export_plain_stats.sql.sample_test
+\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
+\i export_plain_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -721,10 +721,10 @@ SELECT * FROM work_v;
 (0 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm export_plain_stats.sql.sample_test
+\! rm export_plain_stats-9.1.sql.sample_test
 -- No.16-1-9
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' export_plain_stats.sql.sample > export_plain_stats.sql.sample_test
-\i export_plain_stats.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
+\i export_plain_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -804,10 +804,10 @@ SELECT * FROM work_v;
 (4 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm export_plain_stats.sql.sample_test
+\! rm export_plain_stats-9.1.sql.sample_test
 -- No.16-1-10
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_plain_stats.sql.sample > export_plain_stats.sql.sample_test
-\i export_plain_stats.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
+\i export_plain_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -887,10 +887,10 @@ SELECT * FROM work_v;
 (4 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm export_plain_stats.sql.sample_test
+\! rm export_plain_stats-9.1.sql.sample_test
 -- No.16-1-11
-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' export_plain_stats.sql.sample > export_plain_stats.sql.sample_test
-\i export_plain_stats.sql.sample_test
+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
+\i export_plain_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -966,9 +966,9 @@ SELECT * FROM work_v;
 (0 rows)
 
 TRUNCATE dbms_stats.work;
-\! rm export_plain_stats.sql.sample_test
+\! rm export_plain_stats-9.1.sql.sample_test
 /*
- * No.16-2 export_effective_stats.sql.sample
+ * No.16-2 export_effective_stats-9.1.sql.sample
  */
 -- No.16-2-1
 VACUUM ANALYZE;
@@ -1006,7 +1006,7 @@ UPDATE dbms_stats._column_stats_locked
         NULL, NULL, NULL, NULL,
         NULL, NULL, NULL, NULL)
  WHERE starelid = 's0.st0'::regclass;
-\i export_effective_stats.sql.sample
+\i export_effective_stats-9.1.sql.sample
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1099,8 +1099,8 @@ SELECT * FROM work_v;
 
 TRUNCATE dbms_stats.work;
 -- No.16-2-2
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" export_effective_stats.sql.sample > export_effective_stats.sql.sample_test
-\i export_effective_stats.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
+\i export_effective_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1181,11 +1181,11 @@ SELECT * FROM work_v;
  s0      | st3     |        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)
 (12 rows)
 
-\! rm export_effective_stats.sql.sample_test
+\! rm export_effective_stats-9.1.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-3
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" export_effective_stats.sql.sample > export_effective_stats.sql.sample_test
-\i export_effective_stats.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
+\i export_effective_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1262,11 +1262,11 @@ SELECT * FROM work_v;
  s1      | st0     |        1 |         4 |        1 | num     | pg_catalog          | int4    |        -1 | f          |          -2 |       -2 |          -2 |        2 |        3 |        4 |        1 |     22 |     23 |     24 |     21 | {-2,22}     | {-2,23}     | {-2,24}     | {-2,21}     | (null)           | (null)     | {15,25,35,45} | (null)
 (8 rows)
 
-\! rm export_effective_stats.sql.sample_test
+\! rm export_effective_stats-9.1.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-4
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" export_effective_stats.sql.sample > export_effective_stats.sql.sample_test
-\i export_effective_stats.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
+\i export_effective_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1335,11 +1335,11 @@ SELECT * FROM work_v;
 ---------+---------+----------+-----------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
 (0 rows)
 
-\! rm export_effective_stats.sql.sample_test
+\! rm export_effective_stats-9.1.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-5
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" export_effective_stats.sql.sample > export_effective_stats.sql.sample_test
-\i export_effective_stats.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
+\i export_effective_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1410,11 +1410,11 @@ SELECT * FROM work_v;
  s0      | st0_idx |        2 |         2 |        2 |         | (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 export_effective_stats.sql.sample_test
+\! rm export_effective_stats-9.1.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-6
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" export_effective_stats.sql.sample > export_effective_stats.sql.sample_test
-\i export_effective_stats.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
+\i export_effective_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1483,11 +1483,11 @@ SELECT * FROM work_v;
 ---------+---------+----------+-----------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
 (0 rows)
 
-\! rm export_effective_stats.sql.sample_test
+\! rm export_effective_stats-9.1.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-7
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" export_effective_stats.sql.sample > export_effective_stats.sql.sample_test
-\i export_effective_stats.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
+\i export_effective_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1556,11 +1556,11 @@ SELECT * FROM work_v;
 ---------+---------+----------+-----------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
 (0 rows)
 
-\! rm export_effective_stats.sql.sample_test
+\! rm export_effective_stats-9.1.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-8
-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" export_effective_stats.sql.sample > export_effective_stats.sql.sample_test
-\i export_effective_stats.sql.sample_test
+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
+\i export_effective_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1629,11 +1629,11 @@ SELECT * FROM work_v;
 ---------+---------+----------+-----------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
 (0 rows)
 
-\! rm export_effective_stats.sql.sample_test
+\! rm export_effective_stats-9.1.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-9
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" export_effective_stats.sql.sample > export_effective_stats.sql.sample_test
-\i export_effective_stats.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
+\i export_effective_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1706,11 +1706,11 @@ SELECT * FROM work_v;
  s0      | st2     |        1 |         3 |        1 | id      | pg_catalog          | int4    |        -1 | f          |          -1 |       -1 |          -1 |        2 |        3 |        4 |        1 |     22 |     23 |     24 |     21 | {-1,22}     | {-1,23}     | {-1,24}     | {-1,21}     | (null)      | (null)     | {1,2,3}    | (null)
 (4 rows)
 
-\! rm export_effective_stats.sql.sample_test
+\! rm export_effective_stats-9.1.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-10
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_effective_stats.sql.sample > export_effective_stats.sql.sample_test
-\i export_effective_stats.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
+\i export_effective_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1783,11 +1783,11 @@ SELECT * FROM work_v;
  s0      | st3     |        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)
 (4 rows)
 
-\! rm export_effective_stats.sql.sample_test
+\! rm export_effective_stats-9.1.sql.sample_test
 TRUNCATE dbms_stats.work;
 -- No.16-2-11
-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' export_effective_stats.sql.sample > export_effective_stats.sql.sample_test
-\i export_effective_stats.sql.sample_test
+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
+\i export_effective_stats-9.1.sql.sample_test
 /*
  * If you want the statistics of per-relation or per-column, please modify
  * nspname, relname, and attname in 'WHERE' clause.
@@ -1856,7 +1856,7 @@ SELECT * FROM work_v;
 ---------+---------+----------+-----------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
 (0 rows)
 
-\! rm export_effective_stats.sql.sample_test
+\! rm export_effective_stats-9.1.sql.sample_test
 TRUNCATE dbms_stats.work;
 /*
  * Stab function dbms_stats.import