[Phpmyadmin-devel] bug with BLOB
dieter.adriaenssens at gmail.com
Mon Sep 9 17:20:26 CEST 2013
2013/9/6 Marc Delisle <marc at infomarc.info>:
> Isaac Bennetch a écrit :
>> Does anyone recall or is able to reproduce , "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
>> 1 - https://sourceforge.net/p/phpmyadmin/bugs/4062/
> 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'
More information about the Developers