Commit167bc6c

Neil Conway

committed

Add regression test for consecutive newlines in COPY CSV mode. (There is

no bug related to this functionality in HEAD, but it's worth adding a testfor anyway.) From Andrew Dunstan.

1 parent3b6073d commit167bc6cCopy full SHA for 167bc6c

File tree

+14

-0

lines changed

+14

-0

lines changed

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -191,6 +191,9 @@ COPY y TO stdout WITH CSV FORCE QUOTE col2 ESCAPE '\\';`
`191`	`191`	`"Jackson, Sam","\\h"`
`192`	`192`	`"It is \"perfect\".",""`
`193`	`193`	`"",`
	`194`	`+--test that we read consecutive LFs properly`
	`195`	`+CREATE TEMP TABLE testnl (a int, b text, c int);`
	`196`	`+COPY testnl FROM stdin CSV;`
`194`	`197`	`DROP TABLE x, y;`
`195`	`198`	`DROP FUNCTION fn_x_before();`
`196`	`199`	`DROP FUNCTION fn_x_after();`

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -129,6 +129,17 @@ COPY y TO stdout WITH CSV;`
`129`	`129`	`COPY y TO stdout WITH CSV QUOTE'''' DELIMITER'\|';`
`130`	`130`	`COPY y TO stdout WITH CSV FORCE QUOTE col2 ESCAPE'\\';`
`131`	`131`
	`132`	`+--test that we read consecutive LFs properly`
	`133`	`+`
	`134`	`+CREATE TEMP TABLE testnl (aint, btext, cint);`
	`135`	`+`
	`136`	`+COPY testnlFROM stdin CSV;`
	`137`	`+1,"a field with two LFs`
	`138`	`+`
	`139`	`+inside",2`
	`140`	`+\.`
	`141`	`+`
	`142`	`+`
`132`	`143`	`DROPTABLE x, y;`
`133`	`144`	`DROPFUNCTION fn_x_before();`
`134`	`145`	`DROPFUNCTION fn_x_after();`

Comments

(0)