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