History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: IDEADEV-29576
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Normal Normal
Assignee: Gregory Shrago
Reporter: Arik Kfir
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
IDEA: Development

Good SQL code red: using "CASCADE" and "RESTRICT" in "DROP TABLE" statements under MySQL dialect

Created: 18 May 08 18:01   Updated: Monday 19:11
Component/s: SQL
Fix Version/s: Diana 8769

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown
File Attachments: None
Image Attachments:

1. idea.png
(153 kb)

Build: 8,375
Fixed in build: 8,752
Severity: High


 Description  « Hide
The following code is red under MySQL dialect:
DROP TABLE IF EXISTS my_table CASCADE;

According to MySQL reference manual, the "CASADE" keyword is legal (and it works, of course...).



 All   Comments   Work Log   Change History      Sort Order:
Alexander Chernikov - 26 Aug 08 20:28
8745: the same case with RESTRICT.

Alexander Chernikov - 01 Sep 08 19:11
8755: fix confirmed.