============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Vladimir Dobrokhotov
Your email address : root@dvs.rybvod.kamchatka.su
Category : runtime: back-end: SQL
Severity : critical
Summary: 'LIKE' does not work
System Configuration
- --------------------
Operating System : FreeBSD 2.2.5
PostgreSQL version : 6.4
Compiler used : gcc 2.7.2.1
Hardware:
- ---------
Pentium 133Mhz, 64M RAM.
Versions of other tools:
- ------------------------
gmake 3.75, flex 2.5.4
- --------------------------------------------------------------------------
Problem Description:
- --------------------
select .. from .. where Text_Field like 'xx%' work only if
Text_Field = 'xx', but in version 6.1 all work right.
- --------------------------------------------------------------------------
Test Case:
- ----------
create table tst ( a text);
insert into tst values ('abcd');
select * from tst where a like 'abc%';
- -- 0 rows
select * from tst where a like 'abc_';
- -- 0 rows
select * from tst where a like 'abcd%';
- -- 1 row
- --------------------------------------------------------------------------
Solution:
- ---------
- --------------------------------------------------------------------------
