diff options
| author | unknown <venu@myvenu.com> | 2003-04-22 00:54:33 -0700 |
|---|---|---|
| committer | unknown <venu@myvenu.com> | 2003-04-22 00:54:33 -0700 |
| commit | f4c3ed28393abfc2673258cc0079637b1bcf4894 (patch) | |
| tree | 74ad2583e2cd7e7fdedf1652384a62a8a0ee36b0 | |
| parent | 129f10e079f8e039d4168b8c7529cdbc290001cb (diff) | |
| download | mariadb-git-f4c3ed28393abfc2673258cc0079637b1bcf4894.tar.gz | |
update the test for LOAD DATA INFILE warnings
mysql-test/t/warnings.test:
update the test for LOAD DATA INFILE warnings
| -rw-r--r-- | mysql-test/r/warnings.result | 24 | ||||
| -rw-r--r-- | mysql-test/std_data/warnings_loaddata.dat | 8 | ||||
| -rw-r--r-- | mysql-test/t/warnings.test | 12 |
3 files changed, 44 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; diff --git a/mysql-test/std_data/warnings_loaddata.dat b/mysql-test/std_data/warnings_loaddata.dat new file mode 100644 index 00000000000..e645de775ab --- /dev/null +++ b/mysql-test/std_data/warnings_loaddata.dat @@ -0,0 +1,8 @@ +10,20,2003-04-21,mysql +20,\N,2003-04-22,MySQL +30,40,2003-04-23,MySQL is Open Source Database +40,50,monty,30 +50,60,2003-04-24 +60,67 abc,2003-04-25,mysql +70,80,2003-04-26,mysql,open,source +500,90,2003-04-27,mysql diff --git a/mysql-test/t/warnings.test b/mysql-test/t/warnings.test index 8cff8706c43..bfdbb8f025a 100644 --- a/mysql-test/t/warnings.test +++ b/mysql-test/t/warnings.test @@ -17,6 +17,7 @@ set SQL_WARNINGS=0; # # Test other warnings +# drop temporary table if exists not_exists; drop table if exists not_exists_table; @@ -26,3 +27,14 @@ show count(*) warnings; create table t1(id int); create table if not exists t1(id int); select @@warning_count; +drop table t1; + +# +# Test warnings for LOAD DATA INFILE +# + +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 ','; +select @@warning_count; +show warnings; +drop table t1; |