Commit4f63e85

committed

Add COSTS off to two EXPLAIN using tests.

1 parent0927d2f commit4f63e85Copy full SHA for 4f63e85

File tree

+14

-14

lines changed

+14

-14

lines changed

Lines changed: 12 additions & 12 deletions

Original file line number	Diff line number	Diff line change
`@@ -232,23 +232,23 @@ SELECT *, pg_typeof(f1) FROM`
`232`	`232`	`(3 rows)`
`233`	`233`
`234`	`234`	`-- ... unless there's context to suggest differently`
`235`		`-explain verbose select '42' union all select '43';`
`236`		`-QUERY PLAN`
`237`		`--------------------------------------------------`
`238`		`- Append (cost=0.00..0.05 rows=2 width=32)`
`239`		`- -> Result (cost=0.00..0.01 rows=1 width=32)`
	`235`	`+explain(verbose, costs off) select '42' union all select '43';`
	`236`	`+ QUERY PLAN`
	`237`	`+----------------------------`
	`238`	`+ Append`
	`239`	`+ -> Result`
`240`	`240`	`Output: '42'::text`
`241`		`- -> Result (cost=0.00..0.01 rows=1 width=32)`
	`241`	`+ -> Result`
`242`	`242`	`Output: '43'::text`
`243`	`243`	`(5 rows)`
`244`	`244`
`245`		`-explain verbose select '42' union all select 43;`
`246`		`-QUERY PLAN`
`247`		`-------------------------------------------------`
`248`		`- Append (cost=0.00..0.05 rows=2 width=4)`
`249`		`- -> Result (cost=0.00..0.01 rows=1 width=4)`
	`245`	`+explain(verbose, costs off) select '42' union all select 43;`
	`246`	`+ QUERY PLAN`
	`247`	`+--------------------`
	`248`	`+ Append`
	`249`	`+ -> Result`
`250`	`250`	`Output: 42`
`251`		`- -> Result (cost=0.00..0.01 rows=1 width=4)`
	`251`	`+ -> Result`
`252`	`252`	`Output: 43`
`253`	`253`	`(5 rows)`
`254`	`254`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -99,8 +99,8 @@ SELECT *, pg_typeof(f1) FROM`
`99`	`99`
`100`	`100`	`-- ... unless there's context to suggest differently`
`101`	`101`
`102`		`-explain verboseselect'42'union allselect'43';`
`103`		`-explain verboseselect'42'union allselect43;`
	`102`	`+explain(verbose, costs off)select'42'union allselect'43';`
	`103`	`+explain(verbose, costs off)select'42'union allselect43;`
`104`	`104`
`105`	`105`	`-- check materialization of an initplan reference (bug #14524)`
`106`	`106`	`explain (verbose, costs off)`

Comments

(0)