From 6fef1bcd1eb27e0cb6a953cccc9ab32c414ef00d Mon Sep 17 00:00:00 2001 From: Kyotaro Horiguchi Date: Fri, 19 May 2017 10:52:29 +0900 Subject: [PATCH] Revert 4183e27cf1da4f67686f8bfaad3f9f42745c9c33. The commit assumes mistakenly too-old version of PostgreSQL. At least as of 9.4.12 it is not needed. --- expected/pg_hint_plan.out | 1 - expected/ut-A.out | 2 -- expected/ut-S.out | 1 - 3 files changed, 4 deletions(-) diff --git a/expected/pg_hint_plan.out b/expected/pg_hint_plan.out index d040535..c5790c8 100644 --- a/expected/pg_hint_plan.out +++ b/expected/pg_hint_plan.out @@ -6529,7 +6529,6 @@ error hint: (13 rows) EXPLAIN (COSTS false) SELECT val FROM p2 WHERE val >= '50' AND val <= '51' AND p2.ctid = '(1,1)'; -LOG: lc_collate_is_c: LC_COLLATE is "ja_JP.UTF8" QUERY PLAN ----------------------------------------------------------------------------------------- Append diff --git a/expected/ut-A.out b/expected/ut-A.out index 3e19caf..7ba9017 100644 --- a/expected/ut-A.out +++ b/expected/ut-A.out @@ -161,8 +161,6 @@ INSERT INTO hint_plan.hints (norm_query_string, application_name, hints) '', 'SeqScan(t1)'); EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1; -LOG: lc_collate_is_c: LC_COLLATE is "ja_JP.UTF8" -CONTEXT: SQL statement "SELECT hints FROM hint_plan.hints WHERE norm_query_string = $1 AND ( application_name = $2 OR application_name = '' ) ORDER BY application_name DESC" LOG: pg_hint_plan: used hint: SeqScan(t1) diff --git a/expected/ut-S.out b/expected/ut-S.out index b52d534..519f8ea 100644 --- a/expected/ut-S.out +++ b/expected/ut-S.out @@ -4339,7 +4339,6 @@ error hint: -- No. S-3-4-28 EXPLAIN (COSTS false) SELECT c4 FROM s1.ti1 WHERE lower(c4) >= '1'; -LOG: lc_collate_is_c: LC_COLLATE is "ja_JP.UTF8" QUERY PLAN ------------------------------------ Seq Scan on ti1 -- 2.11.0