Bug #93312 insert ignore into

• Submitted: 23 Nov 2018 10:57
• Modified: 22 Oct 2019 11:02
• Reporter: rainyday rainy
• Status: Not a Bug
• Category: MySQL Server: DML
• Severity: S6 (Debug Builds)
• Version: 5.7.19-log
• OS: CentOS
• CPU Architecture: Any

[23 Nov 2018 10:57] rainyday rainy

Description:
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(0) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8

1、insert ignore into user(name) values('test') will insert success whithout name;

2、insert  into user(name) values('test'); Data too long for column 'name' at row 1

How to repeat:
insert  into user(name) values('test');

insert ignore into user(name) values('test')

Suggested fix:
as insert into :- Data too long for column 'name' at row 1

[22 Oct 2019 11:02] MySQL Verification Team

Hello rainyday rainy,

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at https://dev.mysql.com/doc/refman/5.7/en/insert.html and https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#ignore-strict-comparison

regards,
Umesh