Problem when re-ordering many fields

[Patrick8639]

Hello,
if your reorder many fields, there are some cases when the order of the fields change after saving the new table.
You should review the logic of the save and use the order of the fields that are displayed on the list.
This problem was in version 5 and is still here in version 6.
Patrick

[alexa]

We were not able to reproduce this issue.

Could you please record a video and send it to us?

[Patrick8639]

Alexa,
in trying to reproduce the problem with a simple example, I've found another problem with the reordering of the columns:

1. create a new table with the following script:

Code: Select all

USE test;
CREATE TABLE test.test_reorder (
  C01 int(11) NOT NULL AUTO_INCREMENT,
  C02 int(11) NOT NULL,
  C03 int(11) NOT NULL,
  C04 int(11) NOT NULL,
  C05 int(11) NOT NULL,
  C06 int(11) NOT NULL,
  C07 int(11) NOT NULL,
  C08 int(11) NOT NULL,
  C09 int(11) NOT NULL,
  C10 int(11) NOT NULL,
  C11 int(11) NOT NULL,
  C12 int(11) NOT NULL,
  C13 int(11) NOT NULL,
  C14 int(11) NOT NULL,
  C15 int(11) NOT NULL,
  C16 int(11) NOT NULL,
  C17 int(11) NOT NULL,
  C18 int(11) NOT NULL,
  C19 int(11) NOT NULL,
  C20 int(11) NOT NULL,
  PRIMARY KEY (C01)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci;

2. Save the table.
3. Move column C04 at the place C10: C04 moves after C10.
4. Move column C11 at the place C05; C11 moves before C05.

So if you move a column below its position, if moves after the selected column; and when you move it above its position, if moves before the selected column.

Patrick

[Patrick8639]

Alexa,
here is a test case for reordering problem.

1. Create a new table with the following script:

Code: Select all

USE test;
CREATE TABLE test.test_reorder (
  C01 int(11) NOT NULL AUTO_INCREMENT,
  C02 int(11) NOT NULL,
  C03 int(11) NOT NULL,
  C04 int(11) NOT NULL,
  C05 int(11) NOT NULL,
  C06 int(11) NOT NULL,
  C07 int(11) NOT NULL,
  C08 int(11) NOT NULL,
  C09 int(11) NOT NULL,
  C10 int(11) NOT NULL,
  C11 int(11) NOT NULL,
  C12 int(11) NOT NULL,
  C13 int(11) NOT NULL,
  C14 int(11) NOT NULL,
  C15 int(11) NOT NULL,
  C16 int(11) NOT NULL,
  C17 int(11) NOT NULL,
  C18 int(11) NOT NULL,
  C19 int(11) NOT NULL,
  C20 int(11) NOT NULL,
  PRIMARY KEY (C01)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci;

2. Save the table.
3. Move column C19 at the place C10.
4. Move column C18 at the place C19 (the new one).
5. Save the table.

If you look, column C10 has moved at the C19 place and column C18 has returned to its place.

Patrick

[alexa]

We were able to reproduce these issues and will fix them in one of the next builds of dbForge Studio for MySQL. We will notify you once it's available for downloading.