Ticket #501 (new defect)
Opened 2 years ago
Revision 1733 - merge from trunk to postgresql breaks Delete items on postgres
| Reported by: | reporter | Owned by: | mbonetti |
|---|---|---|---|
| Priority: | normal | Milestone: | Gregarius 0.5.5 |
| Component: | BUGS | Version: | 0.5.5 |
| Severity: | major | Keywords: | pgsql |
| Cc: |
Description
Changeset 1733 brought with it changes to postgres from trunk. Since then, I'm unable to delete items from my database. I get the following error:
Failed to execute the SQL query select count(distinct(i.id)) as cnt from item i inner join channels c on c.id=i.cid where 1=1 and (case when i.pubdate is null then i.added else i.pubdate end) < '2008-01-10 23:26:02' and (unread & 2)=0 and not(unread & 16) and (unread & 1)=0 and (i.unread & 8)=0
Error ERROR: argument of NOT must be type boolean, not type integer : ERROR: argument of NOT must be type boolean, not type integer.
Looks like postgres doesn't like integer->boolean conversions
