1--disable_warnings 2drop table if exists t1; 3--enable_warnings 4 5create table t1(n1 int, n2 int, s char(20), vs varchar(20), t text); 6insert into t1 values (1,11, 'one','eleven', 'eleven'), 7 (1,11, 'one','eleven', 'eleven'), 8 (2,11, 'two','eleven', 'eleven'), 9 (2,12, 'two','twevle', 'twelve'), 10 (2,13, 'two','thirteen', 'foo'), 11 (2,13, 'two','thirteen', 'foo'), 12 (2,13, 'two','thirteen', 'bar'), 13 (NULL,13, 'two','thirteen', 'bar'), 14 (2,NULL, 'two','thirteen', 'bar'), 15 (2,13, NULL,'thirteen', 'bar'), 16 (2,13, 'two',NULL, 'bar'), 17 (2,13, 'two','thirteen', NULL); 18 19select distinct n1 from t1; 20select count(distinct n1) from t1; 21 22select distinct n2 from t1; 23select count(distinct n2) from t1; 24 25select distinct s from t1; 26select count(distinct s) from t1; 27 28select distinct vs from t1; 29select count(distinct vs) from t1; 30 31select distinct t from t1; 32select count(distinct t) from t1; 33 34select distinct n1,n2 from t1; 35select count(distinct n1,n2) from t1; 36 37select distinct n1,s from t1; 38select count(distinct n1,s) from t1; 39 40select distinct s,n1,vs from t1; 41select count(distinct s,n1,vs) from t1; 42 43select distinct s,t from t1; 44select count(distinct s,t) from t1; 45 46select count(distinct n1), count(distinct n2) from t1; 47 48select count(distinct n2), n1 from t1 group by n1; 49drop table t1; 50 51# test the conversion from tree to MyISAM 52create table t1 (n int default NULL); 53let $1=5000; 54--disable_query_log 55begin; 56while ($1) 57{ 58 eval insert into t1 values($1); 59 dec $1; 60} 61commit; 62--enable_query_log 63 64flush status; 65select count(distinct n) from t1; 66show status like 'Created_tmp_disk_tables'; 67drop table t1; 68 69# Test use of MyISAM tmp tables 70create table t1 (s text); 71let $1=5000; 72--disable_query_log 73begin; 74while ($1) 75{ 76 eval insert into t1 values('$1'); 77 dec $1; 78} 79commit; 80--enable_query_log 81flush status; 82select count(distinct s) from t1; 83show status like 'Created_tmp_disk_tables'; 84drop table t1; 85 86# End of 4.1 tests 87