MariaDB [(none)]> use innotest1;
Database changed
MariaDB [innotest1]> status
--------------
/home/mariadb-user/mariadb/columnstore/mysql/bin/mysql  Ver 15.1 Distrib 10.2.15-MariaDB, for Linux (x86_64) using readline 5.1

Connection id:		10
Current database:	innotest1
Current user:		root@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server:			MariaDB
Server version:		10.2.15-MariaDB-log Columnstore 1.1.5-2
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:		/home/mariadb-user/mariadb/columnstore/mysql/lib/mysql/mysql.sock
Uptime:			4 min 38 sec

Threads: 8  Questions: 7  Slow queries: 0  Opens: 20  Flush tables: 1  Open tables: 11  Queries per second avg: 0.025
--------------

MariaDB [innotest1]> 

MariaDB [innotest1]> CREATE TABLE t20 (c1 varchar(20)) ENGINE = innodb;
Query OK, 0 rows affected (0.01 sec)

MariaDB [innotest1]> drop table t20;
Query OK, 0 rows affected (0.01 sec)

MariaDB [innotest1]> 
MariaDB [innotest1]> -- Backtic in table name in innodb and no spaces in name
MariaDB [innotest1]> CREATE TABLE `t20` (c1 varchar(20)) ENGINE = innodb;
Query OK, 0 rows affected (0.00 sec)

MariaDB [innotest1]> 
MariaDB [innotest1]> -- Backtic in table name in innodb and 1 spaces after the name
MariaDB [innotest1]> CREATE TABLE `t21 ` (c1 varchar(20)) ENGINE = innodb;
ERROR 1103 (42000): Incorrect table name 't21 '
MariaDB [innotest1]> 
MariaDB [innotest1]> -- Backtic in table name in innodb and 1 space in middle of name
MariaDB [innotest1]> CREATE TABLE `t2  2` (c1 varchar(20)) ENGINE = innodb;
Query OK, 0 rows affected (0.01 sec)
MariaDB [innotest1]> 
MariaDB [innotest1]> -- Backtic in table name in innodb and 1 space in front of name and middle and space at end
MariaDB [innotest1]> CREATE TABLE ` t2  3 ` (c1 varchar(20)) ENGINE = innodb;
ERROR 1103 (42000): Incorrect table name ' t2  3 '
MariaDB [innotest1]> 
MariaDB [innotest1]> -- No Backtic in table name in innodb and 1 space in middle of name
MariaDB [innotest1]> CREATE TABLE t2  4 (c1 varchar(20)) ENGINE = innodb;
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 '4 (c1 varchar(20)) ENGINE = innodb' at line 1

-- ---------------------------------------------------

MariaDB [innotest1]> -- No backtic in table name in columnstore
MariaDB [innotest1]> CREATE TABLE t30 (c1 varchar(20)) ENGINE = columnstore;
Query OK, 0 rows affected (0.29 sec)
MariaDB [innotest1]> 
MariaDB [innotest1]> 
MariaDB [innotest1]> drop table t30;
Query OK, 0 rows affected (0.17 sec)
MariaDB [innotest1]> 
MariaDB [innotest1]> 
MariaDB [innotest1]> -- Backtic in table name in columnstore and no spaces in name
MariaDB [innotest1]> CREATE TABLE `t30` (c1 varchar(20)) ENGINE = columnstore;
Query OK, 0 rows affected (0.14 sec)

MariaDB [innotest1]> 
MariaDB [innotest1]> -- Backtic in table name in columnstore and 1 spaces after the name
MariaDB [innotest1]> CREATE TABLE `t31 ` (c1 varchar(20)) ENGINE = columnstore;
ERROR 1103 (42000): Incorrect table name 't31 '
MariaDB [innotest1]> 
MariaDB [innotest1]> 
MariaDB [innotest1]> -- Backtic in table name in columnstore and 1 space in middle of name
MariaDB [innotest1]> CREATE TABLE `t3  2` (c1 varchar(20)) ENGINE = columnstore;
ERROR 1178 (42000): 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.
MariaDB [innotest1]> 
MariaDB [innotest1]> -- Backtic in table name in columnstore and 1 space in front of name and middle and space at end
MariaDB [innotest1]> CREATE TABLE ` t3  3 ` (c1 varchar(20)) ENGINE = columnstore;
ERROR 1103 (42000): Incorrect table name ' t3  3 '
MariaDB [innotest1]> 
MariaDB [innotest1]> 
MariaDB [innotest1]> -- No Backtic in table name in columnstore and 1 space in middle of name
MariaDB [innotest1]> CREATE TABLE t2  4 (c1 varchar(20)) 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 '4 (c1 varchar(20)) ENGINE = columnstore' at line 1


-- In conclusion for innodb
--  1 backtics and space at end of table name does not work
--  2 backtics and space in the middle of table does work
--  3 backtics and space in front or in the middle or at the end does not work

-- In conclusion for columnstore
--  1 backtics and space at end of table name does not work
--  2 backtics and space in the middle of table does NOT work (this is different vs innodb which allowed this)
--  3 backtics and space in front or in the middle or at the end does not work