SQL: Conkey and confkey values in pg_constraints have different number of elements

[awoods187]

Dbeaver identified a potential CRDB bug in dbeaver/dbeaver#4386 (comment):

This happens because conkey and confkey values in pg_constraints have different number of elements.
In standard PG they always have equal size.

Looks like a bug in CC - the value in conkey seems to be equal to the number of columns in table's primary key. This happens only if foreign key columns are also part of primary key (like in stock or order_line tables).

[BramGruneir]

In postgres, after using the schema posted to the dbeaver issue:

bram=# select oid, conname, conkey, confkey from pg_catalog.pg_constraint where conname like '%fkey';
  oid  |      conname       | conkey  | confkey
-------+--------------------+---------+---------
 25286 | test_parent_fkey   | {2}     | {1}
 33487 | example_b_fkey     | {2}     | {1}
 33508 | b_x_fkey           | {1,2}   | {1,2}
 33529 | d_warehouse_fkey   | {1}     | {1}
 16970 | self_other_id_fkey | {2}     | {1}
 16983 | self_x2_y_fkey     | {2}     | {1}
 16988 | self_x2_z_fkey     | {3}     | {2}
 17008 | weird_id_fkey      | {1}     | {1}
 33542 | c_district_fkey    | {1,2}   | {1,2}
 33556 | h_customer_fkey    | {3,2,1} | {1,2,3}
 33561 | h_district_fkey    | {5,4}   | {1,2}
 33571 | o_customer_fkey    | {1,2,4} | {1,2,3}
 33582 | no_order_fkey      | {1,2,3} | {1,2,3}
 33597 | s_warehouse_fkey   | {1}     | {1}
 33602 | s_item_fkey        | {2}     | {1}
 33612 | ol_order_fkey      | {1,2,3} | {1,2,3}
 33617 | ol_stock_fkey      | {8,5}   | {1,2}
(17 rows)

In cockroach:

root@:26257/defaultdb> select oid, conname, conkey, confkey from pg_catalog.pg_constraint where conname like '%fkey';
     oid     |     conname      |  conkey   | confkey
+------------+------------------+-----------+---------+
  1879483418 | d_warehouse_fkey | {1,2}     | {1}
  2947212382 | c_district_fkey  | {1,2,3}   | {1,2}
  1524765624 | h_district_fkey  | {5,4}     | {1,2}
  3257882111 | h_customer_fkey  | {3,2,1}   | {1,2,3}
  3472271204 | o_customer_fkey  | {1,2,4}   | {1,2,3}
   993267767 | no_order_fkey    | {1,2,3}   | {1,2,3}
  3657084363 | s_warehouse_fkey | {1,2}     | {1}
  4156347737 | s_item_fkey      | {2}       | {1}
  4271105516 | ol_order_fkey    | {1,2,3,4} | {1,2,3}
  3999149087 | ol_stock_fkey    | {8,5}     | {1,2}
(10 rows)