MySQL Bugs: #46847: auto completion completes too much

Bug #46847	auto completion completes too much
Submitted:	21 Aug 2009 3:41	Modified:	4 Sep 2009 10:54
Reporter:	Susanne Ebrecht	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.1, 5.2	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
Try to make the following by drawing/clicking in Workbench:

CREATE TABLE t(i INTEGER, t TEXT);

1) Open Workbench

2) Model -> Add Diagram

3) Place a table

4) double click table

5) Change name to t (this works fine)

6) -> Columns

7) Change name from first column from idt into "i" => this won't work ... always "id" is filled instead of "i" ... you need to type "i " + backspace to get column named "i".

8) Create a second column .... try to type "t" as name. => This also is not working always table1_ is filled here ... same here you need to type "t " + backspace

This is really annoying.

How to repeat:
See above

Suggested fix:
Only complete when completition is choosen from drop down menu. Not complete always with first given in drop down.

fixed. will be included in 5.1.18

An entry has been added to the 5.1.18 changelog:

The auto-completion of column names in the the Table Editor completed names unnecessarily, requiring characters in the name to be manually deleted. This only happened on the Linux version of MySQL Workbench.