BUG #3438: Problem selecting backslash from a byte array

Поиск
Список
Период
Сортировка
От radoslav hodnicak
Тема BUG #3438: Problem selecting backslash from a byte array
Дата
Msg-id 200707111557.l6BFvpJD051057@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #3438: Problem selecting backslash from a byte array  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: BUG #3438: Problem selecting backslash from a byte array  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      3438
Logged by:          radoslav hodnicak
Email address:      rh@4096.sk
PostgreSQL version: 8.2.4
Operating system:   Windows XP SP2
Description:        Problem selecting backslash from a byte array
Details:

I create a table with a byte array column and insert a row with the byte 92
into it (which is backslash). Then I want to select the row.

Steps to reproduce:

create table backslashtest (test bytea null);

insert into backslashtest values (E'\\134'::bytea);

select * from backslashtest where test like E'\\134'::bytea;

Result:
select returns no rows

Expected result:
select should return the row I've inserted

Other remarks:
select * from backslashtest where test like E'\\134\\134'::bytea;

does what I expected from the original select, but that's wrong because I
don't want two backslashes, only one

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Shuo Liu"
Дата:
Сообщение: exit code -1073741819
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: BUG #3438: Problem selecting backslash from a byte array