[Phpmyadmin-devel] bug with BLOB

Dieter Adriaenssens 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 [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
>> 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'

Kind regards,

Dieter Adriaenssens

More information about the Developers mailing list