Project

General

Profile

Bug #3577

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

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

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
09/11/2014
Due date:
% Done:

0%

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

main.cpp (1.15 KB) main.cpp Anonymous, 09/11/2014 05:57 PM
mainNonReflexive.cpp (1.31 KB) mainNonReflexive.cpp Anonymous, 09/11/2014 05:57 PM
#1

Updated by Koen Deforche about 8 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.

#2

Updated by Koen Deforche about 8 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF