[stormyfacts] The code doesn't enforce foreign keys in Sqlite
Bug #990919 reported by
m4v
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ubuntu IRC Bots |
Triaged
|
Low
|
Unassigned |
Bug Description
So until now I have been working thinking that SQLite and MySQL were enforcing foreign keys, but it turns out they weren't. "PRAGMA foreign_keys = ON" doesn't work with storm (https:/
The result is that the code can't even create a table without upsetting the constraint rules, if you're using InnoDB with MySQL then you aren't going to go far with Stormyfacts.
summary: |
- [stormyfacts] MySQL support is fubar in Precise + [stormyfacts] MySQL fails with InnoDB engine |
summary: |
- [stormyfacts] MySQL fails with InnoDB engine + [stormyfacts] The code doesn't enforce foreign keys anywhere |
Changed in ubuntu-bots: | |
importance: | High → Medium |
Changed in ubuntu-bots: | |
status: | Confirmed → Triaged |
description: | updated |
description: | updated |
To post a comment you must log in.
for now I disabled foreign keys, at least this way MySQL will work regardless of the engine.