13.187. Release 0.86

    • Add support for inequality when each term of the condition refers to only one side of the join.
    • Add ntile() function.
    • Add function to create a map from arrays of keys and values.
    • Add min_by() aggregation function.
    • Add support for = and to JSON type.
    • Improve error message when DISTINCT is applied to types that are not comparable.
    • Perform type validation for IN expression where the right-hand side is a subquery expression.
    • Improve error message when ORDER BY ... LIMIT query exceeds its maximum memory allocation.
    • Improve error message when types that are not orderable are used in an ORDER BY clause.
    • Fix a regression where queries could be expired too soon on a highly loaded cluster.
    • Fix scheduling issue for queries involving tables from information_schema, which could result in inconsistent metadata.
    • Fix an issue with and max_by() that could result in an error when used with a variable-length type (e.g., VARCHAR) in a GROUP BY query.
    • Fix rendering of array attributes in JMX connector.
    • Input rows/bytes are now tracked properly for JOIN queries.
    • Fix unnesting arrays and maps that contain the type.