diff options
| author | sergefp@pylon.mylan <> | 2007-03-29 12:24:23 +0400 |
|---|---|---|
| committer | sergefp@pylon.mylan <> | 2007-03-29 12:24:23 +0400 |
| commit | 87d98bec74b54c44e24a9b89fa0296b967c6a8d5 (patch) | |
| tree | 899f2fd8517100118e0727eb54ee00cb8ac31524 /sql/item_sum.cc | |
| parent | 101857299a01f4bf854ff3c6a0241390dba7d250 (diff) | |
| parent | 399bc9861ecdebee886b854cdb11037a6e039a6f (diff) | |
| download | mariadb-git-87d98bec74b54c44e24a9b89fa0296b967c6a8d5.tar.gz | |
Merge mysql.com:/home/psergey/mysql-5.0-merge
into mysql.com:/home/psergey/mysql-5.1-merge
Diffstat (limited to 'sql/item_sum.cc')
| -rw-r--r-- | sql/item_sum.cc | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/sql/item_sum.cc b/sql/item_sum.cc index 8965a5a8f8c..7d7662f06f7 100644 --- a/sql/item_sum.cc +++ b/sql/item_sum.cc @@ -149,6 +149,8 @@ bool Item_sum::check_sum_func(THD *thd, Item **ref) if (register_sum_func(thd, ref)) return TRUE; invalid= aggr_level < 0 && !(allow_sum_func & (1 << nest_level)); + if (!invalid && thd->variables.sql_mode & MODE_ANSI) + invalid= aggr_level < 0 && max_arg_level < nest_level; } if (!invalid && aggr_level < 0) { @@ -164,8 +166,9 @@ bool Item_sum::check_sum_func(THD *thd, Item **ref) Additionally we have to check whether possible nested set functions are acceptable here: they are not, if the level of aggregation of some of them is less than aggr_level. - */ - invalid= aggr_level <= max_sum_func_level; + */ + if (!invalid) + invalid= aggr_level <= max_sum_func_level; if (invalid) { my_message(ER_INVALID_GROUP_FUNC_USE, ER(ER_INVALID_GROUP_FUNC_USE), |