From 315b7d89eb4817d9f60cb7d2496a979af3ef26f0 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 21 Oct 2004 19:52:55 +0500 Subject: A fix (bug #6138: MOD operator should not round non-integral argument). --- mysql-test/r/func_test.result | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'mysql-test/r/func_test.result') diff --git a/mysql-test/r/func_test.result b/mysql-test/r/func_test.result index c3fe1de15db..8a28312b348 100644 --- a/mysql-test/r/func_test.result +++ b/mysql-test/r/func_test.result @@ -174,3 +174,12 @@ SELECT GREATEST(d,d) FROM t1 WHERE k=2; GREATEST(d,d) NULL DROP TABLE t1; +select 1197.90 mod 50; +1197.90 mod 50 +47.90 +select 5.1 mod 3, 5.1 mod -3, -5.1 mod 3, -5.1 mod -3; +5.1 mod 3 5.1 mod -3 -5.1 mod 3 -5.1 mod -3 +2.1 2.1 -2.1 -2.1 +select 5 mod 3, 5 mod -3, -5 mod 3, -5 mod -3; +5 mod 3 5 mod -3 -5 mod 3 -5 mod -3 +2 2 -2 -2 -- cgit v1.2.1