diff options
Diffstat (limited to 'mysql-test/main/subselect.test')
| -rw-r--r-- | mysql-test/main/subselect.test | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/mysql-test/main/subselect.test b/mysql-test/main/subselect.test index 77da710a535..ae072787028 100644 --- a/mysql-test/main/subselect.test +++ b/mysql-test/main/subselect.test @@ -426,8 +426,6 @@ select * from t1; # After this, only data based on old t1 records should have been added. INSERT INTO t1 (x) select (SELECT SUM(x)+2 FROM t1) FROM t2; select * from t1; --- error ER_BAD_FIELD_ERROR -INSERT DELAYED INTO t1 (x) VALUES ((SELECT SUM(x) FROM t2)); let $row_count_before= `SELECT COUNT(*) FROM t1`; INSERT DELAYED INTO t1 (x) VALUES ((SELECT SUM(a) FROM t2)); let $wait_condition= SELECT COUNT(*) <> $row_count_before FROM t1; @@ -6053,12 +6051,12 @@ drop table t1,t2,t3,t4; --echo # MDEV-7122 --echo # Assertion `0' failed in subselect_hash_sj_engine::init --echo # -SET SESSION big_tables=1; +set tmp_memory_table_size=0; # force on-disk tmp table CREATE TABLE t1(a char(255) DEFAULT '', KEY(a(10))) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO t1 VALUES(0),(0),(0); SELECT * FROM t1 WHERE a IN(SELECT MIN(a) FROM t1); DROP TABLE t1; -SET SESSION big_tables=0; +set tmp_memory_table_size=default; --echo # --echo # MDEV-10776: Server crash on query |