A nested SELECT

#1

Hello.

I have a query

UPDATE Look l SET l.partlySold = FALSE
WHERE (SELECT count(a) FROM l.things a WHERE a.thing.status != :status) <= 1

which doesn't work: "Unexpected query token 'SELECT'". Does ObjectDB support queries like this?

Thanks.

#2

Nested queries (issue #11) is currently not supported by ObjectDB.

See JPA features that are not implemented yet by ObjectDB in the issue tracking.

ObjectDB Support

Reply