Fix regression tests to work for PG12.
/*+ Set(enable_seqscan 100)Set(seq_page_cost on)*/
EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
INFO: parameter "enable_seqscan" requires a Boolean value
-INFO: parameter "seq_page_cost" requires a numeric value
+INFO: invalid value for parameter "seq_page_cost": "on"
LOG: pg_hint_plan:
used hint:
not used hint:
$$ VOLATILE LANGUAGE plpgsql;
vacuum analyze t1;
SET pg_hint_plan.enable_hint = false;
+SELECT pg_sleep(1);
+ pg_sleep
+----------
+
+(1 row)
+
SELECT reset_stats_and_wait();
reset_stats_and_wait
----------------------
EXPLAIN (COSTS false) UPDATE s1.p1 SET c4 = c4 WHERE c1 = 1;
LOG: available indexes for IndexScan(p1): p1_pkey
LOG: available indexes for IndexScan(p1c1): p1c1_pkey
+LOG: available indexes for IndexScan(p1): p1_pkey
+LOG: available indexes for IndexScan(p1c1): p1c1_pkey
LOG: pg_hint_plan:
used hint:
IndexScan(p1 p1_pkey)
-- Hints on unhintable relations are just ignored
/*+Parallel(p1 5 hard) Parallel(s1 3 hard) IndexScan(ft1) SeqScan(cte1)
TidScan(fs1) IndexScan(t) IndexScan(*VALUES*) */
+\o results/ut-W.tmpout
EXPLAIN (COSTS false) SELECT id FROM p1_c1_c1 as s1 TABLESAMPLE SYSTEM(10)
UNION ALL
SELECT id FROM ft1
duplication hint:
error hint:
- QUERY PLAN
------------------------------------------------------------------------------------------------
+\o
+\! sql/maskout2.sh results/ut-W.tmpout
+ QUERY PLAN
+--(snip..)
Append
-> Result
-> Append
-> Sample Scan on p1_c1_c1 s1
Sampling: system ('10'::real)
-> Foreign Scan on ft1
- Foreign File: /home/horiguti/work/pg_hint_plan/pg_hint_plan/data/data.csv
+ Foreign File: (snip..)
-> Gather
Workers Planned: 5
-> Parallel Append
--- /dev/null
+#! /bin/sh
+cat $1 | \
+sed 's/^-\+$/--(snip..)/;s/^\( \+Foreign File: \).*$/\1 (snip..)/'
$$ VOLATILE LANGUAGE plpgsql;
vacuum analyze t1;
SET pg_hint_plan.enable_hint = false;
+SELECT pg_sleep(1);
SELECT reset_stats_and_wait();
SELECT dynsql1(9000);
SELECT pg_sleep(1);
-- Hints on unhintable relations are just ignored
/*+Parallel(p1 5 hard) Parallel(s1 3 hard) IndexScan(ft1) SeqScan(cte1)
TidScan(fs1) IndexScan(t) IndexScan(*VALUES*) */
+\o results/ut-W.tmpout
EXPLAIN (COSTS false) SELECT id FROM p1_c1_c1 as s1 TABLESAMPLE SYSTEM(10)
UNION ALL
SELECT id FROM ft1
SELECT userid FROM pg_stat_statements fs1
UNION ALL
SELECT x FROM (VALUES (1), (2), (3)) t(x);
-
+\o
+\! sql/maskout2.sh results/ut-W.tmpout
ALTER SYSTEM SET session_preload_libraries TO DEFAULT;
SELECT pg_reload_conf();