Edgewall Software

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

Add/Change #7764 (Error when sorting report's result)

Author



Change Properties
<Author field>
Action
as new
as The resolution will be set. Next status will be 'closed'
to The owner will change from (none). Next status will be 'new'
The owner will change from (none) to anonymous. Next status will be 'assigned'
 
Note: See TracTickets for help on using tickets.