1. Description

SQLSELECT: Last fields in the query are not returned

Fix issue of last 2 columns being lost when running in jDP style mode.

This is dependent on…

• No extended dictionary’s defined
• No associations defined
• Environment Variable DONT_EXPAND_NONE_ASSOCATED_MV is set.

Overall this behavior should do nothing more than only return the first MV.

2. Previous Release Behavior

Previously, if you were to do:

>mkjdpdemofile
How many records do you want : 10
What filename would you like : MYTEST

>set DONT_EXPAND_NONE_ASSOCATED_MV=1

>SQLSELECT RECID,EMAIL,HARDWARE,OS,SYSTEMTYPE,NUMUSERS FROM MYTEST
RECID          EMAIL                  HARDWARE        OS              SYSTEMTYPE               NUMUSE
-------------- ---------------------- --------------- --------------- ------------------------ ------
       0000002 AMANDAJ@jbase.com      SPARC           HPUX            
…
       0000003 HERVED@jbase.com       COMPAQ          NT              
Selected 10 rows.

The last two column results would be missing.

3. Current Release Behavior

RECID          EMAIL                  HARDWARE        OS              SYSTEMTYPE               NUMUSE
-------------- ---------------------- --------------- --------------- ------------------------ ------
       0000002 AMANDAJ@jbase.com      SPARC           HPUX            IN2                      713
…
       0000003 HERVED@jbase.com       COMPAQ          NT              ROS                      1851
Selected 10 rows.