7 | In version 2.5.2_05 does not work greatest by DateIn earlier versions this query worked fine. In version 2.5.2_05 does not work .orderBy(cb.desc(cb.greatest(root.get("createDate").as(Date.class)))).distinct(true) Thank you for your help. galandor Orlov Sergey Please try build 2.5.2_06 that should fix this regression (of casting to Date). support Support |
7 | ObjectDB version 2.1 has been released). Fixed a bug in distinct queries (duplicates due to bad optimization). Fixed a bug in viewing TreeSet |
7 | How to use JOIN FETCH? duplication then this is normal for JOIN FETCH and you can remove duplication by using SELECT DISTINCT |
7 | Why the internal error was thrown? .getModelElementsByQuery("select distinct m from " + PoolImpl.class.getName() + " m", PoolImpl |
1 | ObjectDB 2.3.7 and issue #634). Fixed a bug in using JPQL operations (e.g. UPPER) in DISTINCT results. Fixed an exception |
1 | several times a day queries take several minuteswe have queries like (see the database that we handed over to you for other issues) select distinct o from ObjectNode o join o.properties p1 join o.properties p2 where o.classIdentifier = "(OP)" and (o.linkedObjects.classIdentifier = "(TC)" and o.linkedObjects.objectNameUpper = "MILLING-EL" and o |
1 | Critical error:: com.objectdb.o.InternalException: Unexpected internal exception with queryThis is the query on the attached db (run in explorer): SELECT DISTINCT $1 FROM com.quasado.foundation.warehouse.payment.Payment $1 LEFT JOIN $1.receivable $2 WHERE (( ((($2 IS NOT NULL) AND ($2.receiver.qubletId=22))))) and this is the result: [ObjectDB 2.4.4] Unexpected exception (Error 990 |
1 | Problem with JOIN and inheritanceHello, Please run this query on the attached DB: SELECT DISTINCT $1 FROM com.quasado.serviceplaza.customer.VendorCustomer $1 JOIN $1.qubletFRAGMENTMAP $2, com.quasado.foundation.warehouse.contract.customer.CustomerContractsFragment $3 WHERE ((NOT (($2=$3) AND ($3.contracts IS EMPTY |
1 | Multiple MEMBER OF query been tested): SELECT DISTINCT item FROM Item item JOIN item.labels label1 JOIN item.labels label2 |
1 | Internal Exception.HND.run(HND.java:132) [objectdb-2.4.4_05.jar:] ... 1 more With this query: SELECT COUNT(DISTINCT |
