Details
-
Type:
Bug
-
Status: Confirmed (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.3.16, 10.2, 10.3, 10.4
-
Component/s: Storage Engine - RocksDB
-
Labels:
-
Environment: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(); |