About LEFT OUTER JOIN

91-100 of 200Refresh
Issue
3

Different behavior for two equal queries

through null in one of the OR components. Navigation should be compiled as LEFT OUTER JOIN to avoid losing results in such cases, but maybe an ordinary JOIN was used in this query. Could you isolate the OR
JDO Doc
3

addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters)

is composed as a Query and subsequently attached to a different query (the outer query) by calling ... of the outer query. Only some of the query parts are copied for use as the subquery. The parts ... is the expression from the outer query that represents the candidates over which the subquery is evaluated
Forum
3

"Problem" with cross join

=InheritanceType.JOINED) ... @ManyToOne private CI ci; subclass CIstring private String text; I ... fields in JOIN queries). Please try the new build (2.0.4_01) that should fix the bug. The attached test
Forum
2

joining of tables

Hi In objectdb site i found :Note: This ORM/SQL annotation is silently ignored by ObjectDB so i want  join tow table and generate a third table. Ex:  table 1: employee    table 2: address  and the generate table will be table 3: emp_add employee: e_id, e_name address: add_id, city, house
Issue
2

Mapped by fields are not initialized by JOIN FETCH in queries

As demonstrated in this forum thread, a mapped by collection field with lazy fetch mode is not initialized in results of a query that uses JOIN FETCH on that collection field (when enhancement is used).   Build 2.4.1_06 fixes this issue (fields are now initialized and the test in the forum passes
Issue
2

Weird issue with variable naming

is that we do a LEFT JOIN on an embedded property as well as ordering is involved in selection ... of our left join variable becomes $1. We're also adding a custom function expression in where clause ... ("embedded", JoinType.LEFT);   final Join join = from.join("map", JoinType.LEFT);   cq
JPA Doc
2

javax.persistence.JoinColumn

a column for joining an entity association or element collection. If the JoinColumn annotation itself is defaulted, a single join column is assumed and the default values apply. Example ... @JoinColumn(name="CUST_ID") // join column is in table for Order public Set
Result
2

ObjectDB version 2.2.8

Version 2.2.8 Fixed a critical bug in extensive removal operations of large objects. Improved the performance of navigation through an inverse (mapped by) field if the owner field is indexed. Fixed a LEFT OUTER JOIN bug. Fixed a bug in parsing queries with parenthesis followed by NOT. Fixed a bug
Result
2

ObjectDB version 2.3.6

a bug in LEFT OUTER JOIN. Fixed GROUP BY DATE(...) - merging AM and PM into the same date.
Forum
2

Fetching Collections Puzzle

from Node n left outer join fetch n.children where ....." this will also fetch your collection