"select distinct arn ..." (and similar) should be "select distinct on (arn) arn ..." #493
Description
Many queries in this mod use distinct to prevent duplicates. For example:
Distinct checks all elements in the tuple (row), as opposed to ensuring the specific arn or name (common ones) is actually distinct.
So, queries like this:
select
distinct arn as resource,
should actually be:
select distinct on (arn)
arn,
A an example to see the difference, please try these two queries:
select distinct region, name from aws_s3_bucket order by region, name;
select distinct on (region) region, name from aws_s3_bucket order by region, name;