diff options
Diffstat (limited to 'storage/sequence')
| -rw-r--r-- | storage/sequence/mysql-test/sequence/group_by.result | 5 | ||||
| -rw-r--r-- | storage/sequence/mysql-test/sequence/group_by.test | 4 |
2 files changed, 9 insertions, 0 deletions
diff --git a/storage/sequence/mysql-test/sequence/group_by.result b/storage/sequence/mysql-test/sequence/group_by.result index b3b56338aef..2941e85c1f4 100644 --- a/storage/sequence/mysql-test/sequence/group_by.result +++ b/storage/sequence/mysql-test/sequence/group_by.result @@ -66,6 +66,11 @@ id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY seq_1_to_15_step_2 index NULL PRIMARY 8 NULL # Using index 1 PRIMARY <derived2> ALL NULL NULL NULL NULL # Using join buffer (flat, BNL join) 2 DERIVED NULL NULL NULL NULL NULL NULL # Storage engine handles GROUP BY +create view v1 as select count(*) from seq_1_to_15_step_2; +select * from v1; +count(*) +8 +drop view v1; # # The engine can't optimize the following queries # diff --git a/storage/sequence/mysql-test/sequence/group_by.test b/storage/sequence/mysql-test/sequence/group_by.test index b2e04037a8b..b3f4ab58771 100644 --- a/storage/sequence/mysql-test/sequence/group_by.test +++ b/storage/sequence/mysql-test/sequence/group_by.test @@ -30,6 +30,10 @@ select * from seq_1_to_15_step_2, (select count(*) from seq_1_to_15_step_2) as t --replace_column 9 # explain select * from seq_1_to_15_step_2, (select count(*) from seq_1_to_15_step_2) as t1; +create view v1 as select count(*) from seq_1_to_15_step_2; +select * from v1; +drop view v1; + --echo # --echo # The engine can't optimize the following queries --echo # |