diff options
Diffstat (limited to 'mysql-test/r/selectivity.result')
| -rw-r--r-- | mysql-test/r/selectivity.result | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/mysql-test/r/selectivity.result b/mysql-test/r/selectivity.result index 64199f983ee..a77c74a3a60 100644 --- a/mysql-test/r/selectivity.result +++ b/mysql-test/r/selectivity.result @@ -1520,7 +1520,10 @@ set use_stat_tables='preferably'; set optimizer_use_condition_selectivity=4; set HISTOGRAM_SIZE = 255; CREATE TABLE t1 (t TIME, d DATE NOT NULL); -INSERT INTO t1 VALUES ('10:00:00', '0000-00-00'),('11:00:00','0000-00-00'); +INSERT IGNORE INTO t1 VALUES ('10:00:00', '0000-00-00'),('11:00:00','0000-00-00'); +Warnings: +Warning 1264 Out of range value for column 'd' at row 1 +Warning 1264 Out of range value for column 'd' at row 2 ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status Engine-independent statistics collected |