diff options
| author | unknown <monty@donna.mysql.fi> | 2001-03-10 17:05:10 +0200 |
|---|---|---|
| committer | unknown <monty@donna.mysql.fi> | 2001-03-10 17:05:10 +0200 |
| commit | 74ea7333032ebc1d396f1939fd5a84c7a6ecc50c (patch) | |
| tree | cc1b41b3c722e4793c0fc03a04d720d88cfa332d /mysql-test/t/bdb.test | |
| parent | 7957ec7e339177d246a34491ccdda9851fc00956 (diff) | |
| download | mariadb-git-74ea7333032ebc1d396f1939fd5a84c7a6ecc50c.tar.gz | |
Fixed bug in MAX() optimizing for BDB tables
Docs/manual.texi:
Updated changelog
mysql-test/README:
Added reference to manual
mysql-test/r/bdb.result:
Added test for MAX() bug
mysql-test/r/innobase.result:
Added test for MAX() bug
mysql-test/t/bdb.test:
Added test for MAX() bug
mysql-test/t/innobase.test:
Added test for MAX() bug
sql-bench/server-cfg.sh:
Don't create big blobs with innobase
sql/ha_berkeley.cc:
Fixed bug in MAX() optimizing
BitKeeper/etc/ignore:
Added sql/.gdbinit to the ignore list
sql/ha_innobase.h:
Fixed bug in MAX() optimizing
sql/handler.h:
Fixed bug in MAX() optimizing
sql/opt_sum.cc:
Fixed bug in MAX() optimizing
Diffstat (limited to 'mysql-test/t/bdb.test')
| -rw-r--r-- | mysql-test/t/bdb.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/bdb.test b/mysql-test/t/bdb.test index 900260217d5..564491fc520 100644 --- a/mysql-test/t/bdb.test +++ b/mysql-test/t/bdb.test @@ -664,3 +664,17 @@ SELECT * FROM t1 WHERE a='a' AND b=2; SELECT * FROM t1 WHERE a='a' AND b in (2); SELECT * FROM t1 WHERE a='a' AND b in (1,2); drop table t1; + +# +# Test min-max optimization +# + +CREATE TABLE t1 ( + a int3 unsigned NOT NULL, + b int1 unsigned NOT NULL, + UNIQUE (a, b) +) TYPE = BDB; + +INSERT INTO t1 VALUES (1, 1); +SELECT MIN(B),MAX(b) FROM t1 WHERE t1.a = 1; +drop table t1; |