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

Enhance logic in PredicateList to use variant type of expression while determining search clauses or predicates, instead of using ConstantNode or ParameterNodes directly.

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.2.1.6
    • Fix Version/s: None
    • Component/s: SQL
    • Environment:
      generic
    • Urgency:
      Low

      Description

      Code in PredicateList can be enhanced to use variant type of expressions while determining whether a predicate qualifies to be a search clause or not.

      Currently code checks for ConstantNode or ParameterNode directly. It should also be possible to enhance this logic to cover constant expressions so that predicates like col = upper('ES5') would also be considered as search clauses. For a customer query in question, having col='ES5' in the query completes the query in about 20 seconds, where as col=upper('ES5') runs for a looong time. (more than several hours)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                bandaram Satheesh E. Bandaram
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated: