[CALCITE-6633] Add CEILING to MSSQL dialect

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.38.0
• Fix Version/s: 1.39.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Sree Harsha Ramanavarapu
• Reporter: Sree Harsha Ramanavarapu
• Created: 6 days ago 15:32
• Updated: 5 days ago 22:27
• Resolved: 5 days ago 22:27

Description

    SELECT 1.24, FLOOR(1.24), CEIL(1.24) FROM (VALUES (0)) AS [t] ([ZERO])
    'CEIL' is not a recognized built-in function name.

The below test will fail because MSSQL support only 'CEILING'.  'CEIL' keyword is not supported.

@Test void testMSSQLCeiling() {
    final String query = "select 1.24, FLOOR(1.24), CEILING(1.24)";
    final String mssqlExpected = "SELECT 1.24, FLOOR(1.24), CEILING(1.24)\n" +
        "FROM (VALUES (0)) AS [t] ([ZERO])";

Issue Links

• links to: GitHub Pull Request #4008