[ http://issues.apache.org/jira/browse/DERBY-2057?page=all ]
Mike Matrigali updated DERBY-2057: ---------------------------------- i'll look at committing this fix. > 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 > Attachments: derby2057-trunk-diff01.txt, derby2057-trunk-stat01.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
