[
https://issues.apache.org/jira/browse/DERBY-2057?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mike Matrigali resolved DERBY-2057.
-----------------------------------
Resolution: Fixed
patch submitted to trunk, marking issue fixed.
> SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE documentation or implementation error
> on its arguments.
> -----------------------------------------------------------------------------------------------
>
> Key: DERBY-2057
> URL: https://issues.apache.org/jira/browse/DERBY-2057
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.1.6, 10.3.0.0
> Environment: Any
> Reporter: Yip Ng
> Assigned To: Yip Ng
> Fix For: 10.3.0.0
>
> Attachments: derby2057-trunk-diff01.txt, derby2057-trunk-diff02.txt,
> derby2057-trunk-stat01.txt, derby2057-trunk-stat02.txt
>
>
> There seems to be an error on the SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
> documentation or the implementation itself when passing the following
> arguments:
> PURGE_ROWS
> If PURGE_ROWS is set to a *non-zero* value, then a single pass is made
> through the table which will purge committed deleted rows from the table.
> <snip>
> DEFRAGMENT_ROWS
> If DEFRAGMENT_ROWS is set to a *non-zero* value, then a single defragment
> pass is made which will move existing rows from the end of the table towards
> the front of the table.
> <snip>
> TRUNCATE_END
> If TRUNCATE_END is set to a *non-zero* value, then all contiguous pages
> at the end of the table will be returned to the operating system.
> <snip>
> The implementation only checks if the above arguments are 1s.
> org.apache.derby.iapi.db.OnlineCompress.compressTable(
> schema,
> tablename,
> (purgeRows == 1),
> (defragementRows == 1),
> (truncateEnd == 1));
> ...
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
