Commit6b72aa5

committed

Add a regression test case for bug #5497

1 parentbc325d8 commit6b72aa5Copy full SHA for 6b72aa5

File tree

+32

-0

lines changed

+32

-0

lines changed

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -528,6 +528,18 @@ SELECT * FROM test_type_conversion_array_int4(ARRAY[[1,2,3],[4,5,6]]);`
`528`	`528`	`ERROR: cannot convert multidimensional array to Python list`
`529`	`529`	`DETAIL: PL/Python only supports one-dimensional arrays.`
`530`	`530`	`CONTEXT: PL/Python function "test_type_conversion_array_int4"`
	`531`	`+CREATE FUNCTION test_type_conversion_array_text(x text[]) RETURNS text[] AS $$`
	`532`	`+plpy.info(x, type(x))`
	`533`	`+return x`
	`534`	`+$$ LANGUAGE plpythonu;`
	`535`	`+SELECT * FROM test_type_conversion_array_text(ARRAY['foo', 'bar']);`
	`536`	`+INFO: (['foo', 'bar'], <type 'list'>)`
	`537`	`+CONTEXT: PL/Python function "test_type_conversion_array_text"`
	`538`	`+ test_type_conversion_array_text`
	`539`	`+---------------------------------`
	`540`	`+ {foo,bar}`
	`541`	`+(1 row)`
	`542`	`+`
`531`	`543`	`CREATE FUNCTION test_type_conversion_array_bytea(x bytea[]) RETURNS bytea[] AS $$`
`532`	`544`	`plpy.info(x, type(x))`
`533`	`545`	`return x`

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -528,6 +528,18 @@ SELECT * FROM test_type_conversion_array_int4(ARRAY[[1,2,3],[4,5,6]]);`
`528`	`528`	`ERROR: cannot convert multidimensional array to Python list`
`529`	`529`	`DETAIL: PL/Python only supports one-dimensional arrays.`
`530`	`530`	`CONTEXT: PL/Python function "test_type_conversion_array_int4"`
	`531`	`+CREATE FUNCTION test_type_conversion_array_text(x text[]) RETURNS text[] AS $$`
	`532`	`+plpy.info(x, type(x))`
	`533`	`+return x`
	`534`	`+$$ LANGUAGE plpython3u;`
	`535`	`+SELECT * FROM test_type_conversion_array_text(ARRAY['foo', 'bar']);`
	`536`	`+INFO: (['foo', 'bar'], <class 'list'>)`
	`537`	`+CONTEXT: PL/Python function "test_type_conversion_array_text"`
	`538`	`+ test_type_conversion_array_text`
	`539`	`+---------------------------------`
	`540`	`+ {foo,bar}`
	`541`	`+(1 row)`
	`542`	`+`
`531`	`543`	`CREATE FUNCTION test_type_conversion_array_bytea(x bytea[]) RETURNS bytea[] AS $$`
`532`	`544`	`plpy.info(x, type(x))`
`533`	`545`	`return x`

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -223,6 +223,14 @@ SELECT * FROM test_type_conversion_array_int4(NULL);`
`223`	`223`	`SELECT*FROM test_type_conversion_array_int4(ARRAY[[1,2,3],[4,5,6]]);`
`224`	`224`
`225`	`225`
	`226`	`+CREATEFUNCTIONtest_type_conversion_array_text(xtext[]) RETURNStext[]AS $$`
	`227`	`+plpy.info(x, type(x))`
	`228`	`+return x`
	`229`	`+$$ LANGUAGE plpythonu;`
	`230`	`+`
	`231`	`+SELECT*FROM test_type_conversion_array_text(ARRAY['foo','bar']);`
	`232`	`+`
	`233`	`+`
`226`	`234`	`CREATEFUNCTIONtest_type_conversion_array_bytea(xbytea[]) RETURNSbytea[]AS $$`
`227`	`235`	`plpy.info(x, type(x))`
`228`	`236`	`return x`

Comments

(0)