steampipe-postgres-fdw icon indicating copy to clipboard operation
steampipe-postgres-fdw copied to clipboard

Cannot use AnyColumn with a bool qual on a list call?

Open e-gineer opened this issue 4 years ago • 0 comments

~/src/steampipe-plugin-alicloud $ steampipe query
Welcome to Steampipe v0.1.0
For more information, type .help
> 
> select * from alicloud_vpc
Error: pq: rpc error: code = Internal desc = 'List' call requires an '=' qual for one of columns: is_default,id
> 
> select * from alicloud_vpc where id = 'vpc-0xink0hecahhfo5h0vy71';
+-------+---------------------------+-----------+-----------+-------------+-----------------+---------------------------+-
| name  | id                        | region_id | status    | cidr_block  | ipv6_cidr_block | vrouter_id                | 
+-------+---------------------------+-----------+-----------+-------------+-----------------+---------------------------+-
| test2 | vpc-0xink0hecahhfo5h0vy71 | us-east-1 | Available | 10.2.0.0/16 |                 | vrt-0xig35dgad2ti8q0n40ke | 
+-------+---------------------------+-----------+-----------+-------------+-----------------+---------------------------+-
> 
> select * from alicloud_vpc where is_default
Error: pq: rpc error: code = Internal desc = 'List' call requires an '=' qual for one of columns: is_default,id
> 
> select * from alicloud_vpc where not is_default
Error: pq: rpc error: code = Internal desc = list call listVpc failed with panic we do not have the quals for a list
> 
> select * from alicloud_vpc where is_default is true
Error: pq: rpc error: code = Internal desc = 'List' call requires an '=' qual for one of columns: is_default,id
> 
> 
> select * from alicloud_vpc where is_default = true
Error: pq: rpc error: code = Internal desc = 'List' call requires an '=' qual for one of columns: is_default,id
> 

e-gineer avatar Feb 01 '21 03:02 e-gineer