diff options
| author | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-26 10:24:59 +0700 |
|---|---|---|
| committer | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-26 10:24:59 +0700 |
| commit | d444536e1dbb0fef7a798b23382711c0448ab784 (patch) | |
| tree | b168bf07bca3ba94f42b8c8b31af675301600aca /mysql-test/main/func_group_innodb.test | |
| parent | 0792aff161132fb953510555fe45544991dec95d (diff) | |
| parent | 184e65954b88266bd426de1c82973bf54a88afb1 (diff) | |
| download | mariadb-git-d444536e1dbb0fef7a798b23382711c0448ab784.tar.gz | |
Merge branch 'bb-10.4-all-builders' into bb-10.5-all-builders
Diffstat (limited to 'mysql-test/main/func_group_innodb.test')
| -rw-r--r-- | mysql-test/main/func_group_innodb.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/main/func_group_innodb.test b/mysql-test/main/func_group_innodb.test index 748c64a43c6..b1f9a28b190 100644 --- a/mysql-test/main/func_group_innodb.test +++ b/mysql-test/main/func_group_innodb.test @@ -15,7 +15,10 @@ set global innodb_stats_persistent_sample_pages=100; create table t1 (USR_ID integer not null, MAX_REQ integer not null, constraint PK_SEA_USER primary key (USR_ID)) engine=InnoDB; --enable_warnings insert into t1 values (1, 3); +#enable after fix MDEV-27871 +--disable_view_protocol 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; +--enable_view_protocol select Case When Count(*) < MAX_REQ Then 1 Else 0 End from t1 where t1.USR_ID = 1 group by MAX_REQ; drop table t1; |