MariaDB 10.3

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

select version();

version()

10.3.11-MariaDB-1:10.3.11+maria~stretch-log

create table x (y enum ('0','1','2','3') );
insert into x values ('1'),('0'),('2'),('3')
select * from x

y

1

0

2

3

alter table x modify y bigint;
select * from x;

y

2

1

3

4

update x set y=y-1
select * from x

y

1

0

2

3