Broken MariaDB 10.2 support

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
SmartSoftwareSystems
Posts: 3
Joined: Mon 03 Oct 2011 08:00
Location: Bulgaria

Broken MariaDB 10.2 support

Post by SmartSoftwareSystems » Wed 02 Aug 2017 08:40

The schema definitions that DbForge shows are wrong, when doing a Schema Compare everything is also very broken. Check the below code. DbForge is 7.2.78.

Code: Select all

-- Server 5.5.5-10.0.31-MariaDB-1~xenial
USE test;

CREATE TABLE tt (
  TestID int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  t1 varchar(255) DEFAULT '',
  t2 date DEFAULT NULL,
  t3 varchar(255) DEFAULT 'smail',
  t4 varchar(255) NOT NULL,
  PRIMARY KEY (TestID)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci;

 

-- Server 5.5.5-10.2.7-MariaDB-10.2.7+maria~xenial-log
USE test;

CREATE TABLE tt (
  TestID int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  t1 varchar(255) DEFAULT '''''',
  t2 date DEFAULT 'NULL',
  t3 varchar(255) DEFAULT '''smail''',
  t4 varchar(255) NOT NULL,
  PRIMARY KEY (TestID)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci
ROW_FORMAT = DYNAMIC;

-- 

SELECT
  c.TABLE_NAME,
  COLUMN_NAME,
  COLUMN_TYPE,
  IS_NULLABLE,
  COLUMN_KEY,
  COLUMN_DEFAULT,
  EXTRA,
  COLLATION_NAME,
  CHARACTER_SET_NAME,
  COLUMN_COMMENT
FROM information_schema.COLUMNS c
  INNER JOIN (SELECT
      TABLE_SCHEMA,
      TABLE_NAME
    FROM information_schema.TABLES
    WHERE LOWER(TABLE_SCHEMA) = LOWER('test')) t
    ON t.TABLE_NAME COLLATE utf8_bin = c.TABLE_NAME
    COLLATE utf8_bin
WHERE LOWER(c.TABLE_SCHEMA) = LOWER('test')
AND ('Y' = ''
OR LOWER(c.TABLE_NAME) IN ('tt'))
ORDER BY t.TABLE_NAME;

alexa

Re: Broken MariaDB 10.2 support

Post by alexa » Wed 02 Aug 2017 11:15

MariaDB 10.2 is to be supported in version 7.4 of dbForge Studio for MySQL.

SmartSoftwareSystems
Posts: 3
Joined: Mon 03 Oct 2011 08:00
Location: Bulgaria

Re: Broken MariaDB 10.2 support

Post by SmartSoftwareSystems » Fri 04 Aug 2017 06:35

When will that be available.

alexa

Re: Broken MariaDB 10.2 support

Post by alexa » Fri 04 Aug 2017 15:54

Unfortunately, there is still no estimated date for this.

SmartSoftwareSystems
Posts: 3
Joined: Mon 03 Oct 2011 08:00
Location: Bulgaria

Re: Broken MariaDB 10.2 support

Post by SmartSoftwareSystems » Wed 13 Sep 2017 15:16

Where are we on this do we have an estimate?

alexa

Re: Broken MariaDB 10.2 support

Post by alexa » Thu 14 Sep 2017 14:47

It should be released within 2 months time.

baumina
Posts: 2
Joined: Thu 23 Nov 2017 14:09

Re: Broken MariaDB 10.2 support

Post by baumina » Thu 23 Nov 2017 14:30

Any news?

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Broken MariaDB 10.2 support

Post by .jp » Mon 27 Nov 2017 07:24

Hello,

dbForge Studio with MariaDB v10.1 as well as v10.2 support is on the final testing stage.
We'll release a new version of the product as soon as our QA team approve it.
Please wait for a while.

Best Regards.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Broken MariaDB 10.2 support

Post by .jp » Thu 07 Dec 2017 12:26


Post Reply