diff options
| author | unknown <mhansson/martin@linux-st28.site> | 2007-03-22 10:58:16 +0100 |
|---|---|---|
| committer | unknown <mhansson/martin@linux-st28.site> | 2007-03-22 10:58:16 +0100 |
| commit | 5b86ad19da5811fe981e5a6768fb7aef206f9a88 (patch) | |
| tree | a96b9c3876a24db72a46a3fa1f18d0dd6eb4f172 /mysql-test/t | |
| parent | a4a23fb907ce7b2c3e998735e074da647b3e9ffc (diff) | |
| parent | aa3233619874c3bfee4d43957148ef2c7904aa6c (diff) | |
| download | mariadb-git-5b86ad19da5811fe981e5a6768fb7aef206f9a88.tar.gz | |
Merge mhansson@bk-internal:/home/bk/mysql-5.0-opt
into linux-st28.site:/home/martin/mysql/src/5.0o-bug24791
sql/field.h:
Auto merged
sql/item_sum.cc:
Auto merged
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/temp_table.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/temp_table.test b/mysql-test/t/temp_table.test index 8cb9e34ca08..90f868f5932 100644 --- a/mysql-test/t/temp_table.test +++ b/mysql-test/t/temp_table.test @@ -163,3 +163,19 @@ DROP TABLE t1; --echo End of 4.1 tests. + +# +# Bug #24791: Union with AVG-groups generates wrong results +# +CREATE TABLE t1 ( c FLOAT( 20, 14 ) ); +INSERT INTO t1 VALUES( 12139 ); + +CREATE TABLE t2 ( c FLOAT(30,18) ); +INSERT INTO t2 VALUES( 123456 ); + +SELECT AVG( c ) FROM t1 UNION SELECT 1; +SELECT 1 UNION SELECT AVG( c ) FROM t1; +SELECT 1 UNION SELECT * FROM t2 UNION SELECT 1; +SELECT c/1 FROM t1 UNION SELECT 1; + +DROP TABLE t1, t2; |