left joins in QV11 and QV12 work differently

[sangland2]

Hi,

Can someone please explain why in QV11 I get one row in my resulting table, but in QV12 I get two with this script:

Calendar:

LOAD * INLINE [

    calendarID,name

    2000,March Financial Year

];

left join

LOAD * INLINE [

    oid,calendarID,year

    1000,2000,'31/03/15'

    1001,2000,'31/03/16'

];

In SQL and QV11 both a left join and inner join would return two rows.

Left or Right keep join will return two rows but only one row will have the calendar name value.

In QV12 is appears to be necessary to create two separate tables to achieve the name result.

[rwunderlich · Accepted solution]

In both QV11 and QV12 I get two rows.

There was a bug back  in QV12Sr1 that matches what you are describing.  What release of QV12 are you using?

-Rob

[sangland2]

Version12.0.20001.0 SR1 64-bit. I have upgraded to QV12.10.20600.0 SR8 and all sorted. thanks