main.group_by w1 [ fail ]
|
Test ended at 2020-01-02 05:14:54
|
|
CURRENT_TEST: main.group_by
|
--- D:/winx64-debug/build/src/mysql-test/r/group_by.result 2020-01-02 04:27:46.548825100 +0000
|
+++ D:\winx64-debug\build\src\mysql-test\r\group_by.reject 2020-01-02 05:14:53.878028000 +0000
|
@@ -2800,11 +2800,11 @@
|
create view v1 as select a, b+1 as x from t1;
|
SELECT x, COUNT(DISTINCT a) AS y FROM v1 GROUP BY x ORDER BY y;
|
x y
|
-101 2
|
201 2
|
+101 2
|
SELECT b+1 AS x, COUNT(DISTINCT a) AS y FROM t1 GROUP BY x ORDER BY y;
|
x y
|
-101 2
|
201 2
|
+101 2
|
drop view v1;
|
drop table t1;
|
|
mysqltest: Result content mismatch
|