search

turbot / steampipe-plugin-aws

Use SQL to instantly query AWS resources across regions and accounts. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/aws
Apache License 2.0
176 stars 89 forks source link

Running an unqualified then qualified query with caching enabled returns incomplete rows for `aws_organizations_account` table #2230

Closed cbruno10 closed 2 days ago

cbruno10 commented 2 days ago

Describe the bug Because parent_id is a key qual for the ListConfig but does not have exact CacheMatch enabled, running an unqualified then qualified list query results in incomplete rows being returned, as parent_id is null from the unqualified query.

Steampipe version (steampipe -v) Steampipe v0.23.2

Plugin version (steampipe plugin list) v0.139.0

To reproduce See above

Expected behavior Correct rows should be returned

Additional context Add any other context about the problem here.