Home » Search

About LEFT OUTER JOIN

91-100 of 200Refresh
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
Forum
2

KEY() / VALUE() not recognized in JPQL??

Hi! Explorer says "unexpected token" on KEY(..: SELECT FROM individual.IndividualContact $1 LEFT OUTER JOIN $1.profile.title.name m WHERE (KEY(m) = 'deu' AND VALUE(m) LIKE '%Dr%') profile = embedded entity title = referenced entity name = Map   thanks, Alex Yes
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
Forum
2

"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
JPA Doc
2

javax.persistence.MapKeyJoinColumn

) Specifies a mapping to an entity that is a map key. The map key join column is in the collection table, join table, or table of the target entity that is used to represent the map. If no MapKeyJoinColumn annotation is specified, a single join column is assumed and the default values apply. Example 1
Forum
2

Problem with distinct select, order by and equivalent alias/attribute path

distinct s_location "             + "from Street s "             + "left join s.location as s ... "             + "left join s.location as s_location "             + "order by s.location.id asc ... "             + "from Street s "             + "left join s.location as s_location