MariaDB support (CREATE TABLE bug for Aria)

[expired user #7029]'s profile image [expired user #7029] posted 7 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.