Release Notes for MariaDB ColumnStore 1.4.4

UPDATE can modify incorrect data due to incorrect WHERE clause handling. (MCOL-4023)

A hang may occur in load_brm on dbroot1 failover. (MCOL-3945)

CREATE TABLE may be blocked by improper failover. (MCOL-3999)

Crash may occur when using cpimport (LOAD DATA LOCAL INFILE) to process data containing multi-byte characters. (MCOL-4005)

Rollback may trigger crash of StorageManager. (MCOL-4021)

PM failover and movePmDbrootConfig failure on CentOS 7 with glusterfs. (MCOL-3842)

ORDER BY over negative SEC_TO_TIME() results produce an incorrect order. (MCOL-3598)

Subqueries with ORDER and LIMIT may produce the wrong answer. (MCOL-3747)

IN clause in WHERE could be evaluated improperly. (MCOL-2096)

Sub-query with GROUP BY and ORDER BY allows non-aggregates in projection. (MCOL-2166)

FILE001.cdf:No such file or directory can occur when query, TRUNCATE and cpimport collide. (MCOL-3251)

Internal error: IDB-2035 can occur with BIT_OR function in projection and subquery in FROM (MCOL-3356)

Incorrect handling of ORDER BY can occur in some queries. (MCOL-3485)

Unexpected syntax errors could be returned from window functions. (MCOL-3580)

Format(c1,0) returns only sign, without a digit, on a decimal(1) field. (MCOL-3595)

TIMEDIFF() returns NULL instead of expected value. (MCOL-3597)

MODA() and REGR_ UDAFs are not properly created. (MCOL-3599)

BIT_COUNT(), CHARSET(), UNHEX(), and MINUTE() functions did not exist. (MCOL-3600)

regr_ tests returns doubles with higher precision than in ColumnStore 1.2. (MCOL-3631)

Window function failures could return results rather than errors. (MCOL-3632)

ISTRUE() function did not exist. (MCOL-3756)

Alternate behavior for rand() vs ColumnStore 1.2. (MCOL-3760)

Wrong error could be returned on every second run of an error-generating query. (MCOL-3777)

Internal error: IDB-2021: 'tablename' is not in GROUP BY clause could occur. (MCOL-3782)

UNION may complain about table not in query. (MCOL-3828)

COUNT() as a window function does not work correctly with NULL values. (MCOL-3839)

SQLYog may encounter an error during ColumnStore cross-engine JOINs. (MCOL-3845)

GROUP_CONCAT() with ORDER BY and long doubles may fail. (MCOL-3904)

Error messages may point to the wrong function. (MCOL-3924)

Microsecond support for FROM_UNIXTIME() (MCOL-3959)

INSERT after a LOAD DATA LOCAL INFILE in a transaction may silently fail. (MCOL-4002)

Unsupported LIMIT in correlated subqueries may give erroneous result. (MCOL-3757)

Subquery wrapping impacts performance. (MCOL-3664)

Unoptimized lines (CPU impact and unnecessary rounding error) in regr_sxx, regr-sxy, and regr_syy (MCOL-3837)

postConfigure uses invalid device nodes for dbroots. (MCOL-2022)

startsystem allows startup without correct DBROOT 1 assignment. (MCOL-2153)

Incorrect handling of unassigned IP addresses in configuration file. (MCOL-2181)

After shutdownsystem, first startsystem always fails. (MCOL-3704)

ColumnStore Tools for 1.4 were unavailable. (MCOL-3847)

postConfigure reports false positive that server is running. (MCOL-3870)

postConfigure looks in incorrect location for columnstore.cnf.rpmsave during an upgrade. (MCOL-3887)

Multi-node non-systemd installation with replication enabled fails to start. (MCOL-3985)

storagemanager.cnf variable $HOME drew path from user's environment. $HOME now points to the current location of ColumnStore data. (MCOL-4014)

Changing systemlang in Columnstore.xml to an unrecognized string will prevent ColumnStore startup. (MCOL-3420)