[teiid-issues] [JBoss JIRA] Created: (TEIID-1436) Error Msg provides no useful information - Actual error msg being lost

[Warren Gibson (JIRA)]

Error Msg provides no useful information - Actual error msg being lost
----------------------------------------------------------------------

                 Key: TEIID-1436
                 URL: https://issues.jboss.org/browse/TEIID-1436
             Project: Teiid
          Issue Type: Bug
          Components: Integration Tests
            Reporter: Warren Gibson
            Assignee: Van Halbert
            Priority: Minor


Query testing is getting the following error message on some queries where an exception is expected.  This actual error message below provides no useful information.  As you can see the expected error message below provide more meaningful information.  It appears the actual error message is being lost.

<?xml version="1.0" encoding="UTF-8"?>
<root>
  <queryResults name="RDBMS_Test_Queries_9550_TestQuery46" value="SELECT IntKey FROM BQT1.SmallA WHERE BQT1.SmallA.StringKey IN (SELECT IntNum FROM BQT1.SmallB) ORDER BY IntKey">
    <actual_exception>
      <exceptionType>TeiidSQLException</exceptionType>
      <message>Error trying to execute a statement SELECT IntKey FROM BQT1.SmallA WHERE BQT1.SmallA.StringKey IN (SELECT IntNum FROM BQT1.SmallB) ORDER BY IntKey.</message>
      <class>org.teiid.jdbc.TeiidSQLException</class>
    </actual_exception>
    <expected_exception>
      <exceptionType>TeiidSQLException</exceptionType>
      <message>Error Code:ERR.015.008.0033 Message:The left expression must have a type convertible to the type of the subquery projected symbol: BQT1.SmallA.StringKey IN (SELECT IntNum FROM BQT1.SmallB)</message>
      <class>org.teiid.jdbc.TeiidSQLException</class>
    </expected_exception>
  </queryResults>
</root>



-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira