Re: Mysql ODBC 8.0.15 SQLFetch returns SQL_NO_DATA for a Select query with where clause if one of the selected fields is blob. Works fine for 5.3.6

[Sunny Taksande]

Following are the create and insert statements -

CREATE
-------
CREATE TABLE `b306_blob_last` (
`Num` smallint(6) NOT NULL,
`Alpha` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
`myBlob` mediumblob,
UNIQUE KEY `MR_BlbLst_Num` (`Num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERTS
--------

INSERT INTO `b306_blob_last` VALUES (1,NULL,_binary 'This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory........... \r\n========================================================================================================================== '),(2,'Rec - 2',_binary 'This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory........... \r\n========================================================================================================================== '),(3,NULL,_binary 'This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory........... \r\n========================================================================================================================== '),(4,'Rec - 4',_binary 'This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory........... \r\n========================================================================================================================== '),(5,NULL,_binary 'This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory...........This text file is used to create the blob data in all background applications so do not delete it from Background directory........... \r\n========================================================================================================================== ');