sql query with check constraint pct

[Amit Kumar]

Getting an error with following sql query with mysql v8 which was working with v5.7.

Create table test (
empId char(36) not null,
tolerance decimal(5,2) not null check (pct > 0 and pct <= 100),
primary key (empId)
);

ERROR 3813 (HY000): Column check constraint 'test_chk_1' references other column.


Please do explain the query and corresponding correct query for mysql 8.