11.22. Release 0.185
General Changes
- Fix incorrect column names in QueryCompletedEvent.
- Fix excessive CPU usage in coordinator for queries that havelarge string literals containing non-ASCII characters.
- Fix potential infinite loop during query optimization when constantexpressions fail during evaluation.
- Fix incorrect ordering when the same field appears multiple timeswith different ordering specifications in a window function ORDER BYclause. For example: OVER (ORDER BY x ASC, x DESC).
- Do not allow dropping or renaming hidden columns.
- When preparing to drop a column, ignore hidden columns whenchecking if the table only has one column.
- Improve performance of joins where the condition is a range over a function.For example: a JOIN b ON b.x < f(a.x) AND b.x > g(a.x)
- Improve performance of certain window functions (e.g., LAG) with similar specifications.
- Extend substr() function to work on VARBINARY in addition to CHAR and VARCHAR.
- Add cast from JSON to ROW.
- Allow usage of TRY within lambda expressions.
Hive Changes
- Improve ORC reader efficiency by only reading small ORC streams when accessed in the query.
- Improve RCFile IO efficiency by increasing the buffer size from 1 to 8 MB.
- Fix native memory leak for optimized RCFile writer.
- Fix potential native memory leak for optimized ORC writer.
Memory Connector Changes
- Add support for views.
原文: https://prestodb.io/docs/current/release/release-0.185.html