NotificationsYou must be signed in to change notification settings
Fork4.9k
Star17.7k

Commitd4d48a5

committed

Tweak new regression test case for better portability.

Buildfarm says we get different plans on 32-bit and 64-bit platforms,probably because of MAXALIGN-related differences in memory-consumptioncalculations. Add some dummy WHERE clauses so that the planner estimatesdifferent sizes for the three generate_series() relations; that shouldstabilize the choice of join order.

1 parent4c8ab1b commitd4d48a5Copy full SHA for d4d48a5

File tree

2 files changed

-2

lines changed

src/test/regress
- expected
  - pg_lsn.out
- sql
  - pg_lsn.sql

2 files changed

-2

lines changed

`‎src/test/regress/expected/pg_lsn.out`

Lines changed: 6 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -70,6 +70,7 @@ SELECT DISTINCT (i \|\| '/' \|\| j)::pg_lsn f`
`70`	`70`	`FROM generate_series(1, 10) i,`
`71`	`71`	`generate_series(1, 10) j,`
`72`	`72`	`generate_series(1, 5) k`
	`73`	`+ WHERE i <= 10 AND j > 0 AND j <= 10`
`73`	`74`	`ORDER BY f;`
`74`	`75`	`QUERY PLAN`
`75`	`76`	`--------------------------------------------------------------------------`
`@@ -81,14 +82,17 @@ SELECT DISTINCT (i \|\| '/' \|\| j)::pg_lsn f`
`81`	`82`	`-> Function Scan on generate_series k`
`82`	`83`	`-> Materialize`
`83`	`84`	`-> Nested Loop`
`84`		`- -> Function Scan on generate_series i`
`85`	`85`	`-> Function Scan on generate_series j`
`86`		`-(10 rows)`
	`86`	`+ Filter: ((j > 0) AND (j <= 10))`
	`87`	`+ -> Function Scan on generate_series i`
	`88`	`+ Filter: (i <= 10)`
	`89`	`+(12 rows)`
`87`	`90`
`88`	`91`	`SELECT DISTINCT (i \|\| '/' \|\| j)::pg_lsn f`
`89`	`92`	`FROM generate_series(1, 10) i,`
`90`	`93`	`generate_series(1, 10) j,`
`91`	`94`	`generate_series(1, 5) k`
	`95`	`+ WHERE i <= 10 AND j > 0 AND j <= 10`
`92`	`96`	`ORDER BY f;`
`93`	`97`	`f`
`94`	`98`	`-------`

`‎src/test/regress/sql/pg_lsn.sql`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -30,10 +30,12 @@ SELECT DISTINCT (i \|\| '/' \|\| j)::pg_lsn f`
`30`	`30`	`FROM generate_series(1,10) i,`
`31`	`31`	`generate_series(1,10) j,`
`32`	`32`	`generate_series(1,5) k`
	`33`	`+WHERE i<=10AND j>0AND j<=10`
`33`	`34`	`ORDER BY f;`
`34`	`35`
`35`	`36`	`SELECT DISTINCT (i\|\|'/'\|\| j)::pg_lsn f`
`36`	`37`	`FROM generate_series(1,10) i,`
`37`	`38`	`generate_series(1,10) j,`
`38`	`39`	`generate_series(1,5) k`
	`40`	`+WHERE i<=10AND j>0AND j<=10`
`39`	`41`	`ORDER BY f;`

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!

Commitd4d48a5

File tree

2 files changed

2 files changed

`‎src/test/regress/expected/pg_lsn.out`

`‎src/test/regress/sql/pg_lsn.sql`

0 commit comments