MariaDB 10.5

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

select version();


version()


10.5.17-MariaDB-1:10.5.17+maria~deb11


CREATE TABLE `people.1`
(ppl_id VARCHAR (5),
ppl_country VARCHAR(5),
ppl_tshirt_size VARCHAR(5) CHECK(ppl_tshirt_size IN('sm','med','lg','xl','xxl')),
primary key(ppl_id)); 
insert into `people.1` values ('id0', 'nz', 'xxl')
insert into `people.1` values ('id', 'au', '2xxl')

CONSTRAINT `people.1.ppl_tshirt_size` failed for `fiddle`.`people.1`