ObjectDB ObjectDB

Issue #634: Issue with full cross joins

Type: Bug ReoprtPriority: 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!?

edit
delete
#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
edit
delete

Reply

To post on this website please sign in.