Unexpected Symbol 'NONE' Archive Engine

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Skeldave
Posts: 2
Joined: Mon 21 Nov 2016 15:59

Unexpected Symbol 'NONE' Archive Engine

Post by Skeldave » Mon 21 Nov 2016 16:04

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)
PRIMARY KEY USING NONE (ArchiveSupplierID)
Below is my table definition

Code: Select all

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;
Also, the 'ARCHIVE' engine doesn't appear in the engine list by default, but I have created the table through entity framework and it has set the engine type to 'ARCHIVE'

Thanks.

alexa

Re: Unexpected Symbol 'NONE' Archive Engine

Post by alexa » Tue 22 Nov 2016 10:14

Could you please provide us the version of MariaDB and the link to the MariaDB documentation where the syntax "PRIMARY KEY USING NONE" described?

Skeldave
Posts: 2
Joined: Mon 21 Nov 2016 15:59

Re: Unexpected Symbol 'NONE' Archive Engine

Post by Skeldave » Tue 22 Nov 2016 12:29

Hello,

Mariadb version: 5.5.5-10.1.11-MariaDB

I do not know of any documentation which mentions 'PRIMARY KEY USING NONE', I DbForge adds that in by itself when I save the the table.

Steps to reproduce:

1. Create a table,
2. Run ALTER TABLE supplier2 ENGINE=ARCHIVE
3. Reopen the table in DbForge
4. Add a primary key,
5. Save by pressing ctrl+s
6. The 'Primary key using none' is automatically added.

I have attached a gif to show the process.

Image

Let me know if you need any other information.]

Thanks.

alexa

Re: Unexpected Symbol 'NONE' Archive Engine

Post by alexa » Tue 22 Nov 2016 15:47

Thank you for clarifying this. We will fix this issue in the next product build and will notify you once it's available for downloading.

alexa

Re: Unexpected Symbol 'NONE' Archive Engine

Post by alexa » Wed 30 Nov 2016 09:54

We would like to let you know that we have released dbForge Studio for MySQL, v7.2.50 where the issue you reported is fixed https://www.devart.com/dbforge/mysql/st ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.

Post Reply