diff options
| author | unknown <gkodinov/kgeorge@macbook.gmz> | 2008-01-09 17:10:09 +0200 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@macbook.gmz> | 2008-01-09 17:10:09 +0200 |
| commit | e2584c9fa03be3ed47a7b05db21327be179e3555 (patch) | |
| tree | 0500e5f837cf0f807ca67ee8d657af64cb7bfb08 /mysql-test/r/func_group.result | |
| parent | 34cae15606134da46ed426d4ac42f01c93992324 (diff) | |
| parent | 06b68454eadd20cbc2af5b2bfa8389e85120c0a3 (diff) | |
| download | mariadb-git-e2584c9fa03be3ed47a7b05db21327be179e3555.tar.gz | |
Merge macbook.gmz:/Users/kgeorge/mysql/work/B33133-5.0-opt
into macbook.gmz:/Users/kgeorge/mysql/work/B33133-5.1-opt
mysql-test/r/func_group.result:
Auto merged
mysql-test/t/func_group.test:
Auto merged
sql/sql_base.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index abf717091af..f3819418edc 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -1398,4 +1398,16 @@ SELECT COUNT(*), a FROM t1; COUNT(*) a 4 1 DROP TABLE t1; +set SQL_MODE=ONLY_FULL_GROUP_BY; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(2),(3),(4); +CREATE VIEW v1 AS SELECT a,(a + 1) AS y FROM t1; +EXPLAIN EXTENDED SELECT y FROM v1 GROUP BY v1.y; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using temporary; Using filesort +Warnings: +Note 1003 select (`test`.`t1`.`a` + 1) AS `y` from `test`.`t1` group by (`test`.`t1`.`a` + 1) +DROP VIEW v1; +DROP TABLE t1; +SET SQL_MODE=DEFAULT; End of 5.0 tests |