1858 PACK INDEX FOR Tablename

[Harlan Haynie]

From time to time, I encounter database corruption, particularly on inserts done by WiTango, such that for the table that was to be inserted, the row count returned by list table tablename is different than the row count returned by select count(*) from tablename.  Subsequent inserts fail with a “warning values for rows must be unique”, because the table to be inserted has a PK on it.   In build 1858, Wayne has provided an enhancement to the “PACK” command.  You can do PACK INDEX FOR tablename, and the pack command will figure out what is necessary to pack all the indexes and constraints (such as PKs), and will quickly execute even in a MULTI USER ENVIRONMENT with MULTI ON, under heavy database usage.  The command will correct the row count discrepancy and the next insert will work just fine.   PACK INDEX FOR Tablename with MULTI ON is one of several new “rocket science” tools that come with 1858 for 6.5++.  Thanks Wayne.   Harlan