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

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.1.3.1
    • Fix Version/s: 10.5.1.1
    • Component/s: SQL, Store
    • Labels:
      None
    • Issue & fix info:
      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
          2 kB
          Knut Anders Hatlen
        2. d1062-escape.diff
          5 kB
          Knut Anders Hatlen
        3. releaseNote.html
          4 kB
          Mamta A. Satoor

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: