diff options
| author | unknown <serg@serg.mylan> | 2003-12-06 23:21:09 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2003-12-06 23:21:09 +0100 |
| commit | f3bf35ec03e683815be4656ec93722e248eb56a0 (patch) | |
| tree | 63c4006a74c5d36672d3bce9c6978cb1a831bdbe /mysql-test/t/union.test | |
| parent | afbeb64e936f4282661e7e904fa9a886f89a653c (diff) | |
| download | mariadb-git-f3bf35ec03e683815be4656ec93722e248eb56a0.tar.gz | |
QUERY_NO_GOOD_INDEX_USED and QUERY_NO_INDEX_USED moved from thd->lex.select_lex->options to thd->server_status
mysql-test/r/union.result:
union and slow log tests
mysql-test/t/union.test:
union and slow log tests
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 26 |
1 files changed, 23 insertions, 3 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index e302378e117..a5cb1ce6b6e 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -419,9 +419,6 @@ drop table t1; # # conversion memory->disk table # -# -# conversion memory->disk table -# create table t1 (s char(200)); insert into t1 values (repeat("1",200)); create table t2 select * from t1; @@ -436,3 +433,26 @@ select count(*) from t1; select count(*) from t2; drop table t1,t2; set local tmp_table_size=default; + +# +# slow logging +# +create table t1 (a int, index (a), b int); +insert t1 values (1,1),(2,2),(3,3),(4,4),(5,5); +insert t1 select a+1, a+b from t1; +insert t1 select a+1, a+b from t1; +insert t1 select a+1, a+b from t1; +insert t1 select a+1, a+b from t1; +insert t1 select a+1, a+b from t1; +FLUSH STATUS; +show status like 'Slow_queries'; +select count(*) from t1 where a=7; +show status like 'Slow_queries'; +select count(*) from t1 where b=13; +show status like 'Slow_queries'; +select count(*) from t1 where b=13 union select count(*) from t1 where a=7; +show status like 'Slow_queries'; +select count(*) from t1 where a=7 union select count(*) from t1 where b=13; +show status like 'Slow_queries'; +drop table t1; + |