8 | InternalError on multiple AND and JOIN QueryHi, 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 |
8 | "Problem" with cross joinAt first, this is my first JPA Projekt - and the code should work with Hibernate and JPA, using the specifc DAOs. Following query string returns no result using ObjectDB - using Hibernate, or EclipseLink this query works fine. select distinct c from CI c, CIstring s where c.name like :SSTR or (c.id |
8 | 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 |
1 | Feature Request: Subclassed PersistenceException for Type Not Found in DB Schema DISTINCT(summary.store) from AbstractClientSummary summary WHERE summary.chain == :chain"; TypedQuery |
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 | 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 |
