Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.16, 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
openSUSE Tumbleweed x86_64
Description
In MariaDB 10.3.16 on ROCKSDB engine ROW_COUNT() return always 1 (not 0), after UPDETE, when data not changed.
In InnoDB always returns 0 if the data has not changed.
DROP TABLE IF EXISTS `test`; |
|
CREATE TABLE `test` |
(
|
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, |
`status` TINYINT UNSIGNED NOT NULL, |
KEY(`status`) |
)
|
ENGINE=ROCKSDB CHARACTER SET utf8 COLLATE utf8_general_ci; |
|
INSERT INTO `test`(`id`,`status`) VALUES (1,1),(2,2),(3,3); |
|
UPDATE `test` SET `status`=2 WHERE `id`=2; |
|
SELECT ROW_COUNT(); |