-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
7.5
-
None
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE (BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND (BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.