Comment 15 for bug 1396793

Verified on the v0117 build. This problem is now fixed:

>>set schema g_hcubedb;

--- SQL operation complete.
>>
>>prepare s13 from select count(*) from trafodion.g_hcubedb.T1,trafodion.g_hcubedb.T2,trafodion.g_hcubedb.T3,trafodion.g_hcubedb.T4,trafodion.g_hcubedb.T5,trafodion.g_hcubedb.T6,trafodion.g_hcubedb.T7,trafodion.g_hcubedb.T8,trafodion.g_hcubedb.T9,trafodion.g_hcubedb.CUBE1 where
+>trafodion.g_hcubedb.CUBE1.a=trafodion.g_hcubedb.T9.a and trafodion.g_hcubedb.CUBE1.b=trafodion.g_hcubedb.T8.b and trafodion.g_hcubedb.CUBE1.c=trafodion.g_hcubedb.T7.c and
+>trafodion.g_hcubedb.T9.b=trafodion.g_hcubedb.T1.b and trafodion.g_hcubedb.T9.c=trafodion.g_hcubedb.T2.c and
+>trafodion.g_hcubedb.T8.a=trafodion.g_hcubedb.T3.a and trafodion.g_hcubedb.T8.c=trafodion.g_hcubedb.T4.c and
+>trafodion.g_hcubedb.T7.a=trafodion.g_hcubedb.T5.a and trafodion.g_hcubedb.T7.b=trafodion.g_hcubedb.T6.a;

--- SQL command prepared.
>>
>>explain options 'f' s13;

LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------

23 . 24 root 1.00E+000
22 . 23 sort_scalar_aggr 1.00E+000
21 1 22 hybrid_hash_join 1.00E+001
20 2 21 hybrid_hash_join 1.00E+001
19 3 20 hybrid_hash_join 1.00E+003
18 4 19 hybrid_hash_join 1.00E+002
17 5 18 hybrid_hash_join 1.00E+002
16 6 17 hybrid_hash_join 1.00E+003
15 7 16 hybrid_hash_join 1.00E+003
14 8 15 hybrid_hash_join 1.00E+002
9 13 14 nested_join 1.00E+002
10 12 13 nested_join 1.00E+001
11 . 12 probe_cache 1.00E+000
. . 11 trafodion_scan T9 1.00E+000
. . 10 trafodion_index_scan T9 1.00E+001
. . 9 trafodion_scan T1 1.00E+001
. . 8 trafodion_scan T2 1.00E+001
. . 7 trafodion_index_scan CUBE1 1.00E+005
. . 6 trafodion_scan T7 1.00E+002
. . 5 trafodion_scan T5 1.00E+001
. . 4 trafodion_scan T6 1.00E+002
. . 3 trafodion_scan T8 1.00E+003
. . 2 trafodion_scan T3 1.00E+001
. . 1 trafodion_scan T4 1.00E+001

--- SQL operation complete.
>>
>>execute s13;

(EXPR)
--------------------

                1000

--- 1 row(s) selected.
>>
>>set parserflags 1;

--- SQL operation complete.
>>select count(*) from table(index_table IXCUBE1F);

(EXPR)
--------------------

              100000

--- 1 row(s) selected.
>>select count(*) from table(index_table IXCUBE1E);

(EXPR)
--------------------

              100000

--- 1 row(s) selected.
>>select count(*) from table(index_table IXCUBE1D);

(EXPR)
--------------------

              100000

--- 1 row(s) selected.
>>select count(*) from cube1;

(EXPR)
--------------------

              100000

--- 1 row(s) selected.