Columnstore 23.10.4-1

Notable Changes

• New memory consumption accounting mechanism to prevent OOM events-related crashes. (MCOL-5797)
• FROM_UNIXTIME(negativeDecimal) not behaving as InnoDB (MCOL-4605)
• SEC_TO_TIME(wideDecimal) returns 0 in DECIMAL context (MCOL-4607)
• MOD loses precision on huge narrow decimal (MCOL-4611)
• Different results compared to innodb with union all and subselect with null in select and impossible where condition (MCOL-4942)
• cmapi support for log collection (MCOL-5300)
• JSON_ARRAYAGG in MCS works differently than in InnoDB. (MCOL-5394)
• CLI Startup - Single start command for Single Node (MCOL-5525)
• Alias "mcs CLUSTER" commands to just mcs (MCOL-5526)
• Cmapi (mcs cli) support for columnstore backups (MCOL-5618)
• Improve Client Error Messaging and async broadcasting config. (MCOL-5638)
• CTE/aggreation function give wrong results (MCOL-5842)
• DROP TABLE IF EXISTS should not generate errors for non existing tables (MCOL-5890)
• Disk based GROUP_CONCAT() (MCOL-5921)
• NULLIF function returns -32768 instead of NULL when querying a Columnstore table (MCOL-5922)
• when a value of a column is empty text ('') the result of group_concat(json_object(...)) is null instead of the correct result set (MCOL-5986)

Issues Fixed

Can result in hang or crash

• Creating different keys with cskeys on all nodes can break cluster(key not distributed properly) (MCOL-5019)
• Bitwise aggregation functions do not work with wide decimals (internal error) (MCOL-5386)
• Loss of PrimProc can lead to infinite loop (MCOL-5396)
  GROUP_CONCAT in query uses enormous amount of RAM causing OOM to kill PrimProc (MCOL-5852)
• mariadbd crashing randomly when running "SELECT calShowPartitions(" (MCOL-5879)
• SubAdapterStep::execute() MCS-2035 Fix Requested (MCOL-5889)
• primproc oversubscribes memory (MCOL-5918)
• primproc 11/SEGV - querying a view (MCOL-5932)
• Fix rollbacks in mcs cli and passing errors during broadcasting config. (MCOL-5962)

Related to performance

• Subselect sorting is single-threaded always (MCOL-5316)

What's Changed

• Fix/flag syntax simple fixes mcs backup manager [DUPLICATE 3126] [TO STABLE-23.10] by @mariadb-AlanMologorsky in #3129
• fix: back merge fixes from 23.10.0.2 release branch by @drrtuy in #3135
• Use of newly introduced schema-based name resolution for Oracle-compatible functions by @mariadb-SergeyZefirov in #3139
• Fix/mcol 5691 distinct aggregate disk based by @drrtuy in #3145
• Fixes MCOL-5700, Oracle mode test results by @mariadb-SergeyZefirov in #3157
• Docker multinode provision script expects container names in the cli by @mariadb-SusilBehera in #3173
• enable mariadb-backup Debian packaging and disable TTY for Docker exec by @timofeyturenko in #3180
• fix(cmapi): handle an exception seen in CMAPI at RHEL 8 by @drrtuy in #3188
• Add dependency on libxcrypt for Rocky/RHEL9 by @timofeyturenko in #3192
• MCOL-5352 Properly handle PP restart for DML/DDL operations. by @denis0x0D in #3191
• MCOL-5237 Proper handle DATETIME column for "ifnull" function. by @denis0x0D in #3201
• MCOL-5709: Duplicate stable-23.10 by @mariadb-AlanMologorsky in #3206
• Containers memory limits for CI [stable-23.10] by @mariadb-LeonidFedorov in #3209
• MCOL-5709: Review fix. [DUPLICATE STABLE-23.10] by @mariadb-AlanMologorsky in #3210
• MCOL-5035: a difference in INSERT and UPDATE behavior [stable-23.10] by @mariadb-LeonidFedorov in #3220
• MCOL-5328: PCRE based regexp regexp_substr regexp_instr regexp_replace [stable-23.10] by @mariadb-LeonidFedorov in #3215
• fix(plugin) MCOL-5699: [stable-23.10] by @mariadb-LeonidFedorov in #3219
• MCOL-5747: gcc-14.1.1 compile error - calloc - transposed args [stable-23.10] by @mariadb-LeonidFedorov in #3216
• MCOL-5746: Cpimport: convert blob data [stable-23.10] by @mariadb-LeonidFedorov in #3217
• MCOL-5594: Duplicate to stable-23.10 by @mariadb-AlanMologorsky in #3222
• MCOL-5597 Rollback changes introduced for DJS [stable-23.10] by @denis0x0D in #3224
• MCOL-4480: TEXT type added for alter table add column [ stable-23.10 ] by @mariadb-LeonidFedorov in #3221
• MCOL-5618-related: Duplicate to stable 23.10 by @mariadb-AlanMologorsky in #3223
• fix(join, disk-based): MCOL-5597: large side read errors (#3117) [stable-23-10] by @denis0x0D in #3225
• fix(plugin): MCOL-5236 Take Item from Ref_Item for group by list by @denis0x0D in #3163
• MCOL-5708 Calculate precision and scale for constant decimal.[stable-23.10] by @denis0x0D in #3227
• MCOL-4234 and MCOL 5772 cherry-picked into [stable 23.10] by @mariadb-SergeyZefirov in #3226
• fix(compilation): add explicit comparison operators and explicitly cast a type by @drrtuy in #3229
• chore(build) bury Centos7 [stable-23.10] by @mariadb-LeonidFedorov in #3236
• fix(build) Remove _GLIBXX flags for Columnstore debug builds[stable-23.10] by @mariadb-LeonidFedorov in #3241
• fix(client): MCOL-5587: enable quick mode for predictable performance by @mariadb-SergeyZefirov in #3243
• fix(mcs-savebrm): replace debug with error to put mcs-savebrm.py log messages in order by @drrtuy in #3250
• [DUPLICATE STABLE-23.10] MCOL-5587: Fix columnstore.cnf. by @mariadb-AlanMologorsky in #3254
• MCOL-5587: revert quick mode due the interactive console bug [stable-23.10] by @mariadb-LeonidFedorov in #3255
• Ubuntu 24.04 for CI [stable-23.10] by @mariadb-LeonidFedorov in #3239
• don't add new build dependencies, especially for unit tests [stable-23.10] by @vuvova in #3259
• match the rename in the handler rows_changed->rows_stats.updated in 11.5 [stable-23.10] by @vuvova in #3190
• feat(SM): MCOL-5785 S3Storage improvements [stable-23.10] by @mariadb-AlexeyAntipovsky in #3269
• MCOL-4696: get rid of boost::iequals [stable-23.10] by @mariadb-LeonidFedorov in #3277
• feat(ddl,partitions): better partition-related commands logging[stable-23.10] by @drrtuy in #3292
• MCOL-5779: comment on alter table [stable 23.10] by @mariadb-LeonidFedorov in https://github.com/mariadb-co...

Columnstore 23.10.1-1

What's Changed

• [stable-23.10] Stable branch for .drone by @mariadb-LeonidFedorov in #2992
• [stable-23.10] chore(docs): rename the doc that affects git clone on Windows by @mariadb-LeonidFedorov in #2998
• [stable-23.10] MCOL-5555 Add support for startreadonly command. by @denis0x0D in #2995
• Fix/mcol 5568 stable 23.10 by @drrtuy in #3008
• MCOL-5595: Wrong metadata in CMAPI packages. [STABLE-23.10 DUPLICATE] by @mariadb-AlanMologorsky in #3012
• Stable 23.10.0.2 by @drrtuy in #3019
• MCOL-5597 Set length for nullptr string to 0. by @denis0x0D in #3034
• chore(ci) allow nightly execution for stable by @mariadb-LeonidFedorov in #3042
• chore(ci) bootstrap and upgrade tests (stable-23.10) by @mariadb-LeonidFedorov in #3044
• fix(cmake): raise cmake version to satisfy all the requirements for the current cmake code by @drrtuy in #3037
• fix(build): MCOL-5612 const func pointer assignement must happen after func definition to satisfy modern compilers static analyzer by @drrtuy in #3039
• Mcol 5607 json key matches crash - for stable branch by @mariadb-SergeyZefirov in #3031
• MCOL-5463. [stable-23-10] Same columns fom diffeernt views in GROUP BY do not produce errors by @mariadb-SergeyZefirov in #3046
• Fixes MCOL-5599 where LIKE operator never finishes by @mariadb-SergeyZefirov in #3048
• MCOL-5467 Add support for duplicate expressions in group by. by @denis0x0D in #3052
• fix(rowstorage): SplitMix64 PRNG implementation to replace stdlib MT … by @drrtuy in #3050
• fix(DEC): MCOL-5602 fixing potentially endless loop in DEC by @drrtuy in #3049
• chore(ci) fix mtr according server updates [stable-23.10] by @mariadb-LeonidFedorov in #3055
• chore(ci), fix dependency on upgrade logs [stable-23.10] by @mariadb-LeonidFedorov in #3059
• MCOL-5625: Fixes json_query implementation by @mariadb-SergeyZefirov in #3065
• MCOL-4202: crossdb rename [stable23.10] by @mariadb-LeonidFedorov in #3067
• fix(linkage) link libm to libmarias3 [stable-23.10] by @mariadb-LeonidFedorov in #3071
• fix(disk-based-join): MCOL-5626 Fix for race in DJS with outer join. [stable-23.10] by @denis0x0D in #3072
• Revert "MCOL-5555 Add support for startreadonly command." by @denis0x0D in #3075
• MCOL-5601: Initilize two fields once in ctor instead of calling makeConfig [stable-23.10] by @mariadb-LeonidFedorov in #3074
• MCOL-5555 Add support for startreadonly command. by @denis0x0D in #3081
• MCOL-5610: Aliases on internally dependent tools. [duplicate to stable] by @mariadb-AlanMologorsky in #3089
• MCOL-5631 Optimize BRM load operation. by @denis0x0D in #3090
• MCOL-5623 This patch changes the logic applied to save function for EM by @denis0x0D in #3080
• MCOL-5624: wrong config option stable by @mariadb-LeonidFedorov in #3087
• MCOL-5630: fix multi node MTR. Add "cmapi is-ready" cli command. [DUPLICATE TO STABLE] by @mariadb-AlanMologorsky in #3096
• Boost1.84[stable-23.10] by @mariadb-LeonidFedorov in #3099
• stable-23.10 remove boost from deps, add procsps, due without ps installation halts by @mariadb-LeonidFedorov in #3088
• Updated mcs_backup_manager.sh + test500 [DUPLICATE TO STABLE] by @mariadb-AlanMologorsky in #3115
• MCOL-5650: CMAPI python3 binary crash. [DUPLICATE] [STABLE-23.10] by @mariadb-AlanMologorsky in #3123
• MCOL-5637 Initialize a new bytestream before write to PS by @denis0x0D in #3119
• MCOL-5565: MCOL-5636: MCOL-5645: port from develop-23.02 to [stable-23.10] by @mariadb-LeonidFedorov in #3127

Full Changelog: vcolumnstore-23.10.0-2...vcolumnstore-23.10.1-1

ColumnStore 23.10.0-1 release for ES 10.6.15 and CS 11.1.2/11.2.1

vcolumnstore-23.10.0-1

fix(packaging) dh_missing: warning are treated as errors for buildbot…

ColumnStore 23.02.4-1 release for Enterprise Server 10.6.14-9

MCOL-5521: Use Columnstore VERSION file for CMAPI versioning.

[fix] columnstore_version.cmake setting extra variables for CMAPI versioning
[fix] CMAPI CmakeLists.txt using columnstore_version.cmake file
[fix] CMAPI VERSION file to template file due to using it inside CMAPI applicatio
n

ColumnStore 23.02.3-1 release for Enterprise Server 10.6.12-7

vcolumnstore-23.02.3-1

MCOL-5437 Fixes to follow the charset_info api change introduced by M…

ColumnStore 23.02.2-1 release for Enterprise Server 10.6.12-7

vcolumnstore-23.02.2-1

Bump VERSION to 23.02.2-1.

ColumnStore 23.02.1-1 release for Enterprise Server 10.6.12.-7

vcolumnstore-23.02.1-1

Update drone to use 10.6-enterprise server branch. (#2763)

ColumnStore 22.08.8-1

ColumnStore 22.08.8-1 release for Enterprise Server 10.6.11-6.

v-columnstore-22.08.4-1

Release for enterprise server 10.6.9-5

Columnstore 22.08.3-1

Used with MariaDB Enterprise 10.6.9-5
Fixes multi-node issue