Features
Connectors
- Increased stability & performance across connectors
Core
- Added support for 32, 64, 128, & 256 byte character strings
- Initial NULL support
- Added support for inner, left & right join set operations
- Added filter planner for displaying join path
- Added set concatenation operation
- Aggregation result sets can be made into views
- New functions:
- Character-based: lower, upper, min, max, ltrim, rtrim & trim
- Geographic: wkt_dist & wkt_is_within_dist
- Null: is_null, nvl, nvl2 & nullif
- Collapsed /alter/table/* and /show/table/* endpoints
Security
- Added role-based security and supporting endpoints
- Removed passphrase-based authorization checks; no longer needed in new security model
GAdmin
- Added to HA & security infrastructures
- Sortable data grid columns
- Added to table view: shard & foreign keys, replicated & protected statuses, TTL
SQL
- Operations: JOIN, LEFT/RIGHT JOIN, EXISTS, SELECT DISTINCT, TOP, UNION ALL & IN
- Functions: CASE, CONVERT, IFNULL, NOT, TIMESTAMPADD, TRUNCATE
