Commit1b3dbb9

committed

more tests for RowMarks

1 parent51f39ab commit1b3dbb9Copy full SHA for 1b3dbb9

File tree

+37

-0

lines changed

+37

-0

lines changed

Lines changed: 15 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -216,6 +216,21 @@ FOR UPDATE;`
`216`	`216`	`10`
`217`	`217`	`(10 rows)`
`218`	`218`
	`219`	`+/* ONLY (plan) */`
	`220`	`+EXPLAIN (COSTS OFF)`
	`221`	`+SELECT * FROM ONLY rowmarks.first FOR SHARE;`
	`222`	`+ QUERY PLAN`
	`223`	`+-------------------------`
	`224`	`+ LockRows`
	`225`	`+ -> Seq Scan on first`
	`226`	`+(2 rows)`
	`227`	`+`
	`228`	`+/* ONLY (execution) */`
	`229`	`+SELECT * FROM ONLY rowmarks.first FOR SHARE;`
	`230`	`+ id`
	`231`	`+----`
	`232`	`+(0 rows)`
	`233`	`+`
`219`	`234`	`/* Check updates (plan) */`
`220`	`235`	`SET enable_hashjoin = f;/* Hash Semi Join on 10 vs Hash Join on 9.6 */`
`221`	`236`	`SET enable_mergejoin = f;/* Merge Semi Join on 10 vs Merge Join on 9.6 */`

Lines changed: 15 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -221,6 +221,21 @@ FOR UPDATE;`
`221`	`221`	`10`
`222`	`222`	`(10 rows)`
`223`	`223`
	`224`	`+/* ONLY (plan) */`
	`225`	`+EXPLAIN (COSTS OFF)`
	`226`	`+SELECT * FROM ONLY rowmarks.first FOR SHARE;`
	`227`	`+ QUERY PLAN`
	`228`	`+-------------------------`
	`229`	`+ LockRows`
	`230`	`+ -> Seq Scan on first`
	`231`	`+(2 rows)`
	`232`	`+`
	`233`	`+/* ONLY (execution) */`
	`234`	`+SELECT * FROM ONLY rowmarks.first FOR SHARE;`
	`235`	`+ id`
	`236`	`+----`
	`237`	`+(0 rows)`
	`238`	`+`
`224`	`239`	`/* Check updates (plan) */`
`225`	`240`	`SET enable_hashjoin = f;/* Hash Semi Join on 10 vs Hash Join on 9.6 */`
`226`	`241`	`SET enable_mergejoin = f;/* Merge Semi Join on 10 vs Merge Join on 9.6 */`

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -81,6 +81,13 @@ JOIN rowmarks.second USING(id)`
`81`	`81`	`ORDER BY id`
`82`	`82`	`FORUPDATE;`
`83`	`83`
	`84`	`+/* ONLY (plan)*/`
	`85`	`+EXPLAIN (COSTS OFF)`
	`86`	`+SELECT*FROM ONLYrowmarks.first FOR SHARE;`
	`87`	`+`
	`88`	`+/* ONLY (execution)*/`
	`89`	`+SELECT*FROM ONLYrowmarks.first FOR SHARE;`
	`90`	`+`
`84`	`91`	`/* Check updates (plan)*/`
`85`	`92`	`SET enable_hashjoin= f;/* Hash Semi Join on 10 vs Hash Join on 9.6*/`
`86`	`93`	`SET enable_mergejoin= f;/* Merge Semi Join on 10 vs Merge Join on 9.6*/`

Comments

(0)