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/r/func_math.result | |
| 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/r/func_math.result')
| -rw-r--r-- | mysql-test/r/func_math.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result index 3f8ab6c78d9..d122d435ac7 100644 --- a/mysql-test/r/func_math.result +++ b/mysql-test/r/func_math.result @@ -663,6 +663,11 @@ SELECT -a FROM t1; ERROR 22003: BIGINT value is out of range in '-(`test`.`t1`.`a`)' SELECT -b FROM t1; ERROR 22003: BIGINT value is out of range in '-(`test`.`t1`.`b`)' +INSERT INTO t1 VALUES(0,0); +SELECT -a FROM t1; +ERROR 22003: BIGINT value is out of range in '-(`test`.`t1`.`a`)' +SELECT -b FROM t1; +ERROR 22003: BIGINT value is out of range in '-(`test`.`t1`.`b`)' DROP TABLE t1; SET @a:=999999999999999999999999999999999999999999999999999999999999999999999999999999999; SELECT @a + @a; |