[CALCITE-3370] Emulate NULL direction for MSSQL

• Type: Task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Justin Swett
• Created: 24/Sep/19 21:18
• Updated: 06/Mar/20 04:34
• Resolved: 25/Sep/19 04:03

Description

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]"

Issue Links

• links to: GitHub Pull Request #1474