diff options
| author | unknown <jimw@mysql.com> | 2005-10-27 10:20:38 -0700 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-10-27 10:20:38 -0700 |
| commit | 5e8515d9f2ccada3e19b109196fb5654e7c9db92 (patch) | |
| tree | 7645b556900b02ebb18770619c60754095dfd655 /mysql-test/t/myisam.test | |
| parent | 47b044f41114cbbfd216030269f7a0380a502050 (diff) | |
| parent | 987c33a97501ccd064ee2e68df44ad1d1e4618e6 (diff) | |
| download | mariadb-git-5e8515d9f2ccada3e19b109196fb5654e7c9db92.tar.gz | |
Merge mysql.com:/home/jimw/my/mysql-4.1-14009
into mysql.com:/home/jimw/my/mysql-4.1-clean
sql/item_func.cc:
Auto merged
Diffstat (limited to 'mysql-test/t/myisam.test')
| -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 |