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

Started by Michael Paquierover 2 years ago1 messagescomitters

michael@paquier.xyz

over 2 years ago

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: /messages/by-id/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(-)