Commit200ba16

committed

Add regression test for bug fixed by recent refactoring.

Test case by Andres Freund for bug fixed by Tom Lane's refactoringin commit5194024

1 parent87d3b35 commit200ba16Copy full SHA for 200ba16

File tree

+19

-0

lines changed

+19

-0

lines changed

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -418,3 +418,15 @@ NOTICE: drop cascades to 3 other objects`
`418`	`418`	`DETAIL: drop cascades to view v_test2`
`419`	`419`	`drop cascades to materialized view mv_test2`
`420`	`420`	`drop cascades to materialized view mv_test3`
	`421`	`+-- test a corner case for "with no data" versus a query which yields no rows`
	`422`	`+CREATE MATERIALIZED VIEW matview_unit_false AS SELECT false WHERE false WITH NO DATA;`
	`423`	`+SELECT * FROM matview_unit_false;`
	`424`	`+ERROR: materialized view "matview_unit_false" has not been populated`
	`425`	`+HINT: Use the REFRESH MATERIALIZED VIEW command.`
	`426`	`+REFRESH MATERIALIZED VIEW matview_unit_false;`
	`427`	`+SELECT * FROM matview_unit_false;`
	`428`	`+ bool`
	`429`	`+------`
	`430`	`+(0 rows)`
	`431`	`+`
	`432`	`+DROP MATERIALIZED VIEW matview_unit_false;`

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -129,3 +129,10 @@ CREATE MATERIALIZED VIEW mv_test3 AS SELECT * FROM mv_test2 WHERE moo = 12345;`
`129`	`129`	`SELECT pg_relation_is_scannable('mv_test3'::regclass);`
`130`	`130`
`131`	`131`	`DROPVIEW v_test1 CASCADE;`
	`132`	`+`
	`133`	`+-- test a corner case for "with no data" versus a query which yields no rows`
	`134`	`+CREATE MATERIALIZED VIEW matview_unit_falseASSELECT falseWHERE false WITH NO DATA;`
	`135`	`+SELECT*FROM matview_unit_false;`
	`136`	`+REFRESH MATERIALIZED VIEW matview_unit_false;`
	`137`	`+SELECT*FROM matview_unit_false;`
	`138`	`+DROP MATERIALIZED VIEW matview_unit_false;`

Comments

(0)