Home » Search

About DISTINCT

61-66 of 66Refresh
Forum
1

ObjectDB version 2.1 has been released

). Fixed a bug in distinct queries (duplicates due to bad optimization). Fixed a bug in viewing TreeSet
Issue
1

Once served to JSF page via @EJB query bean, many list fields are null (but same query ok after fresh persist in @PostConstruct)

the distinction between a Guest object and simple relational database table. I don't mind being wrong if I learn
Issue
1

Problem with JOIN and inheritance

Hello, 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
Forum
1

Query in JPA2 with LEFT JOIN on INNER JOIN

and actionprof9_.ID=9 while my query is select distinct (a.description), a.id, ap1.id
Forum
1

Why the internal error was thrown?

distinct m from " + PoolImpl.class.getName() + " m", PoolImpl.class); The query execution in
Issue
1

several times a day queries take several minutes

we 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