Assert Code: 1000 thrown by redshift

[Gaurav Shetti]

Version: PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.7078

Query:

SELECT
   t_32.color_gbakc4 AS color,
   t_32.country_gbakc5 AS country,
   t_32.gender_gbakc6 AS gender,
   t_32.sum_sales_amount_o_gbakc7 AS sum_sales_amount_ok
FROM
(
   SELECT
      SUBSTRING(REGEXP_SUBSTR(factinternetsales_t22.product_info, 'color:([^,]+)'), 7) AS color_gbakc4,
      t_25.englishcountryregi_c26 AS country_gbakc5,
      dimgender_t29.gendername AS gender_gbakc6,
      CAST(SUM(factinternetsales_t22.salesamount) AS FLOAT8) AS sum_sales_amount_o_gbakc7,
      SUBSTRING(REGEXP_SUBSTR(factinternetsales_t22.product_info, 'color:([^,]+)'), 7) AS color_gbakc1,
      t_25.englishcountryregi_c26 AS country_gbakc2,
      dimgender_t29.genderkey AS gender_gbakc3
   FROM
      as_adventure.factinternetsales AS factinternetsales_t22
   JOIN
      as_adventure.dimcustomer AS dimcustomer_t23
   ON
      factinternetsales_t22.customerkey = dimcustomer_t23.customerkey
   JOIN
   (
      SELECT
         concat(dimgeography_t24.stateprovincename, dimgeography_t24.englishcountryregionname) AS c_28,
         dimgeography_t24.englishcountryregionname AS englishcountryregi_c26,
         dimgeography_t24.geographykey AS geographykey_c27
      FROM
         as_adventure.dimgeography AS dimgeography_t24
      GROUP BY
         1,
         2,
         3
   ) AS t_25
   ON
      dimcustomer_t23.geographykey = t_25.geographykey_c27
   JOIN
      as_adventure.dimgender AS dimgender_t29
   ON
      dimcustomer_t23.gender = dimgender_t29.genderkey
   RIGHT OUTER JOIN
      as_adventure.dimdate AS dimdate_t30
   ON
      factinternetsales_t22.orderdatekey = dimdate_t30.datekey
   JOIN
   (
      SELECT
         t_7.c_10 AS state_topnc1,
         CAST(SUM(factinternetsales_t4.orderquantity) AS BIGINT) AS order_quantity_topnc2
      FROM
         as_adventure.factinternetsales AS factinternetsales_t4
      JOIN
         as_adventure.dimcustomer AS dimcustomer_t5
      ON
         factinternetsales_t4.customerkey = dimcustomer_t5.customerkey
      JOIN
      (
         SELECT
            concat(dimgeography_t6.stateprovincename, dimgeography_t6.englishcountryregionname) AS c_10,
            dimgeography_t6.geographykey AS geographykey_c8,
            dimgeography_t6.stateprovincename AS stateprovincename_c9
         FROM
            as_adventure.dimgeography AS dimgeography_t6
         GROUP BY
            1,
            2,
            3
      ) AS t_7
      ON
         dimcustomer_t5.geographykey = t_7.geographykey_c8
      WHERE
         (LOWER(t_7.stateprovincename_c9) ~ '.*er.*')
      GROUP BY
         1
      ORDER BY
         2 DESC NULLS LAST
      LIMIT 10
   ) AS t_31
   ON
      t_31.state_topnc1 = t_25.c_28
   WHERE
      SUBSTRING(REGEXP_SUBSTR(factinternetsales_t22.product_info, 'color:([^,]+)'), 7) IN ('Blue', 'Multi', 'White')
   AND
      dimdate_t30.calendaryear IN (2006, 2008, 2010)
   GROUP BY
      1,
      2,
      3,
      5,
      6,
      7
) AS t_32
ORDER BY
   1 ASC NULLS FIRST,
   2 ASC NULLS FIRST,
   3 ASC NULLS FIRST

Error
Details:
 -----------------------------------------------
  error: Assert
  code: 1000
  context: distinct_vars.entries == before - distinct_vars.entries=4, before=3.
  query: 11068925
  location: step_project.cpp:489
  process: padbmaster [pid=8963]
  -----------------------------------------------;))]

This query used to work before. Not sure if redshift was currently updated.