array_popback

SinceVersion 1.2.0

array_popback

description

Syntax

1. ARRAY<T> array_popback(ARRAY<T> arr)

Remove the last element from array.

notice

Only supported in vectorized engine

example

1. mysql> set enable_vectorized_engine=true;

3. mysql> select array_popback(['test', NULL, 'value']);
4. +-----------------------------------------------------+
5. | array_popback(ARRAY('test', NULL, 'value'))         |
6. +-----------------------------------------------------+
7. | [test, NULL]                                        |
8. +-----------------------------------------------------+

keywords

ARRAY,POPBACK,ARRAY_POPBACK