Crash when listing distinct destination_cidr_block's from aws_vpc_route

[e-gineer]

I can list all destination_cidr_block values:

> select destination_cidr_block from aws_vpc_route limit 5;
+------------------------+
| destination_cidr_block |
+------------------------+
| 0.0.0.0/0              |
| 10.0.0.0/24            |
| 0.0.0.0/0              |
| 172.31.0.0/16          |
| 0.0.0.0/0              |
+------------------------+

But, If I try to list distinct ones only, steampipe crashes:

> select distinct destination_cidr_block from aws_vpc_route;

Error: unexpected EOF

Here is the log. There is no plugin log file at all available.

2024-08-23 21:24:04.094 UTC [TRACE] steampipe [cda2]: DbClient.startQueryWithRetries end
2024-08-23 21:24:04.095 UTC [TRACE] steampipe [cda2]: DbClient.Close &{1 0 0 0x14000808a00 0x14000e00f60 <nil> <nil> <nil> <nil> <nil> 0 1 86400000000000 0 86400000000000 60000000000 0x140004fe2a0 {{{} 0} {0 0}} 0x140004fe300}
2024-08-23 21:24:04.095 UTC [WARN]  steampipe [cda2]: Error waiting for notification: read tcp 127.0.0.1:59101->127.0.0.1:9193: use of closed network connection
2024-08-23 21:24:04.096 UTC [TRACE] steampipe [cda2]: local client close complete
2024-08-23 21:24:04.096 UTC [TRACE] steampipe [cda2]: shutdown local service query

[e-gineer]

Here is a workaround that returns properly:

with blocks as materialized (select destination_cidr_block from aws_vpc_route) select distinct * from blocks;

[github-actions[bot]]

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[bot]]

This issue was closed because it has been stalled for 90 days with no activity.