Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.7.1.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      As part of DERBY-268, we should document the TRUNCATE command. This involves adding a small section to the Reference Guide.

      1. docs.diff
        3 kB
        Bryan Pendleton
      2. rrefsqljtruncatetable.html
        3 kB
        Bryan Pendleton

        Issue Links

          Activity

          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue is part of DERBY-268 [ DERBY-268 ]
          Bryan Pendleton made changes -
          Assignee Bryan Pendleton [ bryanpendleton ]
          Hide
          Bryan Pendleton added a comment -

          Here's a first stab at a manual page for TRUNCATE TABLE.

          i'm currently having some build problems with my docs build.
          When I get those resolved, I'll attach the HTML-formatted page.

          Show
          Bryan Pendleton added a comment - Here's a first stab at a manual page for TRUNCATE TABLE. i'm currently having some build problems with my docs build. When I get those resolved, I'll attach the HTML-formatted page.
          Bryan Pendleton made changes -
          Attachment docs.diff [ 12454945 ]
          Hide
          Bryan Pendleton added a comment -

          Adding ANT_OPTS=-x512m to my docs build seems to work
          around the out-of-memory problem I was experiencing.

          Attached is an initial version of a TRUNCATE TABLE reference page,
          formatted as HTML.

          Are there specific details about TRUNCATE TABLE that we
          want to make sure that we mention on the docs page?

          Show
          Bryan Pendleton added a comment - Adding ANT_OPTS=-x512m to my docs build seems to work around the out-of-memory problem I was experiencing. Attached is an initial version of a TRUNCATE TABLE reference page, formatted as HTML. Are there specific details about TRUNCATE TABLE that we want to make sure that we mention on the docs page?
          Bryan Pendleton made changes -
          Attachment rrefsqljtruncatetable.html [ 12454954 ]
          Hide
          Rick Hillegas added a comment -

          Thanks for the patch, Bryan. Your new ref guide entry points out that TRUNCATE TABLE operates quickly and can only be issued by the owner or the dbo. I can't think of other behaviors which we would want to call out here. +1.

          Show
          Rick Hillegas added a comment - Thanks for the patch, Bryan. Your new ref guide entry points out that TRUNCATE TABLE operates quickly and can only be issued by the owner or the dbo. I can't think of other behaviors which we would want to call out here. +1.
          Hide
          Bryan Pendleton added a comment -

          Thanks for the review, Rick!

          Committed to the docs trunk as revision 999219.

          Show
          Bryan Pendleton added a comment - Thanks for the review, Rick! Committed to the docs trunk as revision 999219.
          Bryan Pendleton made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Rick Hillegas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12520696 ] Default workflow, editable Closed status [ 12799751 ]

            People

            • Assignee:
              Bryan Pendleton
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development