diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-09-17 11:05:07 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-09-17 11:05:07 +0400 |
| commit | d9b25ae3db8584bde809c0ab3230cbe151fa489b (patch) | |
| tree | cb0ae8c91d4f1bcd614c3c1b2d7847f3ef7a130f /mysql-test/suite/maria | |
| parent | c69cf93bfb3a221d9106f3695aa16e11f7e8b7fb (diff) | |
| download | mariadb-git-d9b25ae3db8584bde809c0ab3230cbe151fa489b.tar.gz | |
MDEV-8466 CAST works differently for DECIMAL/INT vs DOUBLE for empty strings
MDEV-8468 CAST and INSERT work differently for DECIMAL/INT vs DOUBLE for a string with trailing spaces
Diffstat (limited to 'mysql-test/suite/maria')
| -rw-r--r-- | mysql-test/suite/maria/maria2.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/maria2.result b/mysql-test/suite/maria/maria2.result index a0ec440b662..b4b27512054 100644 --- a/mysql-test/suite/maria/maria2.result +++ b/mysql-test/suite/maria/maria2.result @@ -46,12 +46,22 @@ drop table t1; create table t1 (pk int primary key, apk int unique, data int) engine=aria; insert into t1 values (1, 1, 1), (4, 4, 4), (6, 6, 6); load data concurrent infile '../../std_data/loaddata5.dat' replace into table t1 fields terminated by '' enclosed by '' ignore 1 lines (pk, apk); +Warnings: +Note 1265 Data truncated for column 'pk' at row 1 +Note 1265 Data truncated for column 'apk' at row 1 +Note 1265 Data truncated for column 'pk' at row 2 +Note 1265 Data truncated for column 'apk' at row 2 select * from t1 order by pk; pk apk data 1 1 1 3 4 NULL 5 6 NULL load data infile '../../std_data/loaddata5.dat' replace into table t1 fields terminated by '' enclosed by '' ignore 1 lines (pk, apk); +Warnings: +Note 1265 Data truncated for column 'pk' at row 1 +Note 1265 Data truncated for column 'apk' at row 1 +Note 1265 Data truncated for column 'pk' at row 2 +Note 1265 Data truncated for column 'apk' at row 2 select * from t1 order by pk; pk apk data 1 1 1 |