v1.6.0

[edespino]

📝️ What's Changed (Pull Request list)

• Enhance: Add warehouse_id to pg_stat_activity_extended by @lss602726449 in Enhance: Add warehouse_id to pg_stat_activity_extended #453
• Modify the orca optimizer's processing of unionall distribution strat… by @Light-City in Modify the orca optimizer's processing of unionall distribution strat… #399
• Update the location of python-dependencies.txt by @Zhangbaowen-Hashdata in Update the location of python-dependencies.txt #460
• Add hook for exec_simple_query and support self-defined spilling memory threshold in cost module. by @songdongxiaoa2 in Add hook for exec_simple_query and support self-defined spilling memory threshold in cost module. #447
• Fix compile error that pipe is redefined by @gfphoenix78 in Fix compile error that pipe is redefined #349
• [AQUMV] Use contain_var_clause instead of pull_var_clause. by @avamingli in [AQUMV] Use contain_var_clause instead of pull_var_clause. #451
• directory_table: matchignore & remove meta-command username output by @edespino in directory_table: matchignore & remove meta-command username output #464
• Enhance: Add hook to support different way to create/drop/alter wareh… by @lss602726449 in Enhance: Add hook to support different way to create/drop/alter wareh… #462
• Fix: replace gpscp with gpsync in ext fts by @jiaqizho in Fix: replace gpscp with gpsync in ext fts #470
• Re-used index after ALTER COLUMN TYPE shouldn't change relfilenode by @lss602726449 in Re-used index after ALTER COLUMN TYPE shouldn't change relfilenode #474
• Cherry-pick Resgroup related code from GreenPlum [Mar 2, 2022 - Feb 7, 2023] by @foreyes in Cherry-pick Resgroup related code from GreenPlum [Mar 2, 2022 - Feb 7, 2023] #448
• Add weekly build and release process by @Zhangbaowen-Hashdata in Add weekly build and release process #459
• [Answer Query Using Materialized Views] Consider mutable functions and bypass expressions have no Vars for view query target. by @avamingli in [Answer Query Using Materialized Views] Consider mutable functions and bypass expressions have no Vars for view query target.  #455
• [AQUMV] Expose the function adjust view query and varno fix. by @avamingli in [AQUMV] Expose the function adjust view query and varno fix. #469
• Modify weekly build release details by @Zhangbaowen-Hashdata in Modify weekly build release details #477
• Call the query_info_collect_hook directly if expection happens by @foreyes in Call the query_info_collect_hook directly if expection happens #481
• Fix record password_history when the role is not allowed to use profile. by @wenchaozhang-123 in Fix record password_history when the role is not allowed to use profile. #480
• Resolve inconsistent result issue in gpdtm_plpgsql test case by @congxuebin in Resolve inconsistent result issue in gpdtm_plpgsql test case #491
• Fix cbdb ci not running properly by @Zhangbaowen-Hashdata in Fix cbdb ci not running properly #497
• cherry-pick: Work around spurious compiler warning in inet operators by @gfphoenix78 in cherry-pick: Work around spurious compiler warning in inet operators #499
• Add LoongArch(loongarch64) support to s_lock.h by @wangzw in Add LoongArch(loongarch64) support to s_lock.h #500
• Implement some feature of directory table. by @wenchaozhang-123 in Implement some feature of directory table. #484
• Fix copy to replicated table display copy number is incorrect. by @wenchaozhang-123 in Fix copy to replicated table display copy number is incorrect. #498
• Fix the correct size of memory block in bitmapinsert by @gfphoenix78 in Fix the correct size of memory block in bitmapinsert #495
• re-enable the external FTS ICW by @jiaqizho in re-enable the external FTS ICW #483
• Fix ignore of direct table test files. by @avamingli in Fix ignore of direct table test files. #502
• Fix gpinitsystem by @fanfuxiaoran in Fix gpinitsystem #490
• Fix compile errors detected by gcc 12 by @gfphoenix78 in Fix compile errors detected by gcc 12 #503
• Fix bsearch compare function in guc.c by @gfphoenix78 in Fix bsearch compare function in guc.c #507
• [Unstable cases]Fix Some commands forgot to mark meta track. by @avamingli in [Unstable cases]Fix Some commands forgot to mark meta track. #505
• Fix compile error in c++20 by @gfphoenix78 in Fix compile error in c++20 #510
• change AOCO_Compression test case to validate pg_relation_size and get_ao_compression_ratio within ±10% expected range by @congxuebin in change AOCO_Compression test case to validate pg_relation_size and get_ao_compression_ratio within ±10% expected range  #493
• Maintain materialized view data status. by @avamingli in Maintain materialized view data status. #501
• Define EXT_OID_START to suggest oid range for extensions. by @avamingli in Define EXT_OID_START to suggest oid range for extensions. #514
• Ignore pg_upgrade to make CI happy. by @avamingli in Ignore pg_upgrade to make CI happy. #515
• Reduce flakiness in test fts_segment_reset by @jiaqizho in Reduce flakiness in test fts_segment_reset #518
• make gp_dqa test case stable by @congxuebin in make gp_dqa test case stable #521
• Doc: list more tools for Cloudberry Database by @tuhaihe in Doc: list more tools for Cloudberry Database #523
• Fix copy to directory table always return 1. by @wenchaozhang-123 in Fix copy to directory table always return 1. #522
• Reimplement copy from directory table. by @wenchaozhang-123 in Reimplement copy from directory table. #527
• Add materialized view relative triggers case in SingleNode mode. by @avamingli in Add materialized view relative triggers case in SingleNode mode. #517
• [Answer Query Using Materialized Views] Refactor view query target list process. by @avamingli in [Answer Query Using Materialized Views] Refactor view query target list process. #525
• Implementation of Tag. by @wenchaozhang-123 in Implementation of Tag. #444
• Fix segfilecount of AO/AOCO when bulk insertion: COPY by @avamingli in Fix segfilecount of AO/AOCO when bulk insertion: COPY #530
• Feature: Update orafce to 4.9 and enhance it by @foreyes in Feature: Update orafce to 4.9 and enhance it #524
• [AQUMV]Allow to use normal materialized views to answer query. by @avamingli in [AQUMV]Allow to use normal materialized views to answer query. #528
• Support copy from directory table for entry distribution policy. by @wenchaozhang-123 in Support copy from directory table for entry distribution policy. #533
• Small README.md improvement. by @reshke in Small README.md improvement. #534
• Use FDW to query multiple servers as shards by @oppenheimer01 in Use FDW to query multiple servers as shards #320
• Add an option in psql to avoid encoding issues on some platforms by @gfphoenix78 in Add an option in psql to avoid encoding issues on some platforms #535
• Refactor cbdb_log to use vfprintf by @ruhuang2001 in Refactor cbdb_log to use vfprintf #506
• Update aocsam.c: fix safeFSWriteSize arg type by @reshke in Update aocsam.c: fix safeFSWriteSize arg type #540
• Update the image to Rockylinux8 to ensure the normal operation of CI by @Zhangbaowen-Hashdata in Update the image to Rockylinux8 to ensure the normal operation of CI #556
• Remove unsupported AC_FUNC_FSEEKO macro by @gfphoenix78 in Remove unsupported AC_FUNC_FSEEKO macro #543
• adjust test cases for the cloudberrydb binary swap test by @congxuebin in adjust test cases for the cloudberrydb binary swap test #537
• CREATE FOREIGN TABLE LIKE. by @avamingli in CREATE FOREIGN TABLE LIKE. #554
• Enable SingleQE join with SegmentGeneralWorkers by @avamingli in Enable SingleQE join with SegmentGeneralWorkers #327
• Use syscache lookup in ShouldUseReservedSegno by @gongxun0928 in Use syscache lookup in ShouldUseReservedSegno #541
• Implement READ_STRING_FIELD_NULL serializable read function. by @wenchaozhang-123 in Implement READ_STRING_FIELD_NULL serializable read function. #553
• Fix: free tupleDesc on commit or abort transcation. by @yjhjstz in Fix: free tupleDesc on commit or abort transcation. #551
• Update appendonlywriter.c: fix debug message by @reshke in Update appendonlywriter.c: fix debug message #564
• Fix crash of COPY FROM on AO/AOCO/PAX partition tables. by @avamingli in Fix crash of COPY FROM on AO/AOCO/PAX partition tables. #549
• Fix: Add ao_unique_index_build test in greenplum_schedule by @lss602726449 in Fix: Add ao_unique_index_build test in greenplum_schedule #562
• Fix copy some directory table to problems. by @wenchaozhang-123 in Fix copy some directory table to problems. #550
• Fix bug with base relation truncate for IMMV by @reshke in Fix bug with base relation truncate for IMMV #570
• Suppress compile-time error in SparseData.h by @reshke in Suppress compile-time error in SparseData.h #566
• Support lock directory table. by @wenchaozhang-123 in Support lock directory table. #572
• Doc: update the alter table help command content by @EcaleD in Doc: update the alter table help command content #574
• Cherry-pick Resgroup V2 and toolkit from GPDB by @jiaqizho in Cherry-pick Resgroup V2 and toolkit from GPDB #531
• Fix: no need to do the qual-clause twice by @jiaqizho in Fix: no need to do the qual-clause twice #396
• [ORCA]: fallback to postgres optimizer when NL inner plan is index scan by @gfphoenix78 in [ORCA]: fallback to postgres optimizer when NL inner plan is index scan #565
• Add FIXME about redundant param from 'ivm_visible_in_prestate' call. by @reshke in Add FIXME about redundant param from 'ivm_visible_in_prestate' call. #578
• Support distributed by clause specification when Create MV if not exists by @reshke in Support distributed by clause specification when Create MV if not exists #563
• Cherry pick commits related to recent RESGROUP v2 merge. by @reshke in Cherry pick commits related to recent RESGROUP v2 merge.  #579
• Change temp table name used to IMMV to some less frequent sequence of… by @reshke in Change temp table name used to IMMV to some less frequent sequence of… #581
• Rephrase comment for deferred IVM case by @reshke in Rephrase comment for deferred IVM case #576
• Fix pxf_fragment.c compilation failure by @Terry1504 in Fix pxf_fragment.c compilation failure #590
• Fix pg_upgrade version parsing when upgrading from Greenplum by @reshke in Fix pg_upgrade version parsing when upgrading from Greenplum #599
• Enable fsync=on by default in gpAux/gpdemo/gpdemo-defaults.sh by @yjhjstz in Enable fsync=on by default in gpAux/gpdemo/gpdemo-defaults.sh #585
• Fix serialization of expr AEXPR_NOT_DISTINCT. by @avamingli in Fix serialization of expr AEXPR_NOT_DISTINCT. #598
• Forbid inherits tables to store into gp_matview_aux. by @avamingli in Forbid inherits tables to store into gp_matview_aux. #587
• [AQUMV] Check relation actually has children when view matching. by @avamingli in [AQUMV] Check relation actually has children when view matching. #577
• Update check.c: fixed Cloudberry incorrect references by @reshke in Update check.c: fixed Cloudberry incorrect references #600
• Fix writable rules on table has relative matview. by @avamingli in Fix writable rules on table has relative matview. #584
• Fix writable CTE cause wrong matview data status. by @avamingli in Fix writable CTE cause wrong matview data status. #602
• Send rows in binary mode for ANALYZE by @Light-City in Send rows in binary mode for ANALYZE #601
• Enable the resgroup test cases in CI by @jiaqizho in Enable the resgroup test cases in CI #539
• Fix: could not pull up equivalence class using projected target list by @yjhjstz in Fix: could not pull up equivalence class using projected target list #606
• Remove cbdb weekly and release workflows. by @edespino in Remove cbdb weekly and release workflows. #615

Full Changelog: 1.5.4...1.6.0

---

🙌🏻️ New Contributors

• @Light-City made their first contribution in Modify the orca optimizer's processing of unionall distribution strat… #399
• @songdongxiaoa2 made their first contribution in Add hook for exec_simple_query and support self-defined spilling memory threshold in cost module. #447
• @edespino made their first contribution in directory_table: matchignore & remove meta-command username output #464
• @congxuebin made their first contribution in Resolve inconsistent result issue in gpdtm_plpgsql test case #491
• @wangzw made their first contribution in Add LoongArch(loongarch64) support to s_lock.h #500
• @reshke made their first contribution in Small README.md improvement. #534
• @oppenheimer01 made their first contribution in Use FDW to query multiple servers as shards #320
• @ruhuang2001 made their first contribution in Refactor cbdb_log to use vfprintf #506
• @EcaleD made their first contribution in Doc: update the alter table help command content #574
• @Terry1504 made their first contribution in Fix pxf_fragment.c compilation failure #590

---

🧑🏻‍💻 Contributors

👍 Thanks to all the contributors to make this release happen:
@Aegeaner, @EcaleD, @Light-City, @RMTT, @SmartKeyerror, @Tao-T, @Terry1504, @Zhangbaowen-Hashdata, @adam8157, @airfan1994, @andr-sokolov, @ashwinstar, @avamingli, @beeender, @bmdoil, @charliettxx, @congxuebin, @dgkimura, @dh-cloud, @divyeshddv, @dreamedcheng, @edespino, @eespino, @fairyfar, @fanfuxiaoran, @foreyes, @gfphoenix78, @gongxun0928, @gpopt, @higuoxing, @huansong, @hyongtao-db, @jchampio, @jiaqizho, @jimmyyih, @kainwen, @l-wang, @lss602726449, @oppenheimer01, @reshke, @ruhuang2001, @songdongxiaoa2, @soumyadeep2007, @thedanhoffman, @tuhaihe, @wangzw, @wenchaozhang-123, @yanwr1, @yaowangm, @yjhjstz, @zhrt123, @zxuejing

---

_{🧂🧪 Try out Cloudberry Database via building one Docker-based Sandbox, which is tailored to help you gain a basic understanding of Cloudberry Database's capabilities and features a range of materials, including tutorials, sample code, and crash courses.}

---

This discussion was created from the release v1.6.0.

[tuhaihe]

Great work! Thanks @edespino! 👍

[jianlirong]

Great work!

[reshke]

Great 💯 💯 💯