aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/euc_cn.out87
-rw-r--r--src/test/regress/expected/euc_jp.out87
-rw-r--r--src/test/regress/expected/euc_kr.out87
-rw-r--r--src/test/regress/expected/euc_tw.out85
-rw-r--r--src/test/regress/expected/mule_internal.out333
-rw-r--r--src/test/regress/expected/sql_ascii.out87
-rw-r--r--src/test/regress/sql/drop.sql246
-rw-r--r--src/test/regress/sql/euc_cn.sql19
-rw-r--r--src/test/regress/sql/euc_jp.sql19
-rw-r--r--src/test/regress/sql/euc_kr.sql19
-rw-r--r--src/test/regress/sql/euc_tw.sql20
-rw-r--r--src/test/regress/sql/mule_internal.sql72
-rw-r--r--src/test/regress/sql/sql_ascii.sql19
13 files changed, 0 insertions, 1180 deletions
diff --git a/src/test/regress/expected/euc_cn.out b/src/test/regress/expected/euc_cn.out
deleted file mode 100644
index 7fdb13cfe5d..00000000000
--- a/src/test/regress/expected/euc_cn.out
+++ /dev/null
@@ -1,87 +0,0 @@
-drop table 柴麻字宝囂;
-ERROR: Relation '柴麻字宝囂' does not exist
-create table 柴麻字宝囂(宝囂 text, 蛍窃催 varchar, 姥廣1A char(16));
-create index 柴麻字宝囂index1 on 柴麻字宝囂 using btree(宝囂);
-create index 柴麻字宝囂index2 on 柴麻字宝囂 using btree(蛍窃催);
-insert into 柴麻字宝囂 values('窮辻塋焼','字A01貧');
-insert into 柴麻字宝囂 values('窮辻夕侘','蛍B01嶄');
-insert into 柴麻字宝囂 values('窮辻殻會埀','繁Z01和');
-vacuum 柴麻字宝囂;
-select * from 柴麻字宝囂;
- 宝囂 | 蛍窃催 | 姥廣1a
-------------+---------+--------
- 窮辻塋焼 | 字A01貧 |
- 窮辻夕侘 | 蛍B01嶄 |
- 窮辻殻會埀 | 繁Z01和 |
-(3 rows)
-
-select * from 柴麻字宝囂 where 蛍窃催 = '繁Z01和';
- 宝囂 | 蛍窃催 | 姥廣1a
-------------+---------+--------
- 窮辻殻會埀 | 繁Z01和 |
-(1 row)
-
-select * from 柴麻字宝囂 where 蛍窃催 ~* '繁z01和';
- 宝囂 | 蛍窃催 | 姥廣1a
-------------+---------+--------
- 窮辻殻會埀 | 繁Z01和 |
-(1 row)
-
-select * from 柴麻字宝囂 where 蛍窃催 like '_Z01_';
- 宝囂 | 蛍窃催 | 姥廣1a
-------------+---------+--------
- 窮辻殻會埀 | 繁Z01和 |
-(1 row)
-
-select * from 柴麻字宝囂 where 蛍窃催 like '_Z%';
- 宝囂 | 蛍窃催 | 姥廣1a
-------------+---------+--------
- 窮辻殻會埀 | 繁Z01和 |
-(1 row)
-
-select * from 柴麻字宝囂 where 宝囂 ~ '窮辻[塒]';
- 宝囂 | 蛍窃催 | 姥廣1a
-------------+---------+--------
- 窮辻塋焼 | 字A01貧 |
- 窮辻夕侘 | 蛍B01嶄 |
-(2 rows)
-
-select * from 柴麻字宝囂 where 宝囂 ~* '窮辻[塒]';
- 宝囂 | 蛍窃催 | 姥廣1a
-------------+---------+--------
- 窮辻塋焼 | 字A01貧 |
- 窮辻夕侘 | 蛍B01嶄 |
-(2 rows)
-
-select *,character_length(宝囂) from 柴麻字宝囂;
- 宝囂 | 蛍窃催 | 姥廣1a | char_length
-------------+---------+--------+-------------
- 窮辻塋焼 | 字A01貧 | | 5
- 窮辻夕侘 | 蛍B01嶄 | | 4
- 窮辻殻會埀 | 繁Z01和 | | 5
-(3 rows)
-
-select *,octet_length(宝囂) from 柴麻字宝囂;
- 宝囂 | 蛍窃催 | 姥廣1a | octet_length
-------------+---------+--------+--------------
- 窮辻塋焼 | 字A01貧 | | 10
- 窮辻夕侘 | 蛍B01嶄 | | 8
- 窮辻殻會埀 | 繁Z01和 | | 10
-(3 rows)
-
-select *,position('' in 宝囂) from 柴麻字宝囂;
- 宝囂 | 蛍窃催 | 姥廣1a | strpos
-------------+---------+--------+--------
- 窮辻塋焼 | 字A01貧 | | 3
- 窮辻夕侘 | 蛍B01嶄 | | 0
- 窮辻殻會埀 | 繁Z01和 | | 0
-(3 rows)
-
-select *,substring(宝囂 from 3 for 4) from 柴麻字宝囂;
- 宝囂 | 蛍窃催 | 姥廣1a | substr
-------------+---------+--------+--------
- 窮辻塋焼 | 字A01貧 | | 塋焼
- 窮辻夕侘 | 蛍B01嶄 | | 夕侘
- 窮辻殻會埀 | 繁Z01和 | | 殻會埀
-(3 rows)
-
diff --git a/src/test/regress/expected/euc_jp.out b/src/test/regress/expected/euc_jp.out
deleted file mode 100644
index f95d283501b..00000000000
--- a/src/test/regress/expected/euc_jp.out
+++ /dev/null
@@ -1,87 +0,0 @@
-drop table 計算機用語;
-ERROR: table "計算機用語" is nonexistent
-create table 計算機用語 (用語 text, 分類コード varchar, 備考1Aだよ char(16));
-create index 計算機用語index1 on 計算機用語 using btree (用語);
-create index 計算機用語index2 on 計算機用語 using hash (分類コード);
-insert into 計算機用語 values('コンピュータディスプレイ','機A01上');
-insert into 計算機用語 values('コンピュータグラフィックス','分B10中');
-insert into 計算機用語 values('コンピュータプログラマー','人Z01下');
-vacuum 計算機用語;
-select * from 計算機用語;
- 用語 | 分類コード | 備考1aだよ
-----------------------------+------------+------------
- コンピュータディスプレイ | 機A01上 |
- コンピュータグラフィックス | 分B10中 |
- コンピュータプログラマー | 人Z01下 |
-(3 rows)
-
-select * from 計算機用語 where 分類コード = '人Z01下';
- 用語 | 分類コード | 備考1aだよ
---------------------------+------------+------------
- コンピュータプログラマー | 人Z01下 |
-(1 row)
-
-select * from 計算機用語 where 分類コード ~* '人z01下';
- 用語 | 分類コード | 備考1aだよ
---------------------------+------------+------------
- コンピュータプログラマー | 人Z01下 |
-(1 row)
-
-select * from 計算機用語 where 分類コード like '_Z01_';
- 用語 | 分類コード | 備考1aだよ
---------------------------+------------+------------
- コンピュータプログラマー | 人Z01下 |
-(1 row)
-
-select * from 計算機用語 where 分類コード like '_Z%';
- 用語 | 分類コード | 備考1aだよ
---------------------------+------------+------------
- コンピュータプログラマー | 人Z01下 |
-(1 row)
-
-select * from 計算機用語 where 用語 ~ 'コンピュータ[デグ]';
- 用語 | 分類コード | 備考1aだよ
-----------------------------+------------+------------
- コンピュータディスプレイ | 機A01上 |
- コンピュータグラフィックス | 分B10中 |
-(2 rows)
-
-select * from 計算機用語 where 用語 ~* 'コンピュータ[デグ]';
- 用語 | 分類コード | 備考1aだよ
-----------------------------+------------+------------
- コンピュータディスプレイ | 機A01上 |
- コンピュータグラフィックス | 分B10中 |
-(2 rows)
-
-select *,character_length(用語) from 計算機用語;
- 用語 | 分類コード | 備考1aだよ | char_length
-----------------------------+------------+------------+-------------
- コンピュータディスプレイ | 機A01上 | | 12
- コンピュータグラフィックス | 分B10中 | | 13
- コンピュータプログラマー | 人Z01下 | | 12
-(3 rows)
-
-select *,octet_length(用語) from 計算機用語;
- 用語 | 分類コード | 備考1aだよ | octet_length
-----------------------------+------------+------------+--------------
- コンピュータディスプレイ | 機A01上 | | 24
- コンピュータグラフィックス | 分B10中 | | 26
- コンピュータプログラマー | 人Z01下 | | 24
-(3 rows)
-
-select *,position('デ' in 用語) from 計算機用語;
- 用語 | 分類コード | 備考1aだよ | strpos
-----------------------------+------------+------------+--------
- コンピュータディスプレイ | 機A01上 | | 7
- コンピュータグラフィックス | 分B10中 | | 0
- コンピュータプログラマー | 人Z01下 | | 0
-(3 rows)
-
-select *,substring(用語 from 10 for 4) from 計算機用語;
- 用語 | 分類コード | 備考1aだよ | substr
-----------------------------+------------+------------+----------
- コンピュータディスプレイ | 機A01上 | | プレイ
- コンピュータグラフィックス | 分B10中 | | ィックス
- コンピュータプログラマー | 人Z01下 | | ラマー
-(3 rows)
-
diff --git a/src/test/regress/expected/euc_kr.out b/src/test/regress/expected/euc_kr.out
deleted file mode 100644
index 368525b220f..00000000000
--- a/src/test/regress/expected/euc_kr.out
+++ /dev/null
@@ -1,87 +0,0 @@
-drop table 悠潯僞遂嬢;
-ERROR: Relation '悠潯僞遂嬢' does not exist
-create table 悠潯僞遂嬢 (遂嬢 text, 歛彎坪球 varchar, 搾壱1A虞姥 char(16));
-create index 悠潯僞遂嬢index1 on 悠潯僞遂嬢 using btree (遂嬢);
-create index 悠潯僞遂嬢index2 on 悠潯僞遂嬢 using hash (歛彎坪球);
-insert into 悠潯僞遂嬢 values('陳濃斗巨什巴傾戚', '僞A01濔');
-insert into 悠潯僞遂嬢 values('陳濃斗益掘波什', '歛B10驩');
-insert into 悠潯僞遂嬢 values('陳濃斗覗稽益掘袴', '賺Z01');
-vacuum 悠潯僞遂嬢;
-select * from 悠潯僞遂嬢;
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
-------------------+----------+------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 |
- 陳濃斗益掘波什 | 歛B10驩 |
- 陳濃斗覗稽益掘袴 | 賺Z01 |
-(3 rows)
-
-select * from 悠潯僞遂嬢 where 歛彎坪球 = '賺Z01';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
-------------------+----------+------------
- 陳濃斗覗稽益掘袴 | 賺Z01 |
-(1 row)
-
-select * from 悠潯僞遂嬢 where 歛彎坪球 ~* '賺z01';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
-------------------+----------+------------
- 陳濃斗覗稽益掘袴 | 賺Z01 |
-(1 row)
-
-select * from 悠潯僞遂嬢 where 歛彎坪球 like '_Z01_';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
-------------------+----------+------------
- 陳濃斗覗稽益掘袴 | 賺Z01 |
-(1 row)
-
-select * from 悠潯僞遂嬢 where 歛彎坪球 like '_Z%';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
-------------------+----------+------------
- 陳濃斗覗稽益掘袴 | 賺Z01 |
-(1 row)
-
-select * from 悠潯僞遂嬢 where 遂嬢 ~ '陳濃斗[巨益]';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
-------------------+----------+------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 |
- 陳濃斗益掘波什 | 歛B10驩 |
-(2 rows)
-
-select * from 悠潯僞遂嬢 where 遂嬢 ~* '陳濃斗[巨益]';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
-------------------+----------+------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 |
- 陳濃斗益掘波什 | 歛B10驩 |
-(2 rows)
-
-select *,character_length(遂嬢) from 悠潯僞遂嬢;
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥 | char_length
-------------------+----------+------------+-------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 | | 8
- 陳濃斗益掘波什 | 歛B10驩 | | 7
- 陳濃斗覗稽益掘袴 | 賺Z01 | | 8
-(3 rows)
-
-select *,octet_length(遂嬢) from 悠潯僞遂嬢;
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥 | octet_length
-------------------+----------+------------+--------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 | | 16
- 陳濃斗益掘波什 | 歛B10驩 | | 14
- 陳濃斗覗稽益掘袴 | 賺Z01 | | 16
-(3 rows)
-
-select *,position('巨' in 遂嬢) from 悠潯僞遂嬢;
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥 | strpos
-------------------+----------+------------+--------
- 陳濃斗巨什巴傾戚 | 僞A01濔 | | 4
- 陳濃斗益掘波什 | 歛B10驩 | | 0
- 陳濃斗覗稽益掘袴 | 賺Z01 | | 0
-(3 rows)
-
-select *,substring(遂嬢 from 3 for 4) from 悠潯僞遂嬢;
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥 | substr
-------------------+----------+------------+----------
- 陳濃斗巨什巴傾戚 | 僞A01濔 | | 斗巨什巴
- 陳濃斗益掘波什 | 歛B10驩 | | 斗益掘波
- 陳濃斗覗稽益掘袴 | 賺Z01 | | 斗覗稽益
-(3 rows)
-
diff --git a/src/test/regress/expected/euc_tw.out b/src/test/regress/expected/euc_tw.out
deleted file mode 100644
index cf855809ab7..00000000000
--- a/src/test/regress/expected/euc_tw.out
+++ /dev/null
@@ -1,85 +0,0 @@
-drop table 贖抔胥寤;
-ERROR: Relation '贖抔胥寤' does not exist
-create table 贖抔胥寤 (泌籠姫 text, 諦導卵鵑 varchar, 狽敷 varchar(16));
-create index 贖抔胥寤index1 on 贖抔胥寤 using btree (泌籠姫);
-create index 贖抔胥寤index2 on 贖抔胥寤 using hash (諦導卵鵑);
-insert into 贖抔胥寤 values ('艀罟籠', '膊膊呰弊', '董A01廷');
-insert into 贖抔胥寤 values ('襌毯籠', '愨粃抜嚴諦導', '低B10低');
-insert into 贖抔胥寤 values ('鵲磽籠', '咫明牢嚢抜嚴諦導', '罹Z01彫');
-vacuum 贖抔胥寤;
-select * from 贖抔胥寤;
- 泌籠姫 | 諦導卵鵑 | 狽敷
---------+------------------+---------
- 艀罟籠 | 膊膊呰弊 | 董A01廷
- 襌毯籠 | 愨粃抜嚴諦導 | 低B10低
- 鵲磽籠 | 咫明牢嚢抜嚴諦導 | 罹Z01彫
-(3 rows)
-
-select * from 贖抔胥寤 where 狽敷 = '罹Z01彫';
- 泌籠姫 | 諦導卵鵑 | 狽敷
---------+------------------+---------
- 鵲磽籠 | 咫明牢嚢抜嚴諦導 | 罹Z01彫
-(1 row)
-
-select * from 贖抔胥寤 where 狽敷 ~* '罹z01彫';
- 泌籠姫 | 諦導卵鵑 | 狽敷
---------+------------------+---------
- 鵲磽籠 | 咫明牢嚢抜嚴諦導 | 罹Z01彫
-(1 row)
-
-select * from 贖抔胥寤 where 狽敷 like '_Z01_';
- 泌籠姫 | 諦導卵鵑 | 狽敷
---------+------------------+---------
- 鵲磽籠 | 咫明牢嚢抜嚴諦導 | 罹Z01彫
-(1 row)
-
-select * from 贖抔胥寤 where 狽敷 like '_Z%';
- 泌籠姫 | 諦導卵鵑 | 狽敷
---------+------------------+---------
- 鵲磽籠 | 咫明牢嚢抜嚴諦導 | 罹Z01彫
-(1 row)
-
-select * from 贖抔胥寤 where 諦導卵鵑 ~ '膊膊呰[搆愆弊]';
- 泌籠姫 | 諦導卵鵑 | 狽敷
---------+----------+---------
- 艀罟籠 | 膊膊呰弊 | 董A01廷
-(1 row)
-
-select * from 贖抔胥寤 where 諦導卵鵑 ~* '膊膊呰[搆愆弊]';
- 泌籠姫 | 諦導卵鵑 | 狽敷
---------+----------+---------
- 艀罟籠 | 膊膊呰弊 | 董A01廷
-(1 row)
-
-select *, character_length(泌籠姫) from 贖抔胥寤;
- 泌籠姫 | 諦導卵鵑 | 狽敷 | char_length
---------+------------------+---------+-------------
- 艀罟籠 | 膊膊呰弊 | 董A01廷 | 3
- 襌毯籠 | 愨粃抜嚴諦導 | 低B10低 | 3
- 鵲磽籠 | 咫明牢嚢抜嚴諦導 | 罹Z01彫 | 3
-(3 rows)
-
-select *, octet_length(泌籠姫) from 贖抔胥寤;
- 泌籠姫 | 諦導卵鵑 | 狽敷 | octet_length
---------+------------------+---------+--------------
- 艀罟籠 | 膊膊呰弊 | 董A01廷 | 6
- 襌毯籠 | 愨粃抜嚴諦導 | 低B10低 | 6
- 鵲磽籠 | 咫明牢嚢抜嚴諦導 | 罹Z01彫 | 6
-(3 rows)
-
-select *, position('抜嚴' in 諦導卵鵑) from 贖抔胥寤;
- 泌籠姫 | 諦導卵鵑 | 狽敷 | strpos
---------+------------------+---------+--------
- 艀罟籠 | 膊膊呰弊 | 董A01廷 | 0
- 襌毯籠 | 愨粃抜嚴諦導 | 低B10低 | 3
- 鵲磽籠 | 咫明牢嚢抜嚴諦導 | 罹Z01彫 | 5
-(3 rows)
-
-select *, substring(諦導卵鵑 from 3 for 6 ) from 贖抔胥寤;
- 泌籠姫 | 諦導卵鵑 | 狽敷 | substr
---------+------------------+---------+--------------
- 艀罟籠 | 膊膊呰弊 | 董A01廷 | 呰弊
- 襌毯籠 | 愨粃抜嚴諦導 | 低B10低 | 抜嚴諦導
- 鵲磽籠 | 咫明牢嚢抜嚴諦導 | 罹Z01彫 | 牢嚢抜嚴諦導
-(3 rows)
-
diff --git a/src/test/regress/expected/mule_internal.out b/src/test/regress/expected/mule_internal.out
deleted file mode 100644
index bfcffc8490a..00000000000
--- a/src/test/regress/expected/mule_internal.out
+++ /dev/null
@@ -1,333 +0,0 @@
-drop table 計算機用語;
-ERROR: Relation '計算機用語' does not exist
-create table 計算機用語 (用語 text, 分類コード varchar, 備考1Aだよ char(16));
-create index 計算機用語index1 on 計算機用語 using btree (用語);
-create index 計算機用語index2 on 計算機用語 using hash (分類コード);
-insert into 計算機用語 values('コンピュータディスプレイ','機A01上');
-insert into 計算機用語 values('コンピュータグラフィックス','分B10中');
-insert into 計算機用語 values('コンピュータプログラマー','人Z01下');
-vacuum 計算機用語;
-select * from 計算機用語;
- 用語 | 分類コード | 備考1aだよ
------------------------------------------+-----------------+----------------
- コンピュータディスプレイ | 機A01上 |
- コンピュータグラフィックス | 分B10中 |
- コンピュータプログラマー | 人Z01下 |
-(3 rows)
-
-select * from 計算機用語 where 分類コード = '人Z01下';
- 用語 | 分類コード | 備考1aだよ
---------------------------------------+-----------------+----------------
- コンピュータプログラマー | 人Z01下 |
-(1 row)
-
-select * from 計算機用語 where 分類コード ~* '人z01下';
- 用語 | 分類コード | 備考1aだよ
---------------------------------------+-----------------+----------------
- コンピュータプログラマー | 人Z01下 |
-(1 row)
-
-select * from 計算機用語 where 分類コード like '_Z01_';
- 用語 | 分類コード | 備考1aだよ
---------------------------------------+-----------------+----------------
- コンピュータプログラマー | 人Z01下 |
-(1 row)
-
-select * from 計算機用語 where 分類コード like '_Z%';
- 用語 | 分類コード | 備考1aだよ
---------------------------------------+-----------------+----------------
- コンピュータプログラマー | 人Z01下 |
-(1 row)
-
-select * from 計算機用語 where 用語 ~ 'コンピュータ[デグ]';
- 用語 | 分類コード | 備考1aだよ
------------------------------------------+-----------------+----------------
- コンピュータディスプレイ | 機A01上 |
- コンピュータグラフィックス | 分B10中 |
-(2 rows)
-
-select * from 計算機用語 where 用語 ~* 'コンピュータ[デグ]';
- 用語 | 分類コード | 備考1aだよ
------------------------------------------+-----------------+----------------
- コンピュータディスプレイ | 機A01上 |
- コンピュータグラフィックス | 分B10中 |
-(2 rows)
-
-select *,character_length(用語) from 計算機用語;
- 用語 | 分類コード | 備考1aだよ | char_length
------------------------------------------+-----------------+----------------+-------------
- コンピュータディスプレイ | 機A01上 | | 12
- コンピュータグラフィックス | 分B10中 | | 13
- コンピュータプログラマー | 人Z01下 | | 12
-(3 rows)
-
-select *,octet_length(用語) from 計算機用語;
- 用語 | 分類コード | 備考1aだよ | octet_length
------------------------------------------+-----------------+----------------+--------------
- コンピュータディスプレイ | 機A01上 | | 36
- コンピュータグラフィックス | 分B10中 | | 39
- コンピュータプログラマー | 人Z01下 | | 36
-(3 rows)
-
-select *,position('デ' in 用語) from 計算機用語;
- 用語 | 分類コード | 備考1aだよ | strpos
------------------------------------------+-----------------+----------------+--------
- コンピュータディスプレイ | 機A01上 | | 7
- コンピュータグラフィックス | 分B10中 | | 0
- コンピュータプログラマー | 人Z01下 | | 0
-(3 rows)
-
-select *,substring(用語 from 10 for 4) from 計算機用語;
- 用語 | 分類コード | 備考1aだよ | substr
------------------------------------------+-----------------+----------------+--------------
- コンピュータディスプレイ | 機A01上 | | プレイ
- コンピュータグラフィックス | 分B10中 | | ィックス
- コンピュータプログラマー | 人Z01下 | | ラマー
-(3 rows)
-
-drop table 柴麻字宝囂;
-ERROR: Relation '柴麻字宝囂' does not exist
-create table 柴麻字宝囂(宝囂 text, 蛍窃催 varchar, 姥廣1A char(16));
-create index 柴麻字宝囂index1 on 柴麻字宝囂 using btree(宝囂);
-create index 柴麻字宝囂index2 on 柴麻字宝囂 using btree(蛍窃催);
-insert into 柴麻字宝囂 values('窮辻幣徳','字A01貧');
-insert into 柴麻字宝囂 values('窮辻夕侘','蛍B01嶄');
-insert into 柴麻字宝囂 values('窮辻殻會埀','繁Z01和');
-vacuum 柴麻字宝囂;
-select * from 柴麻字宝囂;
- 宝囂 | 蛍窃催 | 姥廣1a
------------------+-----------+----------
- 窮辻幣徳 | 字A01貧 |
- 窮辻夕侘 | 蛍B01嶄 |
- 窮辻殻會埀 | 繁Z01和 |
-(3 rows)
-
-select * from 柴麻字宝囂 where 蛍窃催 = '繁Z01和';
- 宝囂 | 蛍窃催 | 姥廣1a
------------------+-----------+----------
- 窮辻殻會埀 | 繁Z01和 |
-(1 row)
-
-select * from 柴麻字宝囂 where 蛍窃催 ~* '繁z01和';
- 宝囂 | 蛍窃催 | 姥廣1a
------------------+-----------+----------
- 窮辻殻會埀 | 繁Z01和 |
-(1 row)
-
-select * from 柴麻字宝囂 where 蛍窃催 like '_Z01_';
- 宝囂 | 蛍窃催 | 姥廣1a
------------------+-----------+----------
- 窮辻殻會埀 | 繁Z01和 |
-(1 row)
-
-select * from 柴麻字宝囂 where 蛍窃催 like '_Z%';
- 宝囂 | 蛍窃催 | 姥廣1a
------------------+-----------+----------
- 窮辻殻會埀 | 繁Z01和 |
-(1 row)
-
-select * from 柴麻字宝囂 where 宝囂 ~ '窮辻[夕]';
- 宝囂 | 蛍窃催 | 姥廣1a
------------------+-----------+----------
- 窮辻幣徳 | 字A01貧 |
- 窮辻夕侘 | 蛍B01嶄 |
-(2 rows)
-
-select * from 柴麻字宝囂 where 宝囂 ~* '窮辻[夕]';
- 宝囂 | 蛍窃催 | 姥廣1a
------------------+-----------+----------
- 窮辻幣徳 | 字A01貧 |
- 窮辻夕侘 | 蛍B01嶄 |
-(2 rows)
-
-select *,character_length(宝囂) from 柴麻字宝囂;
- 宝囂 | 蛍窃催 | 姥廣1a | char_length
------------------+-----------+----------+-------------
- 窮辻幣徳 | 字A01貧 | | 5
- 窮辻夕侘 | 蛍B01嶄 | | 4
- 窮辻殻會埀 | 繁Z01和 | | 5
-(3 rows)
-
-select *,octet_length(宝囂) from 柴麻字宝囂;
- 宝囂 | 蛍窃催 | 姥廣1a | octet_length
------------------+-----------+----------+--------------
- 窮辻幣徳 | 字A01貧 | | 15
- 窮辻夕侘 | 蛍B01嶄 | | 12
- 窮辻殻會埀 | 繁Z01和 | | 15
-(3 rows)
-
-select *,position('' in 宝囂) from 柴麻字宝囂;
- 宝囂 | 蛍窃催 | 姥廣1a | strpos
------------------+-----------+----------+--------
- 窮辻幣徳 | 字A01貧 | | 3
- 窮辻夕侘 | 蛍B01嶄 | | 0
- 窮辻殻會埀 | 繁Z01和 | | 0
-(3 rows)
-
-select *,substring(宝囂 from 3 for 4) from 柴麻字宝囂;
- 宝囂 | 蛍窃催 | 姥廣1a | substr
------------------+-----------+----------+-----------
- 窮辻幣徳 | 字A01貧 | | 幣徳
- 窮辻夕侘 | 蛍B01嶄 | | 夕侘
- 窮辻殻會埀 | 繁Z01和 | | 殻會埀
-(3 rows)
-
-drop table 悠潯僞遂嬢;
-ERROR: Relation '悠潯僞遂嬢' does not exist
-create table 悠潯僞遂嬢 (遂嬢 text, 歛彎坪球 varchar, 搾壱1A虞姥 char(16));
-create index 悠潯僞遂嬢index1 on 悠潯僞遂嬢 using btree (遂嬢);
-create index 悠潯僞遂嬢index2 on 悠潯僞遂嬢 using hash (歛彎坪球);
-insert into 悠潯僞遂嬢 values('陳濃斗巨什巴傾戚', '僞A01濔');
-insert into 悠潯僞遂嬢 values('陳濃斗益掘波什', '歛B10驩');
-insert into 悠潯僞遂嬢 values('陳濃斗覗稽益掘袴', '賺Z01');
-vacuum 悠潯僞遂嬢;
-select * from 悠潯僞遂嬢;
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
---------------------------+--------------+----------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 |
- 陳濃斗益掘波什 | 歛B10驩 |
- 陳濃斗覗稽益掘袴 | 賺Z01 |
-(3 rows)
-
-select * from 悠潯僞遂嬢 where 歛彎坪球 = '賺Z01';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
---------------------------+--------------+----------------
- 陳濃斗覗稽益掘袴 | 賺Z01 |
-(1 row)
-
-select * from 悠潯僞遂嬢 where 歛彎坪球 ~* '賺z01';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
---------------------------+--------------+----------------
- 陳濃斗覗稽益掘袴 | 賺Z01 |
-(1 row)
-
-select * from 悠潯僞遂嬢 where 歛彎坪球 like '_Z01_';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
---------------------------+--------------+----------------
- 陳濃斗覗稽益掘袴 | 賺Z01 |
-(1 row)
-
-select * from 悠潯僞遂嬢 where 歛彎坪球 like '_Z%';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
---------------------------+--------------+----------------
- 陳濃斗覗稽益掘袴 | 賺Z01 |
-(1 row)
-
-select * from 悠潯僞遂嬢 where 遂嬢 ~ '陳濃斗[巨益]';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
---------------------------+--------------+----------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 |
- 陳濃斗益掘波什 | 歛B10驩 |
-(2 rows)
-
-select * from 悠潯僞遂嬢 where 遂嬢 ~* '陳濃斗[巨益]';
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥
---------------------------+--------------+----------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 |
- 陳濃斗益掘波什 | 歛B10驩 |
-(2 rows)
-
-select *,character_length(遂嬢) from 悠潯僞遂嬢;
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥 | char_length
---------------------------+--------------+----------------+-------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 | | 8
- 陳濃斗益掘波什 | 歛B10驩 | | 7
- 陳濃斗覗稽益掘袴 | 賺Z01 | | 8
-(3 rows)
-
-select *,octet_length(遂嬢) from 悠潯僞遂嬢;
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥 | octet_length
---------------------------+--------------+----------------+--------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 | | 24
- 陳濃斗益掘波什 | 歛B10驩 | | 21
- 陳濃斗覗稽益掘袴 | 賺Z01 | | 24
-(3 rows)
-
-select *,position('巨' in 遂嬢) from 悠潯僞遂嬢;
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥 | strpos
---------------------------+--------------+----------------+--------
- 陳濃斗巨什巴傾戚 | 僞A01濔 | | 4
- 陳濃斗益掘波什 | 歛B10驩 | | 0
- 陳濃斗覗稽益掘袴 | 賺Z01 | | 0
-(3 rows)
-
-select *,substring(遂嬢 from 3 for 4) from 悠潯僞遂嬢;
- 遂嬢 | 歛彎坪球 | 搾壱1a虞姥 | substr
---------------------------+--------------+----------------+--------------
- 陳濃斗巨什巴傾戚 | 僞A01濔 | | 斗巨什巴
- 陳濃斗益掘波什 | 歛B10驩 | | 斗益掘波
- 陳濃斗覗稽益掘袴 | 賺Z01 | | 斗覗稽益
-(3 rows)
-
-drop table test;
-ERROR: Relation 'test' does not exist
-create table test (t text);
-insert into test values('ENGLISH');
-insert into test values('FRANAIS');
-insert into test values('ESPAOL');
-insert into test values('SLENSKA');
-insert into test values('ENGLISH FRANAIS ESPAOL SLENSKA');
-vacuum test;
-select * from test;
- t
---------------------------------------
- ENGLISH
- FRANAIS
- ESPAOL
- SLENSKA
- ENGLISH FRANAIS ESPAOL SLENSKA
-(5 rows)
-
-select * from test where t = 'ESPAOL';
- t
-----------
- ESPAOL
-(1 row)
-
-select * from test where t ~* 'espaol';
- t
---------------------------------------
- ESPAOL
- ENGLISH FRANAIS ESPAOL SLENSKA
-(2 rows)
-
-select *,character_length(t) from test;
- t | char_length
---------------------------------------+-------------
- ENGLISH | 7
- FRANAIS | 8
- ESPAOL | 7
- SLENSKA | 8
- ENGLISH FRANAIS ESPAOL SLENSKA | 33
-(5 rows)
-
-select *,octet_length(t) from test;
- t | octet_length
---------------------------------------+--------------
- ENGLISH | 7
- FRANAIS | 9
- ESPAOL | 8
- SLENSKA | 9
- ENGLISH FRANAIS ESPAOL SLENSKA | 36
-(5 rows)
-
-select *,position('L' in t) from test;
- t | strpos
---------------------------------------+--------
- ENGLISH | 4
- FRANAIS | 0
- ESPAOL | 7
- SLENSKA | 3
- ENGLISH FRANAIS ESPAOL SLENSKA | 4
-(5 rows)
-
-select *,substring(t from 3 for 4) from test;
- t | substr
---------------------------------------+--------
- ENGLISH | GLIS
- FRANAIS | ANA
- ESPAOL | PAO
- SLENSKA | LENS
- ENGLISH FRANAIS ESPAOL SLENSKA | GLIS
-(5 rows)
-
diff --git a/src/test/regress/expected/sql_ascii.out b/src/test/regress/expected/sql_ascii.out
deleted file mode 100644
index 5b7c03575fd..00000000000
--- a/src/test/regress/expected/sql_ascii.out
+++ /dev/null
@@ -1,87 +0,0 @@
-drop table computer_terms;
-ERROR: Relation 'computer_terms' does not exist
-create table computer_terms(term text, category text, comments char(16));
-create index computer_terms_index1 on computer_terms using btree(term);
-create index computer_terms_index2 on computer_terms using btree(category);
-insert into computer_terms values('computer display', 'X-A01-Y', 'a comment 1');
-insert into computer_terms values('computer graphics', 'T-B01-Y', 'a comment 2');
-insert into computer_terms values('computer programmer', 'S-Z01-Y', 'a comment 3');
-vacuum computer_terms;
-select * from computer_terms;
- term | category | comments
----------------------+----------+------------------
- computer display | X-A01-Y | a comment 1
- computer graphics | T-B01-Y | a comment 2
- computer programmer | S-Z01-Y | a comment 3
-(3 rows)
-
-select * from computer_terms where category = 'X-A01-Y';
- term | category | comments
-------------------+----------+------------------
- computer display | X-A01-Y | a comment 1
-(1 row)
-
-select * from computer_terms where category ~* 'x-a01-y';
- term | category | comments
-------------------+----------+------------------
- computer display | X-A01-Y | a comment 1
-(1 row)
-
-select * from computer_terms where category like '_-A01-_';
- term | category | comments
-------------------+----------+------------------
- computer display | X-A01-Y | a comment 1
-(1 row)
-
-select * from computer_terms where category like '_-A%';
- term | category | comments
-------------------+----------+------------------
- computer display | X-A01-Y | a comment 1
-(1 row)
-
-select * from computer_terms where term ~ 'computer [dg]';
- term | category | comments
--------------------+----------+------------------
- computer display | X-A01-Y | a comment 1
- computer graphics | T-B01-Y | a comment 2
-(2 rows)
-
-select * from computer_terms where term ~* 'computer [DG]';
- term | category | comments
--------------------+----------+------------------
- computer display | X-A01-Y | a comment 1
- computer graphics | T-B01-Y | a comment 2
-(2 rows)
-
-select *,character_length(term) from computer_terms;
- term | category | comments | char_length
----------------------+----------+------------------+-------------
- computer display | X-A01-Y | a comment 1 | 16
- computer graphics | T-B01-Y | a comment 2 | 17
- computer programmer | S-Z01-Y | a comment 3 | 19
-(3 rows)
-
-select *,octet_length(term) from computer_terms;
- term | category | comments | octet_length
----------------------+----------+------------------+--------------
- computer display | X-A01-Y | a comment 1 | 16
- computer graphics | T-B01-Y | a comment 2 | 17
- computer programmer | S-Z01-Y | a comment 3 | 19
-(3 rows)
-
-select *,position('s' in term) from computer_terms;
- term | category | comments | strpos
----------------------+----------+------------------+--------
- computer display | X-A01-Y | a comment 1 | 12
- computer graphics | T-B01-Y | a comment 2 | 17
- computer programmer | S-Z01-Y | a comment 3 | 0
-(3 rows)
-
-select *,substring(term from 10 for 4) from computer_terms;
- term | category | comments | substr
----------------------+----------+------------------+--------
- computer display | X-A01-Y | a comment 1 | disp
- computer graphics | T-B01-Y | a comment 2 | grap
- computer programmer | S-Z01-Y | a comment 3 | prog
-(3 rows)
-
diff --git a/src/test/regress/sql/drop.sql b/src/test/regress/sql/drop.sql
deleted file mode 100644
index da9297d8b61..00000000000
--- a/src/test/regress/sql/drop.sql
+++ /dev/null
@@ -1,246 +0,0 @@
---
--- drop.source
---
-
---
--- this will fail if the user is not the postgres superuser.
--- if it does, don't worry about it (you can turn usersuper
--- back on as "postgres"). too many people don't follow
--- directions and run this as "postgres", though...
---
-UPDATE pg_user
- SET usesuper = 't'::bool
- WHERE usename = 'postgres';
-
-
---
--- FUNCTION REMOVAL
---
-DROP FUNCTION hobbies(person);
-
-DROP FUNCTION hobby_construct(text,text);
-
-DROP FUNCTION equipment(hobbies_r);
-
-DROP FUNCTION user_relns();
-
-DROP FUNCTION widget_in(cstring);
-
-DROP FUNCTION widget_out(widget);
-
-DROP FUNCTION pt_in_widget(point,widget);
-
-DROP FUNCTION overpaid(emp);
-
-DROP FUNCTION boxarea(box);
-
-DROP FUNCTION interpt_pp(path,path);
-
-DROP FUNCTION reverse_name(name);
-
-DROP FUNCTION oldstyle_length(int4, text);
-
---
--- OPERATOR REMOVAL
---
-DROP OPERATOR ## (path, path);
-
-DROP OPERATOR <% (point, widget);
-
--- left unary
-DROP OPERATOR @#@ (none, int4);
-
--- right unary
-DROP OPERATOR #@# (int4, none);
-
--- right unary
-DROP OPERATOR #%# (int4, none);
-
-
---
--- ABSTRACT DATA TYPE REMOVAL
---
-DROP TYPE city_budget;
-
-DROP TYPE widget;
-
-
---
--- RULE REMOVAL
--- (is also tested in queries.source)
---
-
---
--- AGGREGATE REMOVAL
---
-DROP AGGREGATE newavg (int4);
-
-DROP AGGREGATE newsum (int4);
-
-DROP AGGREGATE newcnt (int4);
-
-
---
--- CLASS REMOVAL
--- (inheritance hierarchies are deleted in reverse order)
---
-
---
--- DROP ancillary data structures (i.e. indices)
---
-DROP INDEX onek_unique1;
-
-DROP INDEX onek_unique2;
-
-DROP INDEX onek_hundred;
-
-DROP INDEX onek_stringu1;
-
-DROP INDEX tenk1_unique1;
-
-DROP INDEX tenk1_unique2;
-
-DROP INDEX tenk1_hundred;
-
-DROP INDEX tenk2_unique1;
-
-DROP INDEX tenk2_unique2;
-
-DROP INDEX tenk2_hundred;
-
--- DROP INDEX onek2_u1_prtl;
-
--- DROP INDEX onek2_u2_prtl;
-
--- DROP INDEX onek2_stu1_prtl;
-
-DROP INDEX rect2ind;
-
-DROP INDEX rix;
-
-DROP INDEX iix;
-
-DROP INDEX six;
-
-DROP INDEX hash_i4_index;
-
-DROP INDEX hash_name_index;
-
-DROP INDEX hash_txt_index;
-
-DROP INDEX hash_f8_index;
-
--- DROP INDEX hash_ovfl_index;
-
-DROP INDEX bt_i4_index;
-
-DROP INDEX bt_name_index;
-
-DROP INDEX bt_txt_index;
-
-DROP INDEX bt_f8_index;
-
-
-DROP TABLE onek;
-
-DROP TABLE onek2;
-
-DROP TABLE tenk1;
-
-DROP TABLE tenk2;
-
-DROP TABLE Bprime;
-
-
-DROP TABLE hobbies_r;
-
-DROP TABLE equipment_r;
-
-
-DROP TABLE aggtest;
-
-DROP TABLE xacttest;
-
-DROP TABLE arrtest;
-
-DROP TABLE iportaltest;
-
-
-DROP TABLE f_star;
-
-DROP TABLE e_star;
-
-DROP TABLE d_star;
-
-DROP TABLE c_star;
-
-DROP TABLE b_star;
-
-DROP TABLE a_star;
-
-
---
--- must be in reverse inheritance order
---
-DROP TABLE stud_emp;
-
-DROP TABLE student;
-
-DROP TABLE slow_emp4000;
-
-DROP TABLE fast_emp4000;
-
-DROP TABLE emp;
-
-DROP TABLE person;
-
-
-DROP TABLE ramp;
-
-DROP TABLE real_city;
-
-DROP TABLE dept;
-
-DROP TABLE ihighway;
-
-DROP TABLE shighway;
-
-DROP TABLE road;
-
-DROP TABLE city;
-
-
-DROP TABLE hash_i4_heap;
-
-DROP TABLE hash_name_heap;
-
-DROP TABLE hash_txt_heap;
-
-DROP TABLE hash_f8_heap;
-
--- DROP TABLE hash_ovfl_heap;
-
-DROP TABLE bt_i4_heap;
-
-DROP TABLE bt_name_heap;
-
-DROP TABLE bt_txt_heap;
-
-DROP TABLE bt_f8_heap;
-
-
-DROP TABLE ABSTIME_TBL;
-
-DROP TABLE RELTIME_TBL;
-
-DROP TABLE TINTERVAL_TBL;
-
---
--- VIRTUAL CLASS REMOVAL
--- (also tests removal of rewrite rules)
---
-DROP VIEW street;
-
-DROP VIEW iexit;
-
-DROP VIEW toyemp;
diff --git a/src/test/regress/sql/euc_cn.sql b/src/test/regress/sql/euc_cn.sql
deleted file mode 100644
index 7cd0b9b0e25..00000000000
--- a/src/test/regress/sql/euc_cn.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-drop table 柴麻字宝囂;
-create table 柴麻字宝囂(宝囂 text, 蛍窃催 varchar, 姥廣1A char(16));
-create index 柴麻字宝囂index1 on 柴麻字宝囂 using btree(宝囂);
-create index 柴麻字宝囂index2 on 柴麻字宝囂 using btree(蛍窃催);
-insert into 柴麻字宝囂 values('窮辻塋焼','字A01貧');
-insert into 柴麻字宝囂 values('窮辻夕侘','蛍B01嶄');
-insert into 柴麻字宝囂 values('窮辻殻會埀','繁Z01和');
-vacuum 柴麻字宝囂;
-select * from 柴麻字宝囂;
-select * from 柴麻字宝囂 where 蛍窃催 = '繁Z01和';
-select * from 柴麻字宝囂 where 蛍窃催 ~* '繁z01和';
-select * from 柴麻字宝囂 where 蛍窃催 like '_Z01_';
-select * from 柴麻字宝囂 where 蛍窃催 like '_Z%';
-select * from 柴麻字宝囂 where 宝囂 ~ '窮辻[塒]';
-select * from 柴麻字宝囂 where 宝囂 ~* '窮辻[塒]';
-select *,character_length(宝囂) from 柴麻字宝囂;
-select *,octet_length(宝囂) from 柴麻字宝囂;
-select *,position('' in 宝囂) from 柴麻字宝囂;
-select *,substring(宝囂 from 3 for 4) from 柴麻字宝囂;
diff --git a/src/test/regress/sql/euc_jp.sql b/src/test/regress/sql/euc_jp.sql
deleted file mode 100644
index 2021205bf45..00000000000
--- a/src/test/regress/sql/euc_jp.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-drop table 計算機用語;
-create table 計算機用語 (用語 text, 分類コード varchar, 備考1Aだよ char(16));
-create index 計算機用語index1 on 計算機用語 using btree (用語);
-create index 計算機用語index2 on 計算機用語 using hash (分類コード);
-insert into 計算機用語 values('コンピュータディスプレイ','機A01上');
-insert into 計算機用語 values('コンピュータグラフィックス','分B10中');
-insert into 計算機用語 values('コンピュータプログラマー','人Z01下');
-vacuum 計算機用語;
-select * from 計算機用語;
-select * from 計算機用語 where 分類コード = '人Z01下';
-select * from 計算機用語 where 分類コード ~* '人z01下';
-select * from 計算機用語 where 分類コード like '_Z01_';
-select * from 計算機用語 where 分類コード like '_Z%';
-select * from 計算機用語 where 用語 ~ 'コンピュータ[デグ]';
-select * from 計算機用語 where 用語 ~* 'コンピュータ[デグ]';
-select *,character_length(用語) from 計算機用語;
-select *,octet_length(用語) from 計算機用語;
-select *,position('デ' in 用語) from 計算機用語;
-select *,substring(用語 from 10 for 4) from 計算機用語;
diff --git a/src/test/regress/sql/euc_kr.sql b/src/test/regress/sql/euc_kr.sql
deleted file mode 100644
index cf9e07fd1c6..00000000000
--- a/src/test/regress/sql/euc_kr.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-drop table 悠潯僞遂嬢;
-create table 悠潯僞遂嬢 (遂嬢 text, 歛彎坪球 varchar, 搾壱1A虞姥 char(16));
-create index 悠潯僞遂嬢index1 on 悠潯僞遂嬢 using btree (遂嬢);
-create index 悠潯僞遂嬢index2 on 悠潯僞遂嬢 using hash (歛彎坪球);
-insert into 悠潯僞遂嬢 values('陳濃斗巨什巴傾戚', '僞A01濔');
-insert into 悠潯僞遂嬢 values('陳濃斗益掘波什', '歛B10驩');
-insert into 悠潯僞遂嬢 values('陳濃斗覗稽益掘袴', '賺Z01');
-vacuum 悠潯僞遂嬢;
-select * from 悠潯僞遂嬢;
-select * from 悠潯僞遂嬢 where 歛彎坪球 = '賺Z01';
-select * from 悠潯僞遂嬢 where 歛彎坪球 ~* '賺z01';
-select * from 悠潯僞遂嬢 where 歛彎坪球 like '_Z01_';
-select * from 悠潯僞遂嬢 where 歛彎坪球 like '_Z%';
-select * from 悠潯僞遂嬢 where 遂嬢 ~ '陳濃斗[巨益]';
-select * from 悠潯僞遂嬢 where 遂嬢 ~* '陳濃斗[巨益]';
-select *,character_length(遂嬢) from 悠潯僞遂嬢;
-select *,octet_length(遂嬢) from 悠潯僞遂嬢;
-select *,position('巨' in 遂嬢) from 悠潯僞遂嬢;
-select *,substring(遂嬢 from 3 for 4) from 悠潯僞遂嬢;
diff --git a/src/test/regress/sql/euc_tw.sql b/src/test/regress/sql/euc_tw.sql
deleted file mode 100644
index 79f3def432d..00000000000
--- a/src/test/regress/sql/euc_tw.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-drop table 贖抔胥寤;
-create table 贖抔胥寤 (泌籠姫 text, 諦導卵鵑 varchar, 狽敷 varchar(16));
-create index 贖抔胥寤index1 on 贖抔胥寤 using btree (泌籠姫);
-create index 贖抔胥寤index2 on 贖抔胥寤 using hash (諦導卵鵑);
-insert into 贖抔胥寤 values ('艀罟籠', '膊膊呰弊', '董A01廷');
-insert into 贖抔胥寤 values ('襌毯籠', '愨粃抜嚴諦導', '低B10低');
-insert into 贖抔胥寤 values ('鵲磽籠', '咫明牢嚢抜嚴諦導', '罹Z01彫');
-vacuum 贖抔胥寤;
-select * from 贖抔胥寤;
-select * from 贖抔胥寤 where 狽敷 = '罹Z01彫';
-select * from 贖抔胥寤 where 狽敷 ~* '罹z01彫';
-select * from 贖抔胥寤 where 狽敷 like '_Z01_';
-select * from 贖抔胥寤 where 狽敷 like '_Z%';
-select * from 贖抔胥寤 where 諦導卵鵑 ~ '膊膊呰[搆愆弊]';
-select * from 贖抔胥寤 where 諦導卵鵑 ~* '膊膊呰[搆愆弊]';
-
-select *, character_length(泌籠姫) from 贖抔胥寤;
-select *, octet_length(泌籠姫) from 贖抔胥寤;
-select *, position('抜嚴' in 諦導卵鵑) from 贖抔胥寤;
-select *, substring(諦導卵鵑 from 3 for 6 ) from 贖抔胥寤;
diff --git a/src/test/regress/sql/mule_internal.sql b/src/test/regress/sql/mule_internal.sql
deleted file mode 100644
index 2e381f0f7ed..00000000000
--- a/src/test/regress/sql/mule_internal.sql
+++ /dev/null
@@ -1,72 +0,0 @@
-drop table 計算機用語;
-create table 計算機用語 (用語 text, 分類コード varchar, 備考1Aだよ char(16));
-create index 計算機用語index1 on 計算機用語 using btree (用語);
-create index 計算機用語index2 on 計算機用語 using hash (分類コード);
-insert into 計算機用語 values('コンピュータディスプレイ','機A01上');
-insert into 計算機用語 values('コンピュータグラフィックス','分B10中');
-insert into 計算機用語 values('コンピュータプログラマー','人Z01下');
-vacuum 計算機用語;
-select * from 計算機用語;
-select * from 計算機用語 where 分類コード = '人Z01下';
-select * from 計算機用語 where 分類コード ~* '人z01下';
-select * from 計算機用語 where 分類コード like '_Z01_';
-select * from 計算機用語 where 分類コード like '_Z%';
-select * from 計算機用語 where 用語 ~ 'コンピュータ[デグ]';
-select * from 計算機用語 where 用語 ~* 'コンピュータ[デグ]';
-select *,character_length(用語) from 計算機用語;
-select *,octet_length(用語) from 計算機用語;
-select *,position('デ' in 用語) from 計算機用語;
-select *,substring(用語 from 10 for 4) from 計算機用語;
-drop table 柴麻字宝囂;
-create table 柴麻字宝囂(宝囂 text, 蛍窃催 varchar, 姥廣1A char(16));
-create index 柴麻字宝囂index1 on 柴麻字宝囂 using btree(宝囂);
-create index 柴麻字宝囂index2 on 柴麻字宝囂 using btree(蛍窃催);
-insert into 柴麻字宝囂 values('窮辻幣徳','字A01貧');
-insert into 柴麻字宝囂 values('窮辻夕侘','蛍B01嶄');
-insert into 柴麻字宝囂 values('窮辻殻會埀','繁Z01和');
-vacuum 柴麻字宝囂;
-select * from 柴麻字宝囂;
-select * from 柴麻字宝囂 where 蛍窃催 = '繁Z01和';
-select * from 柴麻字宝囂 where 蛍窃催 ~* '繁z01和';
-select * from 柴麻字宝囂 where 蛍窃催 like '_Z01_';
-select * from 柴麻字宝囂 where 蛍窃催 like '_Z%';
-select * from 柴麻字宝囂 where 宝囂 ~ '窮辻[夕]';
-select * from 柴麻字宝囂 where 宝囂 ~* '窮辻[夕]';
-select *,character_length(宝囂) from 柴麻字宝囂;
-select *,octet_length(宝囂) from 柴麻字宝囂;
-select *,position('' in 宝囂) from 柴麻字宝囂;
-select *,substring(宝囂 from 3 for 4) from 柴麻字宝囂;
-drop table 悠潯僞遂嬢;
-create table 悠潯僞遂嬢 (遂嬢 text, 歛彎坪球 varchar, 搾壱1A虞姥 char(16));
-create index 悠潯僞遂嬢index1 on 悠潯僞遂嬢 using btree (遂嬢);
-create index 悠潯僞遂嬢index2 on 悠潯僞遂嬢 using hash (歛彎坪球);
-insert into 悠潯僞遂嬢 values('陳濃斗巨什巴傾戚', '僞A01濔');
-insert into 悠潯僞遂嬢 values('陳濃斗益掘波什', '歛B10驩');
-insert into 悠潯僞遂嬢 values('陳濃斗覗稽益掘袴', '賺Z01');
-vacuum 悠潯僞遂嬢;
-select * from 悠潯僞遂嬢;
-select * from 悠潯僞遂嬢 where 歛彎坪球 = '賺Z01';
-select * from 悠潯僞遂嬢 where 歛彎坪球 ~* '賺z01';
-select * from 悠潯僞遂嬢 where 歛彎坪球 like '_Z01_';
-select * from 悠潯僞遂嬢 where 歛彎坪球 like '_Z%';
-select * from 悠潯僞遂嬢 where 遂嬢 ~ '陳濃斗[巨益]';
-select * from 悠潯僞遂嬢 where 遂嬢 ~* '陳濃斗[巨益]';
-select *,character_length(遂嬢) from 悠潯僞遂嬢;
-select *,octet_length(遂嬢) from 悠潯僞遂嬢;
-select *,position('巨' in 遂嬢) from 悠潯僞遂嬢;
-select *,substring(遂嬢 from 3 for 4) from 悠潯僞遂嬢;
-drop table test;
-create table test (t text);
-insert into test values('ENGLISH');
-insert into test values('FRANAIS');
-insert into test values('ESPAOL');
-insert into test values('SLENSKA');
-insert into test values('ENGLISH FRANAIS ESPAOL SLENSKA');
-vacuum test;
-select * from test;
-select * from test where t = 'ESPAOL';
-select * from test where t ~* 'espaol';
-select *,character_length(t) from test;
-select *,octet_length(t) from test;
-select *,position('L' in t) from test;
-select *,substring(t from 3 for 4) from test;
diff --git a/src/test/regress/sql/sql_ascii.sql b/src/test/regress/sql/sql_ascii.sql
deleted file mode 100644
index 0470f49f92d..00000000000
--- a/src/test/regress/sql/sql_ascii.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-drop table computer_terms;
-create table computer_terms(term text, category text, comments char(16));
-create index computer_terms_index1 on computer_terms using btree(term);
-create index computer_terms_index2 on computer_terms using btree(category);
-insert into computer_terms values('computer display', 'X-A01-Y', 'a comment 1');
-insert into computer_terms values('computer graphics', 'T-B01-Y', 'a comment 2');
-insert into computer_terms values('computer programmer', 'S-Z01-Y', 'a comment 3');
-vacuum computer_terms;
-select * from computer_terms;
-select * from computer_terms where category = 'X-A01-Y';
-select * from computer_terms where category ~* 'x-a01-y';
-select * from computer_terms where category like '_-A01-_';
-select * from computer_terms where category like '_-A%';
-select * from computer_terms where term ~ 'computer [dg]';
-select * from computer_terms where term ~* 'computer [DG]';
-select *,character_length(term) from computer_terms;
-select *,octet_length(term) from computer_terms;
-select *,position('s' in term) from computer_terms;
-select *,substring(term from 10 for 4) from computer_terms;