Re: Question regarding secondary indexes

Hi Venkat, I believe this issue has been fixed in PHOENIX-2601. Please give our 4.7.0 a try as this fix is included there. Thanks, James On Friday, January 22, 2016, Venkat Raman wrote: > Hi All, > > We are using secondary indexes and see the following issue. Consider main >

Re: Question regarding secondary indexes

Hi James, Thanks. This is what i was looking for, guess i have not looked recently. Venkat On Sat, Jan 23, 2016 at 8:37 AM, James Taylor wrote: > Hi Venkat, > I believe this issue has been fixed in PHOENIX-2601. Please give our > 4.7.0 a try as this fix is included

Question regarding secondary indexes

Hi All, We are using secondary indexes and see the following issue. Consider main table ACT with primary key (K1, K2, K3) and column M1 and secondary index of form - CREATE INDEX IF NOT EXISTS act_idx ON ACT(K1, K3, K2); Then query of the following form gives incorrect results - select /*+