Originally reported by: Marcel Bollmann (Bitbucket: mbollmann, GitHub: mbollmann)
Some SQL queries working with AUTO_INCREMENT columns insert NULL into these columns to generate a value automatically. This is documented behavior.
However, it seems that they actually try to insert the string "NULL", which was overlooked so far because it still works fine (though emitting warnings) when MySQL's strict mode is off. With strict mode enabled, these queries throw an error.
The code should be updated to use either the value "null" or a value of zero.
mbollmann
commented
8 years ago
Originally reported by: Marcel Bollmann (Bitbucket: mbollmann, GitHub: mbollmann)
Some SQL queries working with AUTO_INCREMENT columns insert NULL into these columns to generate a value automatically. This is documented behavior.
However, it seems that they actually try to insert the string "NULL", which was overlooked so far because it still works fine (though emitting warnings) when MySQL's strict mode is off. With strict mode enabled, these queries throw an error.
The code should be updated to use either the value "null" or a value of zero.