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

TRUNCATE TABLE docs should state that it doesn't work for temporary tables

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.7.1.1, 10.7.1.4, 10.8.1.2
    • 10.8.1.2
    • Documentation
    • None
    • Newcomer

    Description

      ij> declare global temporary table t(i int) on commit preserve rows not logged;
      0 rows inserted/updated/deleted
      ij> insert into session.t values 1,2,3,4,5,6,7,8,9,10;
      10 rows inserted/updated/deleted
      ij> truncate table session.t;
      ERROR 42995: The requested function does not apply to global temporary tables.

      This limitation is not documented presently.

      Attachments

        1. derby-4943-a.diff
          0.7 kB
          Dag H. Wanvik
        2. rrefsqljtruncatetable.html
          3 kB
          Dag H. Wanvik

        Activity

          People

            dagw Dag H. Wanvik
            dagw Dag H. Wanvik
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: