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

Michael Paquier <michael@paquier.xyz>

Commit: a189ed49d6292979be1478292246be61c4563043
Author: Michael Paquier <michael@paquier.xyz>
Date: 2024-03-13T05:19:21Z
Releases: 17.0
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

Files

PathChange+/−
src/test/regress/expected/copy2.out modified +3 −2
src/test/regress/sql/copy2.sql modified +3 −0

Discussion