MySQL Bugs: #9449: Warnings on insertion are inconsistent

Bug #9449	Warnings on insertion are inconsistent
Submitted:	29 Mar 2005 12:11	Modified:	29 Mar 2005 14:20
Reporter:	Marcus Bointon	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	4.1.10	OS:	Linux (RedHat Enterprise Linux 3)
Assigned to:		CPU Architecture:	Any

Description:
I've been writing a workaround for this bug:

http://bugs.mysql.com/bug.php?id=8684

To reiterate - I'm seeing some warnings reported when importing SQL dumps using the mysql client and there's no way of seeing what they are. I've now written a PHP script that takes these same dump files and issues the queries in them one at a time, and after _every_ query I issue a 'SHOW WARNINGS'. Now comes the weird bit: when I run my script, I get no warnings! I've tried introducing deliberate warning-generating statements to make sure my code is not at fault, and these work as expected. I can't provide you with examples because the queries that are passed through PHP don't generate any warnings, the same queries made through the mysql client do generate warnings, but I can't see them. There has to be a bug somewhere...

How to repeat:
I wish I could tell you why this happens - the very nature of the problem is that I can't find out what the problem is!

Suggested fix:
Fixing the original bug would help, but it seems that there is some internal inconsistency in what constitutes a warning as well, hence this additional bug report.

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.