diff options
Diffstat (limited to 'mysql-test/r/warnings.result')
-rw-r--r-- | mysql-test/r/warnings.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/warnings.result b/mysql-test/r/warnings.result index f2a105827da..c1f3041bf12 100644 --- a/mysql-test/r/warnings.result +++ b/mysql-test/r/warnings.result @@ -30,3 +30,27 @@ create table if not exists t1(id int); select @@warning_count; @@warning_count 0 +drop table t1; +create table t1(a tinyint, b int not null, c date, d char(5)); +load data infile '../../std_data/warnings_loaddata.dat' into table t1 fields terminated by ','; +Warnings: +Warning 1262 Data truncated, NULL supplied to NOT NULL column 'b' at row 2 +Warning 1261 Data truncated for column 'd' at row 3 +Warning 1261 Data truncated for column 'c' at row 4 +Warning 1259 Value count is fewer than the column count at row 5 +Warning 1261 Data truncated for column 'b' at row 6 +Warning 1260 Value count is more than the column count at row 7 +Warning 1261 Data truncated for column 'a' at row 8 +select @@warning_count; +@@warning_count +7 +show warnings; +Level Code Message +Warning 1262 Data truncated, NULL supplied to NOT NULL column 'b' at row 2 +Warning 1261 Data truncated for column 'd' at row 3 +Warning 1261 Data truncated for column 'c' at row 4 +Warning 1259 Value count is fewer than the column count at row 5 +Warning 1261 Data truncated for column 'b' at row 6 +Warning 1260 Value count is more than the column count at row 7 +Warning 1261 Data truncated for column 'a' at row 8 +drop table t1; |