Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1411

Using CASE statements within transformations cause an NPE

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.1
    • 7.4.2
    • Transformations
    • None
    • Hide

      1. unzip CaseTest.zip into $workspace
      2. run JBDS 4.1.2
      3. import CaseTest project
      4. you can see an NPE in $workspace/.metadata/.log

      <snippet from .log>
      !ENTRY org.teiid.designer.transformation 4 0 2012-06-08 15:36:05.443
      !MESSAGE Error encountered while validating the transformation.
      !STACK 0
      java.lang.NullPointerException
      at org.teiid.query.resolver.util.ResolverUtil.getConversion(ResolverUtil.java:280)
      at org.teiid.query.resolver.util.ResolverUtil.convertExpression(ResolverUtil.java:225)
      at org.teiid.query.resolver.util.ResolverVisitor.resolveCompareCriteria(ResolverVisitor.java:664)
      at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:303)
      at org.teiid.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:123)
      at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:52)
      at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:140)

      Show
      1. unzip CaseTest.zip into $workspace 2. run JBDS 4.1.2 3. import CaseTest project 4. you can see an NPE in $workspace/.metadata/.log <snippet from .log> !ENTRY org.teiid.designer.transformation 4 0 2012-06-08 15:36:05.443 !MESSAGE Error encountered while validating the transformation. !STACK 0 java.lang.NullPointerException at org.teiid.query.resolver.util.ResolverUtil.getConversion(ResolverUtil.java:280) at org.teiid.query.resolver.util.ResolverUtil.convertExpression(ResolverUtil.java:225) at org.teiid.query.resolver.util.ResolverVisitor.resolveCompareCriteria(ResolverVisitor.java:664) at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:303) at org.teiid.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:123) at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:52) at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:140)
    • Low

    Description

      CASE clause within transformations causes SQL validation failure and an NPE.

      Attachments

        Activity

          People

            rhn-support-jolee Johnathon Lee
            rhn-support-hokuda Hisanobu Okuda
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: