Simple query with explicit Select list

******************* Query ****************************
Query:<SELECT empno, ename FROM emp>
********************* Parsed Query **********************
SELECT ( -1.empno), ( -1.ename),
FROM emp (-1),
 
********************* Validated Query **********************
SELECT ( 0.empno), ( 0.ename),
FROM SCHEMA.OAUSER.emp (0)( 0.empno, 0.ename, ::),
 
******************* End Validated Query ********************
 
********************* Query Result Specification **********************
Result Column:0 – Name:empno, XoType=4, Nullable=0, Precision = 10, Scale=0
Result Column:1 – Name:ename, XoType=12, Nullable=1, Precision = 32, Scale=0
 
********** Execution Plan for SIMPLE STMT *************
SELECT ( 0.empno), ( 0.ename),
FROM SCHEMA.OAUSER.emp (0)( 0.empno, 0.ename, ::),
 
-- Sub Query has no WHERE expression --
 
********** IP is being called to execute SubQuery on Table:<emp> with Search Column:<NULL>. hstmt:<0x6be880>
 
********************* Query Result Specification **********************
Result Column:0 – Name:empno, XoType=4, Nullable=0, Precision = 10, Scale=0
Result Column:1 – Name:ename, XoType=12, Nullable=1, Precision = 32, Scale=0