cli: EXPLAIN ANALYZE doesn't work in some cases after switch to jackc/pgx

[yuzefovich]

I ran into the following error:

root@localhost:26257/tpch> EXPLAIN ANALYZE SELECT s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment FROM part, supplier, partsupp, nation, region WHERE p_partkey = ps_partkey AND s_suppkey = ps_suppkey AND p_size = 15 AND p_type LIKE '%BRASS' AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'EUROPE' AND ps_supplycost = ( SELECT min(ps_supplycost) FROM partsupp, supplier, nation, region WHERE p_partkey = ps_partkey AND s_suppkey = ps_suppkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'EUROPE') ORDER BY s_acctbal DESC, n_name, s_name, p_partkey LIMIT 100;
EXPLAIN ANALYZE 192
ERROR: number of field descriptions must equal number of destinations, got 1 and 8
SQLSTATE: XX000
HINT: You have encountered an unexpected error.

Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.

If you would rather not post publicly, please contact us directly
using the support form.

We appreciate your feedback.

I've narrowed the problem down to fcc7de4.

In order to repro, restore TPCH dataset with Scale Factor of 1 (internal instructions are here), and run EXPLAIN ANALYZE on TPCH Q2 (others also seem to work, Q2 is one of the shortest).

Jira issue: CRDB-16598