NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit5ce51f8

committed

Work around cross-version-upgrade issues created by commit9e38c2b.

Summarily changing the STYPE of regression-test aggregates thatdepend on array_append or array_cat is an issue for the buildfarm'scross-version-upgrade tests, because those aggregates (as definedin the back branches) now won't load into HEAD. Although this seemslike only a minimal risk for genuine user-defined aggregates, weneed to do something for the buildfarm. Hence, adjust the aggregatedefinitions, in both HEAD and the back branches.Discussion:https://postgr.es/m/1401824.1604537031@sss.pgh.pa.usDiscussion:https://postgr.es/m/E1kaQ2c-0005lx-Eg@gemulon.postgresql.org

1 parent6bb1b38 commit5ce51f8Copy full SHA for 5ce51f8

File tree

2 files changed

+21

-16

lines changed

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

2 files changed

+21

-16

lines changed

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

Lines changed: 13 additions & 11 deletions

Original file line number	Diff line number	Diff line change
`@@ -579,24 +579,24 @@ select q2, sql_if(q2 > 0, q2, q2 + 1) from int8_tbl;`
`579`	`579`	`(5 rows)`
`580`	`580`
`581`	`581`	`-- another sort of polymorphic aggregate`
`582`		`-CREATE AGGREGATEarray_cat_accum (anyarray)`
	`582`	`+CREATE AGGREGATEarray_larger_accum (anyarray)`
`583`	`583`	`(`
`584`		`- sfunc =array_cat,`
	`584`	`+ sfunc =array_larger,`
`585`	`585`	`stype = anyarray,`
`586`	`586`	`initcond = '{}'`
`587`	`587`	`);`
`588`		`-SELECTarray_cat_accum(i)`
	`588`	`+SELECTarray_larger_accum(i)`
`589`	`589`	`FROM (VALUES (ARRAY[1,2]), (ARRAY[3,4])) as t(i);`
`590`		`-array_cat_accum`
`591`		`------------------`
`592`		`- {1,2,3,4}`
	`590`	`+array_larger_accum`
	`591`	`+--------------------`
	`592`	`+ {3,4}`
`593`	`593`	`(1 row)`
`594`	`594`
`595`		`-SELECTarray_cat_accum(i)`
	`595`	`+SELECTarray_larger_accum(i)`
`596`	`596`	`FROM (VALUES (ARRAY[row(1,2),row(3,4)]), (ARRAY[row(5,6),row(7,8)])) as t(i);`
`597`		`- array_cat_accum`
`598`		`------------------------------------`
`599`		`- {"(1,2)","(3,4)","(5,6)","(7,8)"}`
	`597`	`+array_larger_accum`
	`598`	`+--------------------`
	`599`	`+ {"(5,6)","(7,8)"}`
`600`	`600`	`(1 row)`
`601`	`601`
`602`	`602`	`-- another kind of polymorphic aggregate`
`@@ -636,6 +636,8 @@ create aggregate build_group(int8, integer) (`
`636`	`636`	`STYPE = int8[]`
`637`	`637`	`);`
`638`	`638`	`-- check proper resolution of data types for polymorphic transfn/finalfn`
	`639`	`+create function first_el_transfn(anyarray, anyelement) returns anyarray as`
	`640`	`+'select $1 \|\| $2' language sql immutable;`
`639`	`641`	`create function first_el(anyarray) returns anyelement as`
`640`	`642`	`'select $1[1]' language sql strict immutable;`
`641`	`643`	`create aggregate first_el_agg_f8(float8) (`
`@@ -644,7 +646,7 @@ create aggregate first_el_agg_f8(float8) (`
`644`	`646`	`FINALFUNC = first_el`
`645`	`647`	`);`
`646`	`648`	`create aggregate first_el_agg_any(anyelement) (`
`647`		`- SFUNC =array_append,`
	`649`	`+ SFUNC =first_el_transfn,`
`648`	`650`	`STYPE = anyarray,`
`649`	`651`	`FINALFUNC = first_el`
`650`	`652`	`);`

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

Lines changed: 8 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -394,17 +394,17 @@ select q2, sql_if(q2 > 0, q2, q2 + 1) from int8_tbl;`
`394`	`394`
`395`	`395`	`-- another sort of polymorphic aggregate`
`396`	`396`
`397`		`-CREATEAGGREGATEarray_cat_accum (anyarray)`
	`397`	`+CREATEAGGREGATEarray_larger_accum (anyarray)`
`398`	`398`	`(`
`399`		`- sfunc=array_cat,`
	`399`	`+ sfunc=array_larger,`
`400`	`400`	`stype= anyarray,`
`401`	`401`	`initcond='{}'`
`402`	`402`	`);`
`403`	`403`
`404`		`-SELECTarray_cat_accum(i)`
	`404`	`+SELECTarray_larger_accum(i)`
`405`	`405`	`FROM (VALUES (ARRAY[1,2]), (ARRAY[3,4]))as t(i);`
`406`	`406`
`407`		`-SELECTarray_cat_accum(i)`
	`407`	`+SELECTarray_larger_accum(i)`
`408`	`408`	`FROM (VALUES (ARRAY[row(1,2),row(3,4)]), (ARRAY[row(5,6),row(7,8)]))as t(i);`
`409`	`409`
`410`	`410`	`-- another kind of polymorphic aggregate`
`@@ -445,6 +445,9 @@ create aggregate build_group(int8, integer) (`
`445`	`445`
`446`	`446`	`-- check proper resolution of data types for polymorphic transfn/finalfn`
`447`	`447`
	`448`	`+createfunctionfirst_el_transfn(anyarray, anyelement) returns anyarrayas`
	`449`	`+'select $1 \|\| $2' language sql immutable;`
	`450`	`+`
`448`	`451`	`createfunctionfirst_el(anyarray) returns anyelementas`
`449`	`452`	`'select $1[1]' language sql strict immutable;`
`450`	`453`
`@@ -455,7 +458,7 @@ create aggregate first_el_agg_f8(float8) (`
`455`	`458`	`);`
`456`	`459`
`457`	`460`	`createaggregatefirst_el_agg_any(anyelement) (`
`458`		`- SFUNC=array_append,`
	`461`	`+ SFUNC=first_el_transfn,`
`459`	`462`	`STYPE= anyarray,`
`460`	`463`	`FINALFUNC= first_el`
`461`	`464`	`);`

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!

Commit5ce51f8

File tree

2 files changed

2 files changed

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

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

0 commit comments