← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/t/count_distinct2.test

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/count_distinct2.test
52
52
create table t1 (n int default NULL);
53
53
let $1=5000;
54
54
disable_query_log;
55
 
begin;
56
55
while ($1)
57
56
{
58
57
 eval insert into t1 values($1);
59
58
 dec $1;
60
59
}
61
 
commit;
62
60
enable_query_log;
63
61
 
64
62
flush status;
65
63
select count(distinct n) from t1;
66
 
--replace_column 2 #
67
64
show status like 'Created_tmp_disk_tables';
68
65
drop table t1;
69
66
 
71
68
create table t1 (s text);
72
69
let $1=5000;
73
70
disable_query_log;
74
 
begin;
75
71
while ($1)
76
72
{
77
73
 eval insert into t1 values('$1');
78
74
 dec $1;
79
75
}
80
 
commit;
81
76
enable_query_log;
82
77
flush status;
83
78
select count(distinct s) from t1;
84
 
--replace_column 2 #
85
79
show status like 'Created_tmp_disk_tables';
86
80
drop table t1;
87
81