The generated condition contains only the left part of the comparison
AND CONVERT( `audios`.`audio` USING utf8 ) ;
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
Logged In: YES user_id=210714 Originator: YES
Juergen, I just fixed this insert problem in QA_2_10 and trunk.
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
Logged In: YES
user_id=210714
Originator: YES
Juergen,
I just fixed this insert problem in QA_2_10 and trunk.