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

Extend the Table Functions java interface to pass more query context information from Derby

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.8.3.0
    • Fix Version/s: None
    • Component/s: SQL
    • Urgency:
      Urgent
    • Issue & fix info:
      High Value Fix

      Description

      General requirement is to extend the Table Functions java interface (through RestrictedVTI or another interface) and pass more context information from Derby to Table Functions - esp in query execution phase.

      Greater urgency is required for the first 2 items below, especially the ability to access the original SQL which was available with VTIs. This is critical to the GaianDB project - we extract HINTs from the query (where we pass meta data like user credentials), and also extract full original complex predicate expressions (involving functions etc - which cannot be expressed with a Restriction) - to push on in our query prorogation...

      In order of importance + simplicity:
      --------------------------------------------------
      1 - Original SQL (this used to be available with VTIs through VTIEnvironment for both compilation and execution phases)
      2 - Name of function that was called

      3 - User Info (ID, etc) - (this can currently be passed in the SQL hint)
      4 - Richer predicate expressions (incl functions, etc)
      5 - Context within Join query (e.g. inner or outer table, join type)
      6 - Other Query Plan information
      7 - Anything else...?

        Attachments

        1. derby-6117-01-aa-AwareVTI.diff
          23 kB
          Richard N. Hillegas
        2. derby-6117-01-ab-AwareVTI.diff
          23 kB
          Richard N. Hillegas
        3. derby-6117-02-aa-changeColumnNamesInStringColumnVTI.diff
          6 kB
          Richard N. Hillegas
        4. derby-6117-03-aa-ArchiveVTI.diff
          26 kB
          Richard N. Hillegas
        5. derby-6117-04-aa-improveJavadoc.diff
          0.9 kB
          Richard N. Hillegas

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                drv David Vyvyan
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: