Bug #3577
closedWt::Dbo with Sqlite3 backend: clearing a collection for a Dbo::ptr throws an "syntax error" exception
0%
Description
I have a Dbo object in a Sqlite3 database with a ManyToMany relation and I'm trying to clear the collection of the relation by Dbo::collection<>::clear(). It does not work but throws an exception:
terminate called after throwing an instance of 'Wt::Dbo::backend::Sqlite3Exception'
what(): Sqlite3: delete from "testClass" join "testRelation" on "testRelation"."testRelationPassive" = "testClass"."id" where "testRelation"."testRelationActive" = ?: near "join": syntax error
I'm using wt 3.3.3, sqlite3 version is 3.7.17. Note that the problem occurs regardless of the ManyToMany relation being reflexive or not.
Maybe it's related to the following issue:
http://redmine.webtoolkit.eu/boards/2/topics/5363
Examples for the reflexive and the non-reflexive cases are attached.
Regards
Jörg
Files
Updated by Koen Deforche over 9 years ago
- Status changed from New to Resolved
- Assignee set to Koen Deforche
- Target version set to 3.3.4
Hey,
Indeed there was something wrong here, but this has been resolved since.
Koen.
Updated by Koen Deforche over 9 years ago
- Status changed from Resolved to Closed