diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2011-07-08 22:01:02 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2011-07-08 22:01:02 +0400 |
| commit | 834bdfa1c862fcd35a15ebceb36989d6bcbe0963 (patch) | |
| tree | db0157b312a78faca67cfae3f1217ce6e3fe76fc /mysql-test/suite/vcol/r/vcol_select_innodb.result | |
| parent | 41c766f30deb2bb2d46a7219e72257b614f243e4 (diff) | |
| download | mariadb-git-834bdfa1c862fcd35a15ebceb36989d6bcbe0963.tar.gz | |
Update test results for previous csets.
Diffstat (limited to 'mysql-test/suite/vcol/r/vcol_select_innodb.result')
| -rw-r--r-- | mysql-test/suite/vcol/r/vcol_select_innodb.result | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/suite/vcol/r/vcol_select_innodb.result b/mysql-test/suite/vcol/r/vcol_select_innodb.result index 89a79b1acf8..7f7b1e40269 100644 --- a/mysql-test/suite/vcol/r/vcol_select_innodb.result +++ b/mysql-test/suite/vcol/r/vcol_select_innodb.result @@ -44,7 +44,7 @@ a b c 1 -1 -1 explain select * from t3 where c>=-1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t3 range c c 5 NULL 1 Using index condition; Rowid-ordered scan +1 SIMPLE t3 range c c 5 NULL 1 Using where # select_type=SIMPLE, type=ref select * from t1,t3 where t1.c=t3.c and t3.c=-1; a b c a b c @@ -136,11 +136,11 @@ id select_type table type possible_keys key key_len ref rows Extra # SELECT * FROM tbl_name WHERE <vcol expr> select * from t3 where c >= -2; a b c -1 -1 -1 2 -2 -2 +1 -1 -1 explain select * from t3 where c >= -2; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t3 range c c 5 NULL 1 Using index condition; Rowid-ordered scan +1 SIMPLE t3 range c c 5 NULL 1 Using where # SELECT * FROM tbl_name WHERE <non-vcol expr> select * from t3 where a between 1 and 2; a b c @@ -160,11 +160,11 @@ id select_type table type possible_keys key key_len ref rows Extra # SELECT * FROM tbl_name WHERE <indexed vcol expr> select * from t3 where c between -2 and -1; a b c -1 -1 -1 2 -2 -2 +1 -1 -1 explain select * from t3 where c between -2 and -1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t3 range c c 5 NULL 1 Using index condition; Rowid-ordered scan +1 SIMPLE t3 range c c 5 NULL 1 Using where # SELECT * FROM tbl_name WHERE <non-vcol expr> ORDER BY <non-indexed vcol> select * from t3 where a between 1 and 2 order by b; a b c @@ -204,7 +204,7 @@ a b c 1 -1 -1 explain select * from t3 where c between -2 and -1 order by b; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t3 range c c 5 NULL 1 Using index condition; Rowid-ordered scan; Using filesort +1 SIMPLE t3 range c c 5 NULL 1 Using where; Using filesort # SELECT * FROM tbl_name WHERE <non-indexed vcol expr> ORDER BY <indexed vcol> select * from t3 where b between -2 and -1 order by c; a b c @@ -220,7 +220,7 @@ a b c 1 -1 -1 explain select * from t3 where c between -2 and -1 order by c; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t3 range c c 5 NULL 1 Using index condition +1 SIMPLE t3 range c c 5 NULL 1 Using where # SELECT sum(<non-indexed vcol>) FROM tbl_name GROUP BY <non-indexed vcol> select sum(b) from t1 group by b; sum(b) |