diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-04-20 15:26:37 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-04-20 15:26:37 +0200 |
| commit | 8f1f869f68581238b7718169fd50e9d7b6c7f0a3 (patch) | |
| tree | 9506032f67d320f2f3ad79f83bb352f5da1f7e6e /mysql-test/t/func_math.test | |
| parent | b069d19284b70ead3ceb62618acdc8ef93a2703e (diff) | |
| download | mariadb-git-8f1f869f68581238b7718169fd50e9d7b6c7f0a3.tar.gz | |
another test case for ER_DATA_OUT_OF_RANGE on insert
tests it with a non-const table too
Diffstat (limited to 'mysql-test/t/func_math.test')
| -rw-r--r-- | mysql-test/t/func_math.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test index b843cf8c364..cd90184ebf5 100644 --- a/mysql-test/t/func_math.test +++ b/mysql-test/t/func_math.test @@ -484,6 +484,14 @@ SELECT -a FROM t1; --error ER_DATA_OUT_OF_RANGE SELECT -b FROM t1; +# try with two rows now +INSERT INTO t1 VALUES(0,0); + +--error ER_DATA_OUT_OF_RANGE +SELECT -a FROM t1; +--error ER_DATA_OUT_OF_RANGE +SELECT -b FROM t1; + DROP TABLE t1; # Decimal overflows |