Julian Hyde created CALCITE-981:
-----------------------------------

             Summary: Push NULLS FIRST etc. down to JDBC adapter
                 Key: CALCITE-981
                 URL: https://issues.apache.org/jira/browse/CALCITE-981
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


If a JdbcSort has a RelFieldCollation.direction that is different from the JDBC 
source's default direction, we should generate NULLS FIRST or NULLS LAST.  

If the source does not support that syntax, devise something else; e.g. 
{code}ORDER BY ISNULL(x), x{code} in MySQL; see 
http://jira.pentaho.com/browse/MONDRIAN-226.

The dialect should know what each JDBC source's default direction is.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to