diff options
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 62c659dd933..d134804743c 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -51,12 +51,12 @@ userid MIN(t1.score+0.0) 2 2.0 SELECT t2.userid, MIN(t1.score+0.0) FROM t1, t2 WHERE t1.userID=t2.userID AND t1.spID=2 GROUP BY t2.userid ORDER BY NULL; userid MIN(t1.score+0.0) -2 2.0 1 1.0 +2 2.0 EXPLAIN SELECT t2.userid, MIN(t1.score+0.0) FROM t1, t2 WHERE t1.userID=t2.userID AND t1.spID=2 GROUP BY t2.userid ORDER BY NULL; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using where; Using temporary -1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 test.t1.userID 1 Using index +1 SIMPLE t2 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:4 test.t1.userID 5 Using index; Using join buffer (flat, BNLH join) drop table t1,t2; CREATE TABLE t1 ( PID int(10) unsigned NOT NULL auto_increment, @@ -208,11 +208,11 @@ value description bug_id BBBBBBBBBBBBB - conversion 9 BBBBBBBBBBBBB - conversion 10 BBBBBBBBBBBBB - generic 7 -BBBBBBBBBBBBB - generic 14 -BBBBBBBBBBBBB - eeeeeeeee NULL kkkkkkkkkkk lllllllllll 6 kkkkkkkkkkk lllllllllll 8 kkkkkkkkkkk lllllllllll 12 +BBBBBBBBBBBBB - generic 14 +BBBBBBBBBBBBB - eeeeeeeee NULL Test Procedures NULL Documentation NULL Host communication NULL @@ -498,8 +498,8 @@ select * from t1 AS m LEFT JOIN t2 AS c1 ON m.c1id = c1.id AND c1.active = 'Yes' LEFT JOIN t3 AS c2 ON m.c2id = c2.id AND c2.active = 'Yes' WHERE m.pid=1 AND (c1.id IS NOT NULL OR c2.id IS NOT NULL); pid c1id c2id value id active id active -1 1 NULL 1 1 Yes NULL NULL 1 NULL 3 3 NULL NULL 3 Yes +1 1 NULL 1 1 Yes NULL NULL 1 4 NULL 4 4 Yes NULL NULL select max(value) from t1 AS m LEFT JOIN t2 AS c1 ON m.c1id = c1.id AND c1.active = 'Yes' LEFT JOIN t3 AS c2 ON m.c2id = @@ -887,8 +887,8 @@ explain SELECT straight_join sql_no_cache v1.a, v1.b, v1.real_b from t2, v1 where t2.b=v1.a GROUP BY t2.b; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 index b b 2 NULL 10 Using where; Using index -1 SIMPLE t1 eq_ref PRIMARY PRIMARY 1 test.t2.b 1 +1 SIMPLE t2 index b b 2 NULL 10 Using where; Using index; Using temporary; Using filesort +1 SIMPLE t1 hash_ALL PRIMARY #hash#PRIMARY 1 test.t2.b 7 Using join buffer (flat, BNLH join) SELECT straight_join sql_no_cache v1.a, v1.b, v1.real_b from t2, v1 where t2.b=v1.a GROUP BY t2.b; a b real_b @@ -2320,17 +2320,17 @@ field1 field2 2004-10-11 18:13:00 1 2009-02-19 02:05:00 5 Warnings: -Warning 1292 Truncated incorrect DOUBLE value: 'g' Warning 1292 Truncated incorrect DOUBLE value: 'o' Warning 1292 Truncated incorrect DOUBLE value: 'v' +Warning 1292 Truncated incorrect DOUBLE value: 'g' SELECT alias2.f3 AS field1 , alias2.f1 AS field2 FROM t1 AS alias1 JOIN t1 AS alias2 ON alias2.f1 = alias1.f2 AND alias2.f1 != alias1.f4 GROUP BY field1 , field2 ; field1 field2 2004-10-11 18:13:00 1 2009-02-19 02:05:00 5 Warnings: -Warning 1292 Truncated incorrect DOUBLE value: 'g' Warning 1292 Truncated incorrect DOUBLE value: 'o' Warning 1292 Truncated incorrect DOUBLE value: 'v' +Warning 1292 Truncated incorrect DOUBLE value: 'g' SET SESSION SQL_MODE=default; drop table t1; # |