diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-06-10 10:59:55 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-06-10 10:59:55 +0300 |
| commit | 8e6b48f808882e0586beb09259c329729f475015 (patch) | |
| tree | 843e4e7d10f5b0100a82cd522e1a21416d20f204 /mysql-test/r/func_group.result | |
| parent | 350ad5003e90c4129a69937afaf7d87b828a506c (diff) | |
| download | mariadb-git-8e6b48f808882e0586beb09259c329729f475015.tar.gz | |
cleunup() of count() and max()/min() added (BUG#2687)
mysql-test/r/func_group.result:
test of optimized aggregate function re-execution
mysql-test/t/func_group.test:
test of optimized aggregate function re-execution
sql/item_sum.cc:
cleunup() added
sql/item_sum.h:
cleunup() added
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index bd5646f4068..06259ff4931 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -656,3 +656,31 @@ select stddev(2) from t1; stddev(2) NULL drop table t1; +create table t1 (a int); +insert into t1 values (1),(2); +prepare stmt1 from 'SELECT COUNT(*) FROM t1'; +execute stmt1; +COUNT(*) +2 +execute stmt1; +COUNT(*) +2 +execute stmt1; +COUNT(*) +2 +deallocate prepare stmt1; +drop table t1; +create table t1 (a int, primary key(a)); +insert into t1 values (1),(2); +prepare stmt1 from 'SELECT max(a) FROM t1'; +execute stmt1; +max(a) +2 +execute stmt1; +max(a) +2 +execute stmt1; +max(a) +2 +deallocate prepare stmt1; +drop table t1; |