distal-attribute
distal-attribute
distal-attribute
distal-attribute

Problem when altering columns

User, date Message
Written by dmark
7 years ago
Category: General
3 posts since Sun, 03 Dec 06
Hi !

I discovered a problem where HeidiSQL does not recognize the changed properties of an altered column.

How to reproduce:

- Testtable with a column "xxx", data type varchar(10).
- Enter 10 characters of text in the data view.
- Alter table, change varchar(10) to varchar(20)
- Change back to data view and try to enter more characters

At this point HeidiSQL still limits the max length of the column to 10 chars.

If you close and re-open HeidiSQL all is fine and you are able to enter 20 chars.

Perhaps the program should re-read the table properties after altering it. Anyway it is a nice program :-)

Greetings, Dirk
Written by ansgar
7 years ago
4967 posts since Fri, 07 Apr 06
That topic is related to this issue in our tracker: http://sourceforge.net/tracker/index.php?func=detail&aid=1704044&group_id=164593&atid=832347

There will be no simple solution on HeidiSQL's side. Refreshing the datagrid is an incredible easy workaround for that, but I'm not sure if there are more simple ideas how to make that more comfortable.
 

Please login to leave a reply, or register at first.