MySQL Forums
Forum List  »  MySQL Query Browser

bug? table editor apply changes crashes.
Posted by: Kenneth Wagner
Date: October 04, 2005 04:07PM

Hi All:

Using Browser v. 1.1.15, Windows XP Pro, MySQL 4.1.11-nt.

When setting the default value in the table editor of a TIMESTAMP field to CURRENT_TIMESTAMP, the table editor then generates the alter table command with this error: ...default 'CURRENT_TIMESTAMP'....

There should be NO quotes on either side of CURRENT_TIMESTAMP.

If I copy the alter statement display when it shows after selecting "Apply Changes" and then paste it as a query and remove the quotes on either side of CURRENT_TIMESTAMP the command works correctly.

It also displays correctly in the table editor when next opened and viewing the change. The default textfield shows CURRENT_TIMESTAMP. However, it the field is edited we are back to the the quote error.

Bug, yes??

Thanks,

Ken Wagner

Options: ReplyQuote


Subject
Written By
Posted
bug? table editor apply changes crashes.
October 04, 2005 04:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.