Assert Code: 1000 thrown by redshift
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Redshift |
New
|
Undecided
|
Unassigned |
Bug Description
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.
t_32.
t_32.
t_32.
FROM
(
SELECT
SUBSTRING
t_
dimgender
CAST(
SUBSTRING
t_
dimgender
FROM
as_
JOIN
as_
ON
factinter
JOIN
(
SELECT
FROM
GROUP BY
1,
2,
3
) AS t_25
ON
dimcustom
JOIN
as_
ON
dimcustom
RIGHT OUTER JOIN
as_
ON
factinter
JOIN
(
SELECT
t_7.c_10 AS state_topnc1,
FROM
JOIN
ON
JOIN
(
SELECT
FROM
GROUP BY
1,
2,
3
) AS t_7
ON
WHERE
GROUP BY
1
ORDER BY
2 DESC NULLS LAST
LIMIT 10
) AS t_31
ON
t_
WHERE
SUBSTRING
AND
dimdate_
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_
query: 11068925
location: step_project.
process: padbmaster [pid=8963]
-----
This query used to work before. Not sure if redshift was currently updated.