diff options
| author | bell@sanja.is.com.ua <> | 2004-07-20 08:48:28 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-07-20 08:48:28 +0300 |
| commit | 1e3f10a4b14713149df43c2f62e82c542b5e567e (patch) | |
| tree | 9591193210c59420b6bafc8972a50c690f036936 /mysql-test/r/group_by.result | |
| parent | 4246f400655f11080c02e55de00c9e2b84ecede1 (diff) | |
| download | mariadb-git-1e3f10a4b14713149df43c2f62e82c542b5e567e.tar.gz | |
mark subquery in the FROM clause like derived and quoate all identifiers (BUG#4609)
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 9af7304c167..4192a7701b2 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -288,7 +288,7 @@ explain extended select sql_big_result spid,sum(userid) from t1 group by spid de id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 8 Using filesort Warnings: -Note 1003 select sql_big_result test.t1.spID AS `spid`,sum(test.t1.userID) AS `sum(userid)` from test.t1 group by test.t1.spID desc +Note 1003 select sql_big_result `test`.`t1`.`spID` AS `spid`,sum(`test`.`t1`.`userID`) AS `sum(userid)` from `test`.`t1` group by `test`.`t1`.`spID` desc explain select sql_big_result spid,sum(userid) from t1 group by spid desc order by null; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 8 Using filesort |