Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

MariaDB support (CREATE TABLE bug for Aria)

hrvoj3e's profile image hrvoj3e posted 5 years ago in General Permalink

Is MariaDB supported officialy? How much?

Only MySQL is mentioned in user usage statistics and in the main project description. There are MySQL versions 10.0 and 10.1 which are MariaDB versions and not MySQL versions.

MariaDB has Aria engine with ROW_FORMAT=PAGE which is not available when creating tables or when showing create statement.

My code:

CREATE TABLE `z_aria_test` (
  `aaaa` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bbbb` varchar(50) COLLATE utf8mb4_croatian_ci DEFAULT NULL,
  `cccc` text COLLATE utf8mb4_croatian_ci,
  PRIMARY KEY (`aaaa`)
) ENGINE=Aria 
ROW_FORMAT=PAGE 
CHARSET=utf8mb4 COLLATE=utf8mb4_croatian_ci 
PAGE_CHECKSUM=1
;

HeidiSQL "CREATE code" (ROW_FORMAT broken)

CREATE TABLE `z_aria_test` (
    `aaaa` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `bbbb` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_croatian_ci',
    `cccc` TEXT NULL COLLATE 'utf8mb4_croatian_ci',
    PRIMARY KEY (`aaaa`)
)
COLLATE='utf8mb4_croatian_ci'
ENGINE=Aria
ROW_FORMAT=
;

MariaDB query : SHOW CREATE TABLE `z_aria_test`;

CREATE TABLE `z_aria_test` (
  `aaaa` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bbbb` varchar(50) COLLATE utf8mb4_croatian_ci DEFAULT NULL,
  `cccc` text COLLATE utf8mb4_croatian_ci,
  PRIMARY KEY (`aaaa`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_croatian_ci PAGE_CHECKSUM=1 ROW_FORMAT=PAGE
1 attachment(s):
  • 2017-04-30.112314.screenshot

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.