diff options
| author | sergefp@mysql.com <> | 2005-10-23 02:49:57 +0400 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-10-23 02:49:57 +0400 |
| commit | ea3ea9ed1001a0f0d0a86297896b465f9d1cbaf8 (patch) | |
| tree | 496319ac159d34aa63a9666078ddc28558ca04c3 /mysql-test/t | |
| parent | 7510c45423af35a11a6c8942501e4a0a8d0c3da7 (diff) | |
| parent | e3f623d6e81448105a2bfda32931c28ede9e9321 (diff) | |
| download | mariadb-git-ea3ea9ed1001a0f0d0a86297896b465f9d1cbaf8.tar.gz | |
Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1
into mysql.com:/home/psergey/mysql-4.1-nulls-stats-r2
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/myisam.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index dc40ecc2dd4..fbde658660d 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -637,4 +637,23 @@ show index from t1; drop table t1; +# WL#2609, CSC#XXXX: MyISAM +set myisam_stats_method=nulls_ignored; +show variables like 'myisam_stats_method'; + +create table t1 ( + a char(3), b char(4), c char(5), d char(6), + key(a,b,c,d) +); +insert into t1 values ('bcd','def1', NULL, 'zz'); +insert into t1 values ('bcd','def2', NULL, 'zz'); +insert into t1 values ('bce','def1', 'yuu', NULL); +insert into t1 values ('bce','def2', NULL, 'quux'); +analyze table t1; +show index from t1; +delete from t1; +analyze table t1; +show index from t1; + +set myisam_stats_method=DEFAULT; # End of 4.1 tests |