diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-10-21 19:52:55 +0500 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-10-21 19:52:55 +0500 |
| commit | 315b7d89eb4817d9f60cb7d2496a979af3ef26f0 (patch) | |
| tree | 16440e561cf6e37c0650a9287e6f686ad1b2db64 /mysql-test/t/func_test.test | |
| parent | 0da47eae2491b53af11f0e06226de3d0052fc28a (diff) | |
| download | mariadb-git-315b7d89eb4817d9f60cb7d2496a979af3ef26f0.tar.gz | |
A fix (bug #6138: MOD operator should not round non-integral argument).
Diffstat (limited to 'mysql-test/t/func_test.test')
| -rw-r--r-- | mysql-test/t/func_test.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/func_test.test b/mysql-test/t/func_test.test index e7bcd81a15e..eb506a58870 100644 --- a/mysql-test/t/func_test.test +++ b/mysql-test/t/func_test.test @@ -94,3 +94,16 @@ CREATE TABLE t1 (d varchar(6), k int); INSERT INTO t1 VALUES (NULL, 2); SELECT GREATEST(d,d) FROM t1 WHERE k=2; DROP TABLE t1; + +# +# Bug #6138: mod and doubles +# + +select 1197.90 mod 50; +select 5.1 mod 3, 5.1 mod -3, -5.1 mod 3, -5.1 mod -3; + +# +# Test for mod and signed integers +# + +select 5 mod 3, 5 mod -3, -5 mod 3, -5 mod -3; |