diff options
Diffstat (limited to 'src/test/regress/expected/aggregates.out')
| -rw-r--r-- | src/test/regress/expected/aggregates.out | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/src/test/regress/expected/aggregates.out b/src/test/regress/expected/aggregates.out index 3259a22516e..14cdcfcca6e 100644 --- a/src/test/regress/expected/aggregates.out +++ b/src/test/regress/expected/aggregates.out @@ -2453,22 +2453,22 @@ set work_mem='64kB'; set enable_hashagg = false; set jit_above_cost = 0; explain (costs off) -select g%100000 as c1, sum(g::numeric) as c2, count(*) as c3 - from generate_series(0, 199999) g - group by g%100000; +select g%10000 as c1, sum(g::numeric) as c2, count(*) as c3 + from generate_series(0, 19999) g + group by g%10000; QUERY PLAN ------------------------------------------------ GroupAggregate - Group Key: ((g % 100000)) + Group Key: ((g % 10000)) -> Sort - Sort Key: ((g % 100000)) + Sort Key: ((g % 10000)) -> Function Scan on generate_series g (5 rows) create table agg_group_1 as -select g%100000 as c1, sum(g::numeric) as c2, count(*) as c3 - from generate_series(0, 199999) g - group by g%100000; +select g%10000 as c1, sum(g::numeric) as c2, count(*) as c3 + from generate_series(0, 19999) g + group by g%10000; create table agg_group_2 as select * from (values (100), (300), (500)) as r(a), @@ -2493,20 +2493,20 @@ set enable_hashagg = true; set enable_sort = false; set jit_above_cost = 0; explain (costs off) -select g%100000 as c1, sum(g::numeric) as c2, count(*) as c3 - from generate_series(0, 199999) g - group by g%100000; +select g%10000 as c1, sum(g::numeric) as c2, count(*) as c3 + from generate_series(0, 19999) g + group by g%10000; QUERY PLAN ------------------------------------------ HashAggregate - Group Key: (g % 100000) + Group Key: (g % 10000) -> Function Scan on generate_series g (3 rows) create table agg_hash_1 as -select g%100000 as c1, sum(g::numeric) as c2, count(*) as c3 - from generate_series(0, 199999) g - group by g%100000; +select g%10000 as c1, sum(g::numeric) as c2, count(*) as c3 + from generate_series(0, 19999) g + group by g%10000; create table agg_hash_2 as select * from (values (100), (300), (500)) as r(a), |