Comment 2 for bug 911194

Revision history for this message
Sebastian Schmidt (sebastian-schmidt) wrote :

Hi David,

it themes to me, that you've mysqls strict mode not enabled. If I run your example I get mysql error #1366, because '' is not a valid integer value.

Disabling mysqls strict mode is absolutely no option in production. None of your examples should work in a productiv environment. A valid query for your table definition should look like this:

INSERT INTO `mazzo` (`id`, `idgiocatore`, `idcarta`) VALUES
 (null, 0, 0);