Cannot query external table - TableScan replaced with EmptyExec

[andygrove]

Describe the bug
I am using the CLI to try and query a file. It shows that the file has no data but this is not the case.

To Reproduce

create external table partsupp (ps_partkey int, ps_suppkey int, ps_availqty int, ps_supplycost float, ps_comment varchar) stored as csv with delimiter '|' location '../benchmarks/data/partsupp.tbl';

❯ select count(*) from partsupp;
+-----------------+
| COUNT(UInt8(1)) |
+-----------------+
| 0               |
+-----------------+
1 row in set. Query took 0.001 seconds.

explain verbose select count(*) from partsupp;

| logical_plan                                               | Projection: COUNT(UInt8(1))                                     |
|                                                            |   Aggregate: groupBy=[[]], aggr=[[COUNT(UInt8(1))]]             |
|                                                            |     TableScan: partsupp projection=[ps_partkey]                 |
| initial_physical_plan                                      | ProjectionExec: expr=[COUNT(UInt8(1))@0 as COUNT(UInt8(1))]     |
|                                                            |   AggregateExec: mode=Final, gby=[], aggr=[COUNT(UInt8(1))]     |
|                                                            |     AggregateExec: mode=Partial, gby=[], aggr=[COUNT(UInt8(1))] |
|                                                            |       EmptyExec: produce_one_row=false     

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

[tustvold]

Looks like a duplicate of #1736