Thread

LIKE(~~) OR regular pattern(~) deliver incomplete output

PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2000-11-02T12:21:56Z

ernst reeh (ernst.reeh@dfg.de) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
LIKE(~~) OR regular pattern(~) deliver incomplete output

Long Description
I work with POSTGRES version 6.4, so maybe the bug is already fixed. Please tell me if it's so. 

A search with LIKE(~~) or with regular patterns (~) won't give you all matching rows.
If the first missing letter is a 'y' or a 'z', you won't get this row.
(for example: you're searching for 'duftrei%'. You won't find 'duftreiz' or anything starting with 'duftreiz'. The same with 'duftrey'.)

I really hope, this bug is already fixed. 
Bye
Ernst

Sample Code
select * from flexwort;
flexseq      flex
1            duftreiz
2            duftreize
(2 rows)

select * from flexwort where flex ~~ 'duftrei%';
(0 rows)

select * from flexwort where flex ~ '^duftrei.*';
(0 rows)

select * from flexwort where flex ~~ 'duftre%';
flexseq      flex
1            duftreiz
2            duftreize
(2 rows)


No file was uploaded with this report