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

Using CASE statements within transformations cause an NPE

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.4.2
    • Fix Version/s: 8.1
    • Component/s: Transformations
    • Labels:
      None
    • Environment:

      Teiid Designer Version: 7.4.2 bundled in JBoss Developer Studio 4.1.2.GA

    • Steps to Reproduce:
      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)
    • Estimated Difficulty:
      Low
    • Bugzilla Update:
      Perform

      Description

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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jolee Johnathon Lee
                Reporter:
                hisanobu.okuda Hisanobu Okuda
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: