1 Answer
- Newest
- Most votes
- Most comments
1
Hi Chris_B,
Thank you for the details. I have tested it and yes indeed it is not filtering correctly, it seems that it is related to the LEFT OUTER JOIN. The WHERE condition works for the INNER JOIN, RIGHT OUTER JOIN and FULL OUTER JOIN but not the LEFT OUTER JOIN.
I recommend creating a support ticket for a detailed analysis.
Regards, Ziad
Relevant content
- asked a month ago
- asked 7 months ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 months ago
Thanks Ziad! Sadly our AWS support plan doesn't include technical support, which is why I posted here. Hoping someone from the redshift dev team checks these periodically
Thank you Chris for the details. Yes this will be reviewed.