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

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

    XMLWordPrintable

    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:

      Unable to find source-code formatter for language: text. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
      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: