• Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s:
    • Component/s: SQL
    • Labels:


      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.


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

          Issue Links



              • Assignee:
                rhillegas Rick Hillegas
                rhillegas Rick Hillegas
              • Votes:
                2 Vote for this issue
                1 Start watching this issue


                • Created: