diff options
| author | venu@hundin.mysql.fi <> | 2003-07-21 19:37:18 +0300 |
|---|---|---|
| committer | venu@hundin.mysql.fi <> | 2003-07-21 19:37:18 +0300 |
| commit | 0440e70a96a774a1c484c49939e1b7ef1ab87df5 (patch) | |
| tree | 10619d7ae675b27c2d4e8ff5d2605c124694ab51 /mysql-test | |
| parent | bc7cf3033885e91812688a9c9248d8a7acdea211 (diff) | |
| download | mariadb-git-0440e70a96a774a1c484c49939e1b7ef1ab87df5.tar.gz | |
undo one row warning instead use sql_warnings=1
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/warnings.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/warnings.test | 3 |
2 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/warnings.result b/mysql-test/r/warnings.result index 4e526d85d90..0ad165a861a 100644 --- a/mysql-test/r/warnings.result +++ b/mysql-test/r/warnings.result @@ -91,8 +91,11 @@ Warning 1263 Data truncated for column 'b' at row 3 Warning 1261 Data truncated, NULL supplied to NOT NULL column 'a' at row 4 Warning 1263 Data truncated for column 'b' at row 4 insert into t2(b) values('mysqlab'); +set sql_warnings=1; +insert into t2(b) values('mysqlab'); Warnings: Warning 1263 Data truncated for column 'b' at row 1 +set sql_warnings=0; drop table t1, t2; create table t1(a char(10)); alter table t1 add b char; diff --git a/mysql-test/t/warnings.test b/mysql-test/t/warnings.test index 6991f9d9b2f..41aa02e925f 100644 --- a/mysql-test/t/warnings.test +++ b/mysql-test/t/warnings.test @@ -52,6 +52,9 @@ update t1 set d=c; create table t2(a tinyint NOT NULL, b char(3)); insert into t2 select b,c from t1; insert into t2(b) values('mysqlab'); +set sql_warnings=1; +insert into t2(b) values('mysqlab'); +set sql_warnings=0; drop table t1, t2; # |