db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2057) SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE documentation or implementation error on its arguments.
Date Wed, 08 Nov 2006 20:10:53 GMT
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

        

Mime
View raw message