Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit2163d9e

Browse files
committed
Add missing mb files.
1 parenta7ad43c commit2163d9e

File tree

4 files changed

+210
-0
lines changed

4 files changed

+210
-0
lines changed

‎src/test/mb/expected/euc_tw.out

Lines changed: 85 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,85 @@
1+
QUERY: drop table ��ٸ����;
2+
ERROR: Relation ��ٸ���� Does Not Exist!
3+
QUERY: create table ��ٸ���� (����ɱ text, ��Ƴ��� varchar, ���� varchar(16));
4+
QUERY: create index ��ٸ����index1 on ��ٸ���� using btree (����ɱ);
5+
QUERY: create index ��ٸ����index2 on ��ٸ���� using hash (��Ƴ���);
6+
QUERY: insert into ��ٸ���� values ('�����', '������', 'ơA01��');
7+
QUERY: insert into ��ٸ���� values ('������', '����ȴ����Ƴ', '��B10��');
8+
QUERY: insert into ��ٸ���� values ('����', 'ӡ��ϴǹȴ����Ƴ', '��Z01Ħ');
9+
QUERY: vacuum ��ٸ����;
10+
QUERY: select * from ��ٸ����;
11+
����ɱ|��Ƴ��� |����
12+
------+----------------+-------
13+
�����|������ |ơA01��
14+
������|����ȴ����Ƴ |��B10��
15+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ
16+
(3 rows)
17+
18+
QUERY: select * from ��ٸ���� where ���� = '��Z01Ħ';
19+
����ɱ|��Ƴ��� |����
20+
------+----------------+-------
21+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ
22+
(1 row)
23+
24+
QUERY: select * from ��ٸ���� where ���� ~* '��z01Ħ';
25+
����ɱ|��Ƴ��� |����
26+
------+----------------+-------
27+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ
28+
(1 row)
29+
30+
QUERY: select * from ��ٸ���� where ���� like '_Z01_';
31+
����ɱ|��Ƴ��� |����
32+
------+----------------+-------
33+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ
34+
(1 row)
35+
36+
QUERY: select * from ��ٸ���� where ���� like '_Z%';
37+
����ɱ|��Ƴ��� |����
38+
------+----------------+-------
39+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ
40+
(1 row)
41+
42+
QUERY: select * from ��ٸ���� where ��Ƴ��� ~ '����[��ش��]';
43+
����ɱ|��Ƴ���|����
44+
------+--------+-------
45+
�����|������|ơA01��
46+
(1 row)
47+
48+
QUERY: select * from ��ٸ���� where ��Ƴ��� ~* '����[��ش��]';
49+
����ɱ|��Ƴ���|����
50+
------+--------+-------
51+
�����|������|ơA01��
52+
(1 row)
53+
54+
QUERY: select *, character_length(����ɱ) from ��ٸ����;
55+
����ɱ|��Ƴ��� |���� |length
56+
------+----------------+-------+------
57+
�����|������ |ơA01��| 3
58+
������|����ȴ����Ƴ |��B10��| 3
59+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ| 3
60+
(3 rows)
61+
62+
QUERY: select *, octet_length(����ɱ) from ��ٸ����;
63+
����ɱ|��Ƴ��� |���� |octet_length
64+
------+----------------+-------+------------
65+
�����|������ |ơA01��| 6
66+
������|����ȴ����Ƴ |��B10��| 6
67+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ| 6
68+
(3 rows)
69+
70+
QUERY: select *, position('ȴ��' in ��Ƴ���) from ��ٸ����;
71+
����ɱ|��Ƴ��� |���� |strpos
72+
------+----------------+-------+------
73+
�����|������ |ơA01��| 0
74+
������|����ȴ����Ƴ |��B10��| 3
75+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ| 5
76+
(3 rows)
77+
78+
QUERY: select *, substring(��Ƴ��� from 3 for 6 ) from ��ٸ����;
79+
����ɱ|��Ƴ��� |���� |substr
80+
------+----------------+-------+------------
81+
�����|������ |ơA01��|����
82+
������|����ȴ����Ƴ |��B10��|ȴ����Ƴ
83+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ|ϴǹȴ����Ƴ
84+
(3 rows)
85+

‎src/test/mb/sql/euc_tw.sql

Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
droptable 燹俑骜砧;
2+
create table 燹俑骜砧 (如淦杀text, 狞瞥婉螭varchar, 氢蛇varchar(16));
3+
create index 燹俑骜砧index1on 燹俑骜砧 using btree (如淦杀);
4+
create index 燹俑骜砧index2on 燹俑骜砧 using hash (狞瞥婉螭);
5+
insert into 燹俑骜砧values ('缳妾淦','绠绠绎世','啤A01念');
6+
insert into 燹俑骜砧values ('犒葸淦','芈溷却宇狞瞥','你B10你');
7+
insert into 燹俑骜砧values ('螫悖淦','印汤洗枪却宇狞瞥','仨Z01摩');
8+
vacuum 燹俑骜砧;
9+
select*from 燹俑骜砧;
10+
select*from 燹俑骜砧where 氢蛇='仨Z01摩';
11+
select*from 燹俑骜砧where 氢蛇 ~*'仨z01摩';
12+
select*from 燹俑骜砧where 氢蛇like'_Z01_';
13+
select*from 燹俑骜砧where 氢蛇like'_Z%';
14+
select*from 燹俑骜砧where 狞瞥婉螭 ~'绠绠绎[凫卮世]';
15+
select*from 燹俑骜砧where 狞瞥婉螭 ~*'绠绠绎[凫卮世]';
16+
17+
select*, character_length(如淦杀)from 燹俑骜砧;
18+
select*, octet_length(如淦杀)from 燹俑骜砧;
19+
select*, position('却宇'in 狞瞥婉螭)from 燹俑骜砧;
20+
select*,substring(狞瞥婉螭from3 for6 )from 燹俑骜砧;

‎src/test/regress/expected/euc_tw.out

Lines changed: 85 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,85 @@
1+
QUERY: drop table ��ٸ����;
2+
ERROR: Relation ��ٸ���� Does Not Exist!
3+
QUERY: create table ��ٸ���� (����ɱ text, ��Ƴ��� varchar, ���� varchar(16));
4+
QUERY: create index ��ٸ����index1 on ��ٸ���� using btree (����ɱ);
5+
QUERY: create index ��ٸ����index2 on ��ٸ���� using hash (��Ƴ���);
6+
QUERY: insert into ��ٸ���� values ('�����', '������', 'ơA01��');
7+
QUERY: insert into ��ٸ���� values ('������', '����ȴ����Ƴ', '��B10��');
8+
QUERY: insert into ��ٸ���� values ('����', 'ӡ��ϴǹȴ����Ƴ', '��Z01Ħ');
9+
QUERY: vacuum ��ٸ����;
10+
QUERY: select * from ��ٸ����;
11+
����ɱ|��Ƴ��� |����
12+
------+----------------+-------
13+
�����|������ |ơA01��
14+
������|����ȴ����Ƴ |��B10��
15+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ
16+
(3 rows)
17+
18+
QUERY: select * from ��ٸ���� where ���� = '��Z01Ħ';
19+
����ɱ|��Ƴ��� |����
20+
------+----------------+-------
21+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ
22+
(1 row)
23+
24+
QUERY: select * from ��ٸ���� where ���� ~* '��z01Ħ';
25+
����ɱ|��Ƴ��� |����
26+
------+----------------+-------
27+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ
28+
(1 row)
29+
30+
QUERY: select * from ��ٸ���� where ���� like '_Z01_';
31+
����ɱ|��Ƴ��� |����
32+
------+----------------+-------
33+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ
34+
(1 row)
35+
36+
QUERY: select * from ��ٸ���� where ���� like '_Z%';
37+
����ɱ|��Ƴ��� |����
38+
------+----------------+-------
39+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ
40+
(1 row)
41+
42+
QUERY: select * from ��ٸ���� where ��Ƴ��� ~ '����[��ش��]';
43+
����ɱ|��Ƴ���|����
44+
------+--------+-------
45+
�����|������|ơA01��
46+
(1 row)
47+
48+
QUERY: select * from ��ٸ���� where ��Ƴ��� ~* '����[��ش��]';
49+
����ɱ|��Ƴ���|����
50+
------+--------+-------
51+
�����|������|ơA01��
52+
(1 row)
53+
54+
QUERY: select *, character_length(����ɱ) from ��ٸ����;
55+
����ɱ|��Ƴ��� |���� |length
56+
------+----------------+-------+------
57+
�����|������ |ơA01��| 3
58+
������|����ȴ����Ƴ |��B10��| 3
59+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ| 3
60+
(3 rows)
61+
62+
QUERY: select *, octet_length(����ɱ) from ��ٸ����;
63+
����ɱ|��Ƴ��� |���� |octet_length
64+
------+----------------+-------+------------
65+
�����|������ |ơA01��| 6
66+
������|����ȴ����Ƴ |��B10��| 6
67+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ| 6
68+
(3 rows)
69+
70+
QUERY: select *, position('ȴ��' in ��Ƴ���) from ��ٸ����;
71+
����ɱ|��Ƴ��� |���� |strpos
72+
------+----------------+-------+------
73+
�����|������ |ơA01��| 0
74+
������|����ȴ����Ƴ |��B10��| 3
75+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ| 5
76+
(3 rows)
77+
78+
QUERY: select *, substring(��Ƴ��� from 3 for 6 ) from ��ٸ����;
79+
����ɱ|��Ƴ��� |���� |substr
80+
------+----------------+-------+------------
81+
�����|������ |ơA01��|����
82+
������|����ȴ����Ƴ |��B10��|ȴ����Ƴ
83+
����|ӡ��ϴǹȴ����Ƴ|��Z01Ħ|ϴǹȴ����Ƴ
84+
(3 rows)
85+

‎src/test/regress/sql/euc_tw.sql

Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
droptable 燹俑骜砧;
2+
create table 燹俑骜砧 (如淦杀text, 狞瞥婉螭varchar, 氢蛇varchar(16));
3+
create index 燹俑骜砧index1on 燹俑骜砧 using btree (如淦杀);
4+
create index 燹俑骜砧index2on 燹俑骜砧 using hash (狞瞥婉螭);
5+
insert into 燹俑骜砧values ('缳妾淦','绠绠绎世','啤A01念');
6+
insert into 燹俑骜砧values ('犒葸淦','芈溷却宇狞瞥','你B10你');
7+
insert into 燹俑骜砧values ('螫悖淦','印汤洗枪却宇狞瞥','仨Z01摩');
8+
vacuum 燹俑骜砧;
9+
select*from 燹俑骜砧;
10+
select*from 燹俑骜砧where 氢蛇='仨Z01摩';
11+
select*from 燹俑骜砧where 氢蛇 ~*'仨z01摩';
12+
select*from 燹俑骜砧where 氢蛇like'_Z01_';
13+
select*from 燹俑骜砧where 氢蛇like'_Z%';
14+
select*from 燹俑骜砧where 狞瞥婉螭 ~'绠绠绎[凫卮世]';
15+
select*from 燹俑骜砧where 狞瞥婉螭 ~*'绠绠绎[凫卮世]';
16+
17+
select*, character_length(如淦杀)from 燹俑骜砧;
18+
select*, octet_length(如淦杀)from 燹俑骜砧;
19+
select*, position('却宇'in 狞瞥婉螭)from 燹俑骜砧;
20+
select*,substring(狞瞥婉螭from3 for6 )from 燹俑骜砧;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp