diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-05-26 15:52:19 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-05-26 15:52:19 +0300 |
| commit | 145aa40d59150159018676033e30ec227519f6ef (patch) | |
| tree | a8114cc133dc91fd75de0cb7b0c10aa5fd552fd1 /mysql-test/r/func_group.result | |
| parent | a6ebf38d72b9e3852e51314a87d636e2c6f8c37d (diff) | |
| parent | acda3d79b6f16441375171dfc58a78b85d313eff (diff) | |
| download | mariadb-git-145aa40d59150159018676033e30ec227519f6ef.tar.gz | |
merging
sql/item.cc:
Auto merged
sql/item_sum.cc:
Auto merged
sql/sql_derived.cc:
Auto merged
sql/sql_select.cc:
Auto merged
sql/sql_union.cc:
Auto merged
sql/sql_yacc.yy:
Auto merged
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index 99d7bd2d087..b09bb72f879 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -603,3 +603,14 @@ a count(b) sum(b) avg(b) std(b) min(b) max(b) bit_and(b) bit_or(b) 2 1 1 1.0000 0.0000 1 1 1 1 3 1 1 1.0000 0.0000 1 1 1 1 drop table t1; +create table t1 (USR_ID integer not null, MAX_REQ integer not null, constraint PK_SEA_USER primary key (USR_ID)) type=InnoDB; +insert into t1 values (1, 3); +select count(*) + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ from t1 group by MAX_REQ; +count(*) + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ +1 +select Case When Count(*) < MAX_REQ Then 1 Else 0 End from t1 where t1.USR_ID = 1 group by MAX_REQ; +Case When Count(*) < MAX_REQ Then 1 Else 0 End +1 + + +drop table t1; |