aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTatsuo Ishii <ishii@postgresql.org>2000-02-27 10:21:16 +0000
committerTatsuo Ishii <ishii@postgresql.org>2000-02-27 10:21:16 +0000
commit97e38d32b8b618236a9690b9ee820ab8cc94d0ea (patch)
tree9085f9cb8700b227927a70c7cbd8405cdb6b86c5 /src
parent570bb30d73a73d0605903399a8d8d1c8c00d497d (diff)
downloadpostgresql-97e38d32b8b618236a9690b9ee820ab8cc94d0ea.tar.gz
postgresql-97e38d32b8b618236a9690b9ee820ab8cc94d0ea.zip
Update expected files due to the psql format change
Diffstat (limited to 'src')
-rw-r--r--src/test/mb/expected/big5.out124
-rw-r--r--src/test/mb/expected/euc_cn.out128
-rw-r--r--src/test/mb/expected/euc_jp.out38
-rw-r--r--src/test/mb/expected/euc_kr.out128
-rw-r--r--src/test/mb/expected/euc_tw.out124
-rw-r--r--src/test/mb/expected/mule_internal.out498
-rw-r--r--src/test/mb/expected/sjis.out40
-rw-r--r--src/test/mb/expected/unicode.out128
8 files changed, 604 insertions, 604 deletions
diff --git a/src/test/mb/expected/big5.out b/src/test/mb/expected/big5.out
index 0ca86167ece..702579eebaa 100644
--- a/src/test/mb/expected/big5.out
+++ b/src/test/mb/expected/big5.out
@@ -1,84 +1,84 @@
-QUERY: drop table 廠商資料;
-QUERY: create table 廠商資料 (行業別 text, 公司抬頭 varchar, 地址 varchar(16));
-QUERY: create index 廠商資料index1 on 廠商資料 using btree (行業別);
-QUERY: create index 廠商資料index2 on 廠商資料 using hash (公司抬頭);
-QUERY: insert into 廠商資料 values ('電腦業', '達達科技', '北A01仁');
-QUERY: insert into 廠商資料 values ('製造業', '財源有限公司', '中B10中');
-QUERY: insert into 廠商資料 values ('餐飲業', '美味股份有限公司', '高Z01九');
-QUERY: vacuum 廠商資料;
-QUERY: select * from 廠商資料;
-行業別|公司抬頭 |地址
-------+----------------+-------
-電腦業|達達科技 |北A01仁
-製造業|財源有限公司 |中B10中
-餐飲業|美味股份有限公司|高Z01九
+drop table 廠商資料
+create table 廠商資料 (行業別 text, 公司抬頭 varchar, 地址 varchar(16))
+create index 廠商資料index1 on 廠商資料 using btree (行業別)
+create index 廠商資料index2 on 廠商資料 using hash (公司抬頭)
+insert into 廠商資料 values ('電腦業', '達達科技', '北A01仁')
+insert into 廠商資料 values ('製造業', '財源有限公司', '中B10中')
+insert into 廠商資料 values ('餐飲業', '美味股份有限公司', '高Z01九')
+vacuum 廠商資料
+select * from 廠商資料
+ 行業別 | 公司抬頭 | 地址
+--------+------------------+---------
+ 電腦業 | 達達科技 | 北A01仁
+ 製造業 | 財源有限公司 | 中B10中
+ 餐飲業 | 美味股份有限公司 | 高Z01九
(3 rows)
-QUERY: select * from 廠商資料 where 地址 = '高Z01九';
-行業別|公司抬頭 |地址
-------+----------------+-------
-餐飲業|美味股份有限公司|高Z01九
+select * from 廠商資料 where 地址 = '高Z01九'
+ 行業別 | 公司抬頭 | 地址
+--------+------------------+---------
+ 餐飲業 | 美味股份有限公司 | 高Z01九
(1 row)
-QUERY: select * from 廠商資料 where 地址 ~* '高z01九';
-行業別|公司抬頭 |地址
-------+----------------+-------
-餐飲業|美味股份有限公司|高Z01九
+select * from 廠商資料 where 地址 ~* '高z01九'
+ 行業別 | 公司抬頭 | 地址
+--------+------------------+---------
+ 餐飲業 | 美味股份有限公司 | 高Z01九
(1 row)
-QUERY: select * from 廠商資料 where 地址 like '_Z01_';
-行業別|公司抬頭 |地址
-------+----------------+-------
-餐飲業|美味股份有限公司|高Z01九
+select * from 廠商資料 where 地址 like '_Z01_'
+ 行業別 | 公司抬頭 | 地址
+--------+------------------+---------
+ 餐飲業 | 美味股份有限公司 | 高Z01九
(1 row)
-QUERY: select * from 廠商資料 where 地址 like '_Z%';
-行業別|公司抬頭 |地址
-------+----------------+-------
-餐飲業|美味股份有限公司|高Z01九
+select * from 廠商資料 where 地址 like '_Z%'
+ 行業別 | 公司抬頭 | 地址
+--------+------------------+---------
+ 餐飲業 | 美味股份有限公司 | 高Z01九
(1 row)
-QUERY: select * from 廠商資料 where 公司抬頭 ~ '達達科[寄記技]';
-行業別|公司抬頭|地址
-------+--------+-------
-電腦業|達達科技|北A01仁
+select * from 廠商資料 where 公司抬頭 ~ '達達科[寄記技]'
+ 行業別 | 公司抬頭 | 地址
+--------+----------+---------
+ 電腦業 | 達達科技 | 北A01仁
(1 row)
-QUERY: select * from 廠商資料 where 公司抬頭 ~* '達達科[寄記技]';
-行業別|公司抬頭|地址
-------+--------+-------
-電腦業|達達科技|北A01仁
+select * from 廠商資料 where 公司抬頭 ~* '達達科[寄記技]'
+ 行業別 | 公司抬頭 | 地址
+--------+----------+---------
+ 電腦業 | 達達科技 | 北A01仁
(1 row)
-QUERY: select *, character_length(行業別) from 廠商資料;
-行業別|公司抬頭 |地址 |length
-------+----------------+-------+------
-電腦業|達達科技 |北A01仁| 3
-製造業|財源有限公司 |中B10中| 3
-餐飲業|美味股份有限公司|高Z01九| 3
+select *, character_length(行業別) from 廠商資料
+ 行業別 | 公司抬頭 | 地址 | length
+--------+------------------+---------+--------
+ 電腦業 | 達達科技 | 北A01仁 | 3
+ 製造業 | 財源有限公司 | 中B10中 | 3
+ 餐飲業 | 美味股份有限公司 | 高Z01九 | 3
(3 rows)
-QUERY: select *, octet_length(行業別) from 廠商資料;
-行業別|公司抬頭 |地址 |octet_length
-------+----------------+-------+------------
-電腦業|達達科技 |北A01仁| 6
-製造業|財源有限公司 |中B10中| 6
-餐飲業|美味股份有限公司|高Z01九| 6
+select *, octet_length(行業別) from 廠商資料
+ 行業別 | 公司抬頭 | 地址 | octet_length
+--------+------------------+---------+--------------
+ 電腦業 | 達達科技 | 北A01仁 | 6
+ 製造業 | 財源有限公司 | 中B10中 | 6
+ 餐飲業 | 美味股份有限公司 | 高Z01九 | 6
(3 rows)
-QUERY: select *, position('有限' in 公司抬頭) from 廠商資料;
-行業別|公司抬頭 |地址 |strpos
-------+----------------+-------+------
-電腦業|達達科技 |北A01仁| 0
-製造業|財源有限公司 |中B10中| 3
-餐飲業|美味股份有限公司|高Z01九| 5
+select *, position('有限' in 公司抬頭) from 廠商資料
+ 行業別 | 公司抬頭 | 地址 | strpos
+--------+------------------+---------+--------
+ 電腦業 | 達達科技 | 北A01仁 | 0
+ 製造業 | 財源有限公司 | 中B10中 | 3
+ 餐飲業 | 美味股份有限公司 | 高Z01九 | 5
(3 rows)
-QUERY: select *, substring(公司抬頭 from 3 for 6 ) from 廠商資料;
-行業別|公司抬頭 |地址 |substr
-------+----------------+-------+------------
-電腦業|達達科技 |北A01仁|科技
-製造業|財源有限公司 |中B10中|有限公司
-餐飲業|美味股份有限公司|高Z01九|股份有限公司
+select *, substring(公司抬頭 from 3 for 6 ) from 廠商資料
+ 行業別 | 公司抬頭 | 地址 | substr
+--------+------------------+---------+--------------
+ 電腦業 | 達達科技 | 北A01仁 | 科技
+ 製造業 | 財源有限公司 | 中B10中 | 有限公司
+ 餐飲業 | 美味股份有限公司 | 高Z01九 | 股份有限公司
(3 rows)
diff --git a/src/test/mb/expected/euc_cn.out b/src/test/mb/expected/euc_cn.out
index b9944f48fd8..93ff30c25af 100644
--- a/src/test/mb/expected/euc_cn.out
+++ b/src/test/mb/expected/euc_cn.out
@@ -1,87 +1,87 @@
-QUERY: drop table 數呾儂扲逄;
+drop table 數呾儂扲逄
ERROR: Relation '數呾儂扲逄' does not exist
-QUERY: create table 數呾儂扲逄(扲逄 text, 煦濬瘍 varchar, 掘蛁1A char(16));
-QUERY: create index 數呾儂扲逄index1 on 數呾儂扲逄 using btree(扲逄);
-QUERY: create index 數呾儂扲逄index2 on 數呾儂扲逄 using btree(煦濬瘍);
-QUERY: insert into 數呾儂扲逄 values('萇齟珆尨そ','儂A01奻');
-QUERY: insert into 數呾儂扲逄 values('萇齟芞倛','煦B01笢');
-QUERY: insert into 數呾儂扲逄 values('萇齟最唗埜','汳01狟');
-QUERY: vacuum 數呾儂扲逄;
-QUERY: select * from 數呾儂扲逄;
-扲逄 |煦濬瘍 |掘蛁1a
-----------+-------+------
-萇齟珆尨そ|儂A01奻|
-萇齟芞倛 |煦B01笢|
-萇齟最唗埜|汳01狟|
+create table 數呾儂扲逄(扲逄 text, 煦濬瘍 varchar, 掘蛁1A char(16))
+create index 數呾儂扲逄index1 on 數呾儂扲逄 using btree(扲逄)
+create index 數呾儂扲逄index2 on 數呾儂扲逄 using btree(煦濬瘍)
+insert into 數呾儂扲逄 values('萇齟珆尨そ','儂A01奻')
+insert into 數呾儂扲逄 values('萇齟芞倛','煦B01笢')
+insert into 數呾儂扲逄 values('萇齟最唗埜','汳01狟')
+vacuum 數呾儂扲逄
+select * from 數呾儂扲逄
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+------------+---------+--------
+ 萇齟珆尨そ | 儂A01奻 |
+ 萇齟芞倛 | 煦B01笢 |
+ 萇齟最唗埜 | 汳01狟 |
(3 rows)
-QUERY: select * from 數呾儂扲逄 where 煦濬瘍 = '汳01狟';
-扲逄 |煦濬瘍 |掘蛁1a
-----------+-------+------
-萇齟最唗埜|汳01狟|
+select * from 數呾儂扲逄 where 煦濬瘍 = '汳01狟'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+------------+---------+--------
+ 萇齟最唗埜 | 汳01狟 |
(1 row)
-QUERY: select * from 數呾儂扲逄 where 煦濬瘍 ~* '芏01狟';
-扲逄 |煦濬瘍 |掘蛁1a
-----------+-------+------
-萇齟最唗埜|汳01狟|
+select * from 數呾儂扲逄 where 煦濬瘍 ~* '芏01狟'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+------------+---------+--------
+ 萇齟最唗埜 | 汳01狟 |
(1 row)
-QUERY: select * from 數呾儂扲逄 where 煦濬瘍 like '_Z01_';
-扲逄 |煦濬瘍 |掘蛁1a
-----------+-------+------
-萇齟最唗埜|汳01狟|
+select * from 數呾儂扲逄 where 煦濬瘍 like '_Z01_'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+------------+---------+--------
+ 萇齟最唗埜 | 汳01狟 |
(1 row)
-QUERY: select * from 數呾儂扲逄 where 煦濬瘍 like '_Z%';
-扲逄 |煦濬瘍 |掘蛁1a
-----------+-------+------
-萇齟最唗埜|汳01狟|
+select * from 數呾儂扲逄 where 煦濬瘍 like '_Z%'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+------------+---------+--------
+ 萇齟最唗埜 | 汳01狟 |
(1 row)
-QUERY: select * from 數呾儂扲逄 where 扲逄 ~ '萇齟[珆芞]';
-扲逄 |煦濬瘍 |掘蛁1a
-----------+-------+------
-萇齟珆尨そ|儂A01奻|
-萇齟芞倛 |煦B01笢|
+select * from 數呾儂扲逄 where 扲逄 ~ '萇齟[珆芞]'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+------------+---------+--------
+ 萇齟珆尨そ | 儂A01奻 |
+ 萇齟芞倛 | 煦B01笢 |
(2 rows)
-QUERY: select * from 數呾儂扲逄 where 扲逄 ~* '萇齟[珆芞]';
-扲逄 |煦濬瘍 |掘蛁1a
-----------+-------+------
-萇齟珆尨そ|儂A01奻|
-萇齟芞倛 |煦B01笢|
+select * from 數呾儂扲逄 where 扲逄 ~* '萇齟[珆芞]'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+------------+---------+--------
+ 萇齟珆尨そ | 儂A01奻 |
+ 萇齟芞倛 | 煦B01笢 |
(2 rows)
-QUERY: select *,character_length(扲逄) from 數呾儂扲逄;
-扲逄 |煦濬瘍 |掘蛁1a|length
-----------+-------+------+------
-萇齟珆尨そ|儂A01奻| | 5
-萇齟芞倛 |煦B01笢| | 4
-萇齟最唗埜|汳01狟| | 5
+select *,character_length(扲逄) from 數呾儂扲逄
+ 扲逄 | 煦濬瘍 | 掘蛁1a | length
+------------+---------+--------+--------
+ 萇齟珆尨そ | 儂A01奻 | | 5
+ 萇齟芞倛 | 煦B01笢 | | 4
+ 萇齟最唗埜 | 汳01狟 | | 5
(3 rows)
-QUERY: select *,octet_length(扲逄) from 數呾儂扲逄;
-扲逄 |煦濬瘍 |掘蛁1a|octet_length
-----------+-------+------+------------
-萇齟珆尨そ|儂A01奻| | 10
-萇齟芞倛 |煦B01笢| | 8
-萇齟最唗埜|汳01狟| | 10
+select *,octet_length(扲逄) from 數呾儂扲逄
+ 扲逄 | 煦濬瘍 | 掘蛁1a | octet_length
+------------+---------+--------+--------------
+ 萇齟珆尨そ | 儂A01奻 | | 10
+ 萇齟芞倛 | 煦B01笢 | | 8
+ 萇齟最唗埜 | 汳01狟 | | 10
(3 rows)
-QUERY: select *,position('珆' in 扲逄) from 數呾儂扲逄;
-扲逄 |煦濬瘍 |掘蛁1a|strpos
-----------+-------+------+------
-萇齟珆尨そ|儂A01奻| | 3
-萇齟芞倛 |煦B01笢| | 0
-萇齟最唗埜|汳01狟| | 0
+select *,position('珆' in 扲逄) from 數呾儂扲逄
+ 扲逄 | 煦濬瘍 | 掘蛁1a | strpos
+------------+---------+--------+--------
+ 萇齟珆尨そ | 儂A01奻 | | 3
+ 萇齟芞倛 | 煦B01笢 | | 0
+ 萇齟最唗埜 | 汳01狟 | | 0
(3 rows)
-QUERY: select *,substring(扲逄 from 3 for 4) from 數呾儂扲逄;
-扲逄 |煦濬瘍 |掘蛁1a|substr
-----------+-------+------+------
-萇齟珆尨そ|儂A01奻| |珆尨そ
-萇齟芞倛 |煦B01笢| |芞倛
-萇齟最唗埜|汳01狟| |最唗埜
+select *,substring(扲逄 from 3 for 4) from 數呾儂扲逄
+ 扲逄 | 煦濬瘍 | 掘蛁1a | substr
+------------+---------+--------+--------
+ 萇齟珆尨そ | 儂A01奻 | | 珆尨そ
+ 萇齟芞倛 | 煦B01笢 | | 芞倛
+ 萇齟最唗埜 | 汳01狟 | | 最唗埜
(3 rows)
diff --git a/src/test/mb/expected/euc_jp.out b/src/test/mb/expected/euc_jp.out
index 6f38e998a89..838b0a8363c 100644
--- a/src/test/mb/expected/euc_jp.out
+++ b/src/test/mb/expected/euc_jp.out
@@ -1,13 +1,13 @@
-drop table 煌遙窗迕賄;
+drop table 煌遙窗迕賄
ERROR: Relation '煌遙窗迕賄' does not exist
-create table 煌遙窗迕賄 (迕賄 text, 坌挀戊□玉 varchar, 鷞1A分方 char(16));
-create index 煌遙窗迕賄index1 on 煌遙窗迕賄 using btree (迕賄);
-create index 煌遙窗迕賄index2 on 煌遙窗迕賄 using hash (坌挀戊□玉);
-insert into 煌遙窗迕賄 values('戊件疋亙□正犯奴旦皿伊奶','窗A01曉');
-insert into 煌遙窗迕賄 values('戊件疋亙□正弘仿白奴永弁旦','坌B10醱');
-insert into 煌遙窗迕賄 values('戊件疋亙□正皿伕弘仿穴□','諦Z01票');
-vacuum 煌遙窗迕賄;
-select * from 煌遙窗迕賄;
+create table 煌遙窗迕賄 (迕賄 text, 坌挀戊□玉 varchar, 鷞1A分方 char(16))
+create index 煌遙窗迕賄index1 on 煌遙窗迕賄 using btree (迕賄)
+create index 煌遙窗迕賄index2 on 煌遙窗迕賄 using hash (坌挀戊□玉)
+insert into 煌遙窗迕賄 values('戊件疋亙□正犯奴旦皿伊奶','窗A01曉')
+insert into 煌遙窗迕賄 values('戊件疋亙□正弘仿白奴永弁旦','坌B10醱')
+insert into 煌遙窗迕賄 values('戊件疋亙□正皿伕弘仿穴□','諦Z01票')
+vacuum 煌遙窗迕賄
+select * from 煌遙窗迕賄
迕賄 | 坌挀戊□玉 | 鷞1a分方
----------------------------+------------+------------
戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 |
@@ -15,45 +15,45 @@ select * from 煌遙窗迕賄;
戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 |
(3 rows)
-select * from 煌遙窗迕賄 where 坌挀戊□玉 = '諦Z01票';
+select * from 煌遙窗迕賄 where 坌挀戊□玉 = '諦Z01票'
迕賄 | 坌挀戊□玉 | 鷞1a分方
--------------------------+------------+------------
戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 |
(1 row)
-select * from 煌遙窗迕賄 where 坌挀戊□玉 ~* '諦z01票';
+select * from 煌遙窗迕賄 where 坌挀戊□玉 ~* '諦z01票'
迕賄 | 坌挀戊□玉 | 鷞1a分方
--------------------------+------------+------------
戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 |
(1 row)
-select * from 煌遙窗迕賄 where 坌挀戊□玉 like '_Z01_';
+select * from 煌遙窗迕賄 where 坌挀戊□玉 like '_Z01_'
迕賄 | 坌挀戊□玉 | 鷞1a分方
--------------------------+------------+------------
戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 |
(1 row)
-select * from 煌遙窗迕賄 where 坌挀戊□玉 like '_Z%';
+select * from 煌遙窗迕賄 where 坌挀戊□玉 like '_Z%'
迕賄 | 坌挀戊□玉 | 鷞1a分方
--------------------------+------------+------------
戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 |
(1 row)
-select * from 煌遙窗迕賄 where 迕賄 ~ '戊件疋亙□正[犯弘]';
+select * from 煌遙窗迕賄 where 迕賄 ~ '戊件疋亙□正[犯弘]'
迕賄 | 坌挀戊□玉 | 鷞1a分方
----------------------------+------------+------------
戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 |
戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 |
(2 rows)
-select * from 煌遙窗迕賄 where 迕賄 ~* '戊件疋亙□正[犯弘]';
+select * from 煌遙窗迕賄 where 迕賄 ~* '戊件疋亙□正[犯弘]'
迕賄 | 坌挀戊□玉 | 鷞1a分方
----------------------------+------------+------------
戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 |
戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 |
(2 rows)
-select *,character_length(迕賄) from 煌遙窗迕賄;
+select *,character_length(迕賄) from 煌遙窗迕賄
迕賄 | 坌挀戊□玉 | 鷞1a分方 | length
----------------------------+------------+------------+--------
戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 12
@@ -61,7 +61,7 @@ select *,character_length(迕賄) from 煌遙窗迕賄;
戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 12
(3 rows)
-select *,octet_length(迕賄) from 煌遙窗迕賄;
+select *,octet_length(迕賄) from 煌遙窗迕賄
迕賄 | 坌挀戊□玉 | 鷞1a分方 | octet_length
----------------------------+------------+------------+--------------
戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 24
@@ -69,7 +69,7 @@ select *,octet_length(迕賄) from 煌遙窗迕賄;
戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 24
(3 rows)
-select *,position('犯' in 迕賄) from 煌遙窗迕賄;
+select *,position('犯' in 迕賄) from 煌遙窗迕賄
迕賄 | 坌挀戊□玉 | 鷞1a分方 | strpos
----------------------------+------------+------------+--------
戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 7
@@ -77,7 +77,7 @@ select *,position('犯' in 迕賄) from 煌遙窗迕賄;
戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 0
(3 rows)
-select *,substring(迕賄 from 10 for 4) from 煌遙窗迕賄;
+select *,substring(迕賄 from 10 for 4) from 煌遙窗迕賄
迕賄 | 坌挀戊□玉 | 鷞1a分方 | substr
----------------------------+------------+------------+----------
戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 皿伊奶
diff --git a/src/test/mb/expected/euc_kr.out b/src/test/mb/expected/euc_kr.out
index 9d3ca8ce3dd..7899344928e 100644
--- a/src/test/mb/expected/euc_kr.out
+++ b/src/test/mb/expected/euc_kr.out
@@ -1,87 +1,87 @@
-QUERY: drop table 耵蓱悁辨橫;
+drop table 耵蓱悁辨橫
ERROR: Relation '耵蓱悁辨橫' does not exist
-QUERY: create table 耵蓱悁辨橫 (辨橫 text, 暐袛囀萄 varchar, 綠堅1A塭掘 char(16));
-QUERY: create index 耵蓱悁辨橫index1 on 耵蓱悁辨橫 using btree (辨橫);
-QUERY: create index 耵蓱悁辨橫index2 on 耵蓱悁辨橫 using hash (暐袛囀萄);
-QUERY: insert into 耵蓱悁辨橫 values('闡У攪蛤蝶Ы溯檜', '悁A01葞');
-QUERY: insert into 耵蓱悁辨橫 values('闡У攪斜楚а蝶', '暐B10齌');
-QUERY: insert into 耵蓱悁辨橫 values('闡У攪Щ煎斜楚該', '嬣Z01欞');
-QUERY: vacuum 耵蓱悁辨橫;
-QUERY: select * from 耵蓱悁辨橫;
-辨橫 |暐袛囀萄|綠堅1a塭掘
-----------------+--------+----------
-闡У攪蛤蝶Ы溯檜|悁A01葞 |
-闡У攪斜楚а蝶 |暐B10齌 |
-闡У攪Щ煎斜楚該|嬣Z01欞 |
+create table 耵蓱悁辨橫 (辨橫 text, 暐袛囀萄 varchar, 綠堅1A塭掘 char(16))
+create index 耵蓱悁辨橫index1 on 耵蓱悁辨橫 using btree (辨橫)
+create index 耵蓱悁辨橫index2 on 耵蓱悁辨橫 using hash (暐袛囀萄)
+insert into 耵蓱悁辨橫 values('闡У攪蛤蝶Ы溯檜', '悁A01葞')
+insert into 耵蓱悁辨橫 values('闡У攪斜楚а蝶', '暐B10齌')
+insert into 耵蓱悁辨橫 values('闡У攪Щ煎斜楚該', '嬣Z01欞')
+vacuum 耵蓱悁辨橫
+select * from 耵蓱悁辨橫
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+------------------+----------+------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 |
+ 闡У攪斜楚а蝶 | 暐B10齌 |
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 |
(3 rows)
-QUERY: select * from 耵蓱悁辨橫 where 暐袛囀萄 = '嬣Z01欞';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-----------------+--------+----------
-闡У攪Щ煎斜楚該|嬣Z01欞 |
+select * from 耵蓱悁辨橫 where 暐袛囀萄 = '嬣Z01欞'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+------------------+----------+------------
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 |
(1 row)
-QUERY: select * from 耵蓱悁辨橫 where 暐袛囀萄 ~* '嬣z01欞';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-----------------+--------+----------
-闡У攪Щ煎斜楚該|嬣Z01欞 |
+select * from 耵蓱悁辨橫 where 暐袛囀萄 ~* '嬣z01欞'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+------------------+----------+------------
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 |
(1 row)
-QUERY: select * from 耵蓱悁辨橫 where 暐袛囀萄 like '_Z01_';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-----------------+--------+----------
-闡У攪Щ煎斜楚該|嬣Z01欞 |
+select * from 耵蓱悁辨橫 where 暐袛囀萄 like '_Z01_'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+------------------+----------+------------
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 |
(1 row)
-QUERY: select * from 耵蓱悁辨橫 where 暐袛囀萄 like '_Z%';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-----------------+--------+----------
-闡У攪Щ煎斜楚該|嬣Z01欞 |
+select * from 耵蓱悁辨橫 where 暐袛囀萄 like '_Z%'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+------------------+----------+------------
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 |
(1 row)
-QUERY: select * from 耵蓱悁辨橫 where 辨橫 ~ '闡У攪[蛤斜]';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-----------------+--------+----------
-闡У攪蛤蝶Ы溯檜|悁A01葞 |
-闡У攪斜楚а蝶 |暐B10齌 |
+select * from 耵蓱悁辨橫 where 辨橫 ~ '闡У攪[蛤斜]'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+------------------+----------+------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 |
+ 闡У攪斜楚а蝶 | 暐B10齌 |
(2 rows)
-QUERY: select * from 耵蓱悁辨橫 where 辨橫 ~* '闡У攪[蛤斜]';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-----------------+--------+----------
-闡У攪蛤蝶Ы溯檜|悁A01葞 |
-闡У攪斜楚а蝶 |暐B10齌 |
+select * from 耵蓱悁辨橫 where 辨橫 ~* '闡У攪[蛤斜]'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+------------------+----------+------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 |
+ 闡У攪斜楚а蝶 | 暐B10齌 |
(2 rows)
-QUERY: select *,character_length(辨橫) from 耵蓱悁辨橫;
-辨橫 |暐袛囀萄|綠堅1a塭掘|length
-----------------+--------+----------+------
-闡У攪蛤蝶Ы溯檜|悁A01葞 | | 8
-闡У攪斜楚а蝶 |暐B10齌 | | 7
-闡У攪Щ煎斜楚該|嬣Z01欞 | | 8
+select *,character_length(辨橫) from 耵蓱悁辨橫
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | length
+------------------+----------+------------+--------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 8
+ 闡У攪斜楚а蝶 | 暐B10齌 | | 7
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 8
(3 rows)
-QUERY: select *,octet_length(辨橫) from 耵蓱悁辨橫;
-辨橫 |暐袛囀萄|綠堅1a塭掘|octet_length
-----------------+--------+----------+------------
-闡У攪蛤蝶Ы溯檜|悁A01葞 | | 16
-闡У攪斜楚а蝶 |暐B10齌 | | 14
-闡У攪Щ煎斜楚該|嬣Z01欞 | | 16
+select *,octet_length(辨橫) from 耵蓱悁辨橫
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | octet_length
+------------------+----------+------------+--------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 16
+ 闡У攪斜楚а蝶 | 暐B10齌 | | 14
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 16
(3 rows)
-QUERY: select *,position('蛤' in 辨橫) from 耵蓱悁辨橫;
-辨橫 |暐袛囀萄|綠堅1a塭掘|strpos
-----------------+--------+----------+------
-闡У攪蛤蝶Ы溯檜|悁A01葞 | | 4
-闡У攪斜楚а蝶 |暐B10齌 | | 0
-闡У攪Щ煎斜楚該|嬣Z01欞 | | 0
+select *,position('蛤' in 辨橫) from 耵蓱悁辨橫
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | strpos
+------------------+----------+------------+--------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 4
+ 闡У攪斜楚а蝶 | 暐B10齌 | | 0
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 0
(3 rows)
-QUERY: select *,substring(辨橫 from 3 for 4) from 耵蓱悁辨橫;
-辨橫 |暐袛囀萄|綠堅1a塭掘|substr
-----------------+--------+----------+--------
-闡У攪蛤蝶Ы溯檜|悁A01葞 | |攪蛤蝶Ы
-闡У攪斜楚а蝶 |暐B10齌 | |攪斜楚а
-闡У攪Щ煎斜楚該|嬣Z01欞 | |攪Щ煎斜
+select *,substring(辨橫 from 3 for 4) from 耵蓱悁辨橫
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | substr
+------------------+----------+------------+----------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 攪蛤蝶Ы
+ 闡У攪斜楚а蝶 | 暐B10齌 | | 攪斜楚а
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 攪Щ煎斜
(3 rows)
diff --git a/src/test/mb/expected/euc_tw.out b/src/test/mb/expected/euc_tw.out
index a7d2b940695..4e1e588295c 100644
--- a/src/test/mb/expected/euc_tw.out
+++ b/src/test/mb/expected/euc_tw.out
@@ -1,85 +1,85 @@
-QUERY: drop table 徻椓罶涷;
+drop table 徻椓罶涷
ERROR: Relation '徻椓罶涷' does not exist
-QUERY: create table 徻椓罶涷 (諙づ text, 襬く剉韝 varchar, щ彴 varchar(16));
-QUERY: create index 徻椓罶涷index1 on 徻椓罶涷 using btree (諙づ);
-QUERY: create index 徻椓罶涷index2 on 徻椓罶涷 using hash (襬く剉韝);
-QUERY: insert into 徻椓罶涷 values ('諔瑼鞄', '蝞蝞秠岍', 'ヾA01癩');
-QUERY: insert into 徻椓罶涷 values ('蕍楸鞄', '娷鳲植鄸く', '斕B10斕');
-QUERY: insert into 徻椓罶涷 values ('顜聜鞄', '荂抸炴Л植鄸く', '崼Z01藻');
-QUERY: vacuum 徻椓罶涷;
-QUERY: select * from 徻椓罶涷;
-諙づ悴襬く剉韝 |щ彴
-------+----------------+-------
-諔瑼鞄|蝞蝞秠岍 |ヾA01癩
-蕍楸鞄|娷鳲植鄸く |斕B10斕
-顜聜鞄|荂抸炴Л植鄸く|崼Z01藻
+create table 徻椓罶涷 (諙づ text, 襬く剉韝 varchar, щ彴 varchar(16))
+create index 徻椓罶涷index1 on 徻椓罶涷 using btree (諙づ)
+create index 徻椓罶涷index2 on 徻椓罶涷 using hash (襬く剉韝)
+insert into 徻椓罶涷 values ('諔瑼鞄', '蝞蝞秠岍', 'ヾA01癩')
+insert into 徻椓罶涷 values ('蕍楸鞄', '娷鳲植鄸く', '斕B10斕')
+insert into 徻椓罶涷 values ('顜聜鞄', '荂抸炴Л植鄸く', '崼Z01藻')
+vacuum 徻椓罶涷
+select * from 徻椓罶涷
+ 諙づ | 襬く剉韝 | щ彴
+--------+------------------+---------
+ 諔瑼鞄 | 蝞蝞秠岍 | ヾA01癩
+ 蕍楸鞄 | 娷鳲植鄸く | 斕B10斕
+ 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻
(3 rows)
-QUERY: select * from 徻椓罶涷 where щ彴 = '崼Z01藻';
-諙づ悴襬く剉韝 |щ彴
-------+----------------+-------
-顜聜鞄|荂抸炴Л植鄸く|崼Z01藻
+select * from 徻椓罶涷 where щ彴 = '崼Z01藻'
+ 諙づ | 襬く剉韝 | щ彴
+--------+------------------+---------
+ 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻
(1 row)
-QUERY: select * from 徻椓罶涷 where щ彴 ~* '崼z01藻';
-諙づ悴襬く剉韝 |щ彴
-------+----------------+-------
-顜聜鞄|荂抸炴Л植鄸く|崼Z01藻
+select * from 徻椓罶涷 where щ彴 ~* '崼z01藻'
+ 諙づ | 襬く剉韝 | щ彴
+--------+------------------+---------
+ 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻
(1 row)
-QUERY: select * from 徻椓罶涷 where щ彴 like '_Z01_';
-諙づ悴襬く剉韝 |щ彴
-------+----------------+-------
-顜聜鞄|荂抸炴Л植鄸く|崼Z01藻
+select * from 徻椓罶涷 where щ彴 like '_Z01_'
+ 諙づ | 襬く剉韝 | щ彴
+--------+------------------+---------
+ 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻
(1 row)
-QUERY: select * from 徻椓罶涷 where щ彴 like '_Z%';
-諙づ悴襬く剉韝 |щ彴
-------+----------------+-------
-顜聜鞄|荂抸炴Л植鄸く|崼Z01藻
+select * from 徻椓罶涷 where щ彴 like '_Z%'
+ 諙づ | 襬く剉韝 | щ彴
+--------+------------------+---------
+ 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻
(1 row)
-QUERY: select * from 徻椓罶涷 where 襬く剉韝 ~ '蝞蝞秠[溈奡岍]';
-諙づ悴襬く剉韝|щ彴
-------+--------+-------
-諔瑼鞄|蝞蝞秠岍|ヾA01癩
+select * from 徻椓罶涷 where 襬く剉韝 ~ '蝞蝞秠[溈奡岍]'
+ 諙づ | 襬く剉韝 | щ彴
+--------+----------+---------
+ 諔瑼鞄 | 蝞蝞秠岍 | ヾA01癩
(1 row)
-QUERY: select * from 徻椓罶涷 where 襬く剉韝 ~* '蝞蝞秠[溈奡岍]';
-諙づ悴襬く剉韝|щ彴
-------+--------+-------
-諔瑼鞄|蝞蝞秠岍|ヾA01癩
+select * from 徻椓罶涷 where 襬く剉韝 ~* '蝞蝞秠[溈奡岍]'
+ 諙づ | 襬く剉韝 | щ彴
+--------+----------+---------
+ 諔瑼鞄 | 蝞蝞秠岍 | ヾA01癩
(1 row)
-QUERY: select *, character_length(諙づ) from 徻椓罶涷;
-諙づ悴襬く剉韝 |щ彴 |length
-------+----------------+-------+------
-諔瑼鞄|蝞蝞秠岍 |ヾA01癩| 3
-蕍楸鞄|娷鳲植鄸く |斕B10斕| 3
-顜聜鞄|荂抸炴Л植鄸く|崼Z01藻| 3
+select *, character_length(諙づ) from 徻椓罶涷
+ 諙づ | 襬く剉韝 | щ彴 | length
+--------+------------------+---------+--------
+ 諔瑼鞄 | 蝞蝞秠岍 | ヾA01癩 | 3
+ 蕍楸鞄 | 娷鳲植鄸く | 斕B10斕 | 3
+ 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻 | 3
(3 rows)
-QUERY: select *, octet_length(諙づ) from 徻椓罶涷;
-諙づ悴襬く剉韝 |щ彴 |octet_length
-------+----------------+-------+------------
-諔瑼鞄|蝞蝞秠岍 |ヾA01癩| 6
-蕍楸鞄|娷鳲植鄸く |斕B10斕| 6
-顜聜鞄|荂抸炴Л植鄸く|崼Z01藻| 6
+select *, octet_length(諙づ) from 徻椓罶涷
+ 諙づ | 襬く剉韝 | щ彴 | octet_length
+--------+------------------+---------+--------------
+ 諔瑼鞄 | 蝞蝞秠岍 | ヾA01癩 | 6
+ 蕍楸鞄 | 娷鳲植鄸く | 斕B10斕 | 6
+ 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻 | 6
(3 rows)
-QUERY: select *, position('植' in 襬く剉韝) from 徻椓罶涷;
-諙づ悴襬く剉韝 |щ彴 |strpos
-------+----------------+-------+------
-諔瑼鞄|蝞蝞秠岍 |ヾA01癩| 0
-蕍楸鞄|娷鳲植鄸く |斕B10斕| 3
-顜聜鞄|荂抸炴Л植鄸く|崼Z01藻| 5
+select *, position('植' in 襬く剉韝) from 徻椓罶涷
+ 諙づ | 襬く剉韝 | щ彴 | strpos
+--------+------------------+---------+--------
+ 諔瑼鞄 | 蝞蝞秠岍 | ヾA01癩 | 0
+ 蕍楸鞄 | 娷鳲植鄸く | 斕B10斕 | 3
+ 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻 | 5
(3 rows)
-QUERY: select *, substring(襬く剉韝 from 3 for 6 ) from 徻椓罶涷;
-諙づ悴襬く剉韝 |щ彴 |substr
-------+----------------+-------+------------
-諔瑼鞄|蝞蝞秠岍 |ヾA01癩|秠岍
-蕍楸鞄|娷鳲植鄸く |斕B10斕|植鄸く
-顜聜鞄|荂抸炴Л植鄸く|崼Z01藻|炴Л植鄸く
+select *, substring(襬く剉韝 from 3 for 6 ) from 徻椓罶涷
+ 諙づ | 襬く剉韝 | щ彴 | substr
+--------+------------------+---------+--------------
+ 諔瑼鞄 | 蝞蝞秠岍 | ヾA01癩 | 秠岍
+ 蕍楸鞄 | 娷鳲植鄸く | 斕B10斕 | 植鄸く
+ 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻 | 炴Л植鄸く
(3 rows)
diff --git a/src/test/mb/expected/mule_internal.out b/src/test/mb/expected/mule_internal.out
index 09f5489ee5f..6df80473e6e 100644
--- a/src/test/mb/expected/mule_internal.out
+++ b/src/test/mb/expected/mule_internal.out
@@ -1,333 +1,333 @@
-QUERY: drop table 煌遙窗迕賄;
+drop table 煌遙窗迕賄
ERROR: Relation '煌遙窗迕賄' does not exist
-QUERY: create table 煌遙窗迕賄 (迕賄 text, 坌挀戊□玉 varchar, 嗶1A分方 char(16));
-QUERY: create index 煌遙窗迕賄index1 on 煌遙窗迕賄 using btree (迕賄);
-QUERY: create index 煌遙窗迕賄index2 on 煌遙窗迕賄 using hash (坌挀戊□玉);
-QUERY: insert into 煌遙窗迕賄 values('戊件疋亙□正犯奴旦皿伊奶','窗A01曉');
-QUERY: insert into 煌遙窗迕賄 values('戊件疋亙□正弘仿白奴永弁旦','坌B10醱');
-QUERY: insert into 煌遙窗迕賄 values('戊件疋亙□正皿伕弘仿穴□','諦Z01票');
-QUERY: vacuum 煌遙窗迕賄;
-QUERY: select * from 煌遙窗迕賄;
-迕賄 |坌挀戊□玉|嗶1a分方
----------------------------------------+---------------+--------------
-戊件疋亙□正犯奴旦皿伊奶 |窗A01曉 |
-戊件疋亙□正弘仿白奴永弁旦|坌B10醱 |
-戊件疋亙□正皿伕弘仿穴□ |諦Z01票 |
+create table 煌遙窗迕賄 (迕賄 text, 坌挀戊□玉 varchar, 嗶1A分方 char(16))
+create index 煌遙窗迕賄index1 on 煌遙窗迕賄 using btree (迕賄)
+create index 煌遙窗迕賄index2 on 煌遙窗迕賄 using hash (坌挀戊□玉)
+insert into 煌遙窗迕賄 values('戊件疋亙□正犯奴旦皿伊奶','窗A01曉')
+insert into 煌遙窗迕賄 values('戊件疋亙□正弘仿白奴永弁旦','坌B10醱')
+insert into 煌遙窗迕賄 values('戊件疋亙□正皿伕弘仿穴□','諦Z01票')
+vacuum 煌遙窗迕賄
+select * from 煌遙窗迕賄
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方
+-----------------------------------------+-----------------+----------------
+ 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 |
+ 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 |
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 |
(3 rows)
-QUERY: select * from 煌遙窗迕賄 where 坌挀戊□玉 = '諦Z01票';
-迕賄 |坌挀戊□玉|嗶1a分方
-------------------------------------+---------------+--------------
-戊件疋亙□正皿伕弘仿穴□|諦Z01票 |
+select * from 煌遙窗迕賄 where 坌挀戊□玉 = '諦Z01票'
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方
+--------------------------------------+-----------------+----------------
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 |
(1 row)
-QUERY: select * from 煌遙窗迕賄 where 坌挀戊□玉 ~* '諦z01票';
-迕賄 |坌挀戊□玉|嗶1a分方
-------------------------------------+---------------+--------------
-戊件疋亙□正皿伕弘仿穴□|諦Z01票 |
+select * from 煌遙窗迕賄 where 坌挀戊□玉 ~* '諦z01票'
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方
+--------------------------------------+-----------------+----------------
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 |
(1 row)
-QUERY: select * from 煌遙窗迕賄 where 坌挀戊□玉 like '_Z01_';
-迕賄 |坌挀戊□玉|嗶1a分方
-------------------------------------+---------------+--------------
-戊件疋亙□正皿伕弘仿穴□|諦Z01票 |
+select * from 煌遙窗迕賄 where 坌挀戊□玉 like '_Z01_'
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方
+--------------------------------------+-----------------+----------------
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 |
(1 row)
-QUERY: select * from 煌遙窗迕賄 where 坌挀戊□玉 like '_Z%';
-迕賄 |坌挀戊□玉|嗶1a分方
-------------------------------------+---------------+--------------
-戊件疋亙□正皿伕弘仿穴□|諦Z01票 |
+select * from 煌遙窗迕賄 where 坌挀戊□玉 like '_Z%'
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方
+--------------------------------------+-----------------+----------------
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 |
(1 row)
-QUERY: select * from 煌遙窗迕賄 where 迕賄 ~ '戊件疋亙□正[犯弘]';
-迕賄 |坌挀戊□玉|嗶1a分方
----------------------------------------+---------------+--------------
-戊件疋亙□正犯奴旦皿伊奶 |窗A01曉 |
-戊件疋亙□正弘仿白奴永弁旦|坌B10醱 |
+select * from 煌遙窗迕賄 where 迕賄 ~ '戊件疋亙□正[犯弘]'
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方
+-----------------------------------------+-----------------+----------------
+ 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 |
+ 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 |
(2 rows)
-QUERY: select * from 煌遙窗迕賄 where 迕賄 ~* '戊件疋亙□正[犯弘]';
-迕賄 |坌挀戊□玉|嗶1a分方
----------------------------------------+---------------+--------------
-戊件疋亙□正犯奴旦皿伊奶 |窗A01曉 |
-戊件疋亙□正弘仿白奴永弁旦|坌B10醱 |
+select * from 煌遙窗迕賄 where 迕賄 ~* '戊件疋亙□正[犯弘]'
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方
+-----------------------------------------+-----------------+----------------
+ 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 |
+ 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 |
(2 rows)
-QUERY: select *,character_length(迕賄) from 煌遙窗迕賄;
-迕賄 |坌挀戊□玉|嗶1a分方|length
----------------------------------------+---------------+--------------+------
-戊件疋亙□正犯奴旦皿伊奶 |窗A01曉 | | 12
-戊件疋亙□正弘仿白奴永弁旦|坌B10醱 | | 13
-戊件疋亙□正皿伕弘仿穴□ |諦Z01票 | | 12
+select *,character_length(迕賄) from 煌遙窗迕賄
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方 | length
+-----------------------------------------+-----------------+----------------+--------
+ 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 12
+ 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 | | 13
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 12
(3 rows)
-QUERY: select *,octet_length(迕賄) from 煌遙窗迕賄;
-迕賄 |坌挀戊□玉|嗶1a分方|octet_length
----------------------------------------+---------------+--------------+------------
-戊件疋亙□正犯奴旦皿伊奶 |窗A01曉 | | 36
-戊件疋亙□正弘仿白奴永弁旦|坌B10醱 | | 39
-戊件疋亙□正皿伕弘仿穴□ |諦Z01票 | | 36
+select *,octet_length(迕賄) from 煌遙窗迕賄
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方 | octet_length
+-----------------------------------------+-----------------+----------------+--------------
+ 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 36
+ 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 | | 39
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 36
(3 rows)
-QUERY: select *,position('犯' in 迕賄) from 煌遙窗迕賄;
-迕賄 |坌挀戊□玉|嗶1a分方|strpos
----------------------------------------+---------------+--------------+------
-戊件疋亙□正犯奴旦皿伊奶 |窗A01曉 | | 7
-戊件疋亙□正弘仿白奴永弁旦|坌B10醱 | | 0
-戊件疋亙□正皿伕弘仿穴□ |諦Z01票 | | 0
+select *,position('犯' in 迕賄) from 煌遙窗迕賄
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方 | strpos
+-----------------------------------------+-----------------+----------------+--------
+ 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 7
+ 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 | | 0
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 0
(3 rows)
-QUERY: select *,substring(迕賄 from 10 for 4) from 煌遙窗迕賄;
-迕賄 |坌挀戊□玉|嗶1a分方|substr
----------------------------------------+---------------+--------------+------------
-戊件疋亙□正犯奴旦皿伊奶 |窗A01曉 | |皿伊奶
-戊件疋亙□正弘仿白奴永弁旦|坌B10醱 | |奴永弁旦
-戊件疋亙□正皿伕弘仿穴□ |諦Z01票 | |仿穴□
+select *,substring(迕賄 from 10 for 4) from 煌遙窗迕賄
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方 | substr
+-----------------------------------------+-----------------+----------------+--------------
+ 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 皿伊奶
+ 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 | | 奴永弁旦
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 仿穴□
(3 rows)
-QUERY: drop table 數呾儂扲逄;
+drop table 數呾儂扲逄
ERROR: Relation '數呾儂扲逄' does not exist
-QUERY: create table 數呾儂扲逄(扲逄 text, 煦濬瘍 varchar, 掘蛁1A char(16));
-QUERY: create index 數呾儂扲逄index1 on 數呾儂扲逄 using btree(扲逄);
-QUERY: create index 數呾儂扲逄index2 on 數呾儂扲逄 using btree(煦濬瘍);
-QUERY: insert into 數呾儂扲逄 values('萇齟珆尨そ','儂A01奻');
-QUERY: insert into 數呾儂扲逄 values('萇齟芞倛','煦B01笢');
-QUERY: insert into 數呾儂扲逄 values('萇齟最唗埜','汳01狟');
-QUERY: vacuum 數呾儂扲逄;
-QUERY: select * from 數呾儂扲逄;
-扲逄 |煦濬瘍|掘蛁1a
----------------+---------+--------
-萇齟珆尨そ|儂A01奻|
-萇齟芞倛 |煦B01笢|
-萇齟最唗埜|汳01狟|
+create table 數呾儂扲逄(扲逄 text, 煦濬瘍 varchar, 掘蛁1A char(16))
+create index 數呾儂扲逄index1 on 數呾儂扲逄 using btree(扲逄)
+create index 數呾儂扲逄index2 on 數呾儂扲逄 using btree(煦濬瘍)
+insert into 數呾儂扲逄 values('萇齟珆尨そ','儂A01奻')
+insert into 數呾儂扲逄 values('萇齟芞倛','煦B01笢')
+insert into 數呾儂扲逄 values('萇齟最唗埜','汳01狟')
+vacuum 數呾儂扲逄
+select * from 數呾儂扲逄
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+-----------------+-----------+----------
+ 萇齟珆尨そ | 儂A01奻 |
+ 萇齟芞倛 | 煦B01笢 |
+ 萇齟最唗埜 | 汳01狟 |
(3 rows)
-QUERY: select * from 數呾儂扲逄 where 煦濬瘍 = '汳01狟';
-扲逄 |煦濬瘍|掘蛁1a
----------------+---------+--------
-萇齟最唗埜|汳01狟|
+select * from 數呾儂扲逄 where 煦濬瘍 = '汳01狟'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+-----------------+-----------+----------
+ 萇齟最唗埜 | 汳01狟 |
(1 row)
-QUERY: select * from 數呾儂扲逄 where 煦濬瘍 ~* '芏01狟';
-扲逄 |煦濬瘍|掘蛁1a
----------------+---------+--------
-萇齟最唗埜|汳01狟|
+select * from 數呾儂扲逄 where 煦濬瘍 ~* '芏01狟'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+-----------------+-----------+----------
+ 萇齟最唗埜 | 汳01狟 |
(1 row)
-QUERY: select * from 數呾儂扲逄 where 煦濬瘍 like '_Z01_';
-扲逄 |煦濬瘍|掘蛁1a
----------------+---------+--------
-萇齟最唗埜|汳01狟|
+select * from 數呾儂扲逄 where 煦濬瘍 like '_Z01_'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+-----------------+-----------+----------
+ 萇齟最唗埜 | 汳01狟 |
(1 row)
-QUERY: select * from 數呾儂扲逄 where 煦濬瘍 like '_Z%';
-扲逄 |煦濬瘍|掘蛁1a
----------------+---------+--------
-萇齟最唗埜|汳01狟|
+select * from 數呾儂扲逄 where 煦濬瘍 like '_Z%'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+-----------------+-----------+----------
+ 萇齟最唗埜 | 汳01狟 |
(1 row)
-QUERY: select * from 數呾儂扲逄 where 扲逄 ~ '萇齟[珆芞]';
-扲逄 |煦濬瘍|掘蛁1a
----------------+---------+--------
-萇齟珆尨そ|儂A01奻|
-萇齟芞倛 |煦B01笢|
+select * from 數呾儂扲逄 where 扲逄 ~ '萇齟[珆芞]'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+-----------------+-----------+----------
+ 萇齟珆尨そ | 儂A01奻 |
+ 萇齟芞倛 | 煦B01笢 |
(2 rows)
-QUERY: select * from 數呾儂扲逄 where 扲逄 ~* '萇齟[珆芞]';
-扲逄 |煦濬瘍|掘蛁1a
----------------+---------+--------
-萇齟珆尨そ|儂A01奻|
-萇齟芞倛 |煦B01笢|
+select * from 數呾儂扲逄 where 扲逄 ~* '萇齟[珆芞]'
+ 扲逄 | 煦濬瘍 | 掘蛁1a
+-----------------+-----------+----------
+ 萇齟珆尨そ | 儂A01奻 |
+ 萇齟芞倛 | 煦B01笢 |
(2 rows)
-QUERY: select *,character_length(扲逄) from 數呾儂扲逄;
-扲逄 |煦濬瘍|掘蛁1a|length
----------------+---------+--------+------
-萇齟珆尨そ|儂A01奻| | 5
-萇齟芞倛 |煦B01笢| | 4
-萇齟最唗埜|汳01狟| | 5
+select *,character_length(扲逄) from 數呾儂扲逄
+ 扲逄 | 煦濬瘍 | 掘蛁1a | length
+-----------------+-----------+----------+--------
+ 萇齟珆尨そ | 儂A01奻 | | 5
+ 萇齟芞倛 | 煦B01笢 | | 4
+ 萇齟最唗埜 | 汳01狟 | | 5
(3 rows)
-QUERY: select *,octet_length(扲逄) from 數呾儂扲逄;
-扲逄 |煦濬瘍|掘蛁1a|octet_length
----------------+---------+--------+------------
-萇齟珆尨そ|儂A01奻| | 15
-萇齟芞倛 |煦B01笢| | 12
-萇齟最唗埜|汳01狟| | 15
+select *,octet_length(扲逄) from 數呾儂扲逄
+ 扲逄 | 煦濬瘍 | 掘蛁1a | octet_length
+-----------------+-----------+----------+--------------
+ 萇齟珆尨そ | 儂A01奻 | | 15
+ 萇齟芞倛 | 煦B01笢 | | 12
+ 萇齟最唗埜 | 汳01狟 | | 15
(3 rows)
-QUERY: select *,position('珆' in 扲逄) from 數呾儂扲逄;
-扲逄 |煦濬瘍|掘蛁1a|strpos
----------------+---------+--------+------
-萇齟珆尨そ|儂A01奻| | 3
-萇齟芞倛 |煦B01笢| | 0
-萇齟最唗埜|汳01狟| | 0
+select *,position('珆' in 扲逄) from 數呾儂扲逄
+ 扲逄 | 煦濬瘍 | 掘蛁1a | strpos
+-----------------+-----------+----------+--------
+ 萇齟珆尨そ | 儂A01奻 | | 3
+ 萇齟芞倛 | 煦B01笢 | | 0
+ 萇齟最唗埜 | 汳01狟 | | 0
(3 rows)
-QUERY: select *,substring(扲逄 from 3 for 4) from 數呾儂扲逄;
-扲逄 |煦濬瘍|掘蛁1a|substr
----------------+---------+--------+---------
-萇齟珆尨そ|儂A01奻| |珆尨そ
-萇齟芞倛 |煦B01笢| |芞倛
-萇齟最唗埜|汳01狟| |最唗埜
+select *,substring(扲逄 from 3 for 4) from 數呾儂扲逄
+ 扲逄 | 煦濬瘍 | 掘蛁1a | substr
+-----------------+-----------+----------+-----------
+ 萇齟珆尨そ | 儂A01奻 | | 珆尨そ
+ 萇齟芞倛 | 煦B01笢 | | 芞倛
+ 萇齟最唗埜 | 汳01狟 | | 最唗埜
(3 rows)
-QUERY: drop table 耵蓱悁辨橫;
+drop table 耵蓱悁辨橫
ERROR: Relation '耵蓱悁辨橫' does not exist
-QUERY: create table 耵蓱悁辨橫 (辨橫 text, 暐袛囀萄 varchar, 綠堅1A塭掘 char(16));
-QUERY: create index 耵蓱悁辨橫index1 on 耵蓱悁辨橫 using btree (辨橫);
-QUERY: create index 耵蓱悁辨橫index2 on 耵蓱悁辨橫 using hash (暐袛囀萄);
-QUERY: insert into 耵蓱悁辨橫 values('闡У攪蛤蝶Ы溯檜', '悁A01葞');
-QUERY: insert into 耵蓱悁辨橫 values('闡У攪斜楚а蝶', '暐B10齌');
-QUERY: insert into 耵蓱悁辨橫 values('闡У攪Щ煎斜楚該', '嬣Z01欞');
-QUERY: vacuum 耵蓱悁辨橫;
-QUERY: select * from 耵蓱悁辨橫;
-辨橫 |暐袛囀萄|綠堅1a塭掘
-------------------------+------------+--------------
-闡У攪蛤蝶Ы溯檜|悁A01葞 |
-闡У攪斜楚а蝶 |暐B10齌 |
-闡У攪Щ煎斜楚該|嬣Z01欞 |
+create table 耵蓱悁辨橫 (辨橫 text, 暐袛囀萄 varchar, 綠堅1A塭掘 char(16))
+create index 耵蓱悁辨橫index1 on 耵蓱悁辨橫 using btree (辨橫)
+create index 耵蓱悁辨橫index2 on 耵蓱悁辨橫 using hash (暐袛囀萄)
+insert into 耵蓱悁辨橫 values('闡У攪蛤蝶Ы溯檜', '悁A01葞')
+insert into 耵蓱悁辨橫 values('闡У攪斜楚а蝶', '暐B10齌')
+insert into 耵蓱悁辨橫 values('闡У攪Щ煎斜楚該', '嬣Z01欞')
+vacuum 耵蓱悁辨橫
+select * from 耵蓱悁辨橫
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+--------------------------+--------------+----------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 |
+ 闡У攪斜楚а蝶 | 暐B10齌 |
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 |
(3 rows)
-QUERY: select * from 耵蓱悁辨橫 where 暐袛囀萄 = '嬣Z01欞';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-------------------------+------------+--------------
-闡У攪Щ煎斜楚該|嬣Z01欞 |
+select * from 耵蓱悁辨橫 where 暐袛囀萄 = '嬣Z01欞'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+--------------------------+--------------+----------------
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 |
(1 row)
-QUERY: select * from 耵蓱悁辨橫 where 暐袛囀萄 ~* '嬣z01欞';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-------------------------+------------+--------------
-闡У攪Щ煎斜楚該|嬣Z01欞 |
+select * from 耵蓱悁辨橫 where 暐袛囀萄 ~* '嬣z01欞'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+--------------------------+--------------+----------------
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 |
(1 row)
-QUERY: select * from 耵蓱悁辨橫 where 暐袛囀萄 like '_Z01_';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-------------------------+------------+--------------
-闡У攪Щ煎斜楚該|嬣Z01欞 |
+select * from 耵蓱悁辨橫 where 暐袛囀萄 like '_Z01_'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+--------------------------+--------------+----------------
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 |
(1 row)
-QUERY: select * from 耵蓱悁辨橫 where 暐袛囀萄 like '_Z%';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-------------------------+------------+--------------
-闡У攪Щ煎斜楚該|嬣Z01欞 |
+select * from 耵蓱悁辨橫 where 暐袛囀萄 like '_Z%'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+--------------------------+--------------+----------------
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 |
(1 row)
-QUERY: select * from 耵蓱悁辨橫 where 辨橫 ~ '闡У攪[蛤斜]';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-------------------------+------------+--------------
-闡У攪蛤蝶Ы溯檜|悁A01葞 |
-闡У攪斜楚а蝶 |暐B10齌 |
+select * from 耵蓱悁辨橫 where 辨橫 ~ '闡У攪[蛤斜]'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+--------------------------+--------------+----------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 |
+ 闡У攪斜楚а蝶 | 暐B10齌 |
(2 rows)
-QUERY: select * from 耵蓱悁辨橫 where 辨橫 ~* '闡У攪[蛤斜]';
-辨橫 |暐袛囀萄|綠堅1a塭掘
-------------------------+------------+--------------
-闡У攪蛤蝶Ы溯檜|悁A01葞 |
-闡У攪斜楚а蝶 |暐B10齌 |
+select * from 耵蓱悁辨橫 where 辨橫 ~* '闡У攪[蛤斜]'
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘
+--------------------------+--------------+----------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 |
+ 闡У攪斜楚а蝶 | 暐B10齌 |
(2 rows)
-QUERY: select *,character_length(辨橫) from 耵蓱悁辨橫;
-辨橫 |暐袛囀萄|綠堅1a塭掘|length
-------------------------+------------+--------------+------
-闡У攪蛤蝶Ы溯檜|悁A01葞 | | 8
-闡У攪斜楚а蝶 |暐B10齌 | | 7
-闡У攪Щ煎斜楚該|嬣Z01欞 | | 8
+select *,character_length(辨橫) from 耵蓱悁辨橫
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | length
+--------------------------+--------------+----------------+--------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 8
+ 闡У攪斜楚а蝶 | 暐B10齌 | | 7
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 8
(3 rows)
-QUERY: select *,octet_length(辨橫) from 耵蓱悁辨橫;
-辨橫 |暐袛囀萄|綠堅1a塭掘|octet_length
-------------------------+------------+--------------+------------
-闡У攪蛤蝶Ы溯檜|悁A01葞 | | 24
-闡У攪斜楚а蝶 |暐B10齌 | | 21
-闡У攪Щ煎斜楚該|嬣Z01欞 | | 24
+select *,octet_length(辨橫) from 耵蓱悁辨橫
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | octet_length
+--------------------------+--------------+----------------+--------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 24
+ 闡У攪斜楚а蝶 | 暐B10齌 | | 21
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 24
(3 rows)
-QUERY: select *,position('蛤' in 辨橫) from 耵蓱悁辨橫;
-辨橫 |暐袛囀萄|綠堅1a塭掘|strpos
-------------------------+------------+--------------+------
-闡У攪蛤蝶Ы溯檜|悁A01葞 | | 4
-闡У攪斜楚а蝶 |暐B10齌 | | 0
-闡У攪Щ煎斜楚該|嬣Z01欞 | | 0
+select *,position('蛤' in 辨橫) from 耵蓱悁辨橫
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | strpos
+--------------------------+--------------+----------------+--------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 4
+ 闡У攪斜楚а蝶 | 暐B10齌 | | 0
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 0
(3 rows)
-QUERY: select *,substring(辨橫 from 3 for 4) from 耵蓱悁辨橫;
-辨橫 |暐袛囀萄|綠堅1a塭掘|substr
-------------------------+------------+--------------+------------
-闡У攪蛤蝶Ы溯檜|悁A01葞 | |攪蛤蝶Ы
-闡У攪斜楚а蝶 |暐B10齌 | |攪斜楚а
-闡У攪Щ煎斜楚該|嬣Z01欞 | |攪Щ煎斜
+select *,substring(辨橫 from 3 for 4) from 耵蓱悁辨橫
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | substr
+--------------------------+--------------+----------------+--------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 攪蛤蝶Ы
+ 闡У攪斜楚а蝶 | 暐B10齌 | | 攪斜楚а
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 攪Щ煎斜
(3 rows)
-QUERY: drop table test;
+drop table test
ERROR: Relation 'test' does not exist
-QUERY: create table test (t text);
-QUERY: insert into test values('ENGLISH');
-QUERY: insert into test values('FRANォIS');
-QUERY: insert into test values('ESPA埆L');
-QUERY: insert into test values('炓LENSKA');
-QUERY: insert into test values('ENGLISH FRANォIS ESPA埆L 炓LENSKA');
-QUERY: vacuum test;
-QUERY: select * from test;
-t
-------------------------------------
-ENGLISH
-FRANォIS
-ESPA埆L
-炓LENSKA
-ENGLISH FRANォIS ESPA埆L 炓LENSKA
+create table test (t text)
+insert into test values('ENGLISH')
+insert into test values('FRANォIS')
+insert into test values('ESPA埆L')
+insert into test values('炓LENSKA')
+insert into test values('ENGLISH FRANォIS ESPA埆L 炓LENSKA')
+vacuum test
+select * from test
+ t
+--------------------------------------
+ ENGLISH
+ FRANォIS
+ ESPA埆L
+ 炓LENSKA
+ ENGLISH FRANォIS ESPA埆L 炓LENSKA
(5 rows)
-QUERY: select * from test where t = 'ESPA埆L';
-t
---------
-ESPA埆L
+select * from test where t = 'ESPA埆L'
+ t
+----------
+ ESPA埆L
(1 row)
-QUERY: select * from test where t ~* 'espa峱l';
-t
-------------------------------------
-ESPA埆L
-ENGLISH FRANォIS ESPA埆L 炓LENSKA
+select * from test where t ~* 'espa峱l'
+ t
+--------------------------------------
+ ESPA埆L
+ ENGLISH FRANォIS ESPA埆L 炓LENSKA
(2 rows)
-QUERY: select *,character_length(t) from test;
-t |length
-------------------------------------+------
-ENGLISH | 7
-FRANォIS | 8
-ESPA埆L | 7
-炓LENSKA | 8
-ENGLISH FRANォIS ESPA埆L 炓LENSKA| 33
+select *,character_length(t) from test
+ t | length
+--------------------------------------+--------
+ ENGLISH | 7
+ FRANォIS | 8
+ ESPA埆L | 7
+ 炓LENSKA | 8
+ ENGLISH FRANォIS ESPA埆L 炓LENSKA | 33
(5 rows)
-QUERY: select *,octet_length(t) from test;
-t |octet_length
-------------------------------------+------------
-ENGLISH | 7
-FRANォIS | 9
-ESPA埆L | 8
-炓LENSKA | 9
-ENGLISH FRANォIS ESPA埆L 炓LENSKA| 36
+select *,octet_length(t) from test
+ t | octet_length
+--------------------------------------+--------------
+ ENGLISH | 7
+ FRANォIS | 9
+ ESPA埆L | 8
+ 炓LENSKA | 9
+ ENGLISH FRANォIS ESPA埆L 炓LENSKA | 36
(5 rows)
-QUERY: select *,position('L' in t) from test;
-t |strpos
-------------------------------------+------
-ENGLISH | 4
-FRANォIS | 0
-ESPA埆L | 7
-炓LENSKA | 3
-ENGLISH FRANォIS ESPA埆L 炓LENSKA| 4
+select *,position('L' in t) from test
+ t | strpos
+--------------------------------------+--------
+ ENGLISH | 4
+ FRANォIS | 0
+ ESPA埆L | 7
+ 炓LENSKA | 3
+ ENGLISH FRANォIS ESPA埆L 炓LENSKA | 4
(5 rows)
-QUERY: select *,substring(t from 3 for 4) from test;
-t |substr
-------------------------------------+------
-ENGLISH |GLIS
-FRANォIS |ANォ
-ESPA埆L |PA埆
-炓LENSKA |LENS
-ENGLISH FRANォIS ESPA埆L 炓LENSKA|GLIS
+select *,substring(t from 3 for 4) from test
+ t | substr
+--------------------------------------+--------
+ ENGLISH | GLIS
+ FRANォIS | ANォ
+ ESPA埆L | PA埆
+ 炓LENSKA | LENS
+ ENGLISH FRANォIS ESPA埆L 炓LENSKA | GLIS
(5 rows)
diff --git a/src/test/mb/expected/sjis.out b/src/test/mb/expected/sjis.out
index 9dadee10e7f..0a63fc6321a 100644
--- a/src/test/mb/expected/sjis.out
+++ b/src/test/mb/expected/sjis.out
@@ -1,12 +1,12 @@
-drop table vZ@p;
-create table vZ@p (p text, R[h varchar, l1A char(16));
-create index vZ@p甋ndex1 on vZ@p using btree (p);
-create index vZ@p甋ndex2 on vZ@p using hash (R[h);
-insert into vZ@p values('Rs[^fBXvC','@A01');
-insert into vZ@p values('Rs[^OtBbNX','朋10');
-insert into vZ@p values('Rs[^vO}[','lZ01');
-vacuum vZ@p;
-select * from vZ@p;
+drop table vZ@p
+create table vZ@p (p text, R[h varchar, l1A char(16))
+create index vZ@p甋ndex1 on vZ@p using btree (p)
+create index vZ@p甋ndex2 on vZ@p using hash (R[h)
+insert into vZ@p values('Rs[^fBXvC','@A01')
+insert into vZ@p values('Rs[^OtBbNX','朋10')
+insert into vZ@p values('Rs[^vO}[','lZ01')
+vacuum vZ@p
+select * from vZ@p
p | R[h | l1a
----------------------------+------------+------------
Rs[^fBXvC | @A01 |
@@ -14,45 +14,45 @@ select * from vZ@p;
Rs[^vO}[ | lZ01 |
(3 rows)
-select * from vZ@p where R[h = 'lZ01';
+select * from vZ@p where R[h = 'lZ01'
p | R[h | l1a
--------------------------+------------+------------
Rs[^vO}[ | lZ01 |
(1 row)
-select * from vZ@p where R[h ~* 'lz01';
+select * from vZ@p where R[h ~* 'lz01'
p | R[h | l1a
--------------------------+------------+------------
Rs[^vO}[ | lZ01 |
(1 row)
-select * from vZ@p where R[h like '_Z01_';
+select * from vZ@p where R[h like '_Z01_'
p | R[h | l1a
--------------------------+------------+------------
Rs[^vO}[ | lZ01 |
(1 row)
-select * from vZ@p where R[h like '_Z%';
+select * from vZ@p where R[h like '_Z%'
p | R[h | l1a
--------------------------+------------+------------
Rs[^vO}[ | lZ01 |
(1 row)
-select * from vZ@p where p ~ 'Rs[^[fO]';
+select * from vZ@p where p ~ 'Rs[^[fO]'
p | R[h | l1a
----------------------------+------------+------------
Rs[^fBXvC | @A01 |
Rs[^OtBbNX | 朋10 |
(2 rows)
-select * from vZ@p where p ~* 'Rs[^[fO]';
+select * from vZ@p where p ~* 'Rs[^[fO]'
p | R[h | l1a
----------------------------+------------+------------
Rs[^fBXvC | @A01 |
Rs[^OtBbNX | 朋10 |
(2 rows)
-select *,character_length(p) from vZ@p;
+select *,character_length(p) from vZ@p
p | R[h | l1a | length
----------------------------+------------+------------+--------
Rs[^fBXvC | @A01 | | 12
@@ -60,7 +60,7 @@ select *,character_length(p) from vZ@p;
Rs[^vO}[ | lZ01 | | 12
(3 rows)
-select *,octet_length(p) from vZ@p;
+select *,octet_length(p) from vZ@p
p | R[h | l1a | octet_length
----------------------------+------------+------------+--------------
Rs[^fBXvC | @A01 | | 24
@@ -68,7 +68,7 @@ select *,octet_length(p) from vZ@p;
Rs[^vO}[ | lZ01 | | 24
(3 rows)
-select *,position('f' in p) from vZ@p;
+select *,position('f' in p) from vZ@p
p | R[h | l1a | strpos
----------------------------+------------+------------+--------
Rs[^fBXvC | @A01 | | 7
@@ -76,7 +76,7 @@ select *,position('f' in p) from vZ@p;
Rs[^vO}[ | lZ01 | | 0
(3 rows)
-select *,substring(p from 10 for 4) from vZ@p;
+select *,substring(p from 10 for 4) from vZ@p
p | R[h | l1a | substr
----------------------------+------------+------------+----------
Rs[^fBXvC | @A01 | | vC
@@ -84,7 +84,7 @@ select *,substring(p from 10 for 4) from vZ@p;
Rs[^vO}[ | lZ01 | | }[
(3 rows)
-copy vZ@p to stdout;
+copy vZ@p to stdout
Rs[^fBXvC @A01 \N
Rs[^OtBbNX 朋10 \N
Rs[^vO}[ lZ01 \N
diff --git a/src/test/mb/expected/unicode.out b/src/test/mb/expected/unicode.out
index 4f619badd7b..45f565ca67a 100644
--- a/src/test/mb/expected/unicode.out
+++ b/src/test/mb/expected/unicode.out
@@ -1,87 +1,87 @@
-QUERY: drop table 閮蝞璈刻;
+drop table 閮蝞璈刻
ERROR: Relation '閮蝞璈刻' does not exist
-QUERY: create table 閮蝞璈刻 (刻 text, 憿喋潦 varchar, 1A char(16));
-QUERY: create index 閮蝞璈刻index1 on 閮蝞璈刻 using btree (刻);
-QUERY: create index 閮蝞璈刻index2 on 閮蝞璈刻 using hash (憿喋潦);
-QUERY: insert into 閮蝞璈刻 values('喋喋乓潦踴嫘研','璈A01銝');
-QUERY: insert into 閮蝞璈刻 values('喋喋乓潦踴啜押胯','B10銝');
-QUERY: insert into 閮蝞璈刻 values('喋喋乓潦踴准啜押','鈭暢01銝');
-QUERY: vacuum 閮蝞璈刻;
-QUERY: select * from 閮蝞璈刻;
-刻 |憿喋潦|1a
----------------------------------------+---------------+--------------
-喋喋乓潦踴嫘研 |璈A01銝 |
-喋喋乓潦踴啜押胯頌B10銝 |
-喋喋乓潦踴准啜押 |鈭暢01銝 |
+create table 閮蝞璈刻 (刻 text, 憿喋潦 varchar, 1A char(16))
+create index 閮蝞璈刻index1 on 閮蝞璈刻 using btree (刻)
+create index 閮蝞璈刻index2 on 閮蝞璈刻 using hash (憿喋潦)
+insert into 閮蝞璈刻 values('喋喋乓潦踴嫘研','璈A01銝')
+insert into 閮蝞璈刻 values('喋喋乓潦踴啜押胯','B10銝')
+insert into 閮蝞璈刻 values('喋喋乓潦踴准啜押','鈭暢01銝')
+vacuum 閮蝞璈刻
+select * from 閮蝞璈刻
+ 刻 | 憿喋潦 | 1a
+-----------------------------------------+-----------------+----------------
+ 喋喋乓潦踴嫘研 | 璈A01銝 |
+ 喋喋乓潦踴啜押胯 | B10銝 |
+ 喋喋乓潦踴准啜押 | 鈭暢01銝 |
(3 rows)
-QUERY: select * from 閮蝞璈刻 where 憿喋潦 = '鈭暢01銝';
-刻 |憿喋潦|1a
-------------------------------------+---------------+--------------
-喋喋乓潦踴准啜押慝鈭暢01銝 |
+select * from 閮蝞璈刻 where 憿喋潦 = '鈭暢01銝'
+ 刻 | 憿喋潦 | 1a
+--------------------------------------+-----------------+----------------
+ 喋喋乓潦踴准啜押 | 鈭暢01銝 |
(1 row)
-QUERY: select * from 閮蝞璈刻 where 憿喋潦 ~* '鈭漠01銝';
-刻 |憿喋潦|1a
-------------------------------------+---------------+--------------
-喋喋乓潦踴准啜押慝鈭暢01銝 |
+select * from 閮蝞璈刻 where 憿喋潦 ~* '鈭漠01銝'
+ 刻 | 憿喋潦 | 1a
+--------------------------------------+-----------------+----------------
+ 喋喋乓潦踴准啜押 | 鈭暢01銝 |
(1 row)
-QUERY: select * from 閮蝞璈刻 where 憿喋潦 like '_Z01_';
-刻 |憿喋潦|1a
-------------------------------------+---------------+--------------
-喋喋乓潦踴准啜押慝鈭暢01銝 |
+select * from 閮蝞璈刻 where 憿喋潦 like '_Z01_'
+ 刻 | 憿喋潦 | 1a
+--------------------------------------+-----------------+----------------
+ 喋喋乓潦踴准啜押 | 鈭暢01銝 |
(1 row)
-QUERY: select * from 閮蝞璈刻 where 憿喋潦 like '_Z%';
-刻 |憿喋潦|1a
-------------------------------------+---------------+--------------
-喋喋乓潦踴准啜押慝鈭暢01銝 |
+select * from 閮蝞璈刻 where 憿喋潦 like '_Z%'
+ 刻 | 憿喋潦 | 1a
+--------------------------------------+-----------------+----------------
+ 喋喋乓潦踴准啜押 | 鈭暢01銝 |
(1 row)
-QUERY: select * from 閮蝞璈刻 where 刻 ~ '喋喋乓潦璟財';
-刻 |憿喋潦|1a
----------------------------------------+---------------+--------------
-喋喋乓潦踴嫘研 |璈A01銝 |
-喋喋乓潦踴啜押胯頌B10銝 |
+select * from 閮蝞璈刻 where 刻 ~ '喋喋乓潦璟財'
+ 刻 | 憿喋潦 | 1a
+-----------------------------------------+-----------------+----------------
+ 喋喋乓潦踴嫘研 | 璈A01銝 |
+ 喋喋乓潦踴啜押胯 | B10銝 |
(2 rows)
-QUERY: select * from 閮蝞璈刻 where 刻 ~* '喋喋乓潦璟財';
-刻 |憿喋潦|1a
----------------------------------------+---------------+--------------
-喋喋乓潦踴嫘研 |璈A01銝 |
-喋喋乓潦踴啜押胯頌B10銝 |
+select * from 閮蝞璈刻 where 刻 ~* '喋喋乓潦璟財'
+ 刻 | 憿喋潦 | 1a
+-----------------------------------------+-----------------+----------------
+ 喋喋乓潦踴嫘研 | 璈A01銝 |
+ 喋喋乓潦踴啜押胯 | B10銝 |
(2 rows)
-QUERY: select *,character_length(刻) from 閮蝞璈刻;
-刻 |憿喋潦|1a|length
----------------------------------------+---------------+--------------+------
-喋喋乓潦踴嫘研 |璈A01銝 | | 12
-喋喋乓潦踴啜押胯頌B10銝 | | 13
-喋喋乓潦踴准啜押 |鈭暢01銝 | | 12
+select *,character_length(刻) from 閮蝞璈刻
+ 刻 | 憿喋潦 | 1a | length
+-----------------------------------------+-----------------+----------------+--------
+ 喋喋乓潦踴嫘研 | 璈A01銝 | | 12
+ 喋喋乓潦踴啜押胯 | B10銝 | | 13
+ 喋喋乓潦踴准啜押 | 鈭暢01銝 | | 12
(3 rows)
-QUERY: select *,octet_length(刻) from 閮蝞璈刻;
-刻 |憿喋潦|1a|octet_length
----------------------------------------+---------------+--------------+------------
-喋喋乓潦踴嫘研 |璈A01銝 | | 36
-喋喋乓潦踴啜押胯頌B10銝 | | 39
-喋喋乓潦踴准啜押 |鈭暢01銝 | | 36
+select *,octet_length(刻) from 閮蝞璈刻
+ 刻 | 憿喋潦 | 1a | octet_length
+-----------------------------------------+-----------------+----------------+--------------
+ 喋喋乓潦踴嫘研 | 璈A01銝 | | 36
+ 喋喋乓潦踴啜押胯 | B10銝 | | 39
+ 喋喋乓潦踴准啜押 | 鈭暢01銝 | | 36
(3 rows)
-QUERY: select *,position('' in 刻) from 閮蝞璈刻;
-刻 |憿喋潦|1a|strpos
----------------------------------------+---------------+--------------+------
-喋喋乓潦踴嫘研 |璈A01銝 | | 7
-喋喋乓潦踴啜押胯頌B10銝 | | 0
-喋喋乓潦踴准啜押 |鈭暢01銝 | | 0
+select *,position('' in 刻) from 閮蝞璈刻
+ 刻 | 憿喋潦 | 1a | strpos
+-----------------------------------------+-----------------+----------------+--------
+ 喋喋乓潦踴嫘研 | 璈A01銝 | | 7
+ 喋喋乓潦踴啜押胯 | B10銝 | | 0
+ 喋喋乓潦踴准啜押 | 鈭暢01銝 | | 0
(3 rows)
-QUERY: select *,substring(刻 from 10 for 4) from 閮蝞璈刻;
-刻 |憿喋潦|1a|substr
----------------------------------------+---------------+--------------+------------
-喋喋乓潦踴嫘研 |璈A01銝 | |研
-喋喋乓潦踴啜押胯頌B10銝 | |胯
-喋喋乓潦踴准啜押 |鈭暢01銝 | |押
+select *,substring(刻 from 10 for 4) from 閮蝞璈刻
+ 刻 | 憿喋潦 | 1a | substr
+-----------------------------------------+-----------------+----------------+--------------
+ 喋喋乓潦踴嫘研 | 璈A01銝 | | 研
+ 喋喋乓潦踴啜押胯 | B10銝 | | 胯
+ 喋喋乓潦踴准啜押 | 鈭暢01銝 | | 押
(3 rows)
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-05 20:35:34 +0000