Bug #81874 update + text field + order by + OR in where = error 4265

• Submitted: 16 Jun 2016 4:24
• Modified: 16 Jun 2016 6:10
• Reporter: rwe rewrew
• Status: Verified
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 7.4.10, 7.4.11
• OS: Any
• CPU Architecture: Any

[16 Jun 2016 4:24] rwe rewrew

Description:
SQL Error (1296): Got error 4265 'The method is not valid in current blob state' from NDBCLUSTER

if i delete any of the following
ORDER BY
OR in where
'data' field

it works as expected also InnoBD engine works without any change

How to repeat:
CREATE TABLE IF NOT EXISTS `testtr` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `notbefore` datetime DEFAULT NULL,
  `workerkey` varchar(45) DEFAULT NULL,
  `data` text,
  PRIMARY KEY (`id`)
) ENGINE=ndbcluster AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*!40000 ALTER TABLE `testtr` DISABLE KEYS */;
INSERT INTO `testtr` (`id`, `notbefore`, `workerkey`, `data`) VALUES
	(5, '2016-06-16 06:02:32', NULL, NULL),
	(1, '2016-06-14 05:36:05', 'c501d2e70047bcb5c602f16839ae37c7a0155f6b', NULL),
	(2, '2016-06-13 05:36:09', 'c501d2e70047bcb5c602f16839ae37c7a0155f6b', NULL);

UPDATE testtr SET workerkey = "1"
WHERE (id = 1 AND workerkey IS NULL) OR (id = 2 AND workerkey IS NULL)
ORDER BY notbefore ASC, id ASC
LIMIT 1;

[16 Jun 2016 6:10] MySQL Verification Team

Hello!

Thank you for the report and test case.
Observed this with 7.4.11 build.

Thanks,
Umesh