Error when sorting report's result

[hanka]

Im' using Trac 0.11.1 with postgres database. I've created SQL report:

select id as "Cool Ticket", owner, milestone from ticket where id<10

I receive error when trying to sort results by column Cool Ticket.

Report execution failed: syntax error at or near "Ticket" LINE 1: ...e from ticket where id<10 ) AS tab ORDER BY Cool Ticket ASC... ^

In log file of Trac I have found that following SQL is executed:

2008-10-29 15:40:03,775 Trac[report] DEBUG: Query SQL: SELECT * FROM ( select id as "Cool Ticket", owner, milestone from ticket where id<10 ) AS tab  ORDER B
Y Cool Ticket ASC LIMIT 100 OFFSET 0

[Christian Boos]

Milestone 1.0 deleted

[Remy Blank]

Right, the column names should be quoted. And we now have a nice quoting function, so this should be relatively easy.

[Remy Blank]

Easy indeed. Fixed in [9956].