Bug #25540 Can't add foriegn keys
Submitted: 11 Jan 2007 9:53 Modified: 26 May 2010 17:48
Reporter: Jared S (Silver Quality Contributor) Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S4 (Feature request)
Version:5.2.0-falcon-alpha OS:Windows (Vista)
Assigned to: CPU Architecture:Any
Tags: constraint, falcon, foreign key

[11 Jan 2007 9:53] Jared S 
Description:
Using Query Browser I have not been able to add foriegn keys to falcon talbes.  I have verified this by selecting rows from IS database.

How to repeat:
> create new db
> try to link pair of tables

Suggested fix:
1. Provide hyperlink to Falcons capabilities
2. Implement constraints
[11 Jan 2007 9:58] Roland Bouman 
Hi there, 

I don't think this is a bug. It's a known limitation of Falcon

http://dev.mysql.com/doc/refman/5.1/en/se-falcon-limits.html
[11 Jan 2007 10:15] Roland Bouman 
Thank you for your bug report.

We appreciate your efforts testing Falcon. 

The Alpha release of Falcon does not currently implement foreign keys. This is a known limitation. The limitation is documented here:

http://dev.mysql.com/doc/refman/5.1/en/se-falcon-limits.html

Foreign keys will be implemented at a later stage.