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. Nested queries (issue #11) is currently not supported

Hello is there way to get random rows? Functions like rand(), random(), newid() doesn't work ;/ for example:
em.createQuery("SELECT s FROM StawkaVat s ORDER BY rand()").setMaxResults(5).getResultList(); gives exception:
Exception in thread "AWT-EventQueue-0" [ObjectDB 2.5.6_02] SELECT s FROM

extension. To install it: Open the [Install] dialog box by selecting Help > Install New Software... In ... ENTER. Select the ObjectDB Birt/ODA feature. Complete the installation by clicking Next twice, accepting ... and selecting New Data Source. Select ObjectDB Data Source from the list of available data source types

="SELECT c FROM Country c")
The @NamedQuery annotation contains four elements ... class. But since the scope of named queries is the entire persistence unit, names should be selected ... ", query="SELECT c FROM Country c")
public class Country {
...
} Attaching multiple named