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

Re-enable VTIs

    XMLWordPrintableJSON

Details

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

    Description

      Cloudscape used to expose Virtual Table Interfaces, by which any class which implemented ResultSet could be included in a query's FROM list. Derby still exposes a number of these VTIs as diagnostic tools. However, Derby now prevents customers from declaring their own VTIs. The parser raises an error if a VTI's package isn't one of the Derby diagnostic packages.

      This is a very powerful feature which customers can use to solve many problems. We should discuss the reasons that it was disabled and come up with a plan for putting this power back into our customers' hands.

      Attachments

        1. derby-716-01-basic-aa.diff
          110 kB
          Richard N. Hillegas
        2. derby-716-02-DatabaseMetaData-aa.diff
          36 kB
          Richard N. Hillegas
        3. derby-716-03-DatabaseMetaData-aa.diff
          3 kB
          Richard N. Hillegas
        4. derby-716-04-Optimizer-aa.diff
          18 kB
          Richard N. Hillegas
        5. derby-716-05-PublicAPI-aa.diff
          11 kB
          Richard N. Hillegas
        6. derby-716-06-TestEncoding-aa.diff
          1 kB
          Richard N. Hillegas
        7. derby-716-07-dblook-aa.diff
          3 kB
          Richard N. Hillegas
        8. derby-716-08-upgrade-aa.diff
          3 kB
          Richard N. Hillegas
        9. derby-716-09-upgradeLocalization-aa.diff
          0.6 kB
          Richard N. Hillegas
        10. derby-716-10-datatypesCollation-aa.diff
          23 kB
          Richard N. Hillegas
        11. derby-716-11-subqueries-aa.diff
          4 kB
          Richard N. Hillegas
        12. functionTables.html
          41 kB
          Richard N. Hillegas
        13. functionTables.html
          51 kB
          Richard N. Hillegas
        14. functionTables.html
          45 kB
          Richard N. Hillegas

        Issue Links

          incorporates

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3138 Optimizer error when vtis are invoked with correlated references to outer query blocks

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-3072 User documentation for Table Functions

          • Major - Major loss of function.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3135 TableFunctionTest fails with weme6.1 on trunk

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

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-1651 Develop a mechanism to migrate mySQL databases to Derby. Migration tool should include both schema and data migration options.

          • Major - Major loss of function.
          • In Progress

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-3129 Create Demo code, showing how to create and use table functions.

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3545 NullPointerException in TableFunctionTest.noSpecialCollation and specialCollation

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3595 TableFunctionTest.SpecialCollation and NoSpecialCollation fail with IBM iseries in checkGetXXXCalls

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3616 TableFunctionTest fails under Ubuntu 7.10

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              rhillegas Richard N. Hillegas
              rhillegas Richard N. Hillegas
              Votes:
              2 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: