(cloudberry) 10/22: Fix singlenode AOCO compression test for zlib

[le...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

leborchuk pushed a commit to branch REL_2_STABLE
in repository https://gitbox.apache.org/repos/asf/cloudberry.git

commit f32d1bb0befa25121310be1189a6361705f09794
Author: Dianjin Wang <wa...@gmail.com>
AuthorDate: Wed Jul 1 18:47:55 2026 +0800

    Fix singlenode AOCO compression test for zlib
    
    The singlenode AOCO_Compression test asserted an exact on-disk size
    (712 bytes / 36.75), which depends on the zlib version. Rocky Linux
    10's zlib produced 728 bytes / 35.95 and failed the diff. Ignore the
    detailed output here.
    
    Assisted-by: Claude Code
---
 src/test/singlenode_regress/expected/AOCO_Compression.out | 2 ++
 src/test/singlenode_regress/sql/AOCO_Compression.sql      | 2 ++
 2 files changed, 4 insertions(+)

diff --git a/src/test/singlenode_regress/expected/AOCO_Compression.out b/src/test/singlenode_regress/expected/AOCO_Compression.out
index 74eca4dc3b1..7fd03ee1e6e 100644
--- a/src/test/singlenode_regress/expected/AOCO_Compression.out
+++ b/src/test/singlenode_regress/expected/AOCO_Compression.out
@@ -3571,6 +3571,7 @@ Access method: ao_column
 -- When I insert data
 insert into mpp17012_compress_test2 values('a',generate_series(1,250),'ksjdhfksdhfksdhfksjhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh','bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb');
 -- Then the data will be compressed according to a consistent compression ratio
+-- start_ignore
 select pg_size_pretty(pg_relation_size('mpp17012_compress_test2')),
 get_ao_compression_ratio('mpp17012_compress_test2');
  pg_size_pretty | get_ao_compression_ratio 
@@ -3578,6 +3579,7 @@ get_ao_compression_ratio('mpp17012_compress_test2');
  712 bytes      |                    36.75
 (1 row)
 
+-- end_ignore
 -- Test that an AO/CO table with compresstype zlib and invalid compress level will error at create
 create table a_aoco_table_with_zlib_and_invalid_compression_level(col text) WITH (APPENDONLY=true, COMPRESSTYPE=zlib, compresslevel=-1, ORIENTATION=column);
 ERROR:  value -1 out of bounds for option "compresslevel"
diff --git a/src/test/singlenode_regress/sql/AOCO_Compression.sql b/src/test/singlenode_regress/sql/AOCO_Compression.sql
index 120270886c9..14116b2fed3 100644
--- a/src/test/singlenode_regress/sql/AOCO_Compression.sql
+++ b/src/test/singlenode_regress/sql/AOCO_Compression.sql
@@ -1747,8 +1747,10 @@ get_ao_compression_ratio('mpp17012_compress_test2');
 -- When I insert data
 insert into mpp17012_compress_test2 values('a',generate_series(1,250),'ksjdhfksdhfksdhfksjhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh','bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb');
 -- Then the data will be compressed according to a consistent compression ratio
+-- start_ignore
 select pg_size_pretty(pg_relation_size('mpp17012_compress_test2')),
 get_ao_compression_ratio('mpp17012_compress_test2');
+-- end_ignore
 
 -- Test that an AO/CO table with compresstype zlib and invalid compress level will error at create
 create table a_aoco_table_with_zlib_and_invalid_compression_level(col text) WITH (APPENDONLY=true, COMPRESSTYPE=zlib, compresslevel=-1, ORIENTATION=column);


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org