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

Redshift - RS does not support ASCII function

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (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:

      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: 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: