Details
-
Type:
Technical task
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
