MySQL Bugs: #8454: sql request on not null field gets error with no error information

Bug #8454	sql request on not null field gets error with no error information
Submitted:	11 Feb 2005 19:52	Modified:	11 Feb 2005 22:10
Reporter:	Matthias Glastra	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	3.51.09.00	OS:	Windows (Win XP)
Assigned to:		CPU Architecture:	Any

Description:
I was trying to run a sql statement on a database while one of the requested field was set on not null. But this field had a null value. This is possible a bug in MySql Query browser where I inserted the information.

But the ODBC object I used to execute my sql did not have error information on this topic. I wouldt be great if there was a error report.

How to repeat:
Create a table with a not null field. Then insert a record with a null value in the not null field. After that you execute a sql query on the table where you want to select the empty field. This gives a error.

Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.

I want to make a change in my bug report. This because I also have this problem on the latest version. Version 3.51.11. I hope you can re-open  this bug report and change the version info.