Wt::Dbo with Sqlite3 backend: clearing a collection for a Dbo::ptr throws an "syntax error" exception
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:
Examples for the reflexive and the non-reflexive cases are attached.