[MCOL-264] DDL parser doesn't support space instead of equals in table options Created: 2016-08-16  Updated: 2016-09-13  Resolved: 2016-09-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: None
Fix Version/s: 1.0.3

Type: Bug Priority: Minor
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 1.0.3

 Description   

The ddl.yy file doesn't support table options without '='. For example this should work but generates an error:

CREATE TABLE t1 (a int, b int) ENGINE COLUMNSTORE;

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2016-08-16 ]

I have a patch for this ready

Comment by Andrew Hutchings (Inactive) [ 2016-08-16 ]

Created pull request with fix:
https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/2

Comment by David Hall (Inactive) [ 2016-09-02 ]

Test then close

Comment by Daniel Lee (Inactive) [ 2016-09-13 ]

Build verified:

mscadmin> getsoft
getsoftwareinfo Tue Sep 13 17:07:26 2016

Name : mariadb-columnstore-platform
Version : 1.0.3
Release : 1
Architecture: x86_64
Install Date: Tue 13 Sep 2016 09:26:32 AM CDT

MariaDB [mytest]> create table t1 (c1 int, c2 char(25)) engine columnstore;
Query OK, 0 rows affected (0.16 sec)

MariaDB [mytest]> show create table t1;
--------------------------------------------------------------------------------------------------------------------------------+

Table Create Table

--------------------------------------------------------------------------------------------------------------------------------+

t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(25) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=latin1

--------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Generated at Thu Feb 08 02:19:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.