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/r/warnings.result | |
| 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/r/warnings.result')
| -rw-r--r-- | mysql-test/r/warnings.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/warnings.result b/mysql-test/r/warnings.result index 8a87852d582..6be5c9fb130 100644 --- a/mysql-test/r/warnings.result +++ b/mysql-test/r/warnings.result @@ -319,3 +319,17 @@ SHOW ERRORS; Level Code Message Error 1051 Unknown table 't1' End of 5.0 tests +set sql_mode = default; +select CAST(a AS DECIMAL(13,5)) FROM (SELECT '' as a) t; +CAST(a AS DECIMAL(13,5)) +0.00000 +Warnings: +Error 1366 Incorrect decimal value: '' for column '' at row 0 +Warning 1292 Truncated incorrect DECIMAL value: '' +create table t1 (a integer unsigned); +insert into t1 values (1),(-1),(0),(-2); +Warnings: +Warning 1264 Out of range value for column 'a' at row 2 +Warning 1264 Out of range value for column 'a' at row 4 +drop table t1; +End of 5.1 tests |