Support for year(2)

[jdsada30]

Bug Report

1. What did you do?

Attempted to parse the following query

CREATE TABLE t (y2 YEAR(2), y4 YEAR);

Query comes from MySQL documentation , found this executing queries from GitHub project verdict-project .

2. What did you expect to see?

I expected this query and others with year(2) to parse correctly, as they are supported by MySQL.

3. What did you see instead?
   The following parse error:

parse error: [parser:1818]Supports only YEAR or YEAR(4) column

I am not sure whether this feature is deliberately not supported.

[morgo]

@jdsada30 YEAR(2) was removed from MySQL 8.0. Some of its behaviors are quite strange, which makes it not recommended for use.

Typically we do not implement features when they are deprecated/removed in MySQL, but we are open to feedback if you can demonstrate a compatibility requirement such as a popular application or framework depending on it.