Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1401

QueryRewriter issue with certain UDFs

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.3
    • 7.2
    • Query Engine
    • None
    • Workaround Exists
    • Hide

      The workaround is for the user to avoid UDFs starting with 'parse'

      Show
      The workaround is for the user to avoid UDFs starting with 'parse'

      Encountered NPE in QueryRewriter with the following stacktrace:

      java.lang.ArrayIndexOutOfBoundsException: 1
      at com.metamatrix.query.rewriter.QueryRewriter.simplifyParseFormatFunction(QueryRewriter.java:1690)
      at com.metamatrix.query.rewriter.QueryRewriter.simplifyWithInverse(QueryRewriter.java:1368)
      at com.metamatrix.query.rewriter.QueryRewriter.rewriteCriteria(QueryRewriter.java:1314)
      at com.metamatrix.query.rewriter.QueryRewriter.rewriteCriteria(QueryRewriter.java:1112)
      at com.metamatrix.query.rewriter.QueryRewriter.rewriteCriteria(QueryRewriter.java:1095)
      at com.metamatrix.query.rewriter.QueryRewriter.rewriteCriteria(QueryRewriter.java:1091)
      at com.metamatrix.query.optimizer.relational.rules.FrameUtil.convertCriteria(FrameUtil.java:537)

      The issue was traced back to usage of a UDF named 'parsedate_'. The QueryRewriter makes assumption about function starting with the word 'parse'. see next comment for more info.

            rhn-engineering-shawkins Steven Hawkins
            mdrillin1@redhat.com Mark Drilling (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: