src/test/mb/expected/sjis.out - master - githubmirror/postgres

src/test/mb/expected/sjis.out
90 строк4 KB
Robert Haas
Fix MB regression tests for WAL-logging of hash indexes.
15 мар 2017, 14:25
15 мар 2017, 14:25d8f356e
drop table �v�Z�@�p��;
create table �v�Z�@�p�� (�p�� text, ���ރR�[�h varchar, ���l1A���� char(16));
create index �v�Z�@�p��index1 on �v�Z�@�p�� using btree (�p��);
create index �v�Z�@�p��index2 on �v�Z�@�p�� using hash (���ރR�[�h);
insert into �v�Z�@�p�� values('�R���s���[�^�f�B�X�v���C','�@A01��');
insert into �v�Z�@�p�� values('�R���s���[�^�O���t�B�b�N�X','��B10��');
insert into �v�Z�@�p�� values('�R���s���[�^�v���O���}�[','�lZ01��');
vacuum �v�Z�@�p��;
select * from �v�Z�@�p��;
            �p��            | ���ރR�[�h | ���l1a���� 
----------------------------+------------+------------
 �R���s���[�^�f�B�X�v���C   | �@A01��    | 
 �R���s���[�^�O���t�B�b�N�X | ��B10��    | 
 �R���s���[�^�v���O���}�[   | �lZ01��    | 
(3 rows)

select * from �v�Z�@�p�� where ���ރR�[�h = '�lZ01��';
           �p��           | ���ރR�[�h | ���l1a���� 
--------------------------+------------+------------
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
(1 row)

select * from �v�Z�@�p�� where ���ރR�[�h ~* '�lz01��';
           �p��           | ���ރR�[�h | ���l1a���� 
--------------------------+------------+------------
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
(1 row)

select * from �v�Z�@�p�� where ���ރR�[�h like '_Z01_';
           �p��           | ���ރR�[�h | ���l1a���� 
--------------------------+------------+------------
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
(1 row)

select * from �v�Z�@�p�� where ���ރR�[�h like '_Z%';
           �p��           | ���ރR�[�h | ���l1a���� 
--------------------------+------------+------------
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
(1 row)

select * from �v�Z�@�p�� where �p�� ~ '�R���s���[�^[�f�O]';
            �p��            | ���ރR�[�h | ���l1a���� 
----------------------------+------------+------------
 �R���s���[�^�f�B�X�v���C   | �@A01��    | 
 �R���s���[�^�O���t�B�b�N�X | ��B10��    | 
(2 rows)

select * from �v�Z�@�p�� where �p�� ~* '�R���s���[�^[�f�O]';
            �p��            | ���ރR�[�h | ���l1a���� 
----------------------------+------------+------------
 �R���s���[�^�f�B�X�v���C   | �@A01��    | 
 �R���s���[�^�O���t�B�b�N�X | ��B10��    | 
(2 rows)

select *,character_length(�p��) from �v�Z�@�p��;
            �p��            | ���ރR�[�h | ���l1a���� | character_length 
----------------------------+------------+------------+------------------
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            |               12
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            |               13
 �R���s���[�^�v���O���}�[   | �lZ01��    |            |               12
(3 rows)

select *,octet_length(�p��) from �v�Z�@�p��;
            �p��            | ���ރR�[�h | ���l1a���� | octet_length 
----------------------------+------------+------------+--------------
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            |           24
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            |           26
 �R���s���[�^�v���O���}�[   | �lZ01��    |            |           24
(3 rows)

select *,position('�f' in �p��) from �v�Z�@�p��;
            �p��            | ���ރR�[�h | ���l1a���� | position 
----------------------------+------------+------------+----------
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            |        7
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            |        0
 �R���s���[�^�v���O���}�[   | �lZ01��    |            |        0
(3 rows)

select *,substring(�p�� from 10 for 4) from �v�Z�@�p��;
            �p��            | ���ރR�[�h | ���l1a���� | substring 
----------------------------+------------+------------+-----------
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            | �v���C
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            | �B�b�N�X
 �R���s���[�^�v���O���}�[   | �lZ01��    |            | ���}�[
(3 rows)

copy �v�Z�@�p�� to stdout;
�R���s���[�^�f�B�X�v���C	�@A01��	\N
�R���s���[�^�O���t�B�b�N�X	��B10��	\N
�R���s���[�^�v���O���}�[	�lZ01��	\N