Replace ja_JP locale by C (contrib/pg_hint_plan)

dmpgpro · dmpgpro · commit 613e20c0ee00 · 2016-11-09T20:14:40.000+03:00
diff --git a/contrib/pg_hint_plan/expected/init.out b/contrib/pg_hint_plan/expected/init.out
@@ -38,7 +38,7 @@ CREATE INDEX p2_ununi_id_val_idx ON p2 (val);
 CREATE INDEX p2_val_idx_1 ON p2 USING hash (val);
 WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE INDEX p2_val_id_idx ON p2 (val, id);
-CREATE INDEX p2_val_idx2 ON p2 (val COLLATE "ja_JP");
+CREATE INDEX p2_val_idx2 ON p2 (val COLLATE "C");
 CREATE INDEX p2_val_idx3 ON p2 (val varchar_ops);
 CREATE INDEX p2_val_idx4 ON p2 (val DESC NULLS LAST);
 CREATE INDEX p2_val_idx5 ON p2 (val NULLS FIRST);
diff --git a/contrib/pg_hint_plan/expected/ut-init.out b/contrib/pg_hint_plan/expected/ut-init.out
@@ -26,7 +26,7 @@ CREATE TABLE s1.t3 (LIKE s1.t1 INCLUDING ALL);
 CREATE TABLE s1.t4 (LIKE s1.t1 INCLUDING ALL);
 CREATE TABLE s2.t1 (LIKE s1.t1 INCLUDING ALL);
 CREATE TABLE s1.p1 (LIKE s1.t1 INCLUDING ALL);
-CREATE UNIQUE INDEX p1_parent ON s1.p1 USING btree (c4 COLLATE "ja_JP" varchar_ops ASC NULLS LAST, (c1 * 2 < 100)) WHERE c1 < 10;
+CREATE UNIQUE INDEX p1_parent ON s1.p1 USING btree (c4 COLLATE "C" varchar_ops ASC NULLS LAST, (c1 * 2 < 100)) WHERE c1 < 10;
 CREATE TABLE s1.p2 (LIKE s1.t1 INCLUDING ALL);
 CREATE TABLE s1.p1c1 (LIKE s1.p1 INCLUDING ALL, CHECK (c1 <= 100)) INHERITS(s1.p1);
 NOTICE:  merging column "c1" with inherited definition
diff --git a/contrib/pg_hint_plan/sql/init.sql b/contrib/pg_hint_plan/sql/init.sql
@@ -23,7 +23,7 @@ CREATE UNIQUE INDEX p2_val_idx ON p2 (val);
 CREATE INDEX p2_ununi_id_val_idx ON p2 (val);
 CREATE INDEX p2_val_idx_1 ON p2 USING hash (val);
 CREATE INDEX p2_val_id_idx ON p2 (val, id);
-CREATE INDEX p2_val_idx2 ON p2 (val COLLATE "ja_JP");
+CREATE INDEX p2_val_idx2 ON p2 (val COLLATE "C");
 CREATE INDEX p2_val_idx3 ON p2 (val varchar_ops);
 CREATE INDEX p2_val_idx4 ON p2 (val DESC NULLS LAST);
 CREATE INDEX p2_val_idx5 ON p2 (val NULLS FIRST);
diff --git a/contrib/pg_hint_plan/sql/ut-init.sql b/contrib/pg_hint_plan/sql/ut-init.sql
@@ -30,7 +30,7 @@ CREATE TABLE s1.t3 (LIKE s1.t1 INCLUDING ALL);
 CREATE TABLE s1.t4 (LIKE s1.t1 INCLUDING ALL);
 CREATE TABLE s2.t1 (LIKE s1.t1 INCLUDING ALL);
 CREATE TABLE s1.p1 (LIKE s1.t1 INCLUDING ALL);
-CREATE UNIQUE INDEX p1_parent ON s1.p1 USING btree (c4 COLLATE "ja_JP" varchar_ops ASC NULLS LAST, (c1 * 2 < 100)) WHERE c1 < 10;
+CREATE UNIQUE INDEX p1_parent ON s1.p1 USING btree (c4 COLLATE "C" varchar_ops ASC NULLS LAST, (c1 * 2 < 100)) WHERE c1 < 10;
 CREATE TABLE s1.p2 (LIKE s1.t1 INCLUDING ALL);
 CREATE TABLE s1.p1c1 (LIKE s1.p1 INCLUDING ALL, CHECK (c1 <= 100)) INHERITS(s1.p1);
 CREATE TABLE s1.p1c2 (LIKE s1.p1 INCLUDING ALL, CHECK (c1 > 100 AND c1 <= 200)) INHERITS(s1.p1);
