Hi,

Running the following simple query :

select tsp

from F33S13

group by tsp

order by CASE WHEN tsp IS NULL THEN 1 ELSE 0 END, tsp ASC

... gives the issue : org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryResolverException: TEIID30088 Unrelated order by column CASE WHEN tsp IS NULL THEN 1 ELSE 0 END cannot be used in a SET query, with SELECT DISTINCT, or GROUP BY

This is a simple query generated by a rolap engine to create/populate a timestamp dimension (tsp = yyyy-Q).

I'm afraid of a "dialect" issue : Teiid not fully supporting the case when inside an order by.

Anyone to confirm or deny this idea ?

Many thanks

Vincent