[Bug Report] [Columnstore] Wrong Syntax: Create table leads to SQL Fehler (1178)

[expired user #9703]'s profile image [expired user #9703] posted 7 years ago in General Permalink

Hello,

if you create a table

CREATE TABLE coltest ( id INT NULL, description VARCHAR(50) NULL ) COLLATE='latin1_swedish_ci' ENGINE=Columnstore ;

I got en error.

/ SQL Fehler (1178): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types. /

There is a workarround.

MCOL-337 (Error: Sorry, you cannot yet post http links. You need some more posts to do that. )

CREATE TABLE coltest ( id INT NULL, description VARCHAR(50) NULL ) default CHARACTER SET latin1 engine=columnstore;

Regards,

Richard

kalvaro's profile image kalvaro posted 7 years ago Permalink

I guess you're talking about MariaDB

[expired user #9703]'s profile image [expired user #9703] posted 7 years ago Permalink

Yes, MariaDB Columnstore.

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