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 "Yip Ng (JIRA)" <ji...@apache.org> on 2006/11/12 20:19:38 UTC
[jira] Assigned: (DERBY-2057)
SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE documentation or implementation
error on its arguments.
[ http://issues.apache.org/jira/browse/DERBY-2057?page=all ]
Yip Ng reassigned DERBY-2057:
-----------------------------
Assignee: Yip Ng
> SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE documentation or implementation error on its arguments.
> -----------------------------------------------------------------------------------------------
>
> Key: DERBY-2057
> URL: http://issues.apache.org/jira/browse/DERBY-2057
> Project: Derby
> Issue Type: Bug
> Components: Miscellaneous, Documentation, Javadoc
> Affects Versions: 10.2.1.6, 10.3.0.0
> Environment: Any
> Reporter: Yip Ng
> Assigned To: Yip Ng
>
> 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.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira