title: Amazon Redshift Error - ERROR: 0A000: Specified types or functions (one per INFO message) not supported on Redshift tables
body: <p>When running the below query:</p>
  
  <pre><code>WITH sublevels AS (
  SELECT 1 UNION ALL 
  SELECT 1 UNION ALL
  SELECT 1), FIELDA AS (SELECT (ROW_NUMBER() OVER ())::INT sublevel 
  FROM sublevels sl1, sublevels sl2, sublevels sl3)
  SELECT TOP 10 
  FIELDB, 
  sublevel, REPLACE(REGEXP_REPLACE(REGEXP_SUBSTR(UPPER(FIELDC), 'FROM \\S+', 1, sublevel), 'FROM ', ''),')','') ALIASA
  FROM TABLEA
  JOIN FIELDA ON sublevel &lt;= REGEXP_COUNT(UPPER(FIELDC), 'FROM ')
  WHERE ALIASA != 'ABC'
  AND lower(split_part(ALIASA, '.', 2)) IN (
  SELECT DISTINCT lower(t.table_name)
  FROM information_schema.tables t
  INNER JOIN information_schema.columns c on c.table_name = t.table_name AND c.table_schema = t.table_schema
  WHERE lower(column_name) similar TO '%(aaa|bbb|ccc)%')
  </code></pre>
  
  <p>I am getting the following error:</p>
  
  <blockquote>
    <p>ERROR: 0A000: Specified types or functions (one per INFO message) not supported on Redshift tables.</p>
  </blockquote>
  
  <p>I have no idea why, if I run the queries individually they work fine:</p>
  
  <p><strong>Query1</strong></p>
  
  <pre><code>WITH sublevels AS (
  SELECT 1 UNION ALL 
  SELECT 1 UNION ALL
  SELECT 1), FIELDA AS (SELECT (ROW_NUMBER() OVER ())::INT sublevel 
  FROM sublevels sl1, sublevels sl2, sublevels sl3)
  SELECT TOP 10 
  FIELDB, 
  sublevel, REPLACE(REGEXP_REPLACE(REGEXP_SUBSTR(UPPER(FIELDC), 'FROM \\S+', 1, sublevel), 'FROM ', ''),')','') ALIASA
  FROM TABLEA
  JOIN FIELDA ON sublevel &lt;= REGEXP_COUNT(UPPER(FIELDC), 'FROM ')
  WHERE ALIASA != 'ABC'
  </code></pre>
  
  <p><strong>Query2</strong></p>
  
  <pre><code>SELECT DISTINCT lower(t.table_name)
  FROM information_schema.tables t
  INNER JOIN information_schema.columns c on c.table_name = t.table_name AND c.table_schema = t.table_schema
  WHERE lower(column_name) similar TO '%(aaa|bbb|ccc)%'
  </code></pre>