[#IDEADEV-27277] SQL: MySQL: Basic inspection reports time units as not supported

IDEA: Development

Created: 11 Jun 08 18:11 Updated: 19 Sep 08 19:52

Component/s:

SQL

Fix Version/s:

Diana Final

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

Build:

8,454

Description

« Hide

The following valid statement is red now:

 select date_add(curdate(), interval 1 year);

This is ~~IDEADEV-26999~~. To work around, write:

 select date_add(curdate(), interval 1 year microsecond);

See that 'year' is highlighted as warning. The same happens for any time unit except microsecond.
The message is "'Year' operator is not supported by MySQL dialect."
Actually all them are supported, see: http://dev.mysql.com/doc/refman/6.0/en/date-and-time-functions.html#function_date-add.

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

8814: already fixed.