Verified on the v0909_0830 build installed on a workstation. This problem has been fixed:
>>create table t (a int, b int, c int);
--- SQL operation complete. >> >>create index myindex on t (a, b, c);
--- SQL operation complete. >> >>upsert using load into table t values (1, 1, 1), (2, 2, 2), (3, 3, 3);
--- 3 row(s) inserted. >> >>prepare xx from select * from t;
--- SQL command prepared. >> >>explain options 'f' xx;
LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- ---------
1 . 2 root 1.00E+002 . . 1 trafodion_index_scan T 1.00E+002
--- SQL operation complete. >> >>execute xx;
A B C ----------- ----------- -----------
1 1 1 2 2 2 3 3 3
--- 3 row(s) selected. >> >>set parserflags 1;
--- SQL operation complete. >> >>select * from table(INDEX_TABLE myindex);
A@ B@ C@ SYSKEY ----------- ----------- ----------- --------------------
1 1 1 140219451826616608 2 2 2 140219451826619302 3 3 3 140219451826620069
--- 3 row(s) selected. >>
Verified on the v0909_0830 build installed on a workstation. This problem has been fixed:
>>create table t (a int, b int, c int);
--- SQL operation complete.
>>
>>create index myindex on t (a, b, c);
--- SQL operation complete.
>>
>>upsert using load into table t values (1, 1, 1), (2, 2, 2), (3, 3, 3);
--- 3 row(s) inserted.
>>
>>prepare xx from select * from t;
--- SQL command prepared.
>>
>>explain options 'f' xx;
LC RC OP OPERATOR OPT DESCRIPTION CARD ------- ------ -------- ------- ------- ------ ---------
---- ---- ---- -------
1 . 2 root 1.00E+002 index_scan T 1.00E+002
. . 1 trafodion_
--- SQL operation complete.
>>
>>execute xx;
A B C
----------- ----------- -----------
1 1 1
2 2 2
3 3 3
--- 3 row(s) selected.
>>
>>set parserflags 1;
--- SQL operation complete.
>>
>>select * from table(INDEX_TABLE myindex);
A@ B@ C@ SYSKEY ------- ------
----------- ----------- ----------- -------
1 1 1 140219451826616608
2 2 2 140219451826619302
3 3 3 140219451826620069
--- 3 row(s) selected.
>>