Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1062

Change the internal implemetation of SYSCS_INPLACE_COMPRESS_TABLE to share existing alter table

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.1.3.1
    • 10.5.1.1
    • SQL, Store
    • None
    • Release Note Needed

    Description

      Change the internal implemetation of SYSCS_INPLACE_COMPRESS_TABLE to share existing alter table
      code. One suggested approach is to use the same mechanism as SYSCS_COMPRESS_TABLE. Such
      an implementation would involve:
      o change the parser for alter table to accecpt some internal only syntax for SYSCS_INPLACE_COMPRESS_TABLE
      o change the alter table constant action to get the required information for inplace compress
      o move most of the inplace compress driving code to a routine in alter table execution, following the same
      coding pattern as existing alter table compress.

      I believe doing this will have multiple benefits:
      1) shares existing alter table code, so things like error checking, security management, ... is all done by one piece of code
      2) by sharing the code I believe the following outstanding JIRA issues will be addressed: DERBY-719, DERBY-720 -
      3) future changes addressing ddl like grant/revoke will automatically work.

      Attachments

        1. d1062-escape.diff
          5 kB
          Knut Anders Hatlen
        2. d1062-escape.diff
          2 kB
          Knut Anders Hatlen
        3. releaseNote.html
          4 kB
          Mamta A. Satoor

        Activity

          People

            mamtas Mamta A. Satoor
            mikem Mike Matrigali
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: