Changes between Initial Version and Version 1 of Ticket #9311, comment 32
- Timestamp:
- Feb 8, 2014, 4:01:27 AM (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #9311, comment 32
initial v1 1 1 #11480 was closed as duplicated. 2 2 3 It would be simple to use `EXISTS (SELECT * FROM ticket_change ...)` rather than `DISTINCT ... LEFT JOIN ticket_change ...`. I verified with SQLite 3.3.6, PostgreSQL 8.1.23 and MySQL 5.0.95. 3 It would be simple to use `EXISTS (SELECT * FROM ticket_change ...)` rather than `DISTINCT ... LEFT JOIN ticket_change ...`. I verified with SQLite 3.3.6, PostgreSQL 8.1.23 and MySQL 5.0.95. If using MySQL, replace with `CAST(p.value AS signed)`. 4 4 {{{#!sql 5 5 SELECT p.value AS __color__,