Details
-
Task
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Not a Bug
-
None
Description
With builtin table options, the = sign can be used but is optional:
MariaDB [test]> CREATE OR REPLACE TABLE t (a INT) |
-> ENGINE = CONNECT |
-> TABLE_TYPE = CSV
|
-> MIN_ROWS 1000;
|
Query OK, 0 rows affected, 1 warning (0.00 sec) |
But with engine-specific options, omitting the = sign results in a syntax error:
MariaDB [test]> CREATE OR REPLACE TABLE t (a INT) |
-> ENGINE = CONNECT |
-> TABLE_TYPE CSV;
|
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 'CSV' at line 3 |