From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | LIKE(~~) OR regular pattern(~) deliver incomplete output |
Date: | 2000-11-02 12:21:56 |
Message-ID: | 200011021221.eA2CLuq48614@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
ernst reeh (ernst(dot)reeh(at)dfg(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2000-11-02 12:32:27 | version info to bug#94 (LIKE(~~) ...) |
Previous Message | Jan Thomae | 2000-11-02 10:56:06 | My Bug report: JDBC-Driver produces wrong output. |