LevelDB storage engine (MDEV-3841)

[MDEV-4085] LevelDB: Wrong result on range condition and aggregate function with two keys on a field Created: 2013-01-24  Updated: 2013-01-25  Resolved: 2013-01-25

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 t1 (pk INT PRIMARY KEY, a INT, b CHAR(1), KEY(a), KEY(a,b)) 
  ENGINE=LevelDB;
INSERT INTO t1 VALUES (1,10,'x'), (2,20,'y');
 
EXPLAIN EXTENDED SELECT MAX(a) FROM t1 WHERE a < 100;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No matching min/max row
Warnings:
Note	1003	/* select#1 */ select max(`test`.`t1`.`a`) AS `MAX(a)` from `test`.`t1` where (`test`.`t1`.`a` < 100)
 
SELECT MAX(a) FROM t1 WHERE a < 100;
MAX(a)
NULL

Test case:

CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, b CHAR(1), KEY(a), KEY(a,b)) 
  ENGINE=LevelDB;
INSERT INTO t1 VALUES (1,10,'x'), (2,20,'y');
SELECT MAX(a) FROM t1 WHERE a < 100;

revision-id: psergey@askmonty.org-20130124165745-nm4yaxrsu8e4o2ll
revno: 4511
branch-nick: mysql-5.6-leveldb


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