[MDEV-14859] YES/NO values in table options without equality sign cause syntax error Created: 2018-01-02  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Parser
Affects Version/s: 10.1, 10.2
Fix Version/s: 10.4

Type: Bug Priority: Trivial
Reporter: Elena Stepanova Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: 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.


Generated at Thu Feb 08 08:16:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.