ROW_COUNT column in EXA_SQL_LAST_DAY and EXA_DBA_AUDIT_SQL for FETCH includes rows marked as deleted when importing from Exasol

Detail name	Value
Changelog Number	10629
Type	Bug
Status	Resolved
Affected Versions	EXASOL 6.0.0, Exasol 7.0.0
Fix Versions	Exasol 7.1.0
Resolution Date	2021-08-03

Description

When importing from a table in an Exasol database, if the source table contains rows marked as deleted, both EXA_SQL_LAST_DAY and EXA_DBA_AUDIT_SQL exhibit the following behavior:

• The row for IMPORT shows the correct number of rows in the ROW_COUNT column
• The row for FETCH shows as ROW_COUNT the rows marked as deleted in addition to the actual number of rows

Workaround

You can use the row count for IMPORT instead of FETCH in the statistics tables.

Fix

The row count for FECTH will show the correct row count and will not include rows marked as deleted, like with IMPORT