PN5_50488


Patch Number

Ticket Number

Change type

5_50488

738910

Patch

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…

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 [email protected]      SPARC           HPUX            
       0000003 [email protected]       COMPAQ          NT              
Selected 10 rows.

The last two column results would be missing.

3. Current Release Behavior

RECID          EMAIL                  HARDWARE        OS              SYSTEMTYPE               NUMUSE
-------------- ---------------------- --------------- --------------- ------------------------ ------
       0000002 [email protected]      SPARC           HPUX            IN2                      713
       0000003 [email protected]       COMPAQ          NT              ROS                      1851
Selected 10 rows.