LevelDB storage engine (MDEV-3841)

[MDEV-3968] UPDATE produces a wrong result while modifying a PK on a LevelDB table Created: 2012-12-22  Updated: 2012-12-24  Resolved: 2012-12-24

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: leveldb

Issue Links:
Relates

 Description   

 
create table t2 (pk int primary key, a char(8)) engine=LevelDB;
# Query OK, 0 rows affected (0.03 sec)
 
insert into t2 values (1,'a'),(2,'b'),(3,'c'),(4,'d');
# Query OK, 4 rows affected (0.00 sec)
# Records: 4  Duplicates: 0  Warnings: 0
 
update t2 set pk=100, a = 'updated' where a in ('b','c');
# Query OK, 2 rows affected (0.00 sec)
# Rows matched: 2  Changed: 2  Warnings: 0

Actual result

select * from t2;
+-----+---------+
| pk  | a       |
+-----+---------+
|   1 | a       |
|   2 | b       |
|   3 | c       |
|   4 | d       |
| 100 | updated |
+-----+---------+
5 rows in set (0.00 sec)

Expected:

+-----+---------+
| pk  | a       |
+-----+---------+
|   1 | a       |
|   4 | d       |
| 100 | updated |
+-----+---------+

date: 2012-12-21 22:14:26 +0400
build-date: 2012-12-22 21:39:19 +0400
revno: 4477
branch: mysql-5.6-leveldb


Generated at Thu Feb 08 06:52:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.