This is an automated email from the ASF dual-hosted git repository.
chenjinbao1989 pushed a commit to branch cbdb-postgres-merge
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
The following commit(s) were added to refs/heads/cbdb-postgres-merge by this
push:
new d04a3e2894c Fix some answer file for isolation2
d04a3e2894c is described below
commit d04a3e2894c943ded97e4aaa1e4df1cdf35d10c9
Author: Jinbao Chen <[email protected]>
AuthorDate: Wed Feb 4 09:28:54 2026 +0800
Fix some answer file for isolation2
---
...tition_table_operations_should_not_deadlock.out | 32 +--
src/test/isolation2/output/uao/brin.source | 226 ++++++++++-----------
2 files changed, 129 insertions(+), 129 deletions(-)
diff --git
a/src/test/isolation2/expected/concurrent_partition_table_operations_should_not_deadlock.out
b/src/test/isolation2/expected/concurrent_partition_table_operations_should_not_deadlock.out
index 5bf7a29ffbe..1916a6e6cf6 100644
---
a/src/test/isolation2/expected/concurrent_partition_table_operations_should_not_deadlock.out
+++
b/src/test/isolation2/expected/concurrent_partition_table_operations_should_not_deadlock.out
@@ -1,5 +1,5 @@
CREATE EXTENSION IF NOT EXISTS gp_inject_fault;
-CREATE EXTENSION
+CREATE
-- Two concurrent transactions on partitioned table
@@ -7,9 +7,9 @@ CREATE EXTENSION
-- 2) truncate
-- should not cause deadlock
CREATE TABLE pt(a int, b text) DISTRIBUTED BY (a) PARTITION BY range(a) (start
(0) end(10) every(2));
-CREATE TABLE
+CREATE
INSERT INTO pt SELECT i%10, 'text'||i FROM generate_series(1, 10)i;
-INSERT 0 10
+INSERT 10
VACUUM ANALYZE pt;
VACUUM
@@ -18,9 +18,9 @@ VACUUM
------------------------------------------
Gather Motion 3:1 (slice1; segments: 3)
-> Append
- -> Seq Scan on pt_1_prt_1
+ -> Seq Scan on pt_1_prt_1 pt_1
Filter: (a < 4)
- -> Seq Scan on pt_1_prt_2
+ -> Seq Scan on pt_1_prt_2 pt_2
Filter: (a < 4)
Optimizer: Postgres query optimizer
(7 rows)
@@ -75,9 +75,9 @@ BEGIN
0 | text10
(4 rows)
1: END;
-COMMIT
+END
2<: <... completed>
-TRUNCATE TABLE
+TRUNCATE
-- Two concurrent transactions on partitioned table
@@ -85,7 +85,7 @@ TRUNCATE TABLE
-- 2) truncate
-- should not cause deadlock
CREATE INDEX idx ON pt(a);
-CREATE INDEX
+CREATE
VACUUM ANALYZE pt;
VACUUM
@@ -94,9 +94,9 @@ VACUUM
------------------------------------------
Gather Motion 3:1 (slice1; segments: 3)
-> Append
- -> Seq Scan on pt_1_prt_1
+ -> Seq Scan on pt_1_prt_1 pt_1
Filter: (a < 4)
- -> Seq Scan on pt_1_prt_2
+ -> Seq Scan on pt_1_prt_2 pt_2
Filter: (a < 4)
Optimizer: Postgres query optimizer
(7 rows)
@@ -147,9 +147,9 @@ BEGIN
3 | text3
(2 rows)
1: END;
-COMMIT
+END
2<: <... completed>
-TRUNCATE TABLE
+TRUNCATE
-- Two concurrent transactions on partitioned table
@@ -164,9 +164,9 @@ VACUUM
------------------------------------------
Gather Motion 3:1 (slice1; segments: 3)
-> Append
- -> Seq Scan on pt_1_prt_1
+ -> Seq Scan on pt_1_prt_1 pt_1
Filter: (a < 4)
- -> Seq Scan on pt_1_prt_2
+ -> Seq Scan on pt_1_prt_2 pt_2
Filter: (a < 4)
Optimizer: Postgres query optimizer
(7 rows)
@@ -217,6 +217,6 @@ BEGIN
3
(2 rows)
1: END;
-COMMIT
+END
2<: <... completed>
-TRUNCATE TABLE
+TRUNCATE
diff --git a/src/test/isolation2/output/uao/brin.source
b/src/test/isolation2/output/uao/brin.source
index 5fae106e460..db895cc3182 100644
--- a/src/test/isolation2/output/uao/brin.source
+++ b/src/test/isolation2/output/uao/brin.source
@@ -99,11 +99,11 @@ SELECT
brin_summarize_new_values('brin_ao_summarize_@amname@_i_idx');
(2,3)
(3 rows)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_ao_summarize_@amname@_i_idx', 2),
'brin_ao_summarize_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+----------
- 1 | 33554432 | 1 | f | f | f | {1 .. 1}
- 2 | 33554433 | 1 | f | f | f | {1 .. 1}
- 3 | 33554434 | 1 | f | f | f | {1 .. 1}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+----------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 1}
+ 2 | 33554433 | 1 | f | f | f | f |
{1 .. 1}
+ 3 | 33554434 | 1 | f | f | f | f |
{1 .. 1}
(3 rows)
-- Sanity: Scan should return all 3 blocks in the tidbitmap.
@@ -154,11 +154,11 @@ SELECT populate_pages('brin_ao_summarize_@amname@', 20,
tid '(33554436, 0)');
(2,3)
(3 rows)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_ao_summarize_@amname@_i_idx', 2),
'brin_ao_summarize_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+-----------
- 1 | 33554432 | 1 | f | f | f | {1 .. 1}
- 2 | 33554433 | 1 | f | f | f | {1 .. 1}
- 3 | 33554434 | 1 | f | f | f | {1 ..
20}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+-----------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 1}
+ 2 | 33554433 | 1 | f | f | f | f |
{1 .. 1}
+ 3 | 33554434 | 1 | f | f | f | f |
{1 .. 20}
(3 rows)
-- Sanity: Scan should return all blocks in the tidbitmap.
@@ -209,13 +209,13 @@ SELECT
brin_summarize_new_values('brin_ao_summarize_@amname@_i_idx');
(2,5)
(5 rows)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_ao_summarize_@amname@_i_idx', 2),
'brin_ao_summarize_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | f | f | f | {1 .. 1}
- 2 | 33554433 | 1 | f | f | f | {1 .. 1}
- 3 | 33554434 | 1 | f | f | f | {1 ..
20}
- 4 | 33554435 | 1 | f | f | f | {20 ..
20}
- 5 | 33554436 | 1 | f | f | f | {20 ..
20}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 1}
+ 2 | 33554433 | 1 | f | f | f | f |
{1 .. 1}
+ 3 | 33554434 | 1 | f | f | f | f |
{1 .. 20}
+ 4 | 33554435 | 1 | f | f | f | f |
{20 .. 20}
+ 5 | 33554436 | 1 | f | f | f | f |
{20 .. 20}
(5 rows)
-- Sanity: Scan should return only the first 3 blocks in the tidbitmap, now
that
@@ -293,13 +293,13 @@ SELECT populate_pages('brin_ao_summarize_@amname@', 30,
tid '(33554438, 0)');
(2,5)
(5 rows)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_ao_summarize_@amname@_i_idx', 2),
'brin_ao_summarize_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | f | f | f | {1 .. 1}
- 2 | 33554433 | 1 | f | f | f | {1 .. 1}
- 3 | 33554434 | 1 | f | f | f | {1 ..
20}
- 4 | 33554435 | 1 | f | f | f | {20 ..
20}
- 5 | 33554436 | 1 | f | f | f | {20 ..
30}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 1}
+ 2 | 33554433 | 1 | f | f | f | f |
{1 .. 1}
+ 3 | 33554434 | 1 | f | f | f | f |
{1 .. 20}
+ 4 | 33554435 | 1 | f | f | f | f |
{20 .. 20}
+ 5 | 33554436 | 1 | f | f | f | f |
{20 .. 30}
(5 rows)
DELETE FROM brin_ao_summarize_@amname@ WHERE i = 1;
@@ -378,16 +378,16 @@ SELECT distinct(right(split_part(ctid::text, ',', 1),
-1)) AS blknum FROM brin_a
(2,8)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_ao_summarize_@amname@_i_idx', 2),
'brin_ao_summarize_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | f | f | f | {1 .. 1}
- 2 | 33554433 | 1 | f | f | f | {1 .. 1}
- 3 | 33554434 | 1 | f | f | f | {1 ..
20}
- 4 | 33554435 | 1 | f | f | f | {20 ..
20}
- 5 | 33554436 | 1 | f | f | f | {20 ..
30}
- 6 | 33554437 | 1 | t | f | f |
- 7 | 33554438 | 1 | f | f | f | {40 ..
40}
- 8 | 67108864 | 1 | f | f | f | {20 ..
30}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 1}
+ 2 | 33554433 | 1 | f | f | f | f |
{1 .. 1}
+ 3 | 33554434 | 1 | f | f | f | f |
{1 .. 20}
+ 4 | 33554435 | 1 | f | f | f | f |
{20 .. 20}
+ 5 | 33554436 | 1 | f | f | f | f |
{20 .. 30}
+ 6 | 33554437 | 1 | t | f | f | t |
+ 7 | 33554438 | 1 | f | f | f | f |
{40 .. 40}
+ 8 | 67108864 | 1 | f | f | f | f |
{20 .. 30}
(8 rows)
-- Sanity: Scan should return only first 3 blocks corresponding to the vacuumed
@@ -448,16 +448,16 @@ SELECT
brin_summarize_new_values('brin_ao_summarize_@amname@_i_idx');
(2,8)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_ao_summarize_@amname@_i_idx', 2),
'brin_ao_summarize_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | f | f | f | {1 .. 1}
- 2 | 33554433 | 1 | f | f | f | {1 .. 1}
- 3 | 33554434 | 1 | f | f | f | {1 ..
20}
- 4 | 33554435 | 1 | f | f | f | {20 ..
20}
- 5 | 33554436 | 1 | f | f | f | {20 ..
30}
- 6 | 33554437 | 1 | t | f | f |
- 7 | 33554438 | 1 | f | f | f | {40 ..
40}
- 8 | 67108864 | 1 | f | f | f | {20 ..
30}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 1}
+ 2 | 33554433 | 1 | f | f | f | f |
{1 .. 1}
+ 3 | 33554434 | 1 | f | f | f | f |
{1 .. 20}
+ 4 | 33554435 | 1 | f | f | f | f |
{20 .. 20}
+ 5 | 33554436 | 1 | f | f | f | f |
{20 .. 30}
+ 6 | 33554437 | 1 | t | f | f | t |
+ 7 | 33554438 | 1 | f | f | f | f |
{40 .. 40}
+ 8 | 67108864 | 1 | f | f | f | f |
{20 .. 30}
(8 rows)
--------------------------------------------------------------------------------
@@ -552,12 +552,12 @@ SELECT
brin_summarize_range('brin_ao_specific_@amname@_i_idx', 100663296);
(2,4)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_ao_specific_@amname@_i_idx', 2),
'brin_ao_specific_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+----------
- 1 | 33554432 | 1 | f | f | f | {1 .. 1}
- 2 | 33554433 | 1 | f | f | f | {1 .. 1}
- 3 | 33554435 | 1 | f | f | f | {1 .. 1}
- 4 | 67108864 | 1 | f | f | f | {1 .. 1}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+----------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 1}
+ 2 | 33554433 | 1 | f | f | f | f |
{1 .. 1}
+ 3 | 33554435 | 1 | f | f | f | f |
{1 .. 1}
+ 4 | 67108864 | 1 | f | f | f | f |
{1 .. 1}
(4 rows)
-- Now test desummarization
@@ -604,12 +604,12 @@ SELECT
brin_desummarize_range('brin_ao_specific_@amname@_i_idx', 100663296);
(2,4)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_ao_specific_@amname@_i_idx', 2),
'brin_ao_specific_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+----------
- 1 | 33554432 | 1 | f | f | f | {1 .. 1}
- 2 | 33554433 | 1 | f | f | f | {1 .. 1}
- 3 | 33554435 | 1 | f | f | f | {1 .. 1}
- 4 | 67108864 | 1 | f | f | f | {1 .. 1}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+----------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 1}
+ 2 | 33554433 | 1 | f | f | f | f |
{1 .. 1}
+ 3 | 33554435 | 1 | f | f | f | f |
{1 .. 1}
+ 4 | 67108864 | 1 | f | f | f | f |
{1 .. 1}
(4 rows)
-- Should be able to desummarize all existing blocks in aoseg1.
@@ -639,12 +639,12 @@ SELECT
brin_desummarize_range('brin_ao_specific_@amname@_i_idx', 100663296);
(4294967295,0)
(3 rows)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_ao_specific_@amname@_i_idx', 2),
'brin_ao_specific_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+----------
- 4 | 67108864 | 1 | f | f | f | {1 .. 1}
- 1 | | | | | |
- 2 | | | | | |
- 3 | | | | | |
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+----------
+ 4 | 67108864 | 1 | f | f | f | f |
{1 .. 1}
+ 1 | | | | | | |
+ 2 | | | | | | |
+ 3 | | | | | | |
(4 rows)
-- Now desummarize the last remaining range in the data page (from aoseg2).
@@ -744,10 +744,10 @@ SELECT
brin_summarize_new_values('brin_ao_summarize_partial_@amname@_i_idx');
(2,2)
(2 rows)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_ao_summarize_partial_@amname@_i_idx', 2),
'brin_ao_summarize_partial_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+----------
- 1 | 33554432 | 1 | f | f | f | {1 .. 1}
- 2 | 33554435 | 1 | f | f | f | {1 .. 1}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+----------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 1}
+ 2 | 33554435 | 1 | f | f | f | f |
{1 .. 1}
(2 rows)
--------------------------------------------------------------------------------
@@ -800,9 +800,9 @@ SELECT
gp_wait_until_triggered_fault('summarize_last_partial_range', 1, dbid) FR
(2,1)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_range_extended1_@amname@_i_idx', 2),
'brin_range_extended1_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+-------
- 1 | 33554432 | 1 | t | f | t |
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+-------
+ 1 | 33554432 | 1 | t | f | t | t |
(1 row)
-- Insert a different value into seg1 concurrently.
@@ -824,9 +824,9 @@ INSERT 1
(2,1)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_range_extended1_@amname@_i_idx', 2),
'brin_range_extended1_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | f | f | t | {20 ..
20}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | f | f | t | f |
{20 .. 20}
(1 row)
SELECT gp_inject_fault('summarize_last_partial_range', 'reset', dbid) FROM
gp_segment_configuration WHERE content = 1 AND role = 'p';
@@ -858,9 +858,9 @@ SELECT gp_inject_fault('summarize_last_partial_range',
'reset', dbid) FROM gp_se
(2,1)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_range_extended1_@amname@_i_idx', 2),
'brin_range_extended1_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+-----------
- 1 | 33554432 | 1 | f | f | f | {1 ..
20}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+-----------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 20}
(1 row)
-- Sanity: Scan should return all 3 blocks in the tidbitmap, even though the
@@ -933,9 +933,9 @@ SELECT
gp_wait_until_triggered_fault('summarize_last_partial_range', 1, dbid) FR
(2,1)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_range_extended2_@amname@_i_idx', 2),
'brin_range_extended2_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+-------
- 1 | 33554432 | 1 | t | f | t |
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+-------
+ 1 | 33554432 | 1 | t | f | t | t |
(1 row)
-- Extend the last partial range by 1 block.
@@ -960,9 +960,9 @@ SELECT populate_pages('brin_range_extended2_@amname@', 20,
tid '(33554435, 0)');
(2,1)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_range_extended2_@amname@_i_idx', 2),
'brin_range_extended2_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | f | f | t | {20 ..
20}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | f | f | t | f |
{20 .. 20}
(1 row)
SELECT gp_inject_fault('summarize_last_partial_range', 'reset', dbid) FROM
gp_segment_configuration WHERE content = 1 AND role = 'p';
@@ -994,9 +994,9 @@ SELECT gp_inject_fault('summarize_last_partial_range',
'reset', dbid) FROM gp_se
(2,1)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_range_extended2_@amname@_i_idx', 2),
'brin_range_extended2_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | f | f | t | {20 ..
20}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | f | f | t | f |
{20 .. 20}
(1 row)
-- Another insert into the same QE and the same range should not change the
fact
@@ -1016,9 +1016,9 @@ INSERT 1
(2,1)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_range_extended2_@amname@_i_idx', 2),
'brin_range_extended2_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | f | f | t | {20 ..
30}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | f | f | t | f |
{20 .. 30}
(1 row)
--------------------------------------------------------------------------------
@@ -1068,12 +1068,12 @@ CREATE
(2,2)
(2 rows)
1U: SELECT * FROM brin_page_items(get_raw_page('brin_multi_@amname@_i_idx',
2), 'brin_multi_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | f | f | f | {1 .. 1}
- 2 | 33554433 | 1 | f | f | f | {1 .. 1}
- 3 | 67108864 | 1 | f | f | f | {20 ..
20}
- 4 | 67108865 | 1 | f | f | f | {20 ..
20}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | f | f | f | f |
{1 .. 1}
+ 2 | 33554433 | 1 | f | f | f | f |
{1 .. 1}
+ 3 | 67108864 | 1 | f | f | f | f |
{20 .. 20}
+ 4 | 67108865 | 1 | f | f | f | f |
{20 .. 20}
(4 rows)
-- Sanity: Scan should return all 4 blocks across both segfiles in the
tidbitmap.
@@ -1147,11 +1147,11 @@ SELECT
brin_summarize_new_values('brin_abort_@amname@_i_idx');
(2,3)
(3 rows)
1U: SELECT * FROM brin_page_items(get_raw_page('brin_abort_@amname@_i_idx',
2), 'brin_abort_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+-------
- 1 | 33554432 | 1 | t | f | f |
- 2 | 33554433 | 1 | t | f | f |
- 3 | 33554434 | 1 | t | f | f |
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+-------
+ 1 | 33554432 | 1 | t | f | f | t |
+ 2 | 33554433 | 1 | t | f | f | t |
+ 3 | 33554434 | 1 | t | f | f | t |
(3 rows)
-- Sanity: Scan should return no blocks in the tidbitmap, as the summary tuples
@@ -1210,12 +1210,12 @@ SELECT
brin_summarize_new_values('brin_abort_@amname@_i_idx');
(2,4)
(4 rows)
1U: SELECT * FROM brin_page_items(get_raw_page('brin_abort_@amname@_i_idx',
2), 'brin_abort_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | t | f | f |
- 2 | 33554433 | 1 | t | f | f |
- 3 | 33554434 | 1 | f | f | f | {20 ..
20}
- 4 | 33554435 | 1 | f | f | f | {20 ..
20}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | t | f | f | t |
+ 2 | 33554433 | 1 | t | f | f | t |
+ 3 | 33554434 | 1 | f | f | f | f |
{20 .. 20}
+ 4 | 33554435 | 1 | f | f | f | f |
{20 .. 20}
(4 rows)
-- Sanity: Scan should return only the 2 blocks corresponding to the committed
@@ -1266,12 +1266,12 @@ CREATE
(2,4)
(4 rows)
1U: SELECT * FROM brin_page_items(get_raw_page('brin_abort_@amname@_i_idx',
2), 'brin_abort_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33554432 | 1 | t | f | f |
- 2 | 33554433 | 1 | t | f | f |
- 3 | 33554434 | 1 | f | f | f | {20 ..
20}
- 4 | 33554435 | 1 | f | f | f | {20 ..
20}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33554432 | 1 | t | f | f | t |
+ 2 | 33554433 | 1 | t | f | f | t |
+ 3 | 33554434 | 1 | f | f | f | f |
{20 .. 20}
+ 4 | 33554435 | 1 | f | f | f | f |
{20 .. 20}
(4 rows)
-- Sanity: Scan should return only the 2 blocks corresponding to the committed
@@ -1494,9 +1494,9 @@ SELECT
brin_summarize_range('brin_abort_fullpage_@amname@_i_idx', 33559886);
(5,1)
(1 row)
1U: SELECT * FROM
brin_page_items(get_raw_page('brin_abort_fullpage_@amname@_i_idx', 5),
'brin_abort_fullpage_@amname@_i_idx') ORDER BY blknum, attnum;
- itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
-------------+----------+--------+----------+----------+-------------+------------
- 1 | 33559886 | 1 | f | f | f | {20 ..
20}
+ itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty |
value
+------------+----------+--------+----------+----------+-------------+-------+------------
+ 1 | 33559886 | 1 | f | f | f | f |
{20 .. 20}
(1 row)
RESET enable_seqscan;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
