Script Issues

[mimispa]

Hello,
I use MariaDB 10.2.7 and i found "schema comparison" and "edit table" issues.
dbForge create scripts with extra quotations.
for example:
CREATE TABLE test_db.test1_tbl (
id int(11) NOT NULL AUTO_INCREMENT,
test_str varchar(16) DEFAULT 'NULL',
test_int_1 int(11) NOT NULL DEFAULT 0,
test_int_2 int(11) DEFAULT NULL,
test_timestamp timestamp NOT NULL DEFAULT 'current_timestamp()',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci;

CREATE TABLE test_db.test2_tbl (
id varchar(40) NOT NULL DEFAULT '''0''',
test_str varchar(16) NOT NULL DEFAULT '''0''',
PRIMARY KEY (id)
)
ENGINE = INNODB
CHARACTER SET utf8
COLLATE utf8_general_ci;

I think that when see NULL converts to 'NULL' , current_timestamp() converts to 'current_timestamp' and default string converts to '''value'''.

[.jp]

Hello,

Thanks for the post!

So far, dbForge Studio for MySQL v7.2 supports the MariaDB server up to the 10.0 version.
Please have a look at the following link https://www.devart.com/dbforge/mysql/st ... ments.html.
We're going to support MariaDB v10.1 and v10.2 in the next version of the product.

Best Regards.

[mimispa]

Thanks for the reply!
Can you please, tell when next version will release?

[.jp]

Hello,

The development of the new version is in the final stage. So, the release of the product is going to be available in a month or two, we hope.

Best Regards.

[jmlscontrol]

I still see part of this issue with MariaDB 10.2.11 and dbForge 7.2.78 Express

when ever i change something, the change is correctly written

Code: Select all

CREATE TABLE smartconnect.post (
  id INT(11) NOT NULL AUTO_INCREMENT,
  authorId INT(11) DEFAULT NULL,
  text TINYTEXT DEFAULT 'Hej',
  datetime DATETIME DEFAULT current_timestamp(),
  timestamp TIMESTAMP NULL DEFAULT current_timestamp(),
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 55
AVG_ROW_LENGTH = 585
CHARACTER SET utf8
COLLATE utf8_general_ci
ROW_FORMAT = DYNAMIC;

but when i save (CTRL+S) its changed to

Code: Select all

CREATE TABLE smartconnect.post (
  id INT(11) NOT NULL AUTO_INCREMENT,
  authorId INT(11) DEFAULT NULL,
  text TINYTEXT DEFAULT 'Hej',
  datetime DATETIME DEFAULT 'current_timestamp()',
  timestamp TIMESTAMP NULL DEFAULT 'current_timestamp()',
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 55
AVG_ROW_LENGTH = 585
CHARACTER SET utf8
COLLATE utf8_general_ci
ROW_FORMAT = DYNAMIC;

[alexa]

We are planing to release dbForge Studio for MySQL v7.3, where this issue will be resolved, this week.