Relational Indexes AR (OpenInsight 32-bit)
At 20 OCT 2023 03:18:28AM Barry Stevens wrote:
OI9.4.6.
Is there a know issue or a fix I have missed:
I have a relational index set as 'Ascending Right' that is sorting in alpha sequence. I see:
513*1
513*10
513*11
513*12
513*13
513*14
513*15
513*16
513*17
513*18
513*19
513*2
513*20
513*21
513*3
Dict fld23 of the source table shows: VENDORS*ITEMS*AR, the above is in ITEMS data field of the destination data table
At 20 OCT 2023 08:33AM bob carten wrote:
It's a known issue. It affects sorted relational indexes on a table with a multi part key. It was introduced when I made changes to remove the 64k limit and improve update speed for relationals. I have a fix I can send you.
The issue is fixed in the latest OI10.
At 20 OCT 2023 03:59PM Barry Stevens wrote:
It's a known issue. It affects sorted relational indexes on a table with a multi part key. It was introduced when I made changes to remove the 64k limit and improve update speed for relationals. I have a fix I can send you.
The issue is fixed in the latest OI10.
Thanks Bob, that fixed it.