[ http://issues.apache.org/jira/browse/DERBY-2057?page=all ]
Mike Matrigali updated DERBY-2057:
----------------------------------
Fix Version/s: 10.3.0.0
Derby Info: (was: [Patch Available])
committed derby2057-trunk-diff02.txt patch to trunk:
r475330 | mikem | 2006-11-15 09:53:45 -0800 (Wed, 15 Nov 2006) | 10 lines
DERBY-2057
contributed by Yip Ng
patch: derby2057-trunk-diff02.txt
Fixed SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE() implementation to match
documentation. Arguments should treat non-zero as "true", previous to this
fix only "1" was treated as true.
> 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: 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.
-
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
