Cant change AVG_ROW_LENGTH parameter

[vialus]

AVG_ROW_LENGTH has somehow been automatically inserted in create table script and there is no table option to remove it. Why is it there and how I remove it?

Code: Select all

CREATE TABLE user_data.accounts (
  ID int(11) NOT NULL,
  Email varchar(255) DEFAULT NULL,
  MobilePhone varchar(32) DEFAULT NULL,
  PasswordHash varchar(255) DEFAULT NULL,
  PRIMARY KEY (ID)
)
ENGINE = INNODB,
AVG_ROW_LENGTH = 8192,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_0900_ai_ci;

[alexa]

You would need to exclude the 'Include average row length' option in the settings (select 'Tools -> Options...' from the main menu)

[vialus]

Thanks! I have found the settings but I can't figure our how to remove it for the current tables that already have it. Unchecking the box in main menu does not remove it and there is no table option to remove it.

[alexa]

Please set this setting to 0 in the table editor

[vialus]

Does not work. Upon saving it is reverted back to that number of 8192. All other tables are fine. Only this one behaves that strange. Look like more like a bug. Why would you force the number there?

Bellow is the version info

=========================
Application: dbForge Studio 2019 for MySQL
Product: Devart dbForge Studio 2019 for MySQL
Product Edition: Русская редакция
Product Locale: Russian
Trial Info: Активирован
HardwareID: 6127-3597-8D4E-3BAF-25B4
Assembly: dbforgemysql, Version=8.2.23.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.exe
Global cache: False
Framework: 4.6.2 or later
=========================

[alexa]

Unfortunately, we were not able to reproduce this issue.

Will it be possible to record a video demonstrating this?

You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

[vialus]

I have fixed it by
1. deleting the table
2. deleting this line of average row length from the project file
3. restoring the table from the project file

[alexa]

Thank you for updating us on this issue.

Please let us know if any questions arise.