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: Documentation, Javadoc, Store
    Affects Versions: 10.2.1.6, 10.3.0.0
         Environment: Any
            Reporter: 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

        

Reply via email to