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

Support diagnostic vti tables that take parameters, such as SpaceTable

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 10.3.1.4
    • SQL
    • None

    Description

      Expand the work of DERBY-571 to support the remaining diagnostic tables that take parameters.

      Syntax would use the table constructor, like (not sure if an 'AS' clause will be required:

      select * from TABLE(SYSCS_DIAG.SPACE_TABLE(?, ?))

      Diagnostic VTIs that could be handled this way are:

      ErrorLogReader(String log file name)
      SpaceTable(String tableName)
      SpaceTable(String schemaName, String tableName)
      StatementDuration(String inputFileName)

      This is the second stage mentioned in DERBY-571

      Attachments

        1. d2152_vtiMappingCleanup_v1.stat
          0.6 kB
          A B
        2. d2152_vtiMappingCleanup_v1.patch
          16 kB
          A B
        3. d2152_junit_jdk16_fix.patch
          1 kB
          A B
        4. junit-errors.txt
          6 kB
          Knut Anders Hatlen
        5. d2152_engine_v2.patch
          11 kB
          A B
        6. d2152_testing_v2.patch
          31 kB
          A B
        7. d2152_v2.stat
          0.9 kB
          A B
        8. d2152_engine_v1.patch
          7 kB
          A B
        9. d2152_testing_v1.patch
          29 kB
          A B
        10. d2152_v1.stat
          0.7 kB
          A B

        Issue Links

          depends upon

          Sub-task - The sub-task of the issue DERBY-1520 Document new SYSCS_DIAG tables

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-5554 NullPointerException in generated VTI code

          • Major - Major loss of function.
          • Closed

          Activity

            People

              army A B
              djd Daniel John Debrunner
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: