Mismatching number of columns in the output when using SELECT * FROM and tables have same-named columns.

[OndraZizka]

If the source tables have columns of the same names,
then the output table has only 1 column for both.

That makes the 2nd (, 3rd, ...) column not fit into the output table.

Possible solution:
When using *, The columns in the output should be prefixed, either with the full name, or some (internal?) alias.

Example

SQL: INSERT INTO output (SELECT gc_42., cards. FROM gc_42 LEFT JOIN cards ON policyId = previous_pa_policy_id)

DB error: SQLSyntaxErrorException number of target columns does not match that of query expression

Tables and column types:

• CARDS
  • CURRENCY CHARACTER VARYING
• IKEA_GC_42
  • POLICY_NO BIGINT
  • CURRENCY CHARACTER VARYING
• OUTPUT
  • POLICY_NO BIGINT
  • CURRENCY CHARACTER VARYING