diff options
author | Tatsuo Ishii <ishii@postgresql.org> | 2001-09-22 08:47:20 +0000 |
---|---|---|
committer | Tatsuo Ishii <ishii@postgresql.org> | 2001-09-22 08:47:20 +0000 |
commit | 67c26c12aff7d5c41e82b5e220a435e943095bfc (patch) | |
tree | 2d6d6a2d4e247e3e087ee5e2539a3b70ff12c041 /src/test | |
parent | 8ebdac0ed5839cdaaa3ef44ecb917727af4634bb (diff) | |
download | postgresql-67c26c12aff7d5c41e82b5e220a435e943095bfc.tar.gz |
Fix expected files.
Diffstat (limited to 'src/test')
-rw-r--r-- | src/test/mb/expected/big5.out | 1 | ||||
-rw-r--r-- | src/test/mb/expected/euc_cn.out | 87 | ||||
-rw-r--r-- | src/test/mb/expected/euc_kr.out | 87 | ||||
-rw-r--r-- | src/test/mb/expected/euc_tw.out | 85 | ||||
-rw-r--r-- | src/test/mb/expected/mule_internal.out | 167 | ||||
-rw-r--r-- | src/test/mb/expected/unicode.out | 344 |
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) + |