MySQL Bugs: #46390: Inserts doesn't show input field for TEXT datatypes

Bug #46390	Inserts doesn't show input field for TEXT datatypes
Submitted:	26 Jul 2009 18:16	Modified:	28 Aug 2009 9:28
Reporter:	Omer Sabic	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	5.1.16	OS:	Any (ubuntu 9.04, Windows XP)
Assigned to:	Sergei Tkachenko	CPU Architecture:	Any
Tags:	field, input, insert, problem, text

Description:
I have a column named "Value" of TEXT datatype. When I click the "Inserts" tab and then "Open editor", there isn't a input field for "Value" in the editor grid. If I insert data into all of the other fields (that are of other datatypes and work fine), this is what the editor saves:

INSERT INTO `entry_in_language` (`entry_id`, `language_code`, `timestamp`, `author_id`, `value`) VALUES (1, 'en', now(), 1, NULL);

To further add to the problem, when I press "Open editor" again and try to edit some fields, the last non-TEXT value disappears (in this case, 'author_id', just becomes a blank field).

There is no workaround that I know of, so I tagged this S1.

Kind regards.

How to repeat:
- create a table
- create a column INT
- create a column TEXT (or other TEXT variants)
- try to insert values with "Editor" under the "Inserts" tab

Screenshot

Attachment: wbproblem.png (image/png, text), 59.70 KiB.

Thank you for the bug report. Verified just as described on Windows XP. On this OS I can input data for TEXT column, but INSERTs generated are incorrect (values for TEXT column are NOT quoted). Moreover, when I open editor again value for the previous column (in the forst row at least) is indeed lost. TEXT column value with spaces is truncated to the first word etc. 

This is a serious bug, indeed.

I think, that delete part of inserted string after space is another bug so I try to create another bug report. (my version 5.2.2 alpha)

this was fixed and will be included in release 5.1.17

An entry was added to the 5.1.17 changelog:

The INSERT statements generated for columns of type TEXT by the Insert Editor were not correct, as the values were not quoted. Also, when the Insert Editor was closed and then reopened the last column entry was lost.