diff options
| author | serg@serg.mylan <> | 2003-06-27 19:32:59 +0200 |
|---|---|---|
| committer | serg@serg.mylan <> | 2003-06-27 19:32:59 +0200 |
| commit | 32ea8fea28573281cb67b38a8ab09b3944001ebb (patch) | |
| tree | d8600769243256db9c929d23c27a1fc63e6c9fb8 /mysql-test | |
| parent | e7b28cbc56f664cfd85f2c7ecb258cf6dd9faa74 (diff) | |
| download | mariadb-git-32ea8fea28573281cb67b38a8ab09b3944001ebb.tar.gz | |
fix test when no InnoDB is present
Diffstat (limited to 'mysql-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; |