| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] |
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0000141 | Rosetta | [All Projects] Incorrect Results | public | 2012-10-22 13:05 | 2012-10-22 13:05 |
|
| Reporter | momeara | |
| Assigned To | momeara | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | assigned | Resolution | open | |
| Platform | All platforms | OS | Any | OS Version | Any |
| Product Version | Trunk | |
| Fixed in Version | | |
|
| Summary | 0000141: Default SQLite foreign keys "NO ACTION" -> "CASCADE" |
| Description | By default SQLite foreign keys do not complain when broken by updating or deleting. This can be changed by specifying an ON DELETE and ON UPDATE clause when defining the foreign keys. This should be done by default in the schema generator.
http://www.sqlite.org/foreignkeys.html#fk_actions [^] |
| Steps To Reproduce | run the features integration test, then in sqlite3 delete a row from the structures table. |
| Tags | No tags attached. |
|
| Application(s) Affected | Features database generation |
| Command Line Used | see features integration test, for example |
| Developer Options | Feature Request |
| Fixed in SVN Version | |
|
| Attached Files | |
|
Relationships 
Relationships