[#IDEA-18583] [SQL] Good code red: "DELETE" with JOIN in MySQL dialect

IDEA: Feedback

Created: 26 Jun 08 14:58 Updated: 27 Aug 08 20:27

Component/s:

SQL

Environment:

Ubuntu 8.04, Sun JDK 1.6.0_03

Issue Links:

Duplicate

This issue duplicates:
	IDEADEV-28220 SQL: MySQL: valid arythmetic expressi...

Build:	8,493
Severity:	Medium

Description

« Hide

The following SQL statement is valid under MySQL (not sure if it is part of ANSI SQL though) but is highlighted as error:

DELETE  h
FROM    hooks AS h JOIN impressions AS i
            ON h.request_id = i.request_id
WHERE   i.impression_date < NOW() - INTERVAL 3 HOUR;

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

DELETE statement does not play a part. The same false error is shown for

 select NOW() - INTERVAL 3 HOUR;

and described in IDEADEV-28220.