Hi When I used COPY FROM command on windows, I found that If the line data ends with a backslash and carriage return/newlines(\r\n),COPY FROM mishandle the line . As a result, there were unexpected data loaded into database.
The following case can reproduce this issue. ---------------------------------------------------------------------------- Data file: lines ending with carriage return/newlines(\r\n) ----- test.txt ------ AAA\ ★there is only one Backslash characters (\) in the line end. BBB ------------------- Data loading: #CREATE TABLE copytest( a TEXT); #COPY copytest FROM '/test.txt'; Data in database: # SELECT * FROM copytest; a ------- aaa\r ★\r is loaded unexpectedly bbb (2 rows) -------------------------------------------------------------------------- In this case , is it better to throw an error to user than to load the unexpected data to database? Regards,
