diff options
Diffstat (limited to 'src/test/mb/expected/mule_internal.out')
| -rw-r--r-- | src/test/mb/expected/mule_internal.out | 219 |
1 files changed, 103 insertions, 116 deletions
diff --git a/src/test/mb/expected/mule_internal.out b/src/test/mb/expected/mule_internal.out index bfcffc8490a..034701277a7 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 גђ where ʬ = 'Z01'; (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 Ƒ㑻 where ֑ = 'Z01'; (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 ͪߩѦ듾 where ړ = 'Z01'; (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('FRANAIS'); @@ -305,25 +292,25 @@ select *,octet_length(t) from test; t | octet_length --------------------------------------+-------------- ENGLISH | 7 - FRANAIS | 9 - ESPAOL | 8 - SLENSKA | 9 - ENGLISH FRANAIS ESPAOL SLENSKA | 36 + FRANAIS | 10 + ESPAOL | 9 + SLENSKA | 10 + ENGLISH FRANAIS ESPAOL SLENSKA | 39 (5 rows) select *,position('L' in t) from test; - t | strpos ---------------------------------------+-------- - ENGLISH | 4 - FRANAIS | 0 - ESPAOL | 7 - SLENSKA | 3 - ENGLISH FRANAIS ESPAOL SLENSKA | 4 + t | position +--------------------------------------+---------- + ENGLISH | 4 + FRANAIS | 0 + ESPAOL | 7 + SLENSKA | 3 + ENGLISH FRANAIS ESPAOL SLENSKA | 4 (5 rows) select *,substring(t from 3 for 4) from test; - t | substr ---------------------------------------+-------- + t | substring +--------------------------------------+----------- ENGLISH | GLIS FRANAIS | ANA ESPAOL | PAO |