Sree Harsha Ramanavarapu created CALCITE-6633:
-------------------------------------------------
Summary: MSSQL Dialect does not generate CEILING function
Key: CALCITE-6633
URL: https://issues.apache.org/jira/browse/CALCITE-6633
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.38.0
Reporter: Sree Harsha Ramanavarapu
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 and CEIL.
@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])";
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
