pgsql: Add tests for more row patterns with COPY FROM .. (ON_ERROR igno

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add tests for more row patterns with COPY FROM .. (ON_ERROR igno
Date: 2024-03-13 05:20:50
Message-ID: E1rkH2o-003XW2-8M@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add tests for more row patterns with COPY FROM .. (ON_ERROR ignore)

While digging into the code of this feature, I got confused by the fact
that a line is skipped when a value cannot be converted to its expected
attribute even if the line has fewer attributes than the target
relation. The tests had a check for the case of an empty line, this
commit a couple more patterns where a line is incomplete, but skipped
because of a conversion error.

Reviewed-by: Bharath Rupireddy
Discussion: https://postgr.es/m/Ze_7kZqexdt0BiyC@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a189ed49d6292979be1478292246be61c4563043

Modified Files
--------------
src/test/regress/expected/copy2.out | 5 +++--
src/test/regress/sql/copy2.sql | 3 +++
2 files changed, 6 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2024-03-13 05:45:13 pgsql: Fix incorrect format placeholders
Previous Message Amit Kapila 2024-03-13 03:14:39 pgsql: Fix a random failure in 038_save_logical_slots_shutdown.pl.