diff options
| author | unknown <sanja@montyprogram.com> | 2012-11-01 00:06:09 +0200 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2012-11-01 00:06:09 +0200 |
| commit | ee052c3e14e5ece64c1fbc79bf1abb06d7483c0d (patch) | |
| tree | ee8b528d4a34940fd4ca9f70d6622e8622ec7434 | |
| parent | d9a682adcfef7386da167a4b67613f588d6b0219 (diff) | |
| download | mariadb-git-ee052c3e14e5ece64c1fbc79bf1abb06d7483c0d.tar.gz | |
Fix of non-deterministic results.
| -rw-r--r-- | mysql-test/r/user_var.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/user_var.test | 1 |
2 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/r/user_var.result b/mysql-test/r/user_var.result index fbbe6d1839e..0f79e30bfd1 100644 --- a/mysql-test/r/user_var.result +++ b/mysql-test/r/user_var.result @@ -348,10 +348,10 @@ select @a:=f3, count(f3) from t1 group by 1 desc; 1.5 4 select @a:=f4, count(f4) from t1 group by 1 desc; @a:=f4 count(f4) -1.6 4 1.6 1 -1.6 2 1.6 1 +1.6 2 +1.6 4 drop table t1; create table t1 (f1 int); insert into t1 values (2), (1); diff --git a/mysql-test/t/user_var.test b/mysql-test/t/user_var.test index 4e45a4ecbc5..d902563647e 100644 --- a/mysql-test/t/user_var.test +++ b/mysql-test/t/user_var.test @@ -235,6 +235,7 @@ select @a:=f1, count(f1) from t1 group by 1 desc; select @a:=f1, count(f1) from t1 group by 1 asc; select @a:=f2, count(f2) from t1 group by 1 desc; select @a:=f3, count(f3) from t1 group by 1 desc; +--sorted_result select @a:=f4, count(f4) from t1 group by 1 desc; drop table t1; |