aws 0.36.0 plugin broken

[jzendle]

Describe the bug

select v.cidr_block from aws_vpc v join aws_ec2_instance i on i.vpc_id = v.vpc_id where i.instance_id = 'i-0367b6705f9078c25'

gives rpc error:

Warning: executeQueries: query 1 of 1 failed: pq: rpc error: code = Internal desc = 'Get' call requires an '=' qual for column:'instance_id' operator: =

Steampipe version (steampipe -v)
v0.84.0

aws plugin v0.36.0

[jzendle]

appears that any join using aws_ec2_instance.instance_id gives above error

[e-gineer]

Hi @jzendle ... thanks for reporting this issue! This is most likely caused by the postgres planner optimizing our foreign tables into a bad query sequence without sufficient data. It requires investigation by @kaidaguerre .

As a workaround, like will cause the planner to take a different path to the = in this case. (Not awesome, but works in a pinch.)

/tmp $ steampipe query
Welcome to Steampipe v0.9.0-rc.1
For more information, type .help
> select v.cidr_block from aws_vpc v join aws_ec2_instance i on i.vpc_id = v.vpc_id;
+---------------+
| cidr_block    |
+---------------+
| 172.31.0.0/16 |
+---------------+
> select v.cidr_block from aws_vpc v join aws_ec2_instance i on i.vpc_id = v.vpc_id where i.instance_id = 'i-06c423b39987f9246'
Error: rpc error: code = Internal desc = 'Get' call requires an '=' qual for column:'instance_id' operator: =
> select v.cidr_block from aws_vpc v join aws_ec2_instance i on i.vpc_id = v.vpc_id where i.instance_id like 'i-06c423b39987f9246'
+---------------+
| cidr_block    |
+---------------+
| 172.31.0.0/16 |
+---------------+
> 

[kaidaguerre]

thanks for raising this @jzendle, I will have a dig into it

[kaidaguerre]

@jzendle apologies for taking so long to resolve this.

I have identified a bug in the plugin sdk causing this issue, which I have fixed. So the aws plugin should reflect this change once it has gone through it's release cycle