TDBF: Calculated index with -1*<field> fails
Original Reporter info from Mantis: BigChimp
-
Reporter name: Reinier Olislagers
Original Reporter info from Mantis: BigChimp
- Reporter name: Reinier Olislagers
Description:
See attached demo program.
Code:
NewDBF.FieldDefs.Add('CUST_NO', ftInteger);
NewDBF.FieldDefs.Add('CUSTOMER', ftString, 25);
NewDBF.AddIndex('IDXCOMPO','CUSTOMER,(STR(CUST_NO*-1))',[ixCaseInsensitive]);
tried with various permutations of adding ()
Expected: the 5 records in the dbf sorted first on customer, then descending customer number
Actual: the 5 records in the dbf sorted first on customer then apparently ascending customer number
To do: investigate/correlate with dbtestframework test cases/other bug reports
Mantis conversion info:
- Mantis ID: 25533
- Build: 26455
- Version: 2.7.1