Enum select bug Ver 4.01

[rrkramer]

A table has an enum column, one of whose options is “”, as: ENUM(“”,”N”,”Y”) NOT NULL. Using the insert/update mode from the table context menu or via F11 works OK (except see below), in that the column selection pull down shows , (NULL), N and Y.

Using F8 with a query, though, the selection pull-down shows (NULL) and two blank lines. If the enum is ENUM(“N”,”Y”,””) NOT NULL then the “mess up” takes a different form (“n” and “y” are present but not the “”) when F8 is used.

And should (NULL) be an option when the column spec includes NOT NULL? For example, mysql.user columns exhibit this behavior.

Richard

[Author]

Posts