Today, we are releasing MariaDB Server 10.3.5, which is our first Release Candidate for 10.3.
Now feature complete, our user and customer base can move from reviewing and testing new features to integrating MariaDB Server into their staging environment to prove it against existing applications and to enhance their applications with new use cases provided through the abundance of new and exciting features in MariaDB Server, like temporal data processing. Another strong focus of this version is database compatibility where we have added several new features. With MariaDB Server 10.3, it’s even easier to migrate from legacy database systems to open source MariaDB.
Try MariaDB Server 10.3.5 Release Candidate! There are significant features to test out in MariaDB Server 10.3, including:
Temporal Data Processing
- System Versioned Tables store information relating to past and present time.
Database Compatibility Enhancements
- PL/SQL Compatibility for MariaDB Stored Functions: The server now understands a subset of Oracle’s PL/SQL language instead of the traditional MariaDB syntax for stored routines
- Packages for Stored Functions: Grouping logically related stored functions, variables, cursors or subprogram
- New option for CURSOR in stored routines: A CURSOR can now have parameters used by the associated query
- New data types for stored routines: ROW data type, TYPE OF and ROW TYPE OF anchored data types
- Generation of unique primary keys by SEQUENCES: As an alternative to AUTO INCREMENT It is now possible to define names sequence objects to create a sequence of numeric values
- Operations over result sets with INTERSECT and EXCEPT: In addition to the already existing UNION an intersection and subtraction of result sets is now possible
- Invisible Columns: Columns can now can be defined to be invisible.
- Window Function Enhancement: percentile and median window functions have been added
- User Defined Aggregate Functions: In addition to creating SQL functions it is now also possible to create aggregate functions
- Lifted limitations for updates and deletes: A DELETE statement can now delete from a table used in the WHERE clause. UPDATE can be the same for source and target
- Add columns to a InnoDB table instantly: New columns can be appended instantly to a InnoDB Table
- Statement based timeouts: Via WAIT and NOWAIT the lock wait timeout can be explicitly set for a statement
- Column based Compression: Compression is now possible per column for most data types. The compression is storage engine independent
- Proxy Layer Support for MariaDB Server: Client / Server authentication via a Proxy like MariaDB MaxScale using a Server Proxy Protocol Support
Storage Engine Enhancements
- Spider Storage Engine: The partitioning storage engine has been updated to the newest release of the Spider Storage engine to support new Spider features including direct join support, direct update and delete, direct aggregates