Bug #93312 insert ignore into
Submitted: 23 Nov 2018 10:57
Reporter: rainyday rainy Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server Severity:S6 (Debug Builds)
Version:5.7.19-log OS:CentOS
Assigned to: 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