RList MV Sort Bug in OI 4.0.3 (OpenInsight 32-bit Specific)
At 19 NOV 2003 04:12:22PM Richard Guise wrote:
A nasty and embarrassing little bug in OI 4.0.3. I don't know if it's documented.
I have a symbolic MV field which finds neither, one or both of the year(s) of two next events (internal/external property redecoration dates). Thus it may be null, have a single value or two values.
In a report I sort on this field and secondarily on a different single valued field (the property name).
In the first part of the report where the mv field is null, the secondary sort doesn't work (the property names come out random). Where the MV field is non-null (either one or two values), it all works fine (split by date and sorted within each date by name).
If I alter the field so that, instead of null it returns zero (nulled by MDZ oconv) then it all works fine.
Doing the same in OI 4.1.3 everything works fine with null mv value.
OK once we've toured the UK upgrading our users from 4.0.3 to 4.1.3! I haven't tested with 3.7.5 (for those users who haven't paid the penalty to go 32 bit!).