diff options
| author | kaa@kaamos.(none) <> | 2008-02-20 00:33:43 +0300 |
|---|---|---|
| committer | kaa@kaamos.(none) <> | 2008-02-20 00:33:43 +0300 |
| commit | 8d222210c77ba9152e3ba35d937d9b08a8266295 (patch) | |
| tree | 5543a0d99f0ea26b6a31aabda1379272bf9395dd /mysql-test/r/strict.result | |
| parent | 947529acf3f802c23311d3c4bda74713e21a161e (diff) | |
| download | mariadb-git-8d222210c77ba9152e3ba35d937d9b08a8266295.tar.gz | |
Fix for bug #31236: Inconsistent division by zero behavior for
floating point numbers
Some math functions did not check if the result is a valid number
(i.e. neither of +-inf or nan).
Fixed by validating the result where necessary and returning NULL in
case of invalid result.
Diffstat (limited to 'mysql-test/r/strict.result')
| -rw-r--r-- | mysql-test/r/strict.result | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/mysql-test/r/strict.result b/mysql-test/r/strict.result index cc1a2535896..a257d0a8648 100644 --- a/mysql-test/r/strict.result +++ b/mysql-test/r/strict.result @@ -895,7 +895,6 @@ ERROR 22003: Out of range value for column 'col1' at row 1 INSERT INTO t1 (col2) VALUES ('-1.2E-3'); ERROR 22003: Out of range value for column 'col2' at row 1 UPDATE t1 SET col1 =col1 * 5000 WHERE col1 > 0; -ERROR 22003: Out of range value for column 'col1' at row 3 UPDATE t1 SET col2 =col2 / 0 WHERE col2 > 0; ERROR 22012: Division by 0 UPDATE t1 SET col2= MOD(col2,0) WHERE col2 > 0; @@ -923,10 +922,10 @@ SELECT * FROM t1; col1 col2 -2.2e-307 0 1e-303 0 -1.7e+308 1.7e+308 +NULL 1.7e+308 -2.2e-307 0 -2e-307 0 -1.7e+308 1.7e+308 +NULL 1.7e+308 0 NULL 2 NULL NULL NULL |