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
• Status: Verified
• Category: MySQL Server: C API (client library)
• Severity: S4 (Feature request)
• Version: 5.0.67-log
• OS: Linux
• CPU Architecture: Any
• Tags: insert, mysql_info

[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.