Bug #3577: Wt::Dbo with Sqlite3 backend: clearing a collection for a Dbo::ptr throws an "syntax error" exception - Wt - Redmine

Actions

Copy link

Bug #3577

closed

Wt::Dbo with Sqlite3 backend: clearing a collection for a Dbo::ptr throws an "syntax error" exception

Added by Anonymous about 10 years ago. Updated about 10 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Koen Deforche

Target version:

3.3.4

Start date:

09/11/2014

Due date:

% Done:

Estimated time:

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

Download all files