Incorrect (or at least nonportable) SQL in reports 6 and 7

[Dave Abrahams <dave@…>]

The variable $USER needs to be quoted, and at least on PostgreSQL, the "value" field of the priority enum needs to be cast to integer.

The enclosed patch fixes it but is also nonportable. It works for me, but it uses a PostgreSQL-specific cast syntax and I am too much of an SQL n00b to try with any confidence to get the portable syntax right. So please portable-ize it before you use it.

[Dave Abrahams <dave@…>]

Oh, also 'modified' ⇒ 'changetime'

[Dave Abrahams <dave@…>]

See #5543

[exp20070901trac@…]

The correct last line to the query is:

(CASE status WHEN 'closed' THEN changetime ELSE (-1)*CAST(p.value AS INT) END) DESC

I have tried to create an UPDATE query to correct the error and a correction to the db_default.py but haven't finished either.

[exp20070901trac@…]

Oh, I have not trouble with $USER..

[Christian Boos]

Let's try to fix all these issues at once, redirecting to #5543.