Sorting `aws_vpc` by `cidr_block` fails with `error: "driver: bad connection"`

[svend]

Describe the bug

Sorting the VPS from aws_vpc by cidr_block fails with the following error:

$ ~/src/steampipe/steampipe-v0.10.0 query 'select cidr_block from aws_vpc order by cidr_block'
Warning: executeQueries: query 1 of 1 failed: driver: bad connection

Steampipe version (steampipe -v)

$ ~/src/steampipe/steampipe-v0.10.0 --version                                                          
steampipe version 0.10.0

To reproduce

Run the following command:

steampipe query 'select cidr_block from aws_vpc order by cidr_block' 

Expected behavior

Output a table of VPC CIDRs, sorted by CIDR.

Additional context

The same command on steampipe v0.9.1 hangs instead of returning an error.

Casting to network works:

 ~/src/steampipe/steampipe-v0.10.0 query 'select cidr_block from aws_vpc order by network(cidr_block)'

[e-gineer]

Thanks @svend for using Steampipe and letting us know about this problem.

Great that you could share a workaround as well! 👍

[pskrbasu]

@kaidaguerre
Error: unexpected EOF
Related issue: turbot/steampipe-plugin-aws#1613

[github-actions]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.