You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mike Matrigali (JIRA)" <ji...@apache.org> on 2007/01/25 02:08:49 UTC
[jira] Resolved: (DERBY-2057)
SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE documentation or implementation
error on its arguments.
[ 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.