aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/test/mb/expected/big5.out10
-rw-r--r--src/test/mb/expected/euc_cn.out10
-rw-r--r--src/test/mb/expected/euc_jp.out10
-rw-r--r--src/test/mb/expected/euc_kr.out10
-rw-r--r--src/test/mb/expected/euc_tw.out10
-rw-r--r--src/test/mb/expected/mule_internal.out44
-rw-r--r--src/test/mb/expected/sjis.out10
-rw-r--r--src/test/mb/expected/unicode.out10
8 files changed, 57 insertions, 57 deletions
diff --git a/src/test/mb/expected/big5.out b/src/test/mb/expected/big5.out
index 110bf8c7a3c..97100cd0a2d 100644
--- a/src/test/mb/expected/big5.out
+++ b/src/test/mb/expected/big5.out
@@ -51,11 +51,11 @@ select * from 廠商資料 where 公司抬頭 ~* '達達科[寄記技]';
(1 row)
select *, character_length(行業別) from 廠商資料;
- 行業別 | 公司抬頭 | 地址 | char_length
---------+------------------+---------+-------------
- 電腦業 | 達達科技 | 北A01仁 | 3
- 製造業 | 財源有限公司 | 中B10中 | 3
- 餐飲業 | 美味股份有限公司 | 高Z01九 | 3
+ 行業別 | 公司抬頭 | 地址 | character_length
+--------+------------------+---------+------------------
+ 電腦業 | 達達科技 | 北A01仁 | 3
+ 製造業 | 財源有限公司 | 中B10中 | 3
+ 餐飲業 | 美味股份有限公司 | 高Z01九 | 3
(3 rows)
select *, octet_length(行業別) from 廠商資料;
diff --git a/src/test/mb/expected/euc_cn.out b/src/test/mb/expected/euc_cn.out
index 71068f8c55d..4d046fa87dc 100644
--- a/src/test/mb/expected/euc_cn.out
+++ b/src/test/mb/expected/euc_cn.out
@@ -54,11 +54,11 @@ select * from 數呾儂扲逄 where 扲逄 ~* '萇齟[珆芞]';
(2 rows)
select *,character_length(扲逄) from 數呾儂扲逄;
- 扲逄 | 煦濬瘍 | 掘蛁1a | char_length
-------------+---------+--------+-------------
- 萇齟珆尨そ | 儂A01奻 | | 5
- 萇齟芞倛 | 煦B01笢 | | 4
- 萇齟最唗埜 | 汳01狟 | | 5
+ 扲逄 | 煦濬瘍 | 掘蛁1a | character_length
+------------+---------+--------+------------------
+ 萇齟珆尨そ | 儂A01奻 | | 5
+ 萇齟芞倛 | 煦B01笢 | | 4
+ 萇齟最唗埜 | 汳01狟 | | 5
(3 rows)
select *,octet_length(扲逄) from 數呾儂扲逄;
diff --git a/src/test/mb/expected/euc_jp.out b/src/test/mb/expected/euc_jp.out
index 0cdf8fede47..15f83e0231c 100644
--- a/src/test/mb/expected/euc_jp.out
+++ b/src/test/mb/expected/euc_jp.out
@@ -54,11 +54,11 @@ select * from 煌遙窗迕賄 where 迕賄 ~* '戊件疋亙□正[犯弘]';
(2 rows)
select *,character_length(迕賄) from 煌遙窗迕賄;
- 迕賄 | 坌挀戊□玉 | 鷞1a分方 | char_length
-----------------------------+------------+------------+-------------
- 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 12
- 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 | | 13
- 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 12
+ 迕賄 | 坌挀戊□玉 | 鷞1a分方 | character_length
+----------------------------+------------+------------+------------------
+ 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 12
+ 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 | | 13
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 12
(3 rows)
select *,octet_length(迕賄) from 煌遙窗迕賄;
diff --git a/src/test/mb/expected/euc_kr.out b/src/test/mb/expected/euc_kr.out
index 8b90c4d76ec..229ffd8f971 100644
--- a/src/test/mb/expected/euc_kr.out
+++ b/src/test/mb/expected/euc_kr.out
@@ -54,11 +54,11 @@ select * from 耵蓱悁辨橫 where 辨橫 ~* '闡У攪[蛤斜]';
(2 rows)
select *,character_length(辨橫) from 耵蓱悁辨橫;
- 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | char_length
-------------------+----------+------------+-------------
- 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 8
- 闡У攪斜楚а蝶 | 暐B10齌 | | 7
- 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 8
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | character_length
+------------------+----------+------------+------------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 8
+ 闡У攪斜楚а蝶 | 暐B10齌 | | 7
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 8
(3 rows)
select *,octet_length(辨橫) from 耵蓱悁辨橫;
diff --git a/src/test/mb/expected/euc_tw.out b/src/test/mb/expected/euc_tw.out
index 3b0a0f75d6e..99eb4884e12 100644
--- a/src/test/mb/expected/euc_tw.out
+++ b/src/test/mb/expected/euc_tw.out
@@ -52,11 +52,11 @@ select * from 徻椓罶涷 where 襬く剉韝 ~* '蝞蝞秠[溈奡岍]';
(1 row)
select *, character_length(諙づ) from 徻椓罶涷;
- 諙づ | 襬く剉韝 | щ彴 | char_length
---------+------------------+---------+-------------
- 諔瑼鞄 | 蝞蝞秠岍 | ヾA01癩 | 3
- 蕍楸鞄 | 娷鳲植鄸く | 斕B10斕 | 3
- 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻 | 3
+ 諙づ | 襬く剉韝 | щ彴 | character_length
+--------+------------------+---------+------------------
+ 諔瑼鞄 | 蝞蝞秠岍 | ヾA01癩 | 3
+ 蕍楸鞄 | 娷鳲植鄸く | 斕B10斕 | 3
+ 顜聜鞄 | 荂抸炴Л植鄸く | 崼Z01藻 | 3
(3 rows)
select *, octet_length(諙づ) from 徻椓罶涷;
diff --git a/src/test/mb/expected/mule_internal.out b/src/test/mb/expected/mule_internal.out
index 983ece1cfdd..fa1f836febe 100644
--- a/src/test/mb/expected/mule_internal.out
+++ b/src/test/mb/expected/mule_internal.out
@@ -54,11 +54,11 @@ select * from 煌遙窗迕賄 where 迕賄 ~* '戊件疋亙□正[犯弘]';
(2 rows)
select *,character_length(迕賄) from 煌遙窗迕賄;
- 迕賄 | 坌挀戊□玉 | 嗶1a分方 | char_length
------------------------------------------+-----------------+----------------+-------------
- 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 12
- 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 | | 13
- 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 12
+ 迕賄 | 坌挀戊□玉 | 嗶1a分方 | character_length
+-----------------------------------------+-----------------+----------------+------------------
+ 戊件疋亙□正犯奴旦皿伊奶 | 窗A01曉 | | 12
+ 戊件疋亙□正弘仿白奴永弁旦 | 坌B10醱 | | 13
+ 戊件疋亙□正皿伕弘仿穴□ | 諦Z01票 | | 12
(3 rows)
select *,octet_length(迕賄) from 煌遙窗迕賄;
@@ -141,11 +141,11 @@ select * from 數呾儂扲逄 where 扲逄 ~* '萇齟[珆芞]';
(2 rows)
select *,character_length(扲逄) from 數呾儂扲逄;
- 扲逄 | 煦濬瘍 | 掘蛁1a | char_length
------------------+-----------+----------+-------------
- 萇齟珆尨そ | 儂A01奻 | | 5
- 萇齟芞倛 | 煦B01笢 | | 4
- 萇齟最唗埜 | 汳01狟 | | 5
+ 扲逄 | 煦濬瘍 | 掘蛁1a | character_length
+-----------------+-----------+----------+------------------
+ 萇齟珆尨そ | 儂A01奻 | | 5
+ 萇齟芞倛 | 煦B01笢 | | 4
+ 萇齟最唗埜 | 汳01狟 | | 5
(3 rows)
select *,octet_length(扲逄) from 數呾儂扲逄;
@@ -228,11 +228,11 @@ select * from 耵蓱悁辨橫 where 辨橫 ~* '闡У攪[蛤斜]';
(2 rows)
select *,character_length(辨橫) from 耵蓱悁辨橫;
- 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | char_length
---------------------------+--------------+----------------+-------------
- 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 8
- 闡У攪斜楚а蝶 | 暐B10齌 | | 7
- 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 8
+ 辨橫 | 暐袛囀萄 | 綠堅1a塭掘 | character_length
+--------------------------+--------------+----------------+------------------
+ 闡У攪蛤蝶Ы溯檜 | 悁A01葞 | | 8
+ 闡У攪斜楚а蝶 | 暐B10齌 | | 7
+ 闡У攪Щ煎斜楚該 | 嬣Z01欞 | | 8
(3 rows)
select *,octet_length(辨橫) from 耵蓱悁辨橫;
@@ -292,13 +292,13 @@ select * from test where t ~* 'espa峱l';
(2 rows)
select *,character_length(t) from test;
- t | char_length
---------------------------------------+-------------
- ENGLISH | 7
- FRANォIS | 8
- ESPA埆L | 7
- 炓LENSKA | 8
- ENGLISH FRANォIS ESPA埆L 炓LENSKA | 33
+ t | character_length
+--------------------------------------+------------------
+ ENGLISH | 7
+ FRANォIS | 8
+ ESPA埆L | 7
+ 炓LENSKA | 8
+ ENGLISH FRANォIS ESPA埆L 炓LENSKA | 33
(5 rows)
select *,octet_length(t) from test;
diff --git a/src/test/mb/expected/sjis.out b/src/test/mb/expected/sjis.out
index 2a852086e13..db2bfd0d755 100644
--- a/src/test/mb/expected/sjis.out
+++ b/src/test/mb/expected/sjis.out
@@ -53,11 +53,11 @@ select * from vZ@p where p ~* 'Rs[^[fO]';
(2 rows)
select *,character_length(p) from vZ@p;
- p | R[h | l1a | char_length
-----------------------------+------------+------------+-------------
- Rs[^fBXvC | @A01 | | 12
- Rs[^OtBbNX | 朋10 | | 13
- Rs[^vO}[ | lZ01 | | 12
+ p | R[h | l1a | character_length
+----------------------------+------------+------------+------------------
+ Rs[^fBXvC | @A01 | | 12
+ Rs[^OtBbNX | 朋10 | | 13
+ Rs[^vO}[ | lZ01 | | 12
(3 rows)
select *,octet_length(p) from vZ@p;
diff --git a/src/test/mb/expected/unicode.out b/src/test/mb/expected/unicode.out
index e578a016d7a..8f9f63c7e0e 100644
--- a/src/test/mb/expected/unicode.out
+++ b/src/test/mb/expected/unicode.out
@@ -54,11 +54,11 @@ select * from 閮蝞璈刻 where 刻 ~* '喋喋乓潦璟財';
(2 rows)
select *,character_length(刻) from 閮蝞璈刻;
- 刻 | 憿喋潦 | 1a | char_length
-----------------------------+------------+------------+-------------
- 喋喋乓潦踴嫘研 | 璈A01銝 | | 12
- 喋喋乓潦踴啜押胯 | B10銝 | | 13
- 喋喋乓潦踴准啜押 | 鈭暢01銝 | | 12
+ 刻 | 憿喋潦 | 1a | character_length
+----------------------------+------------+------------+------------------
+ 喋喋乓潦踴嫘研 | 璈A01銝 | | 12
+ 喋喋乓潦踴啜押胯 | B10銝 | | 13
+ 喋喋乓潦踴准啜押 | 鈭暢01銝 | | 12
(3 rows)
select *,octet_length(刻) from 閮蝞璈刻;