diff options
Diffstat (limited to 'src/test/mb/expected/mule_internal.out')
| -rw-r--r-- | src/test/mb/expected/mule_internal.out | 498 |
1 files changed, 249 insertions, 249 deletions
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('ԑ̑Ա','Z01'); -QUERY: vacuum Ƒ㑻; -QUERY: select * from Ƒ㑻; - |֑|ע1a ----------------+---------+-------- -ԑԑʾ|A01| -ԑͼ |B01| -ԑ̑Ա|Z01| +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('ԑ̑Ա','Z01') +vacuum Ƒ㑻 +select * from Ƒ㑻 + | ֑ | ע1a +-----------------+-----------+---------- + ԑԑʾ | A01 | + ԑͼ | B01 | + ԑ̑Ա | 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| -ԑͼ |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 -ԑ̑Ա|Z01| | 5 +select *,character_length() from Ƒ㑻 + | ֑ | ע1a | length +-----------------+-----------+----------+-------- + ԑԑʾ | A01 | | 5 + ԑͼ | B01 | | 4 + ԑ̑Ա | Z01 | | 5 (3 rows) -QUERY: select *,octet_length() from Ƒ㑻; - |֑|ע1a|octet_length ----------------+---------+--------+------------ -ԑԑʾ|A01| | 15 -ԑͼ |B01| | 12 -ԑ̑Ա|Z01| | 15 +select *,octet_length() from Ƒ㑻 + | ֑ | ע1a | octet_length +-----------------+-----------+----------+-------------- + ԑԑʾ | A01 | | 15 + ԑͼ | B01 | | 12 + ԑ̑Ա | Z01 | | 15 (3 rows) -QUERY: select *,position('' in ) from Ƒ㑻; - |֑|ע1a|strpos ----------------+---------+--------+------ -ԑԑʾ|A01| | 3 -ԑͼ |B01| | 0 -ԑ̑Ա|Z01| | 0 +select *,position('' in ) from Ƒ㑻 + | ֑ | ע1a | strpos +-----------------+-----------+----------+-------- + ԑԑʾ | A01 | | 3 + ԑͼ | B01 | | 0 + ԑ̑Ա | Z01 | | 0 (3 rows) -QUERY: select *,substring( from 3 for 4) from Ƒ㑻; - |֑|ע1a|substr ----------------+---------+--------+--------- -ԑԑʾ|A01| |ԑʾ -ԑͼ |B01| |ͼ -ԑ̑Ա|Z01| |̑Ա +select *,substring( from 3 for 4) from Ƒ㑻 + | ֑ | ע1a | substr +-----------------+-----------+----------+----------- + ԑԑʾ | A01 | | ԑʾ + ԑͼ | B01 | | ͼ + ԑ̑Ա | 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 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('FRANAIS'); -QUERY: insert into test values('ESPAOL'); -QUERY: insert into test values('SLENSKA'); -QUERY: insert into test values('ENGLISH FRANAIS ESPAOL SLENSKA'); -QUERY: vacuum test; -QUERY: select * from test; -t ------------------------------------- -ENGLISH -FRANAIS -ESPAOL -SLENSKA -ENGLISH FRANAIS ESPAOL SLENSKA +create table test (t text) +insert into test values('ENGLISH') +insert into test values('FRANAIS') +insert into test values('ESPAOL') +insert into test values('SLENSKA') +insert into test values('ENGLISH FRANAIS ESPAOL SLENSKA') +vacuum test +select * from test + t +-------------------------------------- + ENGLISH + FRANAIS + ESPAOL + SLENSKA + ENGLISH FRANAIS ESPAOL SLENSKA (5 rows) -QUERY: select * from test where t = 'ESPAOL'; -t --------- -ESPAOL +select * from test where t = 'ESPAOL' + t +---------- + ESPAOL (1 row) -QUERY: select * from test where t ~* 'espaol'; -t ------------------------------------- -ESPAOL -ENGLISH FRANAIS ESPAOL SLENSKA +select * from test where t ~* 'espaol' + t +-------------------------------------- + ESPAOL + ENGLISH FRANAIS ESPAOL SLENSKA (2 rows) -QUERY: select *,character_length(t) from test; -t |length -------------------------------------+------ -ENGLISH | 7 -FRANAIS | 8 -ESPAOL | 7 -SLENSKA | 8 -ENGLISH FRANAIS ESPAOL SLENSKA| 33 +select *,character_length(t) from test + t | length +--------------------------------------+-------- + ENGLISH | 7 + FRANAIS | 8 + ESPAOL | 7 + SLENSKA | 8 + ENGLISH FRANAIS ESPAOL SLENSKA | 33 (5 rows) -QUERY: select *,octet_length(t) from test; -t |octet_length -------------------------------------+------------ -ENGLISH | 7 -FRANAIS | 9 -ESPAOL | 8 -SLENSKA | 9 -ENGLISH FRANAIS ESPAOL SLENSKA| 36 +select *,octet_length(t) from test + t | octet_length +--------------------------------------+-------------- + ENGLISH | 7 + FRANAIS | 9 + ESPAOL | 8 + SLENSKA | 9 + ENGLISH FRANAIS ESPAOL SLENSKA | 36 (5 rows) -QUERY: select *,position('L' in t) from test; -t |strpos -------------------------------------+------ -ENGLISH | 4 -FRANAIS | 0 -ESPAOL | 7 -SLENSKA | 3 -ENGLISH FRANAIS ESPAOL SLENSKA| 4 +select *,position('L' in t) from test + t | strpos +--------------------------------------+-------- + ENGLISH | 4 + FRANAIS | 0 + ESPAOL | 7 + SLENSKA | 3 + ENGLISH FRANAIS ESPAOL SLENSKA | 4 (5 rows) -QUERY: select *,substring(t from 3 for 4) from test; -t |substr -------------------------------------+------ -ENGLISH |GLIS -FRANAIS |ANA -ESPAOL |PAO -SLENSKA |LENS -ENGLISH FRANAIS ESPAOL SLENSKA|GLIS +select *,substring(t from 3 for 4) from test + t | substr +--------------------------------------+-------- + ENGLISH | GLIS + FRANAIS | ANA + ESPAOL | PAO + SLENSKA | LENS + ENGLISH FRANAIS ESPAOL SLENSKA | GLIS (5 rows) |