diff options
| author | Gleb Shchepa <gleb.shchepa@oracle.com> | 2011-04-02 23:41:10 +0400 |
|---|---|---|
| committer | Gleb Shchepa <gleb.shchepa@oracle.com> | 2011-04-02 23:41:10 +0400 |
| commit | 7ba944c465115f75443cdc7715b0c3b2f17f079f (patch) | |
| tree | 508bdfcfae8d22ffe2c2e0437070bdfbf0fee3fc /mysql-test/r/func_group.result | |
| parent | 8e2b0dc60c6d04e6455e77468262742bbe4b92a7 (diff) | |
| parent | 7aa81e2a02e78200eec105b968bda675af6f4987 (diff) | |
| download | mariadb-git-7ba944c465115f75443cdc7715b0c3b2f17f079f.tar.gz | |
auto-merge 5.1-->5.5 (bug 11766094)
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index 2716a06b22f..5454446984a 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -1737,6 +1737,15 @@ SELECT MIN(GET_LOCK('aaaaaaaaaaaaaaaaa',0) / '0b11111111111111111111111111111111 SELECT MIN(GET_LOCK('aaaaaaaaaaaaaaaaa',0) / '0b1111111111111111111111111111111111111111111111111111111111111111111111111' ^ (RAND())); SELECT RELEASE_LOCK('aaaaaaaaaaaaaaaaa'); # +# Bug #11766094 - 59132: MIN() AND MAX() REMOVE UNSIGNEDNESS +# +CREATE TABLE t1 (a BIGINT UNSIGNED); +INSERT INTO t1 VALUES (18446668621106209655); +SELECT MAX(LENGTH(a)), LENGTH(MAX(a)), MIN(a), MAX(a), CONCAT(MIN(a)), CONCAT(MAX(a)) FROM t1; +MAX(LENGTH(a)) LENGTH(MAX(a)) MIN(a) MAX(a) CONCAT(MIN(a)) CONCAT(MAX(a)) +20 20 18446668621106209655 18446668621106209655 18446668621106209655 18446668621106209655 +DROP TABLE t1; +# End of 5.1 tests # # Bug#52123 Assertion failed: aggregator == aggr->Aggrtype(), |