-
Nisha Gopalakrishnan authored
THE SAME COLUMN. Analysis: -------- Creation of duplicate index is allowed since the logic to detect the duplicate index has not been implemented. Fix: --- A new member 'check_for_duplicate_indexes' has been added to struct KEY_CREATE_INFO. This member is set when a index is created or modified by the user. An SQL-condition of the NOTE level is reported upon execution of such a DDL statement if all the following conditions are satisfied: a) Index types[BTREE|HASH] are the same. b) Key constraint/indexes are the same. c) The constraint/indexes fields are in the same order. However this does not apply to the foreign key constraint. The SQL-condition is not propagated to the ERROR level under the STRICT mode, thus this patch does not introduce backward incompatible changes.
Nisha Gopalakrishnan authoredTHE SAME COLUMN. Analysis: -------- Creation of duplicate index is allowed since the logic to detect the duplicate index has not been implemented. Fix: --- A new member 'check_for_duplicate_indexes' has been added to struct KEY_CREATE_INFO. This member is set when a index is created or modified by the user. An SQL-condition of the NOTE level is reported upon execution of such a DDL statement if all the following conditions are satisfied: a) Index types[BTREE|HASH] are the same. b) Key constraint/indexes are the same. c) The constraint/indexes fields are in the same order. However this does not apply to the foreign key constraint. The SQL-condition is not propagated to the ERROR level under the STRICT mode, thus this patch does not introduce backward incompatible changes.
Loading