FWD » Core Development » Database

The following:

define query q1 for person, pers-addr.
open query q1
  for each person where person.emp-num > 0,
  first pers-addr where person.site-id = pers-addr.site-id outer-join no-lock.

converts to (relevant portion only):

query0.assign(new CompoundQuery(true, false));
query0.addComponent(new AdaptiveQuery(person, "person.empNum > 0", null, "person.siteId asc, person.empNum asc"));
RecordBuffer.prepare(persAddr);
query0.addComponent(new RandomAccessQuery(persAddr, "? = persAddr.siteId", null, "persAddr.siteId asc, persAddr.empNum asc", new Object[]
{
   new FieldReference(person, "siteId")
}, LockType.NONE), QueryConstants.FIRST);

There should be a third parameter -- true -- emitted to the second query0.addComponent call, after QueryConstants.FIRST, indicating that this query component should be joined via a LEFT OUTER JOIN.

This update adds support for the OUTER-JOIN clause for a record phrase. The LEFT OUTER-JOIN will not emit anything. It is going through conversion regression testing now.

LE: LEFT OUTER-JOIN is the same as OUTER-JOIN and will need to convert the same.

Properly handles the OUTER-JOIN and LEFT OUTER-JOIN to convert the same.

Passed conversion regression testing, committed to bzr revision 10328. I'll do a separate server folder conversion with this change tomorrow.