diff options
| author | Michael Widenius <monty@askmonty.org> | 2009-12-06 19:26:12 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2009-12-06 19:26:12 +0200 |
| commit | 17a7debbe3944da83d7b080846ed1748d5238640 (patch) | |
| tree | 0ac932d0e13df6f4112b8b10e3d957daf10f4e38 /mysql-test/t/warnings.test | |
| parent | d8e44ef589964a7afc28ffd7c1398be168a9d693 (diff) | |
| download | mariadb-git-17a7debbe3944da83d7b080846ed1748d5238640.tar.gz | |
Changed -1 row number in some warnings to 0
(-1 doesn't make sence as a row number and when doing insert / load data, first row is 1, so 0 is free to use)
mysql-test/r/warnings.result:
Added test for warnings with row number
mysql-test/suite/funcs_1/r/innodb_func_view.result:
Updated test results
mysql-test/suite/funcs_1/r/memory_func_view.result:
Updated test results
mysql-test/suite/funcs_1/r/myisam_func_view.result:
Updated test results
mysql-test/t/warnings.test:
Added test for warnings with row numberAdded test for warnings with row number
sql/my_decimal.cc:
Don't use -1 as row number
sql/share/errmsg.txt:
Make row numbers unsigned
Diffstat (limited to 'mysql-test/t/warnings.test')
| -rw-r--r-- | mysql-test/t/warnings.test | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/mysql-test/t/warnings.test b/mysql-test/t/warnings.test index 3c9129aedb1..508fc35d02c 100644 --- a/mysql-test/t/warnings.test +++ b/mysql-test/t/warnings.test @@ -194,7 +194,6 @@ DROP PROCEDURE sp1; DROP PROCEDURE sp2; DROP PROCEDURE sp3; - # # Bug#30059: End-space truncation warnings are inconsistent or incorrect # @@ -235,3 +234,15 @@ DROP TABLE t1; SHOW ERRORS; --echo End of 5.0 tests + +# +# Test warning with row numbers +# + +set sql_mode = default; +select CAST(a AS DECIMAL(13,5)) FROM (SELECT '' as a) t; +create table t1 (a integer unsigned); +insert into t1 values (1),(-1),(0),(-2); +drop table t1; + +--echo End of 5.1 tests |