From 62e48272c221e8b38c4aae14a7ad365fe8f93cd5 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Wed, 21 Feb 2001 06:03:25 +0000 Subject: [PATCH] new regression data for 7.1 --- src/test/mb/expected/big5.out | 13 +- src/test/mb/expected/euc_cn.out | 87 ++----- src/test/mb/expected/euc_jp.out | 16 +- src/test/mb/expected/euc_kr.out | 87 ++----- src/test/mb/expected/euc_tw.out | 85 ++---- src/test/mb/expected/mule_internal.out | 219 ++++++++-------- src/test/mb/expected/sjis.out | 14 +- src/test/mb/expected/unicode.out | 344 ++++++++++++++++++++----- 8 files changed, 458 insertions(+), 407 deletions(-) diff --git a/src/test/mb/expected/big5.out b/src/test/mb/expected/big5.out index 14ae2be29a..8ba6a9a25f 100644 --- a/src/test/mb/expected/big5.out +++ b/src/test/mb/expected/big5.out @@ -1,4 +1,5 @@ drop table ¼t°Ó¸ê®Æ; +ERROR: table "¼t°Ó¸ê®Æ" does not exist create table ¼t°Ó¸ê®Æ (¦æ·~§O text, ¤½¥q©ïÀY varchar, ¦a§} varchar(16)); create index ¼t°Ó¸ê®Æindex1 on ¼t°Ó¸ê®Æ using btree (¦æ·~§O); create index ¼t°Ó¸ê®Æindex2 on ¼t°Ó¸ê®Æ using hash (¤½¥q©ïÀY); @@ -67,15 +68,15 @@ select *, octet_length( (3 rows) select *, position('¦³­­' in ¤½¥q©ïÀY) from ¼t°Ó¸ê®Æ; - ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} | strpos ---------+------------------+---------+-------- - ¹q¸£·~ | ¹F¹F¬ì§Þ | ¥_A01¤¯ | 0 - »s³y·~ | °]·½¦³­­¤½¥q | ¤¤B10¤¤ | 3 - À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³­­¤½¥q | °ªZ01¤E | 5 + ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} | position +--------+------------------+---------+---------- + ¹q¸£·~ | ¹F¹F¬ì§Þ | ¥_A01¤¯ | 0 + »s³y·~ | °]·½¦³­­¤½¥q | ¤¤B10¤¤ | 3 + À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³­­¤½¥q | °ªZ01¤E | 5 (3 rows) select *, substring(¤½¥q©ïÀY from 3 for 6 ) from ¼t°Ó¸ê®Æ; - ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} | substr + ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} | substring --------+------------------+---------+-------------- ¹q¸£·~ | ¹F¹F¬ì§Þ | ¥_A01¤¯ | ¬ì§Þ »s³y·~ | °]·½¦³­­¤½¥q | ¤¤B10¤¤ | ¦³­­¤½¥q diff --git a/src/test/mb/expected/euc_cn.out b/src/test/mb/expected/euc_cn.out index 7fdb13cfe5..8b80d6d584 100644 --- a/src/test/mb/expected/euc_cn.out +++ b/src/test/mb/expected/euc_cn.out @@ -1,87 +1,38 @@ drop table ¼ÆËã»úÊõÓï; -ERROR: Relation '¼ÆËã»úÊõÓï' does not exist +ERROR: parser: parse error at or near "(" 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 ¼ÆËã»úÊõÓï; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | - µçÄÔͼÐÎ | ·ÖB01ÖÐ | - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | -(3 rows) - +ERROR: parser: parse error at or near "92" select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ = 'ÈËZ01ÏÂ'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | -(1 row) - +ERROR: parser: parse error at or near "92" select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ ~* 'ÈËz01ÏÂ'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | -(1 row) - +ERROR: parser: parse error at or near "92" select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ like '_Z01_'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | -(1 row) - +ERROR: parser: parse error at or near "92" select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ like '_Z%'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | -(1 row) - +ERROR: parser: parse error at or near "92" select * from ¼ÆËã»úÊõÓï where ÊõÓï ~ 'µçÄÔ[ÏÔͼ]'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | - µçÄÔͼÐÎ | ·ÖB01ÖÐ | -(2 rows) - +ERROR: parser: parse error at or near "92" select * from ¼ÆËã»úÊõÓï where ÊõÓï ~* 'µçÄÔ[ÏÔͼ]'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | - µçÄÔͼÐÎ | ·ÖB01ÖÐ | -(2 rows) - +ERROR: parser: parse error at or near "92" select *,character_length(ÊõÓï) from ¼ÆËã»úÊõÓï; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | char_length -------------+---------+--------+------------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | 5 - µçÄÔͼÐÎ | ·ÖB01ÖÐ | | 4 - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | 5 -(3 rows) - +ERROR: parser: parse error at or near "caf5" select *,octet_length(ÊõÓï) from ¼ÆËã»úÊõÓï; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | octet_length -------------+---------+--------+-------------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | 10 - µçÄÔͼÐÎ | ·ÖB01ÖÐ | | 8 - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | 10 -(3 rows) - +ERROR: parser: parse error at or near "caf5" select *,position('ÏÔ' in ÊõÓï) from ¼ÆËã»úÊõÓï; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | strpos -------------+---------+--------+-------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | 3 - µçÄÔͼÐÎ | ·ÖB01ÖÐ | | 0 - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | 0 -(3 rows) - +ERROR: parser: parse error at or near "caf5" select *,substring(ÊõÓï from 3 for 4) from ¼ÆËã»úÊõÓï; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | substr -------------+---------+--------+-------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | ÏÔʾÆÁ - µçÄÔͼÐÎ | ·ÖB01ÖÐ | | ͼÐÎ - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | ³ÌÐòÔ± -(3 rows) - +ERROR: parser: parse error at or near "caf5" diff --git a/src/test/mb/expected/euc_jp.out b/src/test/mb/expected/euc_jp.out index 190f631fe0..0cdf8fede4 100644 --- a/src/test/mb/expected/euc_jp.out +++ b/src/test/mb/expected/euc_jp.out @@ -1,5 +1,5 @@ drop table ·×»»µ¡ÍѸì; -ERROR: Relation '·×»»µ¡ÍѸì' does not exist +ERROR: table "·×»»µ¡ÍѸì" does not exist create table ·×»»µ¡ÍѸì (ÍѸì text, ʬÎॳ¡¼¥É varchar, È÷¹Í1A¤À¤è char(16)); create index ·×»»µ¡ÍѸìindex1 on ·×»»µ¡ÍѸì using btree (ÍѸì); create index ·×»»µ¡ÍѸìindex2 on ·×»»µ¡ÍѸì using hash (ʬÎॳ¡¼¥É); @@ -70,16 +70,16 @@ select *,octet_length( (3 rows) select *,position('¥Ç' in ÍѸì) from ·×»»µ¡ÍѸì; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è | strpos -----------------------------+------------+------------+-------- - ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | | 7 - ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | | 0 - ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | | 0 + ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è | position +----------------------------+------------+------------+---------- + ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | | 7 + ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | | 0 + ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | | 0 (3 rows) select *,substring(ÍѸì from 10 for 4) from ·×»»µ¡ÍѸì; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è | substr -----------------------------+------------+------------+---------- + ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è | substring +----------------------------+------------+------------+----------- ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | | ¥×¥ì¥¤ ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | | ¥£¥Ã¥¯¥¹ ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | | ¥é¥Þ¡¼ diff --git a/src/test/mb/expected/euc_kr.out b/src/test/mb/expected/euc_kr.out index 368525b220..85282e627f 100644 --- a/src/test/mb/expected/euc_kr.out +++ b/src/test/mb/expected/euc_kr.out @@ -1,87 +1,38 @@ drop table ͪߩѦ¿ë¾î; -ERROR: Relation 'ͪߩѦ¿ë¾î' does not exist +ERROR: parser: parse error at or near "(" 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 ͪߩѦ¿ë¾î; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | -(3 rows) - +ERROR: parser: parse error at or near "92" select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå = 'ìÑZ01ù»'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | -(1 row) - +ERROR: parser: parse error at or near "92" select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå ~* 'ìÑz01ù»'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | -(1 row) - +ERROR: parser: parse error at or near "92" select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z01_'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | -(1 row) - +ERROR: parser: parse error at or near "92" select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z%'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | -(1 row) - +ERROR: parser: parse error at or near "92" select * from ͪߩѦ¿ë¾î where ¿ë¾î ~ 'ÄÄÇ»ÅÍ[µð±×]'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | -(2 rows) - +ERROR: parser: parse error at or near "92" select * from ͪߩѦ¿ë¾î where ¿ë¾î ~* 'ÄÄÇ»ÅÍ[µð±×]'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | -(2 rows) - +ERROR: parser: parse error at or near "92" select *,character_length(¿ë¾î) from ͪߩѦ¿ë¾î; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | char_length -------------------+----------+------------+------------- - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | 8 - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | 7 - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | 8 -(3 rows) - +ERROR: parser: parse error at or near "bfeb" select *,octet_length(¿ë¾î) from ͪߩѦ¿ë¾î; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | octet_length -------------------+----------+------------+-------------- - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | 16 - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | 14 - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | 16 -(3 rows) - +ERROR: parser: parse error at or near "bfeb" select *,position('µð' in ¿ë¾î) from ͪߩѦ¿ë¾î; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | strpos -------------------+----------+------------+-------- - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | 4 - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | 0 - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | 0 -(3 rows) - +ERROR: parser: parse error at or near "bfeb" select *,substring(¿ë¾î from 3 for 4) from ͪߩѦ¿ë¾î; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | substr -------------------+----------+------------+---------- - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | Å͵ð½ºÇà - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | Åͱ׷¡ÇÈ - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | ÅÍÇÁ·Î±× -(3 rows) - +ERROR: parser: parse error at or near "bfeb" diff --git a/src/test/mb/expected/euc_tw.out b/src/test/mb/expected/euc_tw.out index cf855809ab..f9629f9f78 100644 --- a/src/test/mb/expected/euc_tw.out +++ b/src/test/mb/expected/euc_tw.out @@ -1,85 +1,38 @@ drop table ìÞÙ¸æñÕè; -ERROR: Relation 'ìÞÙ¸æñÕè' does not exist +ERROR: parser: parse error at or near "(" 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 ìÞÙ¸æñÕè; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+------------------+--------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî - êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ -(3 rows) - +ERROR: parser: parse error at or near "92" select * from ìÞÙ¸æñÕè where ÇâÉß = 'ØíZ01Ħ'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+------------------+--------- - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ -(1 row) - +ERROR: parser: parse error at or near "92" select * from ìÞÙ¸æñÕè where ÇâÉß ~* 'Øíz01Ħ'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+------------------+--------- - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ -(1 row) - +ERROR: parser: parse error at or near "92" select * from ìÞÙ¸æñÕè where ÇâÉß like '_Z01_'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+------------------+--------- - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ -(1 row) - +ERROR: parser: parse error at or near "92" select * from ìÞÙ¸æñÕè where ÇâÉß like '_Z%'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+------------------+--------- - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ -(1 row) - +ERROR: parser: parse error at or near "92" select * from ìÞÙ¸æñÕè where ÄüƳÍñó¤ ~ 'ç®ç®Òï[ÙìØ´ÊÀ]'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+----------+--------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî -(1 row) - +ERROR: parser: parse error at or near "92" select * from ìÞÙ¸æñÕè where ÄüƳÍñó¤ ~* 'ç®ç®Òï[ÙìØ´ÊÀ]'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+----------+--------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî -(1 row) - +ERROR: parser: parse error at or near "92" select *, character_length(ÈçäÆɱ) from ìÞÙ¸æñÕè; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | char_length ---------+------------------+---------+------------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 3 - êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 3 - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 3 -(3 rows) - +ERROR: parser: parse error at or near "c8e7" select *, octet_length(ÈçäÆɱ) from ìÞÙ¸æñÕè; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | octet_length ---------+------------------+---------+-------------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 6 - êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 6 - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 6 -(3 rows) - +ERROR: parser: parse error at or near "c8e7" select *, position('È´Óî' in ÄüƳÍñó¤) from ìÞÙ¸æñÕè; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | strpos ---------+------------------+---------+-------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 0 - êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 3 - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 5 -(3 rows) - +ERROR: parser: parse error at or near "c4fc" select *, substring(ÄüƳÍñó¤ from 3 for 6 ) from ìÞÙ¸æñÕè; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | substr ---------+------------------+---------+-------------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | ÒïÊÀ - êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | È´ÓîÄüƳ - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | ϴǹȴÓîÄüƳ -(3 rows) - +ERROR: parser: parse error at or near "c4fc" diff --git a/src/test/mb/expected/mule_internal.out b/src/test/mb/expected/mule_internal.out index bfcffc8490..034701277a 100644 --- a/src/test/mb/expected/mule_internal.out +++ b/src/test/mb/expected/mule_internal.out @@ -1,5 +1,5 @@ drop table ’·×’»»’µ¡’Íђ¸ì; -ERROR: Relation '’·×’»»’µ¡’Íђ¸ì' does not exist +ERROR: table "’·×’»»’µ¡’Íђ¸ì" does not exist create table ’·×’»»’µ¡’Íђ¸ì (’Íђ¸ì text, ’ʬ’Îà’¥³’¡¼’¥É varchar, ’È÷’¹Í1A’¤À’¤è char(16)); create index ’·×’»»’µ¡’Íђ¸ìindex1 on ’·×’»»’µ¡’Íђ¸ì using btree (’Íђ¸ì); create index ’·×’»»’µ¡’Íђ¸ìindex2 on ’·×’»»’µ¡’Íђ¸ì using hash (’ʬ’Îà’¥³’¡¼’¥É); @@ -22,71 +22,70 @@ select * from (1 row) select * from ’·×’»»’µ¡’Íђ¸ì where ’ʬ’Îà’¥³’¡¼’¥É ~* '’¿Íz01’²¼'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ---------------------------------------+-----------------+---------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | -(1 row) + ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è +--------+-----------------+---------------- +(0 rows) select * from ’·×’»»’µ¡’Íђ¸ì where ’ʬ’Îà’¥³’¡¼’¥É like '_Z01_'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ---------------------------------------+-----------------+---------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | -(1 row) + ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è +--------+-----------------+---------------- +(0 rows) select * from ’·×’»»’µ¡’Íђ¸ì where ’ʬ’Îà’¥³’¡¼’¥É like '_Z%'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ---------------------------------------+-----------------+---------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | -(1 row) + ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è +--------+-----------------+---------------- +(0 rows) select * from ’·×’»»’µ¡’Íђ¸ì where ’Íђ¸ì ~ '’¥³’¥ó’¥Ô’¥å’¡¼’¥¿[’¥Ç’¥°]'; ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è -----------------------------------------+-----------------+---------------- ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | -(2 rows) + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | +(3 rows) select * from ’·×’»»’µ¡’Íђ¸ì where ’Íђ¸ì ~* '’¥³’¥ó’¥Ô’¥å’¡¼’¥¿[’¥Ç’¥°]'; ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è -----------------------------------------+-----------------+---------------- ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | -(2 rows) + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | +(3 rows) select *,character_length(’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | char_length -----------------------------------------+-----------------+----------------+------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 12 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 13 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 12 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 18 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 20 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 18 (3 rows) select *,octet_length(’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | octet_length -----------------------------------------+-----------------+----------------+-------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 36 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 39 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 36 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 54 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 59 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 54 (3 rows) select *,position('’¥Ç' in ’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | strpos ------------------------------------------+-----------------+----------------+-------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 7 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 0 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 0 + ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | position +-----------------------------------------+-----------------+----------------+---------- + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 0 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 0 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 0 (3 rows) select *,substring(’Íђ¸ì from 10 for 4) from ’·×’»»’µ¡’Íђ¸ì; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | substr ------------------------------------------+-----------------+----------------+-------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | ’¥×’¥ì’¥¤ - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | ’¥£’¥Ã’¥¯’¥¹ - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | ’¥é’¥Þ’¡¼ + ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | substring +-----------------------------------------+-----------------+----------------+----------- + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | ’¥Ç’¥£’¥ + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | ’¥°’¥é’¥ + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | ’¥×’¥í’¥ (3 rows) drop table ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; -ERROR: Relation '‘¼Æ‘Ë㑻ú‘Êõ‘Óï' does not exist +ERROR: table "‘¼Æ‘Ë㑻ú‘Êõ‘Óï" does not exist create table ‘¼Æ‘Ë㑻ú‘Êõ‘Óï(‘Êõ‘Óï text, ‘·Ö‘Àà‘ºÅ varchar, ‘±¸‘×¢1A char(16)); create index ‘¼Æ‘Ë㑻ú‘Êõ‘Óïindex1 on ‘¼Æ‘Ë㑻ú‘Êõ‘Óï using btree(‘Êõ‘Óï); create index ‘¼Æ‘Ë㑻ú‘Êõ‘Óïindex2 on ‘¼Æ‘Ë㑻ú‘Êõ‘Óï using btree(‘·Ö‘Àà‘ºÅ); @@ -109,71 +108,66 @@ select * from (1 row) select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘·Ö‘Àà‘ºÅ ~* '‘ÈËz01‘ÏÂ'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ------------------+-----------+---------- - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | -(1 row) + ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a +--------+-----------+---------- +(0 rows) select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘·Ö‘Àà‘ºÅ like '_Z01_'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ------------------+-----------+---------- - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | -(1 row) + ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a +--------+-----------+---------- +(0 rows) select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘·Ö‘Àà‘ºÅ like '_Z%'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ------------------+-----------+---------- - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | -(1 row) + ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a +--------+-----------+---------- +(0 rows) select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘Êõ‘Óï ~ '‘µç‘ÄÔ[‘Ïԑͼ]'; ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a -----------------+-----------+---------- ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | -(2 rows) +(1 row) select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘Êõ‘Óï ~* '‘µç‘ÄÔ[‘Ïԑͼ]'; ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a -----------------+-----------+---------- ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | -(2 rows) +(1 row) select *,character_length(‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | char_length -----------------+-----------+----------+------------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 5 - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 4 - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 5 + ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 8 + ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 6 + ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 8 (3 rows) select *,octet_length(‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | octet_length -----------------+-----------+----------+-------------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 15 - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 12 - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 15 + ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 23 + ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 18 + ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 23 (3 rows) select *,position('‘ÏÔ' in ‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | strpos ------------------+-----------+----------+-------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 3 - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 0 - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 0 + ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | position +-----------------+-----------+----------+---------- + ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 0 + ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 0 + ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 0 (3 rows) select *,substring(‘Êõ‘Óï from 3 for 4) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | substr + ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | substring -----------------+-----------+----------+----------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | ‘Ïԑʾ‘ÆÁ - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | ‘ͼ‘ÐÎ - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | ‘³Ì‘Ðò‘Ô± + ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | ÄԑÏԑʾ + ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | Äԑͼ‘ÐÎ + ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | Äԑ³Ì‘Ðò (3 rows) drop table “ͪ“ß©“Ѧ“¿ë“¾î; -ERROR: Relation '“ͪ“ß©“Ѧ“¿ë“¾î' does not exist +ERROR: table "“ͪ“ß©“Ѧ“¿ë“¾î" does not exist create table “ͪ“ß©“Ѧ“¿ë“¾î (“¿ë“¾î text, “Ý“׾“Äړµå varchar, “ºñ“°í1A“¶ó“±¸ char(16)); create index “ͪ“ß©“Ѧ“¿ë“¾îindex1 on “ͪ“ß©“Ѧ“¿ë“¾î using btree (“¿ë“¾î); create index “ͪ“ß©“Ѧ“¿ë“¾îindex2 on “ͪ“ß©“Ѧ“¿ë“¾î using hash (“Ý“׾“Äړµå); @@ -196,71 +190,64 @@ select * from (1 row) select * from “ͪ“ß©“Ѧ“¿ë“¾î where “Ý“׾“Äړµå ~* '“ìÑz01“ù»'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | -(1 row) + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ +--------+--------------+---------------- +(0 rows) select * from “ͪ“ß©“Ѧ“¿ë“¾î where “Ý“׾“Äړµå like '_Z01_'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | -(1 row) + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ +--------+--------------+---------------- +(0 rows) select * from “ͪ“ß©“Ѧ“¿ë“¾î where “Ý“׾“Äړµå like '_Z%'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | -(1 row) + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ +--------+--------------+---------------- +(0 rows) select * from “ͪ“ß©“Ѧ“¿ë“¾î where “¿ë“¾î ~ '“Äēǻ“ÅÍ[“µð“±×]'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | -(2 rows) + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ +--------+--------------+---------------- +(0 rows) select * from “ͪ“ß©“Ѧ“¿ë“¾î where “¿ë“¾î ~* '“Äēǻ“ÅÍ[“µð“±×]'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | -(2 rows) + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ +--------+--------------+---------------- +(0 rows) select *,character_length(“¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | char_length --------------------------+--------------+----------------+------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 8 - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 7 - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 8 + “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 12 + “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 11 + “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 12 (3 rows) select *,octet_length(“¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | octet_length --------------------------+--------------+----------------+-------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 24 - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 21 - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 24 + “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 36 + “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 32 + “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 36 (3 rows) select *,position('“µð' in “¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | strpos ---------------------------+--------------+----------------+-------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 4 - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 0 - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 0 + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | position +--------------------------+--------------+----------------+---------- + “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 0 + “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 0 + “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 0 (3 rows) select *,substring(“¿ë“¾î from 3 for 4) from “ͪ“ß©“Ѧ“¿ë“¾î; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | substr ---------------------------+--------------+----------------+-------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | “Å͓µð“½º“Çà - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | “Å͓±×“·¡“ÇÈ - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | “Å͓ÇÁ“·Î“±× + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | substring +--------------------------+--------------+----------------+----------- + “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | Ç»“Å͓µð + “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | Ç»“Å͓±× + “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | Ç»“Å͓ÇÁ (3 rows) drop table test; -ERROR: Relation 'test' does not exist +ERROR: table "test" does not exist create table test (t text); insert into test values('ENGLISH'); insert into test values('FRANÇAIS'); @@ -305,25 +292,25 @@ select *,octet_length(t) from test; t | octet_length --------------------------------------+-------------- ENGLISH | 7 - FRANÇAIS | 9 - ESPAÑOL | 8 - ÍSLENSKA | 9 - ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | 36 + FRANÇAIS | 10 + ESPAÑOL | 9 + ÍSLENSKA | 10 + ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | 39 (5 rows) select *,position('L' in t) from test; - t | strpos ---------------------------------------+-------- - ENGLISH | 4 - FRANÇAIS | 0 - ESPAÑOL | 7 - ÍSLENSKA | 3 - ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | 4 + t | position +--------------------------------------+---------- + ENGLISH | 4 + FRANÇAIS | 0 + ESPAÑOL | 7 + ÍSLENSKA | 3 + ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | 4 (5 rows) select *,substring(t from 3 for 4) from test; - t | substr ---------------------------------------+-------- + t | substring +--------------------------------------+----------- ENGLISH | GLIS FRANÇAIS | ANÇA ESPAÑOL | PAÑO diff --git a/src/test/mb/expected/sjis.out b/src/test/mb/expected/sjis.out index 39ae540da4..2a852086e1 100644 --- a/src/test/mb/expected/sjis.out +++ b/src/test/mb/expected/sjis.out @@ -69,16 +69,16 @@ select *,octet_length( (3 rows) select *,position('ƒf' in —pŒê) from ŒvŽZ‹@—pŒê; - —pŒê | •ª—ÞƒR[ƒh | ”õl1a‚¾‚æ | strpos -----------------------------+------------+------------+-------- - ƒRƒ“ƒsƒ…[ƒ^ƒfƒBƒXƒvƒŒƒC | ‹@A01ã | | 7 - ƒRƒ“ƒsƒ…[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX | •ªB10’† | | 0 - ƒRƒ“ƒsƒ…[ƒ^ƒvƒƒOƒ‰ƒ}[ | lZ01‰º | | 0 + —pŒê | •ª—ÞƒR[ƒh | ”õl1a‚¾‚æ | position +----------------------------+------------+------------+---------- + ƒRƒ“ƒsƒ…[ƒ^ƒfƒBƒXƒvƒŒƒC | ‹@A01ã | | 7 + ƒRƒ“ƒsƒ…[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX | •ªB10’† | | 0 + ƒRƒ“ƒsƒ…[ƒ^ƒvƒƒOƒ‰ƒ}[ | lZ01‰º | | 0 (3 rows) select *,substring(—pŒê from 10 for 4) from ŒvŽZ‹@—pŒê; - —pŒê | •ª—ÞƒR[ƒh | ”õl1a‚¾‚æ | substr -----------------------------+------------+------------+---------- + —pŒê | •ª—ÞƒR[ƒh | ”õl1a‚¾‚æ | substring +----------------------------+------------+------------+----------- ƒRƒ“ƒsƒ…[ƒ^ƒfƒBƒXƒvƒŒƒC | ‹@A01ã | | ƒvƒŒƒC ƒRƒ“ƒsƒ…[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX | •ªB10’† | | ƒBƒbƒNƒX ƒRƒ“ƒsƒ…[ƒ^ƒvƒƒOƒ‰ƒ}[ | lZ01‰º | | ƒ‰ƒ}[ diff --git a/src/test/mb/expected/unicode.out b/src/test/mb/expected/unicode.out index df7f5f8306..71c9e9a441 100644 --- a/src/test/mb/expected/unicode.out +++ b/src/test/mb/expected/unicode.out @@ -1,87 +1,295 @@ drop table 計算機用語; -ERROR: Relation '計算機用語' does not exist +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 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 計算機用語index1 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 計算機用語index2 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('コンピュータディスプレイ','機A01上'); +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('コンピュータグラフィックス','分B10中'); +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('コンピュータプログラマー','人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 (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 計算機用語; - 用語 | 分類コード | 備考1aだよ ------------------------------------------+-----------------+---------------- - コンピュータディスプレイ | 機A01上 | - コンピュータグラフィックス | 分B10中 | - コンピュータプログラマー | 人Z01下 | -(3 rows) - +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 select * from 計算機用語 where 分類コード = '人Z01下'; - 用語 | 分類コード | 備考1aだよ ---------------------------------------+-----------------+---------------- - コンピュータプログラマー | 人Z01下 | -(1 row) - +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 "=" select * from 計算機用語 where 分類コード ~* '人z01下'; - 用語 | 分類コード | 備考1aだよ ---------------------------------------+-----------------+---------------- - コンピュータプログラマー | 人Z01下 | -(1 row) - +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 "~*" select * from 計算機用語 where 分類コード like '_Z01_'; - 用語 | 分類コード | 備考1aだよ ---------------------------------------+-----------------+---------------- - コンピュータプログラマー | 人Z01下 | -(1 row) - +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 "'" select * from 計算機用語 where 分類コード like '_Z%'; - 用語 | 分類コード | 備考1aだよ ---------------------------------------+-----------------+---------------- - コンピュータプログラマー | 人Z01下 | -(1 row) - +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 "'" select * from 計算機用語 where 用語 ~ 'コンピュータ[デグ]'; - 用語 | 分類コード | 備考1aだよ ------------------------------------------+-----------------+---------------- - コンピュータディスプレイ | 機A01上 | - コンピュータグラフィックス | 分B10中 | -(2 rows) - +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 "~" select * from 計算機用語 where 用語 ~* 'コンピュータ[デグ]'; - 用語 | 分類コード | 備考1aだよ ------------------------------------------+-----------------+---------------- - コンピュータディスプレイ | 機A01上 | - コンピュータグラフィックス | 分B10中 | -(2 rows) - +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 "~*" select *,character_length(用語) from 計算機用語; - 用語 | 分類コード | 備考1aだよ | char_length ------------------------------------------+-----------------+----------------+------------- - コンピュータディスプレイ | 機A01上 | | 12 - コンピュータグラフィックス | 分B10中 | | 13 - コンピュータプログラマー | 人Z01下 | | 12 -(3 rows) - +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 select *,octet_length(用語) from 計算機用語; - 用語 | 分類コード | 備考1aだよ | octet_length ------------------------------------------+-----------------+----------------+-------------- - コンピュータディスプレイ | 機A01上 | | 36 - コンピュータグラフィックス | 分B10中 | | 39 - コンピュータプログラマー | 人Z01下 | | 36 -(3 rows) - +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 select *,position('デ' in 用語) from 計算機用語; - 用語 | 分類コード | 備考1aだよ | strpos ------------------------------------------+-----------------+----------------+-------- - コンピュータディスプレイ | 機A01上 | | 7 - コンピュータグラフィックス | 分B10中 | | 0 - コンピュータプログラマー | 人Z01下 | | 0 -(3 rows) - +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 select *,substring(用語 from 10 for 4) from 計算機用語; - 用語 | 分類コード | 備考1aだよ | substr ------------------------------------------+-----------------+----------------+-------------- - コンピュータディスプレイ | 機A01上 | | プレイ - コンピュータグラフィックス | 分B10中 | | ィックス - コンピュータプログラマー | 人Z01下 | | ラマー -(3 rows) - +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" -- 2.40.0