diff options
author | unknown <gkodinov/kgeorge@magare.gmz> | 2007-11-01 18:49:45 +0200 |
---|---|---|
committer | unknown <gkodinov/kgeorge@magare.gmz> | 2007-11-01 18:49:45 +0200 |
commit | 4cb4a53eb46cdbb910b5b212154e1cc82a34f48f (patch) | |
tree | 55302edd74a02870fafa4fa157e6f581b3d3b58f /mysql-test/t/func_group.test | |
parent | 61bd5d0fec4e4089642aac3f0d4b07c354dec5c8 (diff) | |
parent | 660eb5bb40314d37b2f6e0f4f84a6936285ffc8a (diff) | |
download | mariadb-git-4cb4a53eb46cdbb910b5b212154e1cc82a34f48f.tar.gz |
Merge magare.gmz:/home/kgeorge/mysql/work/B31794-5.0-opt
into magare.gmz:/home/kgeorge/mysql/work/B31794-5.1-opt
mysql-test/r/func_group.result:
Auto merged
mysql-test/t/func_group.test:
Auto merged
sql/sql_select.cc:
Auto merged
Diffstat (limited to 'mysql-test/t/func_group.test')
-rw-r--r-- | mysql-test/t/func_group.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index d80d853b9cc..8beed28cfbf 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -889,5 +889,24 @@ CREATE TABLE t1 (a int, b date NOT NULL, KEY k1 (a,b)); SELECT MIN(b) FROM t1 WHERE a=1 AND b>'2007-08-01'; DROP TABLE t1; +# +# Bug #31794: no syntax error on SELECT id FROM t HAVING count(*)>2; +# + +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(2),(3),(4); + +SET SQL_MODE=ONLY_FULL_GROUP_BY; +--error ER_MIX_OF_GROUP_FUNC_AND_FIELDS +SELECT a FROM t1 HAVING COUNT(*)>2; +--error ER_MIX_OF_GROUP_FUNC_AND_FIELDS +SELECT COUNT(*), a FROM t1; + +SET SQL_MODE=DEFAULT; +SELECT a FROM t1 HAVING COUNT(*)>2; +SELECT COUNT(*), a FROM t1; + +DROP TABLE t1; + ### --echo End of 5.0 tests |