Ticket #7764 (new defect)
Opened 2 months ago
Error when sorting report's result
| Reported by: | hanka | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | report system | Version: | |
| Severity: | normal | Keywords: | |
| Cc: |
Description
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
Attachments
Note: See
TracTickets for help on using
tickets.


