mysql中int类型与varchar类型比较的bug==完全不相等的两个值居然相等
-- mysql中int类型与varchar类型比较的bug
-- mysql数据库,版本是5.7.29时,0 = 'cddf910909b74c8ea49b50047e969388'判断条件结果为true
select 1 from dual
where 0 = 'cddf910909b74c8ea49b50047e969388';-- 结果是1
SELECT VERSION();-- 5.7.29
-- mysql中int类型与varchar类型比较的bug
-- mysql数据库,版本是8.0.23时,0 = 'cddf910909b74c8ea49b50047e969388'判断条件结果为true
select 1 from dual
where 0 = 'cddf910909b74c8ea49b50047e969388';-- 结果是1
SELECT VERSION();-- 8.0.23