RLIST exploding sort (OpenInsight 64-bit)
At 25 APR 2024 06:58:59AM Nick Stevenson wrote:
I have a table EXPENSE with a multi-valued column EXPENSE_TYPE.
In OI9 I had an RLIST statement "LIST EXPENSE BY EXPENSE_TYPE…" which returned the correct result.
In OI10 I find it duplicates MV info. So if the EXPENSE row has 4 MV'd instances of EXPENSE_TYPE, RLIST is coming back with 16 rows, each MV instance duplicated 4 times.
If I remove the "BY EXPENSE_TYPE " it correctly comes back with 4 rows.
Is there a keyword that will stop this behaviour or is it an OI10 feature?
At 25 APR 2024 08:50AM bob carten wrote:
That's a bug. It will be fixed for 10.2.2