MariaDB 10.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

10.7.8-MariaDB-1:10.7.8+maria~deb11

-- the UUID type arrived in MariaDB 10.7
create table t (id uuid, name varchar(10));
insert into t values ('123e4567-e89b-12d3-a456-426614174000','alpha');
select id, name from t;

id
name

123e4567-e89b-12d3-a456-426614174000
alpha

-- natural_sort_key() is also new in 10.7: a10 sorts after a9
select x from (select 'a10' as x union all select 'a9') t
order by natural_sort_key(x);

x

a9

a10