Testcase:
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE innodb_default(
c36 TEXT, c46 DATE, c32 BLOB, c3 char, c24 INT unsigned not null,
c195 INT, c0 char, c44 TEXT, c40 TEXT, c48 DATE, c27 BLOB, c38 TEXT,
c4 char, c21 INT not null, c5 char, c39 TEXT, c198 INT unsigned,
c8 char, c19 char, c53 DATE not null, c190 INT, c6 char, c9 INT,
c193 INT unsigned, c35 BLOB not null, c192 INT unsigned, c28 BLOB,
c34 BLOB not null, c25 INT unsigned not null, c196 INT, c42 TEXT,
c52 DATE not null, c37 TEXT, c191 INT, c33 BLOB not null, c30 BLOB,
c7 char, c20 INT unsigned, c26 INT unsigned not null, c47 DATE,
c2 char, c199 INT unsigned, c51 DATE not null, c194 INT unsigned,
c29 BLOB, c49 DATE, c41 TEXT, c31 BLOB, c22 INT not null, c45 DATE,
c50 DATE, c43 TEXT, c23 INT not null, c197 INT, unique(c52),
key(c197)) ENGINE=innodb ROW_FORMAT=default;
INSERT INTO innodb_default VALUES
(0,1,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,6,0,0,0,0,0,0,0,0,0,1,0,0,0,0,5,0,0,1,0,0,0,1,0,0,0,0,1,0,0,-107);
SET SESSION EXPAND_FAST_INDEX_CREATION=ON;
CREATE TEMPORARY TABLE t LIKE innodb_default;
INSERT INTO t SELECT * FROM innodb_default;
ALTER TABLE t RENAME innodb_default;
REPLACE INTO innodb_default (c192) VALUES (0);
Results in:
2013-09-30 15:55:49 32238 [ERROR] Cannot find index c52 in InnoDB index translation table.
2013-09-30 15:55:49 32238 [Warning] InnoDB could not find index c52 key no 0 for table tmp/#sql7dee_1_1 through its index translation table
mysql> REPLACE INTO innodb_default (c192) VALUES (0);
Query OK, 2 rows affected, 12 warnings (0.00 sec)
mysql> show warnings;
+------
| Level | Code | Message |
+------
| Warning | 1364 | Field 'c24' doesn't have a default value |
| Warning | 1364 | Field 'c21' doesn't have a default value |
| Warning | 1364 | Field 'c53' doesn't have a default value |
| Warning | 1364 | Field 'c35' doesn't have a default value |
| Warning | 1364 | Field 'c34' doesn't have a default value |
| Warning | 1364 | Field 'c25' doesn't have a default value |
| Warning | 1364 | Field 'c52' doesn't have a default value |
| Warning | 1364 | Field 'c33' doesn't have a default value |
| Warning | 1364 | Field 'c26' doesn't have a default value |
| Warning | 1364 | Field 'c51' doesn't have a default value |
| Warning | 1364 | Field 'c22' doesn't have a default value |
| Warning | 1364 | Field 'c23' doesn't have a default value |
+------
12 rows in set (0.00 sec)