3296722 - Querying table returns different value, select count(*) returns an inaccurate value in an archive database -ASE

• Using an archive database
• bcp out of an archive database shows 

144609 rows copied.
Clock Time (ms.): total = 649 Avg = 0 (222818.18 rows per sec.)

• bcp in to a traditional table shows 144609 rows
• select count(*) in the archive database is missing 6 row

select count(*) from <table>
go

-----------
144603

• select count(*) from <table> (0) - forces a scan on indid 0 returns correct number of rows in the archive database

.1> select count(*) from <table> (0)
 2> go

-----------     
144609

SAP Adaptive Server Enterprise (ASE) 16.0

corruption, archive, index scan, table scan , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem