5.2 Release Notes

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