You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
Running a query using the aws_servicequotas_service_quota table and filtering by service_code column fails if there is more than one region configured.
As an example the following query fails:
>select* from aws_servicequotas_service_quota WHERE quota_code = 'L-0263D0A3' and service_code = 'ec2'
Error: get call returned 17 results - the key column is not globally unique (SQLSTATE HV000)
But the following one, filtering by a single region, works as expected.
>select* from aws_servicequotas_service_quota WHERE quota_code = 'L-0263D0A3' and service_code = 'ec2' and region = 'us-east-1'
Steampipe version (steampipe -v)
Example: v0.24.2
Plugin version (steampipe plugin list)
hub.steampipe.io/plugins/turbot/aws@latest: 0.147.0
To reproduce
select* from aws_servicequotas_service_quota WHERE quota_code = 'L-0263D0A3' and service_code = 'ec2'
Expected behavior
The query should return all rows without raising an error.
Additional context
The GetConfigkey colums are service_code and quota_code. In the query, for each region, service_code and quota_code columns have the same value.
The text was updated successfully, but these errors were encountered:
Describe the bug
Running a query using the
aws_servicequotas_service_quota
table and filtering byservice_code
column fails if there is more than one region configured.As an example the following query fails:
But the following one, filtering by a single region, works as expected.
Steampipe version (
steampipe -v
)Example: v0.24.2
Plugin version (
steampipe plugin list
)hub.steampipe.io/plugins/turbot/aws@latest: 0.147.0
To reproduce
Expected behavior
The query should return all rows without raising an error.
Additional context
The
GetConfig
key colums areservice_code
andquota_code
. In the query, for each region,service_code
andquota_code
columns have the same value.The text was updated successfully, but these errors were encountered: