[dev] Small gotchas wrt. Oracle and SQL syntax

Hi, Stumbled over some small gotchas regarding SQL syntax and Oracle 9 today. Here's the error message: ORA-00933: SQL command not properly ended (DBD ERROR: error possibly near <*> indicator at char 26 in 'SELECT st.id FROM ticket <*>as st WHERE st.ticket_state_id IN ( 7, 8 ) '), SQL: 'SELECT st.id FROM ticket as st WHERE st.ticket_state_id IN ( 7, 8 ) ' The problem is the "From column as foo" construct. The "as" in there is optional in PostgreSQL and MySQL (according to the web documentation), but not allowed in Oracle. So I removed them: Regards, -- Kristoffer.