# Release 0.246#

Warning

There is a bug causing SORT orLIMIT to be incorrectly eliminated when using GROUPING SETS (()), CUBE or ROLLUP, first introduced in 0.246 by #14915

## Details#

### General Changes#

• Fix a bug introduced in #15313 that would cause queries to fail when using upper case in SQL function catalog schema names.

• Fix a possible integer overflow error when spilling to temporary storage.

• Fix an issue where prepared statements would allow some non-constant parameters.

• Fix an error where Presto server can fail to start when using function namespace manager.

• Add a minimum value of 30 seconds to the configuration property query.min-expire-age.

• Add listener-based revocation model for spilling strategy PER_TASK_MEMORY_THRESHOLD.

• Disable spill to disk for join queries where the probe side uses grouped execution and the build does not. Previously these queries would fail with GENERIC_INTERNAL_ERRORS.

• Disallow ORDER BY literals used with Window functions as it’s not useful, expensive and most often used wrongly.

• Add support for fragment result caching for queries with local exchange (e.g. intermediate aggregation).

• Improve queries that have unnecessary limits and order bys. This feature is enabled by default and can be disabled by using the configuration property optimizer.skip-redundant-sort or session property skip_redundant_sort`.