NotificationsYou must be signed in to change notification settings
Fork54
Star463

Commit763b45b

committed

Suppress a line of EXPLAIN in parallel_workers test which contains substring

'Gather Merge'.It might be better to inquiry why OS/hardware platform changes decision ona number of parallel workers, but it requires direct access to problematicenvironment... So, postpone for the better future.

1 parentb036dd9 commit763b45bCopy full SHA for 763b45b

File tree

2 files changed

-5

lines changed

expected
- parallel_workers.out
sql
- parallel_workers.sql

2 files changed

-5

lines changed

`‎expected/parallel_workers.out`

Lines changed: 3 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -69,7 +69,8 @@ SELECT count(*) FROM`
`69`	`69`	`(SELECT max(id) AS id, payload FROM t`
`70`	`70`	`WHERE id % 101 = 0 GROUP BY (payload)) AS q2`
`71`	`71`	`WHERE q1.id = q2.id;') AS str`
`72`		`-WHERE str NOT LIKE '%Workers%' AND str NOT LIKE '%Sort Method%';`
	`72`	`+WHERE str NOT LIKE '%Workers%' AND str NOT LIKE '%Sort Method%'`
	`73`	`+ AND str NOT LIKE '%Gather Merge%';`
`73`	`74`	`str`
`74`	`75`	`--------------------------------------------------------------------------------------------------`
`75`	`76`	`Aggregate (actual rows=1 loops=1)`
`@@ -84,7 +85,6 @@ WHERE str NOT LIKE '%Workers%' AND str NOT LIKE '%Sort Method%';`
`84`	`85`	`-> Finalize GroupAggregate (actual rows=1 loops=1)`
`85`	`86`	`AQO not used`
`86`	`87`	`Group Key: t.payload`
`87`		`- -> Gather Merge (actual rows=3 loops=1)`
`88`	`88`	`AQO not used`
`89`	`89`	`-> Partial GroupAggregate (actual rows=1 loops=3)`
`90`	`90`	`AQO not used`
`@@ -99,7 +99,6 @@ WHERE str NOT LIKE '%Workers%' AND str NOT LIKE '%Sort Method%';`
`99`	`99`	`-> Group (actual rows=1000 loops=1)`
`100`	`100`	`AQO not used`
`101`	`101`	`Group Key: t_1.id`
`102`		`- -> Gather Merge (actual rows=1000 loops=1)`
`103`	`102`	`AQO not used`
`104`	`103`	`-> Group (actual rows=333 loops=3)`
`105`	`104`	`AQO not used`
`@@ -114,7 +113,7 @@ WHERE str NOT LIKE '%Workers%' AND str NOT LIKE '%Sort Method%';`
`114`	`113`	`Using aqo: true`
`115`	`114`	`AQO mode: LEARN`
`116`	`115`	`JOINS: 1`
`117`		`-(42 rows)`
	`116`	`+(40 rows)`
`118`	`117`
`119`	`118`	`RESET parallel_tuple_cost;`
`120`	`119`	`RESET parallel_setup_cost;`

`‎sql/parallel_workers.sql`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -49,7 +49,8 @@ SELECT count(*) FROM`
`49`	`49`	`(SELECT max(id) AS id, payload FROM t`
`50`	`50`	`WHERE id % 101 = 0 GROUP BY (payload)) AS q2`
`51`	`51`	`WHERE q1.id = q2.id;')AS str`
`52`		`-WHERE str NOTLIKE'%Workers%'AND str NOTLIKE'%Sort Method%';`
	`52`	`+WHERE str NOTLIKE'%Workers%'AND str NOTLIKE'%Sort Method%'`
	`53`	`+AND str NOTLIKE'%Gather Merge%';`
`53`	`54`
`54`	`55`
`55`	`56`	`RESET parallel_tuple_cost;`

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!

Commit763b45b

File tree

2 files changed

2 files changed

`‎expected/parallel_workers.out`

`‎sql/parallel_workers.sql`

0 commit comments