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)