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

SYSCS_DIAG.SPACE_TABLE sample query to show all tables and indexes should include schema

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 10.10.1.1
    • Fix Version/s: 10.10.2.0, 10.11.1.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      It would be good if the sample query for SYSCS_DIAG.SPACE_TABLE also showed the schema name as that will be required by SYSCS_UTIL.SYSCS_COMPRESS_TABLE if the tables are compressed.

      The doc page as at:
      http://db.apache.org/derby/docs/10.10/ref/rrefsyscsdiagspacetable.html

      The query for all tables and indexes could be:

      SELECT sysschemas.schemaname, T2.*
      FROM
      SYS.SYSTABLES systabs, SYS.SYSSCHEMAS sysschemas,
      TABLE (SYSCS_DIAG.SPACE_TABLE()) AS T2
      WHERE systabs.tabletype = 'T'
      AND sysschemas.schemaid = systabs.schemaid
      AND systabs.tableid = T2.tableid;

        Attachments

        1. DERBY-6415.diff
          1 kB
          Camilla Haase
        2. rrefsyscsdiagspacetable.html
          11 kB
          Camilla Haase

          Activity

            People

            • Assignee:
              chaase3 Camilla Haase
              Reporter:
              kmarsden Katherine Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: