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

Commit6095e36

Browse files
committed
Prepare for new psql
1 parent1cd4c14 commit6095e36

File tree

1 file changed

+64
-64
lines changed

1 file changed

+64
-64
lines changed

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

Lines changed: 64 additions & 64 deletions
Original file line numberDiff line numberDiff line change
@@ -1,87 +1,87 @@
1-
QUERY:drop table �׻����Ѹ�;
1+
drop table �׻����Ѹ�;
22
ERROR: Relation '�׻����Ѹ�' does not exist
3-
QUERY:create table �׻����Ѹ� (�Ѹ� text, ʬ�ॳ���� varchar, ����1A���� char(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-
�Ѹ�|ʬ�ॳ����|����1a����
12-
--------------------------+----------+----------
13-
����ԥ塼���ǥ����ץ쥤|��A01��|
14-
����ԥ塼������ե��å���|ʬB10��|
15-
����ԥ塼���ץ�����ޡ�|��Z01��|
3+
create table �׻����Ѹ� (�Ѹ� text, ʬ�ॳ���� varchar, ����1A���� char(16));
4+
create index �׻����Ѹ�index1 on �׻����Ѹ� using btree (�Ѹ�);
5+
create index �׻����Ѹ�index2 on �׻����Ѹ� using hash (ʬ�ॳ����);
6+
insert into �׻����Ѹ� values('����ԥ塼���ǥ����ץ쥤','��A01��');
7+
insert into �׻����Ѹ� values('����ԥ塼������ե��å���','ʬB10��');
8+
insert into �׻����Ѹ� values('����ԥ塼���ץ�����ޡ�','��Z01��');
9+
vacuum �׻����Ѹ�;
10+
select * from �׻����Ѹ�;
11+
�Ѹ� |ʬ�ॳ���� |����1a����
12+
----------------------------+------------+------------
13+
����ԥ塼���ǥ����ץ쥤 |��A01�� |
14+
����ԥ塼������ե��å��� |ʬB10�� |
15+
����ԥ塼���ץ�����ޡ� |��Z01�� |
1616
(3 rows)
1717

18-
QUERY:select * from �׻����Ѹ� where ʬ�ॳ���� = '��Z01��';
19-
�Ѹ�|ʬ�ॳ����|����1a����
20-
------------------------+----------+----------
21-
����ԥ塼���ץ�����ޡ�|��Z01��|
18+
select * from �׻����Ѹ� where ʬ�ॳ���� = '��Z01��';
19+
�Ѹ� |ʬ�ॳ���� |����1a����
20+
--------------------------+------------+------------
21+
����ԥ塼���ץ�����ޡ� |��Z01�� |
2222
(1 row)
2323

24-
QUERY:select * from �׻����Ѹ� where ʬ�ॳ���� ~* '��z01��';
25-
�Ѹ�|ʬ�ॳ����|����1a����
26-
------------------------+----------+----------
27-
����ԥ塼���ץ�����ޡ�|��Z01��|
24+
select * from �׻����Ѹ� where ʬ�ॳ���� ~* '��z01��';
25+
�Ѹ� |ʬ�ॳ���� |����1a����
26+
--------------------------+------------+------------
27+
����ԥ塼���ץ�����ޡ� |��Z01�� |
2828
(1 row)
2929

30-
QUERY:select * from �׻����Ѹ� where ʬ�ॳ���� like '_Z01_';
31-
�Ѹ�|ʬ�ॳ����|����1a����
32-
------------------------+----------+----------
33-
����ԥ塼���ץ�����ޡ�|��Z01��|
30+
select * from �׻����Ѹ� where ʬ�ॳ���� like '_Z01_';
31+
�Ѹ� |ʬ�ॳ���� |����1a����
32+
--------------------------+------------+------------
33+
����ԥ塼���ץ�����ޡ� |��Z01�� |
3434
(1 row)
3535

36-
QUERY:select * from �׻����Ѹ� where ʬ�ॳ���� like '_Z%';
37-
�Ѹ�|ʬ�ॳ����|����1a����
38-
------------------------+----------+----------
39-
����ԥ塼���ץ�����ޡ�|��Z01��|
36+
select * from �׻����Ѹ� where ʬ�ॳ���� like '_Z%';
37+
�Ѹ� |ʬ�ॳ���� |����1a����
38+
--------------------------+------------+------------
39+
����ԥ塼���ץ�����ޡ� |��Z01�� |
4040
(1 row)
4141

42-
QUERY:select * from �׻����Ѹ� where �Ѹ� ~ '����ԥ塼��[�ǥ�]';
43-
�Ѹ�|ʬ�ॳ����|����1a����
44-
--------------------------+----------+----------
45-
����ԥ塼���ǥ����ץ쥤|��A01��|
46-
����ԥ塼������ե��å���|ʬB10��|
42+
select * from �׻����Ѹ� where �Ѹ� ~ '����ԥ塼��[�ǥ�]';
43+
�Ѹ� |ʬ�ॳ���� |����1a����
44+
----------------------------+------------+------------
45+
����ԥ塼���ǥ����ץ쥤 |��A01�� |
46+
����ԥ塼������ե��å��� |ʬB10�� |
4747
(2 rows)
4848

49-
QUERY:select * from �׻����Ѹ� where �Ѹ� ~* '����ԥ塼��[�ǥ�]';
50-
�Ѹ�|ʬ�ॳ����|����1a����
51-
--------------------------+----------+----------
52-
����ԥ塼���ǥ����ץ쥤|��A01��|
53-
����ԥ塼������ե��å���|ʬB10��|
49+
select * from �׻����Ѹ� where �Ѹ� ~* '����ԥ塼��[�ǥ�]';
50+
�Ѹ� |ʬ�ॳ���� |����1a����
51+
----------------------------+------------+------------
52+
����ԥ塼���ǥ����ץ쥤 |��A01�� |
53+
����ԥ塼������ե��å��� |ʬB10�� |
5454
(2 rows)
5555

56-
QUERY:select *,character_length(�Ѹ�) from �׻����Ѹ�;
57-
�Ѹ�|ʬ�ॳ����|����1a����|length
58-
--------------------------+----------+----------+------
59-
����ԥ塼���ǥ����ץ쥤|��A01�� || 12
60-
����ԥ塼������ե��å���|ʬB10�� || 13
61-
����ԥ塼���ץ�����ޡ�|��Z01�� || 12
56+
select *,character_length(�Ѹ�) from �׻����Ѹ�;
57+
�Ѹ� |ʬ�ॳ���� |����1a���� |length
58+
----------------------------+------------+------------+--------
59+
����ԥ塼���ǥ����ץ쥤 |��A01��| | 12
60+
����ԥ塼������ե��å��� |ʬB10��| | 13
61+
����ԥ塼���ץ�����ޡ� |��Z01��| | 12
6262
(3 rows)
6363

64-
QUERY:select *,octet_length(�Ѹ�) from �׻����Ѹ�;
65-
�Ѹ�|ʬ�ॳ����|����1a����|octet_length
66-
--------------------------+----------+----------+------------
67-
����ԥ塼���ǥ����ץ쥤|��A01�� || 24
68-
����ԥ塼������ե��å���|ʬB10�� || 26
69-
����ԥ塼���ץ�����ޡ�|��Z01�� || 24
64+
select *,octet_length(�Ѹ�) from �׻����Ѹ�;
65+
�Ѹ� |ʬ�ॳ���� |����1a���� |octet_length
66+
----------------------------+------------+------------+--------------
67+
����ԥ塼���ǥ����ץ쥤 |��A01��| | 24
68+
����ԥ塼������ե��å��� |ʬB10��| | 26
69+
����ԥ塼���ץ�����ޡ� |��Z01��| | 24
7070
(3 rows)
7171

72-
QUERY:select *,position('��' in �Ѹ�) from �׻����Ѹ�;
73-
�Ѹ�|ʬ�ॳ����|����1a����|strpos
74-
--------------------------+----------+----------+------
75-
����ԥ塼���ǥ����ץ쥤|��A01�� || 7
76-
����ԥ塼������ե��å���|ʬB10�� || 0
77-
����ԥ塼���ץ�����ޡ�|��Z01�� || 0
72+
select *,position('��' in �Ѹ�) from �׻����Ѹ�;
73+
�Ѹ� |ʬ�ॳ���� |����1a���� |strpos
74+
----------------------------+------------+------------+--------
75+
����ԥ塼���ǥ����ץ쥤 |��A01��| | 7
76+
����ԥ塼������ե��å��� |ʬB10��| | 0
77+
����ԥ塼���ץ�����ޡ� |��Z01��| | 0
7878
(3 rows)
7979

80-
QUERY:select *,substring(�Ѹ� from 10 for 4) from �׻����Ѹ�;
81-
�Ѹ�|ʬ�ॳ����|����1a����|substr
82-
--------------------------+----------+----------+--------
83-
����ԥ塼���ǥ����ץ쥤|��A01�� ||�ץ쥤
84-
����ԥ塼������ե��å���|ʬB10�� ||���å���
85-
����ԥ塼���ץ�����ޡ�|��Z01�� ||��ޡ�
80+
select *,substring(�Ѹ� from 10 for 4) from �׻����Ѹ�;
81+
�Ѹ� |ʬ�ॳ���� |����1a���� |substr
82+
----------------------------+------------+------------+----------
83+
����ԥ塼���ǥ����ץ쥤 |��A01��| |�ץ쥤
84+
����ԥ塼������ե��å��� |ʬB10��| |���å���
85+
����ԥ塼���ץ�����ޡ� |��Z01��| |��ޡ�
8686
(3 rows)
8787

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp