MariaDB 10.6

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

select version();

version()

10.6.9-MariaDB-1:10.6.9+maria~deb11

SELECT CAST('4.94' AS DOUBLE(10,2)) = '4.94' `comp`, 
  CAST('4.94' AS DOUBLE(10,2)) `cast`, '4.94' `string`;

comp
cast
string

0
4.94
4.94

SELECT CAST('4.94' AS DECIMAL(10,2)) = '4.94' `comp`,
  CAST('4.94' AS DECIMAL(10,2)) `cast`, '4.94' `string`;

comp
cast
string

1
4.94
4.94