diff options
| author | unknown <serg@serg.mylan> | 2003-06-27 19:32:59 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2003-06-27 19:32:59 +0200 |
| commit | 7e4b7fef26496ea07562252f81c7617efeaf86b9 (patch) | |
| tree | d8600769243256db9c929d23c27a1fc63e6c9fb8 /mysql-test/t/func_group.test | |
| parent | 4b2bb5f8e16108f65c4345a362f4f9e94def4199 (diff) | |
| download | mariadb-git-7e4b7fef26496ea07562252f81c7617efeaf86b9.tar.gz | |
fix test when no InnoDB is present
Diffstat (limited to 'mysql-test/t/func_group.test')
| -rw-r--r-- | mysql-test/t/func_group.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index 1bf924100a9..fed19cbe07c 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -348,7 +348,9 @@ insert into t1 values (3,1); select a,count(b), sum(b), avg(b), std(b), min(b), max(b), bit_and(b), bit_or(b) from t1 group by a; select SQL_BIG_RESULT a,count(b), sum(b), avg(b), std(b), min(b), max(b), bit_and(b), bit_or(b) from t1 group by a; drop table t1; +--disable_warnings create table t1 (USR_ID integer not null, MAX_REQ integer not null, constraint PK_SEA_USER primary key (USR_ID)) type=InnoDB; +--enable_warnings 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; select Case When Count(*) < MAX_REQ Then 1 Else 0 End from t1 where t1.USR_ID = 1 group by MAX_REQ; |