diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/group_by.result | 16 | ||||
| -rw-r--r-- | mysql-test/t/group_by.test | 11 |
2 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index aafeb64ee2a..200cbc29b08 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -68,3 +68,19 @@ One Two sum(Four) 1 1 16 1 2 16 1 3 16 +xID xID1 +1 1 +2 2 +2 2 +3 134 +3 134 +3 134 +4 185 +4 185 +4 185 +4 185 +xID xID1 Level +1 1 * +2 2 ** +3 134 *** +4 185 **** diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index 11408511e99..dfbb2f325a9 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -259,3 +259,14 @@ 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; + +# +# The GROUP BY returned rows in wrong order in 3.23.51 +# + +CREATE TABLE t1 (ID1 int, ID2 int, ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID +)); +insert into t1 values (1,244,NULL),(2,243,NULL),(134,223,NULL),(185,186,NULL); +select S.ID as xID, S.ID1 as xID1 from t1 as S left join t1 as yS on S.ID1 between yS.ID1 and yS.ID2; +select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level from t1 as S left join t1 as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID order by xID1; +drop table t1; |