2013/9/6 Marc Delisle marc@infomarc.info:
Isaac Bennetch a écrit :
Does anyone recall or is able to reproduce [1], "If you update a row with a BLOB column and set it to NULL, the operation works but says 0 rows affected, which obviously is an incorrect row count."
I recall there was an issue, but I don't remember the details.
This was one of the bugs we discovered at the team meeting but we're having difficulty reproducing it. If you were the one to discover/mention it, could you jump in the conversation at that bug thread?
Thanks
At the team meeting, the only BLOB situation I remember is that, for the tutorial, we had a LONGBLOB in the employees table. Not sure if it could be set to NULL.
Setting a LONGBLOB to NULL is possible, I used a statement of this form : 'UPDATE `table` SET `longblob_column` = NULL'