Comment on A Bad Privacy BugparentComments−ars14yEvery product has bugs.The philosophy of attempting to work when possible (coercion and other things) is good.They clearly messed up here, but it doesn't mean they should never try to coerce values.Even the warning when you try it makes no sense (what double?): 1292: Truncated incorrect DOUBLE value: 'y ' It's clearly a bug, and not something fundamental to MySQL.−drivebyacct214ySure, I think we agree. I agree it's a mistake here and should be corrected, I wasn't advocating removing type coercion by any means, nor do I think that this one-off (?) incident is worthy of making broad statements about MySQL.
Comments
Every product has bugs.
The philosophy of attempting to work when possible (coercion and other things) is good.
They clearly messed up here, but it doesn't mean they should never try to coerce values.
Even the warning when you try it makes no sense (what double?):
It's clearly a bug, and not something fundamental to MySQL.Sure, I think we agree. I agree it's a mistake here and should be corrected, I wasn't advocating removing type coercion by any means, nor do I think that this one-off (?) incident is worthy of making broad statements about MySQL.