Devart Forums

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'''.

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.

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

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.

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 but when i save (CTRL+S) its changed to

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