Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.31, 10.11.4
-
MySQL version: 10.11.4-MariaDB-1:10.11.4+maria~ubu2204 through PHP extension MySQLi
Description
The following INSERT IGNORE emits an error instead of a warning:
DROP TABLE IF EXISTS `my_table`;
CREATE TABLE `my_table` (
`first_col` char(63),
`second_col` char(63),
constraint `my_const` check (`first_col` != `second_col`)
);INSERT IGNORE INTO `my_table` VALUES ('a', 'a');
Attachments
Issue Links
- relates to
-
MDEV-31985 IGNORE in INSERT and LOAD are being ignored in InnoDB bulk insert
- Confirmed