Bug #385 Inserts through several gui interfaces broken
Submitted: 6 May 2003 15:04 Modified: 22 May 2003 10:53
Reporter: John Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:4.1 OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[6 May 2003 15:04] John
Seems that the new release will not allow a new record to be added with either the control center or mascon although each can on earlier releases.

How to repeat:
Create a table. Use a gui tool to add a record.

Suggested fix:
Sorry but I don't know.
[22 May 2003 10:53] MySQL Verification Team
I was be able for to insert rows using MySQLCC 0.9.2.
Please verify the users privileges.
[27 May 2003 8:12] John
I verified the permissions and I have full permission. I checked a bit more and it seems that the insert will actually work with MySQLCC 0.9.2 but it will say that it had an error when you look at the history. When I look at the structure of any of my tables using WinMySQLadmin the default values are showing the values for what should be the key values. So it seems that something has changed slightly when talking to the gui and when you try to add a record through it is seeing things such as MUL and PRI as default values for the data which would not be true if the default was supposed to be a number or NUL or some other assigned value.