LevelDB: Wrong result on SELECT and ER_KEY_NOT_FOUND on DELETE with search by NULL-able secondary key after updating PK

CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, b CHAR(1), KEY(a)) ENGINE=LevelDB;

INSERT INTO t1 VALUES (1,8,'g'),(2,9,'x');

UPDATE t1 SET pk = 10 WHERE a = 8;

REPLACE INTO t1 ( a ) VALUES ( 8 );

Warnings:

Warning	1364	Field 'pk' doesn't have a default value

REPLACE INTO t1 ( b ) VALUES ( 'y' );

Warnings:

Warning	1364	Field 'pk' doesn't have a default value

SELECT * FROM t1;

pk	a	b

0	NULL	y

2	9	x

10	8	g

EXPLAIN EXTENDED

SELECT * FROM t1 WHERE a = 8;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra

1	SIMPLE	t1	ref	a	a	5	const	10	100.00	NULL

Warnings:

Note	1003	/* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where (`test`.`t1`.`a` = 8)

SELECT * FROM t1 WHERE a = 8;

pk	a	b

0	NULL	y

EXPLAIN EXTENDED

DELETE FROM t1 WHERE a = 8;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra

1	SIMPLE	t1	range	PRIMARY,a	a	5	NULL	10	100.00	Using where

query 'DELETE FROM t1 WHERE a = 8' failed: 1032: Can't find record in 't1'

CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, b CHAR(1), KEY(a)) ENGINE=LevelDB;

INSERT INTO t1 VALUES (1,8,'g'),(2,9,'x');

UPDATE t1 SET pk = 10 WHERE a = 8;

REPLACE INTO t1 ( a ) VALUES ( 8 );

REPLACE INTO t1 ( b ) VALUES ( 'y' );

SELECT * FROM t1 WHERE a = 8;

DELETE FROM t1 WHERE a = 8;

revision-id: psergey@askmonty.org-20130125200959-a7gq7phbaiajqs12

revno: 4519

branch-nick: mysql-5.6-leveldb