SkelDave SkelDave - 14 days ago 5
MySQL Question

Unexpected Symbol 'NONE' Archive Engine - MariaDB DBForge

I am trying to create an archive table in MariaDB using dbForge and I'm getting the following error when I save the table.


Unexpected Symbol 'NONE'


dbForge automatically changes the following line from:


PRIMARY KEY (ArchiveSupplierID)


To


PRIMARY KEY USING NONE (ArchiveSupplierID)


Below is my table definition

CREATE TABLE supplierarchives (
ArchiveSupplierID INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY USING NONE (ArchiveSupplierID)
)
ENGINE = ARCHIVE
AUTO_INCREMENT = 31888
AVG_ROW_LENGTH = 148
CHARACTER SET utf8
COLLATE utf8_general_ci;


Thanks,

Answer

I posted this question on the devart forums and it turns out it is a valid bug.

http://forums.devart.com/viewtopic.php?f=23&t=34602