Opened 13 years ago
Last modified 11 years ago
#8391 closed defect
SQL error when using PostgreSQL viewing /hours where no tickets exist — at Initial Version
Reported by: | Adam Piper | Owned by: | Ryan J Ollos |
---|---|---|---|
Priority: | high | Component: | TracHoursPlugin |
Severity: | normal | Keywords: | postgresql postgres sql syntax error |
Cc: | Trac Release: | 0.11 |
Description
While this works fine on SQLite the "WHERE ticket IN ()" is invalid for PostgreSQL. As such I have tweaked the code to merely return an empty list in this circumstance. See attached patch.
Note: See
TracTickets for help on using
tickets.
patch for early return where no ticket ID is provided