Issue #2562: selective update not working

Type: DocumentationVersion: 2.7.5_05Priority: HighStatus: ClosedReplies: 1
#1

we try to optimize for our queries and tried a selective update, but in explorer it just shows query execution error:

 

UPDATE ObjectNode o SET o.state = 5 where o.classIdentifier = '(MA)' and o.objectNameUpper = 'DMU200P2' and  o.state = 0 and o.type = 1 and o.parentNode.classIdentifier = '(NC)'
#2

This query includes an implicit JOIN (o.parentNode.classIdentifier), which is not allowed in UPDATE queries. See this stackoverflow thread for a more detailed explanation.

ObjectDB Support

Reply