[#IDEADEV-27535] SQL: MySQL: YEAR type with parameter is reported as error

IDEA: Development

Created: 23 Jun 08 20:08 Updated: 23 Jun 08 20:08

Component/s:

SQL

Fix Version/s:

None

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

Build:

8,492

Description

« Hide

The following MySQL statement is valid:

 create table t1 (c1 year, c2 year(2), c3 year(4));

YEAR type supports YEAR(2) and YEAR(4) specification: http://dev.mysql.com/doc/refman/6.0/en/numeric-type-overview.html.
(Actually MySQL server accepts YEAR with any numeric parameter.)
IDEA reports YEAR(N) as an error.

All

Comments

Work Log

Change History

Sort Order:

There are no comments yet on this issue.