Home » Search

About DISTINCT

51-60 of 67Refresh
Issue
1

Critical error:: com.objectdb.o.InternalException: Unexpected internal exception with query

This 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
Issue
1

Deadlock

Hi, 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
Issue
1

Error reading UTF string (Serialized Objects in Explorer)

This is the message I get for attached db and this query: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE ((($1.qubletID=278) AND NOT (((com.lexware.vereinsverwaltung.abrechnung.api.model.mitglied.MitgliedDebitorenKontoFragment) $1.qubletFRAGMENTMAP
Issue
1

Feature Request: Subclassed PersistenceException for Type Not Found in DB Schema

>();         String queryString = "select DISTINCT(summary.store) from AbstractClientSummary summary WHERE summary
Forum
1

How to convert a boolean to an int in the query?

directly in the query, depending on the query for example SELECT DISTINCT m FROM Person m LEFT OUTER
Forum
1

How to use JOIN FETCH?

then this is normal for JOIN FETCH and you can remove duplication by using SELECT DISTINCT. The main problem
Forum
1

In version 2.5.2_05 does not work greatest by Date

In 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. Please try build 2.5.2_06 that should fix this regression (of casting to Date). galandor
Issue
1

Internal Exception

(DISTINCT $1) FROM com.lexware.vereinsverwaltung.abrechnung.beitrag.BeitragForderung $1 LEFT JOIN $1
Forum
1

InternalError on multiple AND and JOIN Query

Hi, Using objectdb 2.2.8_06. Running the following query: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.contactDetails $2 JOIN $2.addresses $3 JOIN $3.attributeList $4 JOIN $2.phoneNumbers $5 JOIN $5.attributeList $6 WHERE ((($4.name='suburb') AND ($4.valueAsString='Los Angeles')) AND (($6.name='areacode
Forum
1

InternalError on query of empty database

DISTINCT $1 FROM CDI $1 JOIN $1.attributeList $2 JOIN $1.attributeList $3 WHERE ((($2.name='firstname