Justin Swett created CALCITE-3370: ------------------------------------- Summary: Emulate NULL direction for MSSQL Key: CALCITE-3370 URL: https://issues.apache.org/jira/browse/CALCITE-3370 Project: Calcite Issue Type: Task Reporter: Justin Swett
MSSQL cannot handle NULLS LAST/FIRST and should emulate the NULLS LAST/FIRST in order by, i.e. --for nulls last select [column] from [table] ORDER BY CASE WHEN [column] IS NULL THEN 1 ELSE 0 END, [column]" --for nulls first select [column] from [table] ORDER BY CASE WHEN [column] IS NULL THEN 0 ELSE 1 END, [column]" -- This message was sent by Atlassian Jira (v8.3.4#803005)