Bug #41285 All insert commands could generate message for mysql_info()
Submitted: 6 Dec 2008 23:25 Modified: 22 Mar 2011 0:55
Reporter: Tomas Telensky Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: C API (client library) Severity:S4 (Feature request)
Version:5.0.67-log OS:Linux
Assigned to: CPU Architecture:Any
Tags: insert, mysql_info
Triage: Needs Triage: D5 (Feature request)

[6 Dec 2008 23:25] Tomas Telensky
Description:

Not all insert commands generate the info message that could be read with mysql_info(), as it is being said at http://dev.mysql.com/doc/refman/5.1/en/mysql-info.html ,

Currently this command generates the info message: insert into a (a) values(0), (0): "Records: 2  Duplicates: 0  Warnings: 0".

I wish also this INSERT command generated the info message: insert into a (a) values(0).

How to repeat:
drop table if exists a;
create table a (
        a int auto_increment primary key,
        b int not null
);
select * from a;
insert into a (a) values(0); /* mysql_info() message IS NOT generated */
insert into a (a) values(0), (0); /* mysql_info() message is generated: Records: 2  Duplicates: 0  Warnings: 0 */
[22 Mar 2011 0:55] Sveta Smirnova
Thank you for the feature request.