modules/sql-engine/src/integrationTest/sql/group1/function/numeric/test_mod.test

# name: test/sql/function/numeric/test_mod.test
# description: Mod test
# group: [numeric]

statement ok
CREATE TABLE modme(a DOUBLE, b INTEGER)

statement ok
INSERT INTO modme VALUES (42.123456, 3)

query R
select CAST(mod(a, 40) AS FLOAT) from modme
----
2.123456

query R
select CAST(mod(a, 2) AS FLOAT) from modme
----
0.123456

query R
select CAST(mod(b, 2.1) AS FLOAT) from modme
----
0.900000

query T
select MOD(1, null)
----
NULL

query T
select MOD(null, 1)
----
NULL