PRB: _Tally System Variable Reports Incorrect Record Count

MORE INFORMATION

The code example below creates two tables and populates them with one and three records, respectively. After creating an index on the second table, the APPEND FROM command adds records based on the results of the SEEK command. The SEEK command, however, moves the record pointer while records are being added, which causes _TALLY to return an incorrect value.

Steps to Reproduce Behavior

Create a program with the following code and run it:

   CREATE TABLE test1 (fld1 c(10))
   CREATE TABLE test2 (fld1 c(10))
   INSERT INTO test2 (fld1) VALUES ('AA')
   INSERT INTO test1 (fld1) VALUES ('AA')
   INSERT INTO test1 (fld1) VALUES ('AA')
   INSERT INTO test1 (fld1) VALUES ('BB')
   SELECT test2
   INDEX ON fld1 TAG fld1
   APPEND FROM test1 FOR NOT SEEK(fld1,'test2')
   ? _TALLY
				

_TALLY returns zero (0) instead of 2.