NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commite61a82c

committed

Adjust file_fdw regression tests foracc95f2 FREEZE commit

Reported-by: Tom LaneDiscussion:https://postgr.es/m/2161529.1699899452@sss.pgh.pa.usBackpatch-through: master

1 parent151a0ee commite61a82cCopy full SHA for e61a82c

File tree

1 file changed

-7

lines changed

contrib/file_fdw/expected
- file_fdw.out

1 file changed

-7

lines changed

`‎contrib/file_fdw/expected/file_fdw.out`

Lines changed: 7 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -51,23 +51,23 @@ CREATE USER MAPPING FOR regress_no_priv_user SERVER file_server;`
`51`	`51`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'xml'); -- ERROR`
`52`	`52`	`ERROR: COPY format "xml" not recognized`
`53`	`53`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', quote ':'); -- ERROR`
`54`		`-ERROR: COPYquote available only in CSV mode`
	`54`	`+ERROR: COPYQUOTE requires CSV mode`
`55`	`55`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', escape ':'); -- ERROR`
`56`		`-ERROR: COPYescape available only in CSV mode`
	`56`	`+ERROR: COPYESCAPE requires CSV mode`
`57`	`57`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', header 'true'); -- ERROR`
`58`	`58`	`ERROR: cannot specify HEADER in BINARY mode`
`59`	`59`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', quote ':'); -- ERROR`
`60`		`-ERROR: COPYquote available only in CSV mode`
	`60`	`+ERROR: COPYQUOTE requires CSV mode`
`61`	`61`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', escape ':'); -- ERROR`
`62`		`-ERROR: COPYescape available only in CSV mode`
	`62`	`+ERROR: COPYESCAPE requires CSV mode`
`63`	`63`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter 'a'); -- ERROR`
`64`	`64`	`ERROR: COPY delimiter cannot be "a"`
`65`	`65`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', escape '-'); -- ERROR`
`66`		`-ERROR: COPYescape available only in CSV mode`
	`66`	`+ERROR: COPYESCAPE requires CSV mode`
`67`	`67`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', quote '-', null '=-='); -- ERROR`
`68`	`68`	`ERROR: CSV quote character must not appear in the NULL specification`
`69`	`69`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '-', null '=-='); -- ERROR`
`70`		`-ERROR: COPY delimiter must not appear in the NULL specification`
	`70`	`+ERROR: COPY delimitercharactermust not appear in the NULL specification`
`71`	`71`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '-', quote '-'); -- ERROR`
`72`	`72`	`ERROR: COPY delimiter and quote must be different`
`73`	`73`	`CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '---'); -- ERROR`
`@@ -138,7 +138,7 @@ CREATE FOREIGN TABLE text_csv (`
`138`	`138`	`) SERVER file_server`
`139`	`139`	`OPTIONS (format 'text', filename :'filename', null 'NULL');`
`140`	`140`	`SELECT * FROM text_csv; -- ERROR`
`141`		`-ERROR: COPYforce not null available only in CSV mode`
	`141`	`+ERROR: COPYFORCE_NOT_NULL requires CSV mode`
`142`	`142`	`ALTER FOREIGN TABLE text_csv OPTIONS (SET format 'csv');`
`143`	`143`	`\pset null _null_`
`144`	`144`	`SELECT * FROM text_csv;`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commite61a82c

File tree

1 file changed

1 file changed

`‎contrib/file_fdw/expected/file_fdw.out`

0 commit comments