diff options
| author | sergefp@mysql.com <> | 2005-10-28 23:31:32 +0400 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-10-28 23:31:32 +0400 |
| commit | 8b9bab27634a012e35b87c440000e2c9ebc9f078 (patch) | |
| tree | 9303ffec88f27b8195b9e023a8cb898af6e3ee1b /mysql-test/r/myisam.result | |
| parent | 7a8bd252d2f0826010e0549f4b176c430075e6c1 (diff) | |
| download | mariadb-git-8b9bab27634a012e35b87c440000e2c9ebc9f078.tar.gz | |
Fix for BUG#13814: in mi_pack_key(), when processing NULL value for TINYBLOB key segment,
do advance the source pointer over 2 bytes that specify value length.
Diffstat (limited to 'mysql-test/r/myisam.result')
| -rw-r--r-- | mysql-test/r/myisam.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 17dba82dc00..55504e8e75b 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -702,3 +702,21 @@ t1 1 a 2 b A 0 NULL NULL YES BTREE t1 1 a 3 c A 0 NULL NULL YES BTREE t1 1 a 4 d A 0 NULL NULL YES BTREE set myisam_stats_method=DEFAULT; +drop table t1; +create table t1( +cip INT NOT NULL, +time TIME NOT NULL, +score INT NOT NULL DEFAULT 0, +bob TINYBLOB +); +insert into t1 (cip, time) VALUES (1, '00:01'), (2, '00:02'), (3,'00:03'); +insert into t1 (cip, bob, time) VALUES (4, 'a', '00:04'), (5, 'b', '00:05'), +(6, 'c', '00:06'); +select * from t1 where bob is null and cip=1; +cip time score bob +1 00:01:00 0 NULL +create index bug on t1 (bob(22), cip, time); +select * from t1 where bob is null and cip=1; +cip time score bob +1 00:01:00 0 NULL +drop table t1; |