search

google / lovefield

Lovefield is a relational database for web apps. Written in JavaScript, works cross-browser. Provides SQL-like APIs that are fast, safe, and easy to use.
https://google.github.io/lovefield/
Apache License 2.0
6.81k stars 366 forks source link

Foreign key constraints are not enforced #8

Closed arthurhsu closed 9 years ago

arthurhsu commented 10 years ago

Need to implement such constraints for INSERT and UPDATE queries, also honor the "cascade" keyword in the schema.

freshp86 commented 9 years ago

Foreign key constraints have been implemented for all types of queries (insert, insertOrReplace, update and delete). All foreign key constraints are currently treated as RESTRICT (see explanation at https://github.com/google/lovefield/blob/master/docs/spec/08_referential_integrity.md#821-restrict).

I am closing this issue since there is already a bug to track the CASCADE work, see https://github.com/google/lovefield/issues/14.