Comment 2 for bug 1364575

Revision history for this message
Weishiun Tsai (wei-shiun-tsai) wrote :

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.
>>