diff options
| author | unknown <evgen@moonbone.local> | 2007-06-03 16:06:55 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2007-06-03 16:06:55 +0400 |
| commit | 687191a0783408cb5f2ca44a81d6e6c89f755e17 (patch) | |
| tree | 20ca6dbe497dce42cebd5e4623271a320c38c24b /mysql-test/t | |
| parent | 8b0afa63fb2d42bea3f992a57e8ebb883d914bee (diff) | |
| parent | e19dcfa91f63a7ff310a11a00ac670a04dfdd1fb (diff) | |
| download | mariadb-git-687191a0783408cb5f2ca44a81d6e6c89f755e17.tar.gz | |
Merge moonbone.local:/mnt/gentoo64/work/test-5.0-opt-mysql
into moonbone.local:/mnt/gentoo64/work/test-5.1-opt-mysql
mysql-test/r/user_var.result:
Auto merged
mysql-test/t/user_var.test:
Auto merged
sql/item_func.cc:
Auto merged
sql/item_func.h:
Auto merged
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/user_var.test | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/mysql-test/t/user_var.test b/mysql-test/t/user_var.test index 3df949ae669..3a3e8f88f83 100644 --- a/mysql-test/t/user_var.test +++ b/mysql-test/t/user_var.test @@ -226,8 +226,14 @@ SHOW COUNT(*) ERRORS; # # Bug#28494: Grouping by Item_func_set_user_var produces incorrect result. # -create table t1(f1 int); -insert into t1 values(1),(1),(2),(3),(4),(1),(3),(1); +create table t1(f1 int, f2 varchar(2), f3 float, f4 decimal(2,1)); +insert into t1 values + (1, "a", 1.5, 1.6), (1, "a", 1.5, 1.6), (2, "b", 2.5, 2.6), + (3, "c", 3.5, 3.6), (4, "d", 4.5, 4.6), (1, "a", 1.5, 1.6), + (3, "c", 3.5, 3.6), (1, "a", 1.5, 1.6); 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; +select @a:=f4, count(f4) from t1 group by 1 desc; drop table t1; |