v.25.12New Feature

Support negative

Support negative indexes for tuple element access (e.g. tuple.-1). #91665 (Amos Bird).
Support negative indexes for tuple element access (e.g. tuple.-1) in ClickHouse.

Why it matters

This feature allows users to access tuple elements using negative indexes, similar to Python-style indexing. It simplifies retrieval of elements from the end of a tuple, enhancing query flexibility and convenience.

How to use it

Users can now access tuple elements with negative indexes directly in their queries. For example, to get the last element of a tuple, use tuple.-1. This requires no additional configuration and is available by default after updating to the version including this feature.