Release Notes for MariaDB ColumnStore 1.4.4

MariaDB ColumnStore is a columnar storage engine. This is the second GA release in the ColumnStore 1.4 series. This release contains new features and fixes, compared to MariaDB ColumnStore 1.4.3.

This release of MariaDB ColumnStore is included with MariaDB Enterprise Server 10.4.13-7.

MariaDB ColumnStore 1.4.4 was released on 2020-06-08.

Notable Changes

  • columnstore_use_import_for_batchinsert system variable option ALWAYS added to use cpimport for LOAD DATA LOCAL INFILE and INSERT .. SELECT regardless of whether the query runs in a transaction. This gives the user the ability to use a faster import method, with the caveat that if a user issues a rollback of the transaction, it will have no effect as the data would have already been committed to actual database files by cpimport. (MCOL-4000)

Bugs Fixed

Can result in data loss

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

Can result in crashes, hangs, stalls

  • 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)

Can result in unexpected behavior

  • 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)

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

  • 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)

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

  • 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)

Known Issues

  • Built-in SQL functions do not work in ColumnStore when sql_mode=ORACLE (MCOL-4044)

Interface Changes

None.

Platforms

In alignment to the MariaDB Corporation Engineering Policy, MariaDB ColumnStore 1.4.4 is provided for:

  • Red Hat Enterprise Linux 8

  • Red Hat Enterprise Linux 7

  • CentOS 8

  • CentOS 7

  • Ubuntu 20.04

  • Ubuntu 18.04

  • Ubuntu 16.04

  • Debian 10

  • Debian 9

  • Debian 8

  • SUSE Linux Enterprise Server 15

  • SUSE Linux Enterprise Server 12

Upgrade Instructions