#2405 (ok 2.10.1) Can\'t edit if BLOB and no PK

[Marc Delisle]

The generated condition contains only the left part of the comparison

AND CONVERT( `audios`.`audio`
USING utf8 ) ;

[Jürgen Wind]

Logged In: YES
user_id=1383652
Originator: NO

regardless of index or not i can't insert rows if the blog field is empty:

INSERT INTO `abc`.`blobsizetest` (
`autoID` ,`what` ,`size_KB` ,`mediumBlob16M` ,`longblob` ,`comment`
)
VALUES (
'33', 'test', '777', , , 'test'
)

MySQL said:
#1064 - You have an error in your SQL syntax; ... near ' , 'test')' at line 1

but
.... VALUES (
'33', 'test', '777' , '' , '', 'test'
)
works fine

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: YES

Juergen,
I just fixed this insert problem in QA_2_10 and trunk.