diff options
| author | unknown <monty@mashka.mysql.fi> | 2003-02-08 01:12:58 +0200 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2003-02-08 01:12:58 +0200 |
| commit | cb38070e9f4e3dcaf3e2f9dc42577802ba035085 (patch) | |
| tree | d54b65dfc052978dab95842c84f1a39745ef0d0c /mysql-test | |
| parent | 5dd528a2fda1412b8b75a6311dbc7262670983b6 (diff) | |
| parent | 133ed0bf6ffde95d02ea35b6c02b5a042d73ecc0 (diff) | |
| download | mariadb-git-cb38070e9f4e3dcaf3e2f9dc42577802ba035085.tar.gz | |
merge
configure.in:
Auto merged
mysql-test/t/explain.test:
Auto merged
sql/ha_innodb.cc:
Auto merged
sql/item_create.cc:
Auto merged
sql/item_create.h:
Auto merged
sql/opt_range.cc:
Auto merged
sql/opt_sum.cc:
Auto merged
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/explain.result | 13 | ||||
| -rw-r--r-- | mysql-test/t/explain.test | 8 |
2 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result index ff38e9fae7d..9c9cac4762b 100644 --- a/mysql-test/r/explain.result +++ b/mysql-test/r/explain.result @@ -31,3 +31,16 @@ drop table t1; explain select 1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used +create table t1 (a int not null); +explain select count(*) from t1; +Comment +Select tables optimized away +insert into t1 values(1); +explain select count(*) from t1; +Comment +Select tables optimized away +insert into t1 values(1); +explain select count(*) from t1; +Comment +Select tables optimized away +drop table t1; diff --git a/mysql-test/t/explain.test b/mysql-test/t/explain.test index 1cf8c5e93e1..ff1803368b9 100644 --- a/mysql-test/t/explain.test +++ b/mysql-test/t/explain.test @@ -22,3 +22,11 @@ explain select * from t1 ignore key (str,str,foo) where str="foo"; drop table t1; explain select 1; + +create table t1 (a int not null); +explain select count(*) from t1; +insert into t1 values(1); +explain select count(*) from t1; +insert into t1 values(1); +explain select count(*) from t1; +drop table t1; |