Hi When executing the query below, H2 raises an error: Order by expression "UCASE(COMPONENT.DESCRIPTION)" must be in the result list in this case;
SELECT DISTINCT COMPONENT.DESCRIPTION, COMPONENT.COMPONENT_EXECUTION FROM COMPONENT ORDER BY UCASE(COMPONENT.DESCRIPTION) The same query without 'DISTINCT' or a modified query that returns distinct records by means of GROUP BY (see below) works fine. SELECT COMPONENT.DESCRIPTION, COMPONENT.COMPONENT_EXECUTION FROM COMPONENT GROUP BY COMPONENT.DESCRIPTION, COMPONENT.COMPONENT_EXECUTION ORDER BY UCASE(COMPONENT.DESCRIPTION) What's the reason for this behaviour? Thanks, Remo -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
