diff options
| author | unknown <bell@sanja.is.com.ua> | 2005-01-20 13:56:22 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2005-01-20 13:56:22 +0200 |
| commit | b3cd49f3127f5cf41d2b4e42c6597262ca6a5376 (patch) | |
| tree | 21dfccc4d439dea41620fde468f0da09aa412135 /mysql-test/r/derived.result | |
| parent | 0a8852c343c97fdb22c6754ac4cae569f474960e (diff) | |
| download | mariadb-git-b3cd49f3127f5cf41d2b4e42c6597262ca6a5376.tar.gz | |
fixed problem with distinct select with grouping and subqueries (BUG#7946)
mysql-test/r/derived.result:
DISTINCT over grouped select on subquery in the FROM clause
mysql-test/t/derived.test:
DISTINCT over grouped select on subquery in the FROM clause
sql/sql_select.cc:
used current join copy for test
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 7e6b9b44566..61d745d0236 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -330,3 +330,12 @@ SELECT MIN(price) min, MAX(price) max, AVG(price) avg FROM (SELECT SUBSTRING( MA min max avg 10.00 10.00 10 DROP TABLE t1; +create table t1 (a integer, b integer); +insert into t1 values (1,4), (2,2),(2,2), (4,1),(4,1),(4,1),(4,1); +select distinct sum(b) from t1 group by a; +sum(b) +4 +select distinct sum(b) from (select a,b from t1) y group by a; +sum(b) +4 +drop table t1; |