diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/aggregates.out | 28 | ||||
| -rw-r--r-- | src/test/regress/expected/opr_sanity.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/aggregates.sql | 11 | 
3 files changed, 39 insertions, 2 deletions
| diff --git a/src/test/regress/expected/aggregates.out b/src/test/regress/expected/aggregates.out index 8ac13b562c4..e14e7356567 100644 --- a/src/test/regress/expected/aggregates.out +++ b/src/test/regress/expected/aggregates.out @@ -1950,7 +1950,7 @@ select string_agg(distinct f1::text, ',' order by f1::text) from varchar_tbl;  -   a,ab,abcd  (1 row) --- string_agg bytea tests +-- string_agg, min, max bytea tests  create table bytea_test_table(v bytea);  select string_agg(v, '') from bytea_test_table;   string_agg  @@ -1984,6 +1984,32 @@ select string_agg(v, decode('ee', 'hex')) from bytea_test_table;   \xffeeaa  (1 row) +select min(v) from bytea_test_table; + min   +------ + \xaa +(1 row) + +select max(v) from bytea_test_table; + max   +------ + \xff +(1 row) + +insert into bytea_test_table values(decode('ffff','hex')); +insert into bytea_test_table values(decode('aaaa','hex')); +select min(v) from bytea_test_table; + min   +------ + \xaa +(1 row) + +select max(v) from bytea_test_table; +  max    +-------- + \xffff +(1 row) +  drop table bytea_test_table;  -- Test parallel string_agg and array_agg  create table pagg_test (x int, y int) with (autovacuum_enabled = off); diff --git a/src/test/regress/expected/opr_sanity.out b/src/test/regress/expected/opr_sanity.out index 0d734169f11..34a32bd11d2 100644 --- a/src/test/regress/expected/opr_sanity.out +++ b/src/test/regress/expected/opr_sanity.out @@ -876,6 +876,8 @@ uuid_extract_timestamp(uuid)  uuid_extract_version(uuid)  crc32(bytea)  crc32c(bytea) +bytea_larger(bytea,bytea) +bytea_smaller(bytea,bytea)  -- restore normal output mode  \a\t  -- List of functions used by libpq's fe-lobj.c diff --git a/src/test/regress/sql/aggregates.sql b/src/test/regress/sql/aggregates.sql index ca6d1bcfb7f..ddf38bafb42 100644 --- a/src/test/regress/sql/aggregates.sql +++ b/src/test/regress/sql/aggregates.sql @@ -747,7 +747,7 @@ select string_agg(distinct f1::text, ',' order by f1) from varchar_tbl;  -- not  select string_agg(distinct f1, ',' order by f1::text) from varchar_tbl;  -- not ok  select string_agg(distinct f1::text, ',' order by f1::text) from varchar_tbl;  -- ok --- string_agg bytea tests +-- string_agg, min, max bytea tests  create table bytea_test_table(v bytea);  select string_agg(v, '') from bytea_test_table; @@ -762,6 +762,15 @@ select string_agg(v, '') from bytea_test_table;  select string_agg(v, NULL) from bytea_test_table;  select string_agg(v, decode('ee', 'hex')) from bytea_test_table; +select min(v) from bytea_test_table; +select max(v) from bytea_test_table; + +insert into bytea_test_table values(decode('ffff','hex')); +insert into bytea_test_table values(decode('aaaa','hex')); + +select min(v) from bytea_test_table; +select max(v) from bytea_test_table; +  drop table bytea_test_table;  -- Test parallel string_agg and array_agg | 
