Ticket #501 (new defect)

Opened 5 months ago

Revision 1733 - merge from trunk to postgresql breaks Delete items on postgres

Reported by: reporter Assigned to: 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