[MCOL-1415] DDL Space between dot and table name regression Created: 2018-05-15  Updated: 2018-05-22  Resolved: 2018-05-22

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

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

Sprint: 2018-10, 2018-11

 Description   

The following query from test005 fails due to the space between the '.' and the table name in quotes. This is a regression.

CREATE TABLE dml. `sam_r368530763500` (   `cmp_inst_id` varchar(32) DEFAULT
 
NULL,   `agt_inst_id` varchar(32) DEFAULT NULL,   `output_id` varchar(10)
 
DEFAULT NULL,   `level_id` varchar(100) DEFAULT NULL,   `tgt_level_id`
 
varchar(100) DEFAULT NULL,   `row_id` int(11) DEFAULT NULL,   `rndnr`
 
decimal(18,0) DEFAULT NULL,   `b_cmp_inst_id` varchar(32) DEFAULT NULL,
 
`b_agt_inst_id` varchar(32) DEFAULT NULL,   `b_output_id` varchar(10) DEFAULT
 
NULL,   `clientid` varchar(32) DEFAULT NULL,   `A_` varchar(100) DEFAULT NULL,
 
 `C_` varchar(100) DEFAULT NULL,   `B_` varchar(100) DEFAULT NULL )
 
engine=columnstore;



 Comments   
Comment by Roman [ 2018-05-17 ]

The regression was fixed.
MariaDB [dml]> CREATE TABLE dml. `sam_r368530763500` ( `cmp_inst_id` varchar(32) DEFAULT
-> NULL, `agt_inst_id` varchar(32) DEFAULT NULL, `output_id` varchar(10)
-> DEFAULT NULL, `level_id` varchar(100) DEFAULT NULL, `tgt_level_id`
-> varchar(100) DEFAULT NULL, `row_id` int(11) DEFAULT NULL, `rndnr`
-> decimal(18,0) DEFAULT NULL, `b_cmp_inst_id` varchar(32) DEFAULT NULL,
-> `b_agt_inst_id` varchar(32) DEFAULT NULL, `b_output_id` varchar(10) DEFAULT
-> NULL, `clientid` varchar(32) DEFAULT NULL, `A_` varchar(100) DEFAULT NULL,
-> `C_` varchar(100) DEFAULT NULL, `B_` varchar(100) DEFAULT NULL )
-> engine=columnstore;
Query OK, 0 rows affected (2.13 sec)

MariaDB [dml]>

Comment by Roman [ 2018-05-17 ]

Please review.

Comment by Daniel Lee (Inactive) [ 2018-05-22 ]

Build verified: 1.1.5-1

[root@localhost ~]# cat mariadb-columnstore-1.1.5-1-centos7.x86_64.bin.tar.gz.txt
/root/columnstore/mariadb-columnstore-server
commit 0c983bff02172849a174dde46b62d76aa66485f8
Merge: 6b8a674 d5e6d89
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Thu Apr 26 16:16:51 2018 -0500

Merge pull request #112 from mariadb-corporation/davidhilldallas-patch-3

update to 1.1.5

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 1ea5198e0e9ecc2a8d13e6b44bf6c632f8561199
Merge: 4533116 59858aa
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Fri May 18 12:37:47 2018 +0100

Merge pull request #475 from drrtuy/MCOL-1415

MCOL-1415

Verified it works in 1.1.5-1, as well as 1.1.4-1

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