diff options
| author | monty@hundin.mysql.fi <> | 2002-05-31 15:22:38 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2002-05-31 15:22:38 +0300 |
| commit | e2a116411e7b293b5d0d920c8a94794dd75dd334 (patch) | |
| tree | 85c51f351e6086eebde739636a64e7ab09b85277 /mysql-test | |
| parent | a2ec51cec16205154aa2c7f5ecf6ec3c98a978e8 (diff) | |
| download | mariadb-git-e2a116411e7b293b5d0d920c8a94794dd75dd334.tar.gz | |
Portability fixes for SCO and HPUX
Change TRUNCATE(number) to truncate towards zero for negative numbers
Fix NULL handling for DESCRIBE table_name
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_math.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/func_math.test | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result index cee67a3e25c..e2723311682 100644 --- a/mysql-test/r/func_math.result +++ b/mysql-test/r/func_math.result @@ -2,8 +2,8 @@ floor(5.5) floor(-5.5) 5 -6 ceiling(5.5) ceiling(-5.5) 6 -5 -truncate(52.64,1) truncate(52.64,2) truncate(52.64,-1) truncate(52.64,-2) -52.6 52.64 50 0 +truncate(52.64,1) truncate(52.64,2) truncate(52.64,-1) truncate(52.64,-2) truncate(-52.64,1) truncate(-52.64,-1) +52.6 52.64 50 0 -52.6 -50 round(5.5) round(-5.5) 6 -6 round(5.64,1) round(5.64,2) round(5.64,-1) round(5.64,-2) diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test index ab7990eea79..5299897d0f0 100644 --- a/mysql-test/t/func_math.test +++ b/mysql-test/t/func_math.test @@ -4,7 +4,7 @@ select floor(5.5),floor(-5.5); select ceiling(5.5),ceiling(-5.5); -select truncate(52.64,1),truncate(52.64,2),truncate(52.64,-1),truncate(52.64,-2); +select truncate(52.64,1),truncate(52.64,2),truncate(52.64,-1),truncate(52.64,-2), truncate(-52.64,1),truncate(-52.64,-1); select round(5.5),round(-5.5); select round(5.64,1),round(5.64,2),round(5.64,-1),round(5.64,-2); select abs(-10), sign(-5), sign(5), sign(0); |