Home » Support » Issue Tracking » Issue with full cross joins

Issue with full cross joins

Type: BugPriority: NormalStatus: FixedReplies: 1
#1

hi,

There seems to be an issue with full cross joins & maps.

This query:

SELECT  $1
FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied  $1
     LEFT JOIN $1.qubletFRAGMENTMAP $4,
     com.vereinsverwaltung.abrechnung.mitglied.MitgliedDebitorenKontoFragment $5
WHERE ($4=$5)

returns 30 entries from "Mitglied" whereas there should be 32 of them (see attached db). The two "Mitglied" entries with id 273 and 274 don't get selected eventhough they do have valid "MitgliedDebitorenKontoFragment" entity reference in their "qubletFRAGMENTMAP" map!?

#2

It seems that simple iteration on map values in JOIN has not been implemented and a map was handled as a collection of the first half of keys and values.

Thank you for this report. Build  2.3.5_06 fixes this issue.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)

Post Reply

To post a reply and/or subscribe to update notifications - please login