8 | Query in JPA2 with LEFT JOIN on INNER JOIN and actionprof8_.ID=7 and actionprof9_.ID=9 while my query is select distinct (a.description |
8 | How to use JOIN FETCH? duplication then this is normal for JOIN FETCH and you can remove duplication by using SELECT DISTINCT |
8 | An InternalException occurs when gets an result list yet? support Support it is actually a simple query: select distinct m from ArchitectureImpl m |
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 | 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 | ObjectDB 2.2.4 JOIN FETCH with DISTINCT. Fixed Metamodel API's getTypeId method to support single ID field. |
1 | ObjectDB 2.1.0 enabled (issue #142). Fixed a bug in distinct queries (duplicates due to bad optimization). Fixed |
1 | Once served to JSF page via @EJB query bean, many list fields are null (but same query ok after fresh persist in @PostConstruct), because without any relationships there is no way of demonstrating the distinction between a Guest |
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 | DeadlockHi, Query: SELECT DISTINCT $1, UPPER($1.name) AS $O0, UPPER($2.lastName) AS $O1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.profile $2 WHERE (($1.getClass().getName()='com.lexware.vereinsverwaltung.verein.api.model.mitglied.Mitglied')) ORDER BY $O0, $O1 |
