Closed janedbal closed 3 months ago
Separated from #506
Coalesce is pretty nasty function:
COALESCE(1, 'foo')
'1'
1
Therefore, we cannot use the constant types if we do not know the casting logic as it results in wrong types deduced.
Thank you.
Separated from #506
Coalesce is pretty nasty function:
COALESCE(1, 'foo')
is'1'
in MySQL and1
in SQLite and SQL serverTherefore, we cannot use the constant types if we do not know the casting logic as it results in wrong types deduced.