Backport the feature from the issue.

Please review. I will come regression tests later.

Build verified: 1.1.5-1 source

[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

Could not reproduced the issue in 1.1.4-1. Verified that it works in 1.1.5-1.

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 136
Server version: 10.2.14-MariaDB-log Columnstore 1.1.5-1

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [tpch1]> create database cs;
Query OK, 1 row affected (0.00 sec)

MariaDB [tpch1]> use cs;
Database changed
MariaDB [cs]> create table `cs`.`cs1`(i bigint) engine=columnstore;
Query OK, 0 rows affected (0.16 sec)

MariaDB [cs]> desc cs1;
------------------------------------+

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

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

MariaDB [mytest]> create database cs;
Query OK, 1 row affected (0.00 sec)

MariaDB [mytest]> create table `cs`.`insert`(i bigint) engine=columnstore;
Query OK, 0 rows affected (0.12 sec)

MariaDB [mytest]> create table cs.update(i bigint) engine=columnstore;
Query OK, 0 rows affected (0.11 sec)

MariaDB [mytest]> insert into cs.insert values (1);
Query OK, 1 row affected (0.11 sec)

MariaDB [mytest]> select * from cs.insert;
------

------

------
1 row in set (0.05 sec)

MariaDB [mytest]> update cs.insert set i=5;
Query OK, 1 row affected (0.07 sec)
Rows matched: 0 Changed: 0 Warnings: 0

MariaDB [mytest]> select * from cs.insert;
------

------

------
1 row in set (0.02 sec)

MariaDB [mytest]> delete from cs.insert;
Query OK, 1 row affected (0.10 sec)

MariaDB [mytest]> truncate table cs.insert;
Query OK, 0 rows affected (0.09 sec)

MariaDB [mytest]> drop table cs.insert;
Query OK, 0 rows affected (0.13 sec)

Build tested: 1.1.5-1 source

/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

Developer provided additional test case. The original provided test case did not test the issue sufficiently.

Reproduced the reported issues in 1.1.4-1

In 1.1.5-1, these two statements worked:

MariaDB [mytest]> set session sql_mode=ANSI_QUOTES;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mytest]> create table `cs`. `SELECTe`(`key` bigint) engine=columnstore;
Query OK, 0 rows affected (1.33 sec)

MariaDB [mytest]> create table "cs". "SELECTf"("key" bigint) engine=columnstore;
Query OK, 0 rows affected (0.13 sec)

but the following statement hung and never returned:

create table cs.`somea`(`key` bigint) engine=columnstore;

I restarted ColumnStore and tried the create statement again and got:

MariaDB [mytest]> create table cs.`somea`(`key` bigint) engine=columnstore;
ERROR 1050 (42S01): Table 'somea' already exists

I tried to drop the table and it also hung:

MariaDB [mytest]> drop table cs.`somea`;

Not fixed yet.

Build tested: 1.1.5-1 source

/root/columnstore/mariadb-columnstore-server
commit 3e6e2b692a5847cc6e89fb200558ebc781b14b09
Merge: 0c983bf 1f94211
Author: David.Hall <david.hall@mariadb.com>
Date: Thu May 31 09:30:12 2018 -0500

Merge pull request #118 from mariadb-corporation/MCOL-1435

Merge MariaDB 10.2.15 into develop-1.1

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 3ab634bde692e5c96f823aef933120eb09c72465
Merge: 12f2e11 efbf297
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Thu May 31 13:15:46 2018 +0100

Merge pull request #485 from drrtuy/MCOL-1384_2

MCOL-1384 Backport MCOL-573 to 1.1

The reported hanging issue has been fixed, but the following create statement that was working, now no longer works.

MariaDB [mytest]> create table "cs". "SELECTf"("key" bigint) engine=columnstore;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"cs". "SELECTf"("key" bigint) engine=columnstore' at line 1
MariaDB [mytest]> create table "cs"."SELECTf"("key" bigint) engine=columnstore;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"cs"."SELECTf"("key" bigint) engine=columnstore' at line 1

The 2nd one has the space between the schema name and table name removed.

It seems that double quote is no longer supported.

reopened per my last comment

Your CREATE TABLE statement isn't valid for MariaDB, this is not a regression. This is regular MariaDB:

MariaDB [test]> create table "cs". "SELECTf" ("key" bigint);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"cs"."SELECTf" ("key" bigint)' at line 1

Since the statement with double is not supposed by the MariaDB server, it is a non-issue.