diff options
author | unknown <monty@mysql.com> | 2005-07-04 03:50:04 +0300 |
---|---|---|
committer | unknown <monty@mysql.com> | 2005-07-04 03:50:04 +0300 |
commit | 3c82f72091d2c21519540ee5bcc3b2acadfbf198 (patch) | |
tree | 8d29892167ff9d836d0992c219bf4307f1c03b75 /mysql-test/r/group_by.result | |
parent | 428830c50024475e85e12f6b188879c2de536529 (diff) | |
parent | 306ebf7b1c1b26b45e93fbcbbf248b3479142c41 (diff) | |
download | mariadb-git-3c82f72091d2c21519540ee5bcc3b2acadfbf198.tar.gz |
manual merge
sql/field.cc:
Auto merged
sql/item.cc:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
sql/item_cmpfunc.h:
Auto merged
sql/item_func.cc:
Auto merged
sql/mysqld.cc:
Auto merged
sql/opt_range.cc:
Auto merged
sql/sql_parse.cc:
Auto merged
sql/sql_select.cc:
Auto merged
sql/sql_view.cc:
Auto merged
strings/ctype-utf8.c:
Auto merged
Diffstat (limited to 'mysql-test/r/group_by.result')
-rw-r--r-- | mysql-test/r/group_by.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 28fa101f45f..34a9cc4221f 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -731,6 +731,27 @@ n Warnings: Warning 1052 Column 'n' in group statement is ambiguous DROP TABLE t1; +create table t1 (c1 char(3), c2 char(3)); +create table t2 (c3 char(3), c4 char(3)); +insert into t1 values ('aaa', 'bb1'), ('aaa', 'bb2'); +insert into t2 values ('aaa', 'bb1'), ('aaa', 'bb2'); +select t1.c1 as c2 from t1, t2 where t1.c2 = t2.c4 +group by c2; +c2 +aaa +aaa +Warnings: +Warning 1052 Column 'c2' in group statement is ambiguous +show warnings; +Level Code Message +Warning 1052 Column 'c2' in group statement is ambiguous +select t1.c1 as c2 from t1, t2 where t1.c2 = t2.c4 +group by t1.c1; +c2 +aaa +show warnings; +Level Code Message +drop table t1, t2; CREATE TABLE t1 (a int, b int); INSERT INTO t1 VALUES (1,2), (1,3); SELECT a, b FROM t1 GROUP BY 'const'; |