Table naming does not allow for spaces

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