diff options
Diffstat (limited to 'mysql-test/r/xtradb_mrr.result')
-rw-r--r-- | mysql-test/r/xtradb_mrr.result | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/mysql-test/r/xtradb_mrr.result b/mysql-test/r/xtradb_mrr.result index db90ada8053..88e77d6add4 100644 --- a/mysql-test/r/xtradb_mrr.result +++ b/mysql-test/r/xtradb_mrr.result @@ -363,12 +363,17 @@ KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ) ENGINE=InnoDB; -INSERT INTO t1 VALUES +INSERT IGNORE INTO t1 VALUES (1,5,5,'2009-10-16','2009-10-16','09:28:15','09:28:15','2007-09-14 05:34:08','2007-09-14 05:34:08','qk','qk'), (2,6,6,'0000-00-00','0000-00-00','23:06:39','23:06:39','0000-00-00 00:00:00','0000-00-00 00:00:00','j','j'), (3,10,10,'2000-12-18','2000-12-18','22:16:19','22:16:19','2006-11-04 15:42:50','2006-11-04 15:42:50','aew','aew'), (4,0,0,'2001-09-18','2001-09-18','00:00:00','00:00:00','2004-03-23 13:23:35','2004-03-23 13:23:35',NULL,NULL), (5,6,6,'2007-08-16','2007-08-16','22:13:38','22:13:38','2004-08-19 11:01:28','2004-08-19 11:01:28','qu','qu'); +Warnings: +Warning 1264 Out of range value for column 'date_key' at row 2 +Warning 1264 Out of range value for column 'date_nokey' at row 2 +Warning 1264 Out of range value for column 'datetime_key' at row 2 +Warning 1264 Out of range value for column 'datetime_nokey' at row 2 select pk from t1 WHERE `varchar_key` > 'kr' group by pk; pk 1 @@ -782,7 +787,7 @@ INSERT INTO t1 VALUES ('MS','Microsoft'), ('IB','IBM- Inc.'), ('GO','Google Inc.'); -INSERT INTO t2 VALUES +INSERT IGNORE INTO t2 VALUES ('AB','Sweden'), ('JA','USA'), ('MS','United States of America'), |