| From: | pgsql-bugs(at)postgresql(dot)org |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | LIKE 'bla%' |
| Date: | 2000-09-02 09:18:18 |
| Message-ID: | 200009020918.e829IIh55600@hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Henrik Steffen (steffen(at)city-map(dot)de) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
LIKE 'bla%'
Long Description
I just wanted to delete a record from a table, using
DELETE FROM MYTABLE WHERE NAME LIKE 'Ant%';
knowing that there existed only one record with 'Anton' as name.
However, the code above delivered 'DELETE 0'
Then I did this:
DELETE FROM MYTABLE WHERE NAME LIKE 'Anto%';
which gave 'DELETE 1'
Isn't this strange?
Sample Code
DELETE FROM MYTABLE WHERE NAME LIKE 'Ant%';
<=>
DELETE FROM MYTABLE WHERE NAME LIKE 'Anto%';
No file was uploaded with this report
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pgsql-bugs | 2000-09-02 16:08:55 | PG still fussy to compile on Solaris + GCC, may still need Sun ld |
| Previous Message | Richard Ellis | 2000-09-02 06:04:33 | Possible bug in referential integrity system |