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

Informix translator - convert function in definition of view is not pushed down

    Details

      Description

      I defined a view (see definition below). When I try to select all rows from the view, teiid/informix jdbc driver throws an exception.

      Teiid DDL:

      CREATE VIEW U6 (StringCol string,
          IntCol integer)
        AS
          SELECT CONVERT(BQT1.SmallA.IntNum, string) AS StringCol, BQT1.SmallA.IntNum AS IntCol
          FROM BQT1.SmallA
          UNION ALL
          SELECT BQT1.SmallB.StringNum, CONVERT(BQT1.SmallB.StringNum, integer)
          FROM BQT1.SmallB;
      }
      

      Query:

      SELECT * FROM VQT.U6
      

      Source-specific query

      SELECT g_1.intnum AS c_0, g_1.intnum AS c_1 FROM smalla AS g_1 UNION ALL SELECT g_0.stringnum AS c_0, g_0.stringnum AS c_1 FROM smallb AS g_0
      

      Actual exception:

      Caused by: java.sql.SQLException: The statement failed because corresponding column data types must be compatible for each UNION, INTERSECT, or MINUS query.
      	at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
      	at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3178)
      ...
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jdurani Juraj Duráni
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: