Details
-
Bug
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
10.1, 10.2
-
None
Description
Starting from 10.1, we have a couple of table options with YES/NO values (as opposed to 0/1) – ENCRYPTED and IETF_QUOTES. According to the documentation, equality sign between the option and the value is optional, and this should work:
CREATE TABLE t1 (i INT NOT NULL DEFAULT 1) ENGINE=CSV IETF_QUOTES NO; |
but it doesn't:
MariaDB [test]> CREATE TABLE t1 (i INT NOT NULL DEFAULT 1) ENGINE=CSV IETF_QUOTES NO; |
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 'NO' at line 1 |
It works with = sign.
Same for ENCRYPTED.
For options with 0/1 values both variants work.
Possibly it's a documentation issue.