1. Derby
  2. DERBY-5822

Document the new SQL standard behavior of the SPACE_TABLE vti


    • Urgency:
    • Bug behavior facts:
      Deviation from standard


      We will want to improve the Reference Guide section on the SPACE_TABLE vti after we commit the derby-5554-02-aa-0argConstructor.diff attached to DERBY-5554. We will want to make the following changes:

      1) Describe the new TABLEID column which was added to SPACE_TABLE:

      Column Name: TABLEID
      Type: CHAR
      Length: 36
      Nullable: False
      Contents: The id of the table which the conglomerate belongs to.

      2) Describe the additional no-arg constructor for this vti. There are now 3 ways to construct this vti:

      i) No args. This is the new constructor which needs to be described. When the vti is invoked with no arguments, it retrieves space information for all tables and indexes in the database.

      ii) One argument. This constructor is already described. If the vti is invoked with one string argument, then that argument is the name of a table in the current schema.

      iii) Two arguments. This constructor is already described also. When the vti is invoked with two string arguments, the first argument is a schema name and the second argument is a table name.

      3) Replace the first SPACE_TABLE example. That example uses Derby-specific syntax which falls outside the SQL Standard. Showcasing non-standard syntax encourages users to try out other non-standard syntax, giving rise to bugs like DERBY-5554. We should showcase the following standard syntax instead:

      select t2.*
      sys.systables systabs,
      table (syscs_diag.space_table()) as t2
      where systabs.tabletype = 'T'
      and systabs.tableid = t2.tableid;

      1. DERBY-5822.diff
        3 kB
        Kim Haase
      2. rrefsyscsdiagtables.html
        24 kB
        Kim Haase

        Issue Links


          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-5554 [ DERBY-5554 ]
          Kim Haase made changes -
          Assignee Kim Haase [ chaase3 ]
          Kim Haase made changes -
          Attachment rrefsyscsdiagtables.html [ 12533052 ]
          Attachment DERBY-5822.diff [ 12533053 ]
          Kim Haase made changes -
          Issue & fix info Patch Available [ 10102 ]
          Kim Haase made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Issue & fix info Patch Available [ 10102 ]
          Fix Version/s [ 12318540 ]
          Fix Version/s [ 12321551 ]
          Fix Version/s [ 12321550 ]
          Resolution Fixed [ 1 ]
          Kim Haase made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kathey Marsden made changes -
          Fix Version/s [ 12323456 ]
          Fix Version/s [ 12318540 ]
          Kathey Marsden made changes -
          Fix Version/s [ 12323562 ]
          Fix Version/s [ 12321551 ]
          Gavin made changes -
          Workflow jira [ 12707859 ] Default workflow, editable Closed status [ 12802084 ]


            • Assignee:
              Kim Haase
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              3 Start watching this issue


              • Created: