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)

Issues 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

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

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

  • SUSE Linux Enterprise Server 15

  • SUSE Linux Enterprise Server 12

Note

MariaDB Enterprise ColumnStore 1.4 is no longer supported. If you would like to deploy Enterprise ColumnStore, please use MariaDB Enterprise ColumnStore 5.5 in MariaDB Enterprise Server 10.5. For installation and upgrade instructions, see Deploy MariaDB ColumnStore 5.5 with MariaDB Enterprise Server 10.5.