mihaibudiu commented on code in PR #4653: URL: https://github.com/apache/calcite/pull/4653#discussion_r2578284660
########## core/src/test/resources/sql/misc.iq: ########## @@ -2467,10 +2477,62 @@ FROM "hr"."emps"; !ok -# [CALCITE-6566] JDBC adapter should generate PI function with parentheses in most dialects - !use scott-mysql +# [CALCITE-7270] Add support for a DIVIDE_0_NULL operator +select 5 / 0 as a; ++---+ +| A | ++---+ +| | ++---+ +(1 row) + +!ok + +# No NULL result produced for double division +select CAST(5 AS DOUBLE) / 0 as a; ++----------+ +| A | ++----------+ +| Infinity | ++----------+ +(1 row) + +!ok + +select 5 / 1 as a; ++---+ +| A | ++---+ +| 5 | ++---+ +(1 row) + +!ok + +# [CALCITE-7270] Add support for a DIVIDE_0_NULL operator +select 5 % 0 as a; Review Comment: Yes, this is how NULL is rendered -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
