A bug fix and test case for a bug that appears in quereis where there

is a GROUP BY a column that is not NOT NULL and ORDER BY is done by
another column.

Even better fix would be to make a separate function for this.

1 files changed, 17 insertions, 0 deletions

diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test
index 171b5510227..09a2bee0d0c 100644
--- a/mysql-test/t/group_by.test
+++ b/mysql-test/t/group_by.test
@@ -299,3 +299,20 @@ insert into t1 values (1,3,3,4);
 insert into t1 values (1,3,4,4);
 select One, Two, sum(Four) from t1 group by One,Two;
 drop table if exists t1;
+drop table if exists t1,t2;
+create table t1 (id integer primary key not null auto_increment, gender char(1));
+insert into t1 values(NULL, 'M');
+insert into t1 values(NULL, 'F');
+insert into t1 values(NULL, 'F');
+insert into t1 values(NULL, 'F');
+insert into t1 values(NULL, 'M');
+create table t2 (user_id integer not null, timestamp datetime);
+insert into t2 values (1, sysdate());
+insert into t2 values (2, sysdate());
+insert into t2 values (1, sysdate());
+insert into t2 values (3, sysdate());
+insert into t2 values (4, sysdate());
+insert into t2 values (4, sysdate());
+select u.gender as gender, count(distinct  u.id) as dist_count, (count(distinct u.id)/5*100) as percentage from t1 u, t2 l where l.user_id = u.id group by u.gender;
+select u.gender as  gender, count(distinct  u.id) as dist_count, (count(distinct u.id)/5*100) as percentage from t1 u, t2 l where l.user_id = u.id group by u.gender  order by percentage;
+drop table t1,t2;