Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitcd7d8cd

Browse files
committed
Second attempt to stabilize 05c02589.
Removing the EXPLAIN test to stabilize the buildfarm. The executiontest should still be effective to catch the bug even if the plan isslightly different on different platforms.
1 parent6669cc7 commitcd7d8cd

File tree

2 files changed

+0
-24
lines changed

2 files changed

+0
-24
lines changed

‎src/test/regress/expected/groupingsets.out

Lines changed: 0 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -1673,25 +1673,6 @@ update pg_class set reltuples = 10 where relname='bug_16784';
16731673
insert into bug_16784 select g/10, g from generate_series(1,40) g;
16741674
set work_mem='64kB';
16751675
set enable_sort = false;
1676-
explain (costs off) select * from
1677-
(values (1),(2)) v(a),
1678-
lateral (select v.a, i, j, count(*) from
1679-
bug_16784 group by cube(i,j)) s
1680-
order by v.a, i, j;
1681-
QUERY PLAN
1682-
----------------------------------------------------------
1683-
Sort
1684-
Sort Key: "*VALUES*".column1, bug_16784.i, bug_16784.j
1685-
-> Nested Loop
1686-
-> Values Scan on "*VALUES*"
1687-
-> MixedAggregate
1688-
Hash Key: bug_16784.i, bug_16784.j
1689-
Hash Key: bug_16784.i
1690-
Hash Key: bug_16784.j
1691-
Group Key: ()
1692-
-> Seq Scan on bug_16784
1693-
(10 rows)
1694-
16951676
select * from
16961677
(values (1),(2)) v(a),
16971678
lateral (select a, i, j, count(*) from

‎src/test/regress/sql/groupingsets.sql

Lines changed: 0 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -468,11 +468,6 @@ insert into bug_16784 select g/10, g from generate_series(1,40) g;
468468
set work_mem='64kB';
469469
set enable_sort= false;
470470

471-
explain (costs off)select*from
472-
(values (1),(2)) v(a),
473-
lateral (selectv.a, i, j,count(*)from
474-
bug_16784group by cube(i,j)) s
475-
order byv.a, i, j;
476471
select*from
477472
(values (1),(2)) v(a),
478473
lateral (select a, i, j,count(*)from

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp