summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorTatsuo Ishii <ishii@postgresql.org>2001-09-22 08:47:20 +0000
committerTatsuo Ishii <ishii@postgresql.org>2001-09-22 08:47:20 +0000
commit67c26c12aff7d5c41e82b5e220a435e943095bfc (patch)
tree2d6d6a2d4e247e3e087ee5e2539a3b70ff12c041 /src/test
parent8ebdac0ed5839cdaaa3ef44ecb917727af4634bb (diff)
downloadpostgresql-67c26c12aff7d5c41e82b5e220a435e943095bfc.tar.gz
Fix expected files.
Diffstat (limited to 'src/test')
-rw-r--r--src/test/mb/expected/big5.out1
-rw-r--r--src/test/mb/expected/euc_cn.out87
-rw-r--r--src/test/mb/expected/euc_kr.out87
-rw-r--r--src/test/mb/expected/euc_tw.out85
-rw-r--r--src/test/mb/expected/mule_internal.out167
-rw-r--r--src/test/mb/expected/unicode.out344
6 files changed, 360 insertions, 411 deletions
diff --git a/src/test/mb/expected/big5.out b/src/test/mb/expected/big5.out
index 8ba6a9a25f..110bf8c7a3 100644
--- a/src/test/mb/expected/big5.out
+++ b/src/test/mb/expected/big5.out
@@ -1,5 +1,4 @@
drop table 紅坝戈;
-ERROR: table "紅坝戈" does not exist
create table 紅坝戈 (︽穨 text, そ╋繷 varchar,  varchar(16));
create index 紅坝戈index1 on 紅坝戈 using btree (︽穨);
create index 紅坝戈index2 on 紅坝戈 using hash (そ╋繷);
diff --git a/src/test/mb/expected/euc_cn.out b/src/test/mb/expected/euc_cn.out
index 8b80d6d584..71068f8c55 100644
--- a/src/test/mb/expected/euc_cn.out
+++ b/src/test/mb/expected/euc_cn.out
@@ -1,38 +1,87 @@
drop table 计算机术语;
-ERROR: parser: parse error at or near "("
+ERROR: table "计算机术语" does not exist
create table 计算机术语(术语 text, 分类号 varchar, 备注1A char(16));
-ERROR: parser: parse error at or near "("
create index 计算机术语index1 on 计算机术语 using btree(术语);
-ERROR: parser: parse error at or near "("
create index 计算机术语index2 on 计算机术语 using btree(分类号);
-ERROR: parser: parse error at or near "("
insert into 计算机术语 values('电脑显示屏','机A01上');
-ERROR: parser: parse error at or near "("
insert into 计算机术语 values('电脑图形','分B01中');
-ERROR: parser: parse error at or near "("
insert into 计算机术语 values('电脑程序员','人Z01下');
-ERROR: parser: parse error at or near "("
vacuum 计算机术语;
-ERROR: parser: parse error at or near "("
select * from 计算机术语;
-ERROR: parser: parse error at or near "92"
+ 术语 | 分类号 | 备注1a
+------------+---------+--------
+ 电脑显示屏 | 机A01上 |
+ 电脑图形 | 分B01中 |
+ 电脑程序员 | 人Z01下 |
+(3 rows)
+
select * from 计算机术语 where 分类号 = '人Z01下';
-ERROR: parser: parse error at or near "92"
+ 术语 | 分类号 | 备注1a
+------------+---------+--------
+ 电脑程序员 | 人Z01下 |
+(1 row)
+
select * from 计算机术语 where 分类号 ~* '人z01下';
-ERROR: parser: parse error at or near "92"
+ 术语 | 分类号 | 备注1a
+------------+---------+--------
+ 电脑程序员 | 人Z01下 |
+(1 row)
+
select * from 计算机术语 where 分类号 like '_Z01_';
-ERROR: parser: parse error at or near "92"
+ 术语 | 分类号 | 备注1a
+------------+---------+--------
+ 电脑程序员 | 人Z01下 |
+(1 row)
+
select * from 计算机术语 where 分类号 like '_Z%';
-ERROR: parser: parse error at or near "92"
+ 术语 | 分类号 | 备注1a
+------------+---------+--------
+ 电脑程序员 | 人Z01下 |
+(1 row)
+
select * from 计算机术语 where 术语 ~ '电脑[显图]';
-ERROR: parser: parse error at or near "92"
+ 术语 | 分类号 | 备注1a
+------------+---------+--------
+ 电脑显示屏 | 机A01上 |
+ 电脑图形 | 分B01中 |
+(2 rows)
+
select * from 计算机术语 where 术语 ~* '电脑[显图]';
-ERROR: parser: parse error at or near "92"
+ 术语 | 分类号 | 备注1a
+------------+---------+--------
+ 电脑显示屏 | 机A01上 |
+ 电脑图形 | 分B01中 |
+(2 rows)
+
select *,character_length(术语) from 计算机术语;
-ERROR: parser: parse error at or near "caf5"
+ 术语 | 分类号 | 备注1a | char_length
+------------+---------+--------+-------------
+ 电脑显示屏 | 机A01上 | | 5
+ 电脑图形 | 分B01中 | | 4
+ 电脑程序员 | 人Z01下 | | 5
+(3 rows)
+
select *,octet_length(术语) from 计算机术语;
-ERROR: parser: parse error at or near "caf5"
+ 术语 | 分类号 | 备注1a | octet_length
+------------+---------+--------+--------------
+ 电脑显示屏 | 机A01上 | | 10
+ 电脑图形 | 分B01中 | | 8
+ 电脑程序员 | 人Z01下 | | 10
+(3 rows)
+
select *,position('显' in 术语) from 计算机术语;
-ERROR: parser: parse error at or near "caf5"
+ 术语 | 分类号 | 备注1a | position
+------------+---------+--------+----------
+ 电脑显示屏 | 机A01上 | | 3
+ 电脑图形 | 分B01中 | | 0
+ 电脑程序员 | 人Z01下 | | 0
+(3 rows)
+
select *,substring(术语 from 3 for 4) from 计算机术语;
-ERROR: parser: parse error at or near "caf5"
+ 术语 | 分类号 | 备注1a | substring
+------------+---------+--------+-----------
+ 电脑显示屏 | 机A01上 | | 显示屏
+ 电脑图形 | 分B01中 | | 图形
+ 电脑程序员 | 人Z01下 | | 程序员
+(3 rows)
+
diff --git a/src/test/mb/expected/euc_kr.out b/src/test/mb/expected/euc_kr.out
index 85282e627f..8b90c4d76e 100644
--- a/src/test/mb/expected/euc_kr.out
+++ b/src/test/mb/expected/euc_kr.out
@@ -1,38 +1,87 @@
drop table 酮擤薛侩绢;
-ERROR: parser: parse error at or near "("
+ERROR: table "酮擤薛侩绢" does not exist
create table 酮擤薛侩绢 (侩绢 text, 萋拙内靛 varchar, 厚绊1A扼备 char(16));
-ERROR: parser: parse error at or near "("
create index 酮擤薛侩绢index1 on 酮擤薛侩绢 using btree (侩绢);
-ERROR: parser: parse error at or near "("
create index 酮擤薛侩绢index2 on 酮擤薛侩绢 using hash (萋拙内靛);
-ERROR: parser: parse error at or near "("
insert into 酮擤薛侩绢 values('哪腔磐叼胶敲饭捞', '薛A01呔');
-ERROR: parser: parse error at or near "("
insert into 酮擤薛侩绢 values('哪腔磐弊贰侨胶', '萋B10耖');
-ERROR: parser: parse error at or near "("
insert into 酮擤薛侩绢 values('哪腔磐橇肺弊贰赣', '煅Z01');
-ERROR: parser: parse error at or near "("
vacuum 酮擤薛侩绢;
-ERROR: parser: parse error at or near "("
select * from 酮擤薛侩绢;
-ERROR: parser: parse error at or near "92"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备
+------------------+----------+------------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔 |
+ 哪腔磐弊贰侨胶 | 萋B10耖 |
+ 哪腔磐橇肺弊贰赣 | 煅Z01 |
+(3 rows)
+
select * from 酮擤薛侩绢 where 萋拙内靛 = '煅Z01';
-ERROR: parser: parse error at or near "92"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备
+------------------+----------+------------
+ 哪腔磐橇肺弊贰赣 | 煅Z01 |
+(1 row)
+
select * from 酮擤薛侩绢 where 萋拙内靛 ~* '煅z01';
-ERROR: parser: parse error at or near "92"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备
+------------------+----------+------------
+ 哪腔磐橇肺弊贰赣 | 煅Z01 |
+(1 row)
+
select * from 酮擤薛侩绢 where 萋拙内靛 like '_Z01_';
-ERROR: parser: parse error at or near "92"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备
+------------------+----------+------------
+ 哪腔磐橇肺弊贰赣 | 煅Z01 |
+(1 row)
+
select * from 酮擤薛侩绢 where 萋拙内靛 like '_Z%';
-ERROR: parser: parse error at or near "92"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备
+------------------+----------+------------
+ 哪腔磐橇肺弊贰赣 | 煅Z01 |
+(1 row)
+
select * from 酮擤薛侩绢 where 侩绢 ~ '哪腔磐[叼弊]';
-ERROR: parser: parse error at or near "92"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备
+------------------+----------+------------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔 |
+ 哪腔磐弊贰侨胶 | 萋B10耖 |
+(2 rows)
+
select * from 酮擤薛侩绢 where 侩绢 ~* '哪腔磐[叼弊]';
-ERROR: parser: parse error at or near "92"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备
+------------------+----------+------------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔 |
+ 哪腔磐弊贰侨胶 | 萋B10耖 |
+(2 rows)
+
select *,character_length(侩绢) from 酮擤薛侩绢;
-ERROR: parser: parse error at or near "bfeb"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备 | char_length
+------------------+----------+------------+-------------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔 | | 8
+ 哪腔磐弊贰侨胶 | 萋B10耖 | | 7
+ 哪腔磐橇肺弊贰赣 | 煅Z01 | | 8
+(3 rows)
+
select *,octet_length(侩绢) from 酮擤薛侩绢;
-ERROR: parser: parse error at or near "bfeb"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备 | octet_length
+------------------+----------+------------+--------------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔 | | 16
+ 哪腔磐弊贰侨胶 | 萋B10耖 | | 14
+ 哪腔磐橇肺弊贰赣 | 煅Z01 | | 16
+(3 rows)
+
select *,position('叼' in 侩绢) from 酮擤薛侩绢;
-ERROR: parser: parse error at or near "bfeb"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备 | position
+------------------+----------+------------+----------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔 | | 4
+ 哪腔磐弊贰侨胶 | 萋B10耖 | | 0
+ 哪腔磐橇肺弊贰赣 | 煅Z01 | | 0
+(3 rows)
+
select *,substring(侩绢 from 3 for 4) from 酮擤薛侩绢;
-ERROR: parser: parse error at or near "bfeb"
+ 侩绢 | 萋拙内靛 | 厚绊1a扼备 | substring
+------------------+----------+------------+-----------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔 | | 磐叼胶敲
+ 哪腔磐弊贰侨胶 | 萋B10耖 | | 磐弊贰侨
+ 哪腔磐橇肺弊贰赣 | 煅Z01 | | 磐橇肺弊
+(3 rows)
+
diff --git a/src/test/mb/expected/euc_tw.out b/src/test/mb/expected/euc_tw.out
index f9629f9f78..3b0a0f75d6 100644
--- a/src/test/mb/expected/euc_tw.out
+++ b/src/test/mb/expected/euc_tw.out
@@ -1,38 +1,85 @@
drop table 燹俑骜砧;
-ERROR: parser: parse error at or near "("
+ERROR: table "燹俑骜砧" does not exist
create table 燹俑骜砧 (如淦杀 text, 狞瞥婉螭 varchar, 氢蛇 varchar(16));
-ERROR: parser: parse error at or near "("
create index 燹俑骜砧index1 on 燹俑骜砧 using btree (如淦杀);
-ERROR: parser: parse error at or near "("
create index 燹俑骜砧index2 on 燹俑骜砧 using hash (狞瞥婉螭);
-ERROR: parser: parse error at or near "("
insert into 燹俑骜砧 values ('缳妾淦', '绠绠绎世', '啤A01念');
-ERROR: parser: parse error at or near "("
insert into 燹俑骜砧 values ('犒葸淦', '芈溷却宇狞瞥', '你B10你');
-ERROR: parser: parse error at or near "("
insert into 燹俑骜砧 values ('螫悖淦', '印汤洗枪却宇狞瞥', '仨Z01摩');
-ERROR: parser: parse error at or near "("
vacuum 燹俑骜砧;
-ERROR: parser: parse error at or near "("
select * from 燹俑骜砧;
-ERROR: parser: parse error at or near "92"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇
+--------+------------------+---------
+ 缳妾淦 | 绠绠绎世 | 啤A01念
+ 犒葸淦 | 芈溷却宇狞瞥 | 你B10你
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
+(3 rows)
+
select * from 燹俑骜砧 where 氢蛇 = '仨Z01摩';
-ERROR: parser: parse error at or near "92"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇
+--------+------------------+---------
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
+(1 row)
+
select * from 燹俑骜砧 where 氢蛇 ~* '仨z01摩';
-ERROR: parser: parse error at or near "92"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇
+--------+------------------+---------
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
+(1 row)
+
select * from 燹俑骜砧 where 氢蛇 like '_Z01_';
-ERROR: parser: parse error at or near "92"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇
+--------+------------------+---------
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
+(1 row)
+
select * from 燹俑骜砧 where 氢蛇 like '_Z%';
-ERROR: parser: parse error at or near "92"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇
+--------+------------------+---------
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
+(1 row)
+
select * from 燹俑骜砧 where 狞瞥婉螭 ~ '绠绠绎[凫卮世]';
-ERROR: parser: parse error at or near "92"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇
+--------+----------+---------
+ 缳妾淦 | 绠绠绎世 | 啤A01念
+(1 row)
+
select * from 燹俑骜砧 where 狞瞥婉螭 ~* '绠绠绎[凫卮世]';
-ERROR: parser: parse error at or near "92"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇
+--------+----------+---------
+ 缳妾淦 | 绠绠绎世 | 啤A01念
+(1 row)
+
select *, character_length(如淦杀) from 燹俑骜砧;
-ERROR: parser: parse error at or near "c8e7"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇 | char_length
+--------+------------------+---------+-------------
+ 缳妾淦 | 绠绠绎世 | 啤A01念 | 3
+ 犒葸淦 | 芈溷却宇狞瞥 | 你B10你 | 3
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 | 3
+(3 rows)
+
select *, octet_length(如淦杀) from 燹俑骜砧;
-ERROR: parser: parse error at or near "c8e7"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇 | octet_length
+--------+------------------+---------+--------------
+ 缳妾淦 | 绠绠绎世 | 啤A01念 | 6
+ 犒葸淦 | 芈溷却宇狞瞥 | 你B10你 | 6
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 | 6
+(3 rows)
+
select *, position('却宇' in 狞瞥婉螭) from 燹俑骜砧;
-ERROR: parser: parse error at or near "c4fc"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇 | position
+--------+------------------+---------+----------
+ 缳妾淦 | 绠绠绎世 | 啤A01念 | 0
+ 犒葸淦 | 芈溷却宇狞瞥 | 你B10你 | 3
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 | 5
+(3 rows)
+
select *, substring(狞瞥婉螭 from 3 for 6 ) from 燹俑骜砧;
-ERROR: parser: parse error at or near "c4fc"
+ 如淦杀 | 狞瞥婉螭 | 氢蛇 | substring
+--------+------------------+---------+--------------
+ 缳妾淦 | 绠绠绎世 | 啤A01念 | 绎世
+ 犒葸淦 | 芈溷却宇狞瞥 | 你B10你 | 却宇狞瞥
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 | 洗枪却宇狞瞥
+(3 rows)
+
diff --git a/src/test/mb/expected/mule_internal.out b/src/test/mb/expected/mule_internal.out
index 034701277a..983ece1cfd 100644
--- a/src/test/mb/expected/mule_internal.out
+++ b/src/test/mb/expected/mule_internal.out
@@ -22,66 +22,67 @@ select * from 挿讙换挼脱捀 where 捠瑨梧挜硳〖挜 = '捒蚙01挷';
(1 row)
select * from 挿讙换挼脱捀 where 捠瑨梧挜硳〖挜 ~* '捒蛕01挷';
- 捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ
---------+-----------------+----------------
-(0 rows)
+ 捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ
+--------------------------------------+-----------------+----------------
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 |
+(1 row)
select * from 挿讙换挼脱捀 where 捠瑨梧挜硳〖挜 like '_Z01_';
- 捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ
---------+-----------------+----------------
-(0 rows)
+ 捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ
+--------------------------------------+-----------------+----------------
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 |
+(1 row)
select * from 挿讙换挼脱捀 where 捠瑨梧挜硳〖挜 like '_Z%';
- 捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ
---------+-----------------+----------------
-(0 rows)
+ 捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ
+--------------------------------------+-----------------+----------------
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 |
+(1 row)
select * from 挿讙换挼脱捀 where 捦褣胳 ~ '挜硳ン挜話ュ挕紥タ[挜菕グ]';
捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ
-----------------------------------------+-----------------+----------------
挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ | 挼01捑 |
挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜 | 捠珺10捗 |
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 |
-(3 rows)
+(2 rows)
select * from 挿讙换挼脱捀 where 捦褣胳 ~* '挜硳ン挜話ュ挕紥タ[挜菕グ]';
捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ
-----------------------------------------+-----------------+----------------
挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ | 挼01捑 |
挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜 | 捠珺10捗 |
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 |
-(3 rows)
+(2 rows)
select *,character_length(捦褣胳) from 挿讙换挼脱捀;
捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ | char_length
-----------------------------------------+-----------------+----------------+-------------
- 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ | 挼01捑 | | 18
- 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜 | 捠珺10捗 | | 20
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 | | 18
+ 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ | 挼01捑 | | 12
+ 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜 | 捠珺10捗 | | 13
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 | | 12
(3 rows)
select *,octet_length(捦褣胳) from 挿讙换挼脱捀;
捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ | octet_length
-----------------------------------------+-----------------+----------------+--------------
- 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ | 挼01捑 | | 54
- 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜 | 捠珺10捗 | | 59
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 | | 54
+ 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ | 挼01捑 | | 36
+ 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜 | 捠珺10捗 | | 39
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 | | 36
(3 rows)
select *,position('挜' in 捦褣胳) from 挿讙换挼脱捀;
捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ | position
-----------------------------------------+-----------------+----------------+----------
- 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ | 挼01捑 | | 0
+ 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ | 挼01捑 | | 7
挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜 | 捠珺10捗 | | 0
挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 | | 0
(3 rows)
select *,substring(捦褣胳 from 10 for 4) from 挿讙换挼脱捀;
- 捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ | substring
------------------------------------------+-----------------+----------------+-----------
- 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ | 挼01捑 | | 挜菕ィ挜
- 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜 | 捠珺10捗 | | 挜皰ラ挜
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 | | 挜讙ロ挜
+ 捦褣胳 | 捠瑨梧挜硳〖挜 | 捜鲯雇1a挙罀よ | substring
+-----------------------------------------+-----------------+----------------+--------------
+ 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ | 挼01捑 | | 挜讙レ挜
+ 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜 | 捠珺10捗 | | 挜ッ挜瘨ス
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷 | | 挜閽マ挕
(3 rows)
drop table 懠茟算懟鷳术懹;
@@ -108,52 +109,57 @@ select * from 懠茟算懟鷳术懹 where 懛謶类懞 = '懭薢01懴';
(1 row)
select * from 懠茟算懟鷳术懹 where 懛謶类懞 ~* '懭藌01懴';
- 懯鯌语 | 懛謶类懞 | 懕笐注1a
---------+-----------+----------
-(0 rows)
+ 懯鯌语 | 懛謶类懞 | 懕笐注1a
+-----------------+-----------+----------
+ 懙鐟脑懗虘序懺 | 懭薢01懴 |
+(1 row)
select * from 懠茟算懟鷳术懹 where 懛謶类懞 like '_Z01_';
- 懯鯌语 | 懛謶类懞 | 懕笐注1a
---------+-----------+----------
-(0 rows)
+ 懯鯌语 | 懛謶类懞 | 懕笐注1a
+-----------------+-----------+----------
+ 懙鐟脑懗虘序懺 | 懭薢01懴 |
+(1 row)
select * from 懠茟算懟鷳术懹 where 懛謶类懞 like '_Z%';
- 懯鯌语 | 懛謶类懞 | 懕笐注1a
---------+-----------+----------
-(0 rows)
+ 懯鯌语 | 懛謶类懞 | 懕笐注1a
+-----------------+-----------+----------
+ 懙鐟脑懗虘序懺 | 懭薢01懴 |
+(1 row)
select * from 懠茟算懟鷳术懹 where 懯鯌语 ~ '懙鐟脑[懴詰图]';
懯鯌语 | 懛謶类懞 | 懕笐注1a
-----------------+-----------+----------
懙鐟脑懴詰示懫 | 懟鶤01懮 |
-(1 row)
+ 懙鐟脑懲紤形 | 懛諦01懼 |
+(2 rows)
select * from 懠茟算懟鷳术懹 where 懯鯌语 ~* '懙鐟脑[懴詰图]';
懯鯌语 | 懛謶类懞 | 懕笐注1a
-----------------+-----------+----------
懙鐟脑懴詰示懫 | 懟鶤01懮 |
-(1 row)
+ 懙鐟脑懲紤形 | 懛諦01懼 |
+(2 rows)
select *,character_length(懯鯌语) from 懠茟算懟鷳术懹;
懯鯌语 | 懛謶类懞 | 懕笐注1a | char_length
-----------------+-----------+----------+-------------
- 懙鐟脑懴詰示懫 | 懟鶤01懮 | | 8
- 懙鐟脑懲紤形 | 懛諦01懼 | | 6
- 懙鐟脑懗虘序懺 | 懭薢01懴 | | 8
+ 懙鐟脑懴詰示懫 | 懟鶤01懮 | | 5
+ 懙鐟脑懲紤形 | 懛諦01懼 | | 4
+ 懙鐟脑懗虘序懺 | 懭薢01懴 | | 5
(3 rows)
select *,octet_length(懯鯌语) from 懠茟算懟鷳术懹;
懯鯌语 | 懛謶类懞 | 懕笐注1a | octet_length
-----------------+-----------+----------+--------------
- 懙鐟脑懴詰示懫 | 懟鶤01懮 | | 23
- 懙鐟脑懲紤形 | 懛諦01懼 | | 18
- 懙鐟脑懗虘序懺 | 懭薢01懴 | | 23
+ 懙鐟脑懴詰示懫 | 懟鶤01懮 | | 15
+ 懙鐟脑懲紤形 | 懛諦01懼 | | 12
+ 懙鐟脑懗虘序懺 | 懭薢01懴 | | 15
(3 rows)
select *,position('懴' in 懯鯌语) from 懠茟算懟鷳术懹;
懯鯌语 | 懛謶类懞 | 懕笐注1a | position
-----------------+-----------+----------+----------
- 懙鐟脑懴詰示懫 | 懟鶤01懮 | | 0
+ 懙鐟脑懴詰示懫 | 懟鶤01懮 | | 3
懙鐟脑懲紤形 | 懛諦01懼 | | 0
懙鐟脑懗虘序懺 | 懭薢01懴 | | 0
(3 rows)
@@ -161,9 +167,9 @@ select *,position('懴' in 懯鯌语) from 懠茟算懟鷳术懹;
select *,substring(懯鯌语 from 3 for 4) from 懠茟算懟鷳术懹;
懯鯌语 | 懛謶类懞 | 懕笐注1a | substring
-----------------+-----------+----------+-----------
- 懙鐟脑懴詰示懫 | 懟鶤01懮 | | 脑懴詰示
- 懙鐟脑懲紤形 | 懛諦01懼 | | 脑懲紤形
- 懙鐟脑懗虘序懺 | 懭薢01懴 | | 脑懗虘序
+ 懙鐟脑懴詰示懫 | 懟鶤01懮 | | 懴詰示懫
+ 懙鐟脑懲紤形 | 懛諦01懼 | | 懲紤形
+ 懙鐟脑懗虘序懺 | 懭薢01懴 | | 懗虘序懺
(3 rows)
drop table 撏獡擤撗侩摼;
@@ -190,60 +196,67 @@ select * from 撏獡擤撗侩摼 where 撦聯拙撃趽靛 = '撿裐01擓';
(1 row)
select * from 撏獡擤撗侩摼 where 撦聯拙撃趽靛 ~* '撿褄01擓';
- 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备
---------+--------------+----------------
-(0 rows)
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备
+--------------------------+--------------+----------------
+ 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓 |
+(1 row)
select * from 撏獡擤撗侩摼 where 撦聯拙撃趽靛 like '_Z01_';
- 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备
---------+--------------+----------------
-(0 rows)
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备
+--------------------------+--------------+----------------
+ 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓 |
+(1 row)
select * from 撏獡擤撗侩摼 where 撦聯拙撃趽靛 like '_Z%';
- 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备
---------+--------------+----------------
-(0 rows)
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备
+--------------------------+--------------+----------------
+ 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓 |
+(1 row)
select * from 撏獡擤撗侩摼 where 摽霌绢 ~ '撃膿腔撆蚚摰饟弊]';
- 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备
---------+--------------+----------------
-(0 rows)
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备
+--------------------------+--------------+----------------
+ 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨 |
+ 撃膿腔撆蛽弊摲侨摻 | 撦翨10擇 |
+(2 rows)
select * from 撏獡擤撗侩摼 where 摽霌绢 ~* '撃膿腔撆蚚摰饟弊]';
- 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备
---------+--------------+----------------
-(0 rows)
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备
+--------------------------+--------------+----------------
+ 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨 |
+ 撃膿腔撆蛽弊摲侨摻 | 撦翨10擇 |
+(2 rows)
select *,character_length(摽霌绢) from 撏獡擤撗侩摼;
摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 | char_length
--------------------------+--------------+----------------+-------------
- 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨 | | 12
- 撃膿腔撆蛽弊摲侨摻 | 撦翨10擇 | | 11
- 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓 | | 12
+ 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨 | | 8
+ 撃膿腔撆蛽弊摲侨摻 | 撦翨10擇 | | 7
+ 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓 | | 8
(3 rows)
select *,octet_length(摽霌绢) from 撏獡擤撗侩摼;
摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 | octet_length
--------------------------+--------------+----------------+--------------
- 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨 | | 36
- 撃膿腔撆蛽弊摲侨摻 | 撦翨10擇 | | 32
- 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓 | | 36
+ 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨 | | 24
+ 撃膿腔撆蛽弊摲侨摻 | 撦翨10擇 | | 21
+ 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓 | | 24
(3 rows)
select *,position('摰' in 摽霌绢) from 撏獡擤撗侩摼;
摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 | position
--------------------------+--------------+----------------+----------
- 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨 | | 0
+ 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨 | | 4
撃膿腔撆蛽弊摲侨摻 | 撦翨10擇 | | 0
撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓 | | 0
(3 rows)
select *,substring(摽霌绢 from 3 for 4) from 撏獡擤撗侩摼;
- 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 | substring
---------------------------+--------------+----------------+-----------
- 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨 | | 腔撆蛽叼
- 撃膿腔撆蛽弊摲侨摻 | 撦翨10擇 | | 腔撆蛽弊
- 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓 | | 腔撆蛽橇
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 | substring
+--------------------------+--------------+----------------+--------------
+ 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨 | | 撆蛽叼摻簱敲
+ 撃膿腔撆蛽弊摲侨摻 | 撦翨10擇 | | 撆蛽弊摲侨
+ 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓 | | 撆蛽橇摲螕弊
(3 rows)
drop table test;
@@ -292,10 +305,10 @@ select *,octet_length(t) from test;
t | octet_length
--------------------------------------+--------------
ENGLISH | 7
- FRAN伹AIS | 10
- ESPA佈OL | 9
- 佂SLENSKA | 10
- ENGLISH FRAN伹AIS ESPA佈OL 佂SLENSKA | 39
+ FRAN伹AIS | 9
+ ESPA佈OL | 8
+ 佂SLENSKA | 9
+ ENGLISH FRAN伹AIS ESPA佈OL 佂SLENSKA | 36
(5 rows)
select *,position('L' in t) from test;
diff --git a/src/test/mb/expected/unicode.out b/src/test/mb/expected/unicode.out
index 71c9e9a441..b32ab76838 100644
--- a/src/test/mb/expected/unicode.out
+++ b/src/test/mb/expected/unicode.out
@@ -1,295 +1,87 @@
drop table 瑷堢畻姗熺敤瑾;
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
-ERROR: table "瑷姗瑾" does not exist
+ERROR: table "瑷堢畻姗熺敤瑾" does not exist
create table 瑷堢畻姗熺敤瑾 (鐢ㄨ獮 text, 鍒嗛銈炽兗銉 varchar, 鍌欒1A銇犮倛 char(16));
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe582) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x99e8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8083) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe381) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa0e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8288) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "1"
create index 瑷堢畻姗熺敤瑾瀒ndex1 on 瑷堢畻姗熺敤瑾 using btree (鐢ㄨ獮);
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e69) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "btree"
create index 瑷堢畻姗熺敤瑾瀒ndex2 on 瑷堢畻姗熺敤瑾 using hash (鍒嗛銈炽兗銉);
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e69) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8929) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "hash"
insert into 瑷堢畻姗熺敤瑾 values('銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆','姗烝01涓');
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x87e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82a3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8397) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xace3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82a4) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9f41) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8a27) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "'"
insert into 瑷堢畻姗熺敤瑾 values('銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈','鍒咮10涓');
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83a9) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x95e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82a3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82af) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xb927) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8642) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xad27) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "'"
insert into 瑷堢畻姗熺敤瑾 values('銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗','浜篫01涓');
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x97e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83ad) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83a9) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9ee3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xba5a) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8b27) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "'"
vacuum 瑷堢畻姗熺敤瑾;
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
-NOTICE: Vacuum: table not found
select * from 瑷堢畻姗熺敤瑾;
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
-ERROR: Relation '瑷姗瑾' does not exist
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛
+-----------------------------------------+-----------------+----------------
+ 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆 | 姗烝01涓 |
+ 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈 | 鍒咮10涓 |
+ 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓 |
+(3 rows)
+
select * from 瑷堢畻姗熺敤瑾 where 鍒嗛銈炽兗銉 = '浜篫01涓';
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xba5a) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8b27) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "="
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛
+--------------------------------------+-----------------+----------------
+ 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓 |
+(1 row)
+
select * from 瑷堢畻姗熺敤瑾 where 鍒嗛銈炽兗銉 ~* '浜簔01涓';
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xba7a) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8b27) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "~*"
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛
+--------------------------------------+-----------------+----------------
+ 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓 |
+(1 row)
+
select * from 瑷堢畻姗熺敤瑾 where 鍒嗛銈炽兗銉 like '_Z01_';
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "'"
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛
+--------------------------------------+-----------------+----------------
+ 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓 |
+(1 row)
+
select * from 瑷堢畻姗熺敤瑾 where 鍒嗛銈炽兗銉 like '_Z%';
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "'"
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛
+--------------------------------------+-----------------+----------------
+ 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓 |
+(1 row)
+
select * from 瑷堢畻姗熺敤瑾 where 鐢ㄨ獮 ~ '銈炽兂銉斻儱銉笺偪[銉囥偘]';
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x87e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82b0) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "~"
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛
+-----------------------------------------+-----------------+----------------
+ 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆 | 姗烝01涓 |
+ 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈 | 鍒咮10涓 |
+(2 rows)
+
select * from 瑷堢畻姗熺敤瑾 where 鐢ㄨ獮 ~* '銈炽兂銉斻儱銉笺偪[銉囥偘]';
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x87e3) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x82b0) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "~*"
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛
+-----------------------------------------+-----------------+----------------
+ 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆 | 姗烝01涓 |
+ 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈 | 鍒咮10涓 |
+(2 rows)
+
select *,character_length(鐢ㄨ獮) from 瑷堢畻姗熺敤瑾;
-NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
-ERROR: Relation '瑷姗瑾' does not exist
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛 | char_length
+-----------------------------------------+-----------------+----------------+-------------
+ 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆 | 姗烝01涓 | | 12
+ 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈 | 鍒咮10涓 | | 13
+ 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓 | | 12
+(3 rows)
+
select *,octet_length(鐢ㄨ獮) from 瑷堢畻姗熺敤瑾;
-NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
-ERROR: Relation '瑷姗瑾' does not exist
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛 | octet_length
+-----------------------------------------+-----------------+----------------+--------------
+ 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆 | 姗烝01涓 | | 36
+ 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈 | 鍒咮10涓 | | 39
+ 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓 | | 36
+(3 rows)
+
select *,position('銉' in 鐢ㄨ獮) from 瑷堢畻姗熺敤瑾;
-NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x8727) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
-ERROR: Unterminated quoted string
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛 | position
+-----------------------------------------+-----------------+----------------+----------
+ 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆 | 姗烝01涓 | | 7
+ 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈 | 鍒咮10涓 | | 0
+ 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓 | | 0
+(3 rows)
+
select *,substring(鐢ㄨ獮 from 10 for 4) from 瑷堢畻姗熺敤瑾;
-NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
-NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
-ERROR: parser: parse error at or near "from"
+ 鐢ㄨ獮 | 鍒嗛銈炽兗銉 | 鍌欒1a銇犮倛 | substring
+-----------------------------------------+-----------------+----------------+--------------
+ 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆 | 姗烝01涓 | | 銉椼儸銈
+ 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈 | 鍒咮10涓 | | 銈c儍銈偣
+ 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓 | | 銉┿優銉
+(3 rows)
+