← Back to branch summary

~vcs-imports/mammoth-replicator/trunk

« back to all changes in this revision

Viewing changes to src/test/mb/expected/sjis.out

  • Committer: alvherre
  • Date: 2005-12-16 21:24:52 UTC
  • Revision ID: svn-v4:db760fc0-0f08-0410-9d63-cc6633f64896:trunk:1
Initial import of the REL8_0_3 sources from the Pgsql CVS repository.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/test/mb/expected/sjis.out
 
1
drop table �v�Z�@�p��;
 
2
create table �v�Z�@�p�� (�p�� text, ���ރR�[�h varchar, ���l1A���� char(16));
 
3
create index �v�Z�@�p��index1 on �v�Z�@�p�� using btree (�p��);
 
4
create index �v�Z�@�p��index2 on �v�Z�@�p�� using hash (���ރR�[�h);
 
5
insert into �v�Z�@�p�� values('�R���s���[�^�f�B�X�v���C','�@A01��');
 
6
insert into �v�Z�@�p�� values('�R���s���[�^�O���t�B�b�N�X','��B10��');
 
7
insert into �v�Z�@�p�� values('�R���s���[�^�v���O���}�[','�lZ01��');
 
8
vacuum �v�Z�@�p��;
 
9
select * from �v�Z�@�p��;
 
10
            �p��            | ���ރR�[�h | ���l1a���� 
 
11
----------------------------+------------+------------
 
12
 �R���s���[�^�f�B�X�v���C   | �@A01��    | 
 
13
 �R���s���[�^�O���t�B�b�N�X | ��B10��    | 
 
14
 �R���s���[�^�v���O���}�[   | �lZ01��    | 
 
15
(3 rows)
 
16
 
 
17
select * from �v�Z�@�p�� where ���ރR�[�h = '�lZ01��';
 
18
           �p��           | ���ރR�[�h | ���l1a���� 
 
19
--------------------------+------------+------------
 
20
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
 
21
(1 row)
 
22
 
 
23
select * from �v�Z�@�p�� where ���ރR�[�h ~* '�lz01��';
 
24
           �p��           | ���ރR�[�h | ���l1a���� 
 
25
--------------------------+------------+------------
 
26
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
 
27
(1 row)
 
28
 
 
29
select * from �v�Z�@�p�� where ���ރR�[�h like '_Z01_';
 
30
           �p��           | ���ރR�[�h | ���l1a���� 
 
31
--------------------------+------------+------------
 
32
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
 
33
(1 row)
 
34
 
 
35
select * from �v�Z�@�p�� where ���ރR�[�h like '_Z%';
 
36
           �p��           | ���ރR�[�h | ���l1a���� 
 
37
--------------------------+------------+------------
 
38
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
 
39
(1 row)
 
40
 
 
41
select * from �v�Z�@�p�� where �p�� ~ '�R���s���[�^[�f�O]';
 
42
            �p��            | ���ރR�[�h | ���l1a���� 
 
43
----------------------------+------------+------------
 
44
 �R���s���[�^�f�B�X�v���C   | �@A01��    | 
 
45
 �R���s���[�^�O���t�B�b�N�X | ��B10��    | 
 
46
(2 rows)
 
47
 
 
48
select * from �v�Z�@�p�� where �p�� ~* '�R���s���[�^[�f�O]';
 
49
            �p��            | ���ރR�[�h | ���l1a���� 
 
50
----------------------------+------------+------------
 
51
 �R���s���[�^�f�B�X�v���C   | �@A01��    | 
 
52
 �R���s���[�^�O���t�B�b�N�X | ��B10��    | 
 
53
(2 rows)
 
54
 
 
55
select *,character_length(�p��) from �v�Z�@�p��;
 
56
            �p��            | ���ރR�[�h | ���l1a���� | character_length 
 
57
----------------------------+------------+------------+------------------
 
58
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            |               12
 
59
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            |               13
 
60
 �R���s���[�^�v���O���}�[   | �lZ01��    |            |               12
 
61
(3 rows)
 
62
 
 
63
select *,octet_length(�p��) from �v�Z�@�p��;
 
64
            �p��            | ���ރR�[�h | ���l1a���� | octet_length 
 
65
----------------------------+------------+------------+--------------
 
66
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            |           24
 
67
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            |           26
 
68
 �R���s���[�^�v���O���}�[   | �lZ01��    |            |           24
 
69
(3 rows)
 
70
 
 
71
select *,position('�f' in �p��) from �v�Z�@�p��;
 
72
            �p��            | ���ރR�[�h | ���l1a���� | position 
 
73
----------------------------+------------+------------+----------
 
74
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            |        7
 
75
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            |        0
 
76
 �R���s���[�^�v���O���}�[   | �lZ01��    |            |        0
 
77
(3 rows)
 
78
 
 
79
select *,substring(�p�� from 10 for 4) from �v�Z�@�p��;
 
80
            �p��            | ���ރR�[�h | ���l1a���� | substring 
 
81
----------------------------+------------+------------+-----------
 
82
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            | �v���C
 
83
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            | �B�b�N�X
 
84
 �R���s���[�^�v���O���}�[   | �lZ01��    |            | ���}�[
 
85
(3 rows)
 
86
 
 
87
copy �v�Z�@�p�� to stdout;
 
88
�R���s���[�^�f�B�X�v���C        �@A01�� \N
 
89
�R���s���[�^�O���t�B�b�N�X      ��B10�� \N
 
90
�R���s���[�^�v���O���}�[        �lZ01�� \N