diff options
| author | unknown <monty@mysql.com> | 2005-02-03 16:50:06 +0200 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2005-02-03 16:50:06 +0200 |
| commit | c41989a28e674829614068d0558bda2d220bdde2 (patch) | |
| tree | 263c4802be24a98c40a87086c8641ff4c4cbfd78 /mysql-test/r/derived.result | |
| parent | 888c211805fdc501e078c7f8576821b121eb6637 (diff) | |
| parent | 4f1cbb6031d8310f17db9e503234ef169805412a (diff) | |
| download | mariadb-git-c41989a28e674829614068d0558bda2d220bdde2.tar.gz | |
Merge bk-internal.mysql.com:/home/bk/mysql-5.0
into mysql.com:/home/my/mysql-5.0
BitKeeper/etc/logging_ok:
auto-union
configure.in:
Auto merged
scripts/mysql_install_db.sh:
Auto merged
sql/examples/ha_archive.cc:
Auto merged
sql/ha_innodb.cc:
Auto merged
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 da2bb9081de..8322933a360 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -335,3 +335,12 @@ INSERT INTO t1 VALUES ('root','localhost'), ('root','%'); SELECT * FROM (SELECT (SELECT a.a FROM t1 AS a WHERE a.a = b.a) FROM t1 AS b) AS c; ERROR 21000: Subquery returns more than 1 row 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; |