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

Redshift - RS does not support ASCII function

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.12.3
    • Fix Version/s: 8.13, 8.12.4
    • Component/s: JDBC Connector
    • Labels:
      None
    • Environment:

      driver - PostgreSQL 9.2
      translator - postgresql

    • Steps to Reproduce:
      Hide

      VDB:

      <vdb name="test" version="1">
          <model name="Source" type="PHYSICAL">
              <source name="rs" connection-jndi-name="java:/Redshift" translator-name="postgresql"/>
              <metadata type="DDL">
                  <![CDATA[create foreign table SmallA (
                      intkey integer OPTIONS(NAMEINSOURCE 'intkey', NATIVE_TYPE 'int4'),
                      timevalue timestamp OPTIONS(NAMEINSOURCE 'timevalue', NATIVE_TYPE 'timestamp')) OPTIONS(NAMEINSOURCE 'smalla');
                  ]]>
              </metadata>
          </model>
      </vdb>
      

      Show
      VDB: < vdb name = "test" version = "1" > < model name = "Source" type = "PHYSICAL" > < source name = "rs" connection-jndi-name = "java:/Redshift" translator-name = "postgresql" /> < metadata type = "DDL" > <![CDATA[create foreign table SmallA ( intkey integer OPTIONS(NAMEINSOURCE 'intkey', NATIVE_TYPE 'int4'), timevalue timestamp OPTIONS(NAMEINSOURCE 'timevalue', NATIVE_TYPE 'timestamp')) OPTIONS(NAMEINSOURCE 'smalla'); ]]> </ metadata > </ model > </ vdb >
    • Bugzilla Update:
      Perform

      Description

      Redshift database does not support ASCII function

      E.g. SELECT INTKEY, ASCII(INTKEY) FROM BQT1.SmallA ORDER BY INTKEY is translated as SELECT g_0.intkey AS c_0, ascii(cast(g_0.intkey AS varchar(4000))) AS c_1 FROM smalla AS g_0 ORDER BY c_0

      Result:

      Caused by: org.postgresql.util.PSQLException: ERROR: Specified types or functions (one per INFO message) not supported on Redshift tables.
      

        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: