diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/sql_big_tables_func.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/sql_big_tables_func.test | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/mysql-test/suite/sys_vars/t/sql_big_tables_func.test b/mysql-test/suite/sys_vars/t/sql_big_tables_func.test index 5f919fac2c7..8bbec202efa 100644 --- a/mysql-test/suite/sys_vars/t/sql_big_tables_func.test +++ b/mysql-test/suite/sys_vars/t/sql_big_tables_func.test @@ -55,8 +55,7 @@ let $totalTablesBig = query_get_value(SHOW STATUS LIKE 'Created_tmp_tables', Val eval SET @diskTableCount = $diskTablesBig; eval SET @tempTableCount = $totalTablesBig; -SELECT * FROM (SELECT ta.a as a, tb.b as b -FROM t1 as ta INNER JOIN t1 as tb ON ta.a = tb.a) sub; +select count(a), b from t1 group by b; let $newDiskTablesBig = query_get_value(SHOW STATUS LIKE 'Created_tmp_disk_tables', Value, 1); let $newTotalTablesBig = query_get_value(SHOW STATUS LIKE 'Created_tmp_tables', Value, 1); |