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)
