diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2020-01-20 16:48:56 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2020-01-20 16:48:56 +0200 |
| commit | ded128aa9b3d40775e626a08a744a93d9ba71b01 (patch) | |
| tree | 2abae3ef8fd5438fc99d269b47d645faec3cb8e8 /mysql-test/main/func_math.test | |
| parent | 64952203af161c6e72744b6a2fb8e0f5274ea4d6 (diff) | |
| parent | 259185764ba949bbe0cfa6bbef4673f61155cb90 (diff) | |
| download | mariadb-git-ded128aa9b3d40775e626a08a744a93d9ba71b01.tar.gz | |
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/main/func_math.test')
| -rw-r--r-- | mysql-test/main/func_math.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/main/func_math.test b/mysql-test/main/func_math.test index ad2929888fc..1c360f7c3c0 100644 --- a/mysql-test/main/func_math.test +++ b/mysql-test/main/func_math.test @@ -1733,6 +1733,13 @@ SELECT HEX(c1) FROM t2; SHOW CREATE TABLE t2; DROP TABLE t1,t2; +CREATE OR REPLACE TABLE t1 (f float); +INSERT INTO t1 VALUES (3e38), (-3e38), (0), (12.34), (-12.34); +CREATE OR REPLACE TABLE t2 AS SELECT FORMAT(f,0) FROM t1; +SELECT * FROM t2; +SHOW CREATE TABLE t2; +DROP TABLE t1,t2; + --echo # --echo # End of 10.4 tests --echo # |