diff options
| author | monty@mysql.com <> | 2005-07-03 14:17:52 +0300 |
|---|---|---|
| committer | monty@mysql.com <> | 2005-07-03 14:17:52 +0300 |
| commit | 86d7b02199faddf91f9c7d7a6d62dda101be36ed (patch) | |
| tree | bf06496ea5d097316e5972a5cf4c4d5f674fb90b /mysql-test/r/group_by.result | |
| parent | 2941da3971a13318836ca85e204e49e3bb034253 (diff) | |
| parent | 62173c5a9d8fcd1f9b365f3cbf14198d06b2170e (diff) | |
| download | mariadb-git-86d7b02199faddf91f9c7d7a6d62dda101be36ed.tar.gz | |
Merge with 4.1
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index a56cfd4492a..85b923bf15a 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -721,6 +721,12 @@ SELECT hostname, COUNT(DISTINCT user_id) as no FROM t1 WHERE hostname LIKE '%aol%' GROUP BY hostname; hostname no +CREATE TABLE t1 (n int); +INSERT INTO t1 VALUES (1); +SELECT n+1 AS n FROM t1 GROUP BY n; +n +2 +DROP TABLE t1; cache-dtc-af05.proxy.aol.com 1 DROP TABLE t1; CREATE TABLE t1 (a int, b int); |