summaryrefslogtreecommitdiff
path: root/mysql-test/main/subselect_no_opts.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/subselect_no_opts.result')
-rw-r--r--mysql-test/main/subselect_no_opts.result6
1 files changed, 2 insertions, 4 deletions
diff --git a/mysql-test/main/subselect_no_opts.result b/mysql-test/main/subselect_no_opts.result
index 09f664d3c28..39306df943a 100644
--- a/mysql-test/main/subselect_no_opts.result
+++ b/mysql-test/main/subselect_no_opts.result
@@ -685,8 +685,6 @@ x
3
11
11
-INSERT DELAYED INTO t1 (x) VALUES ((SELECT SUM(x) FROM t2));
-ERROR 42S22: Unknown column 'x' in 'field list'
INSERT DELAYED INTO t1 (x) VALUES ((SELECT SUM(a) FROM t2));
select * from t1;
x
@@ -7125,7 +7123,7 @@ drop table t1,t2,t3,t4;
# MDEV-7122
# Assertion `0' failed in subselect_hash_sj_engine::init
#
-SET SESSION big_tables=1;
+set tmp_memory_table_size=0;
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);
@@ -7134,7 +7132,7 @@ a
0
0
DROP TABLE t1;
-SET SESSION big_tables=0;
+set tmp_memory_table_size=default;
#
# MDEV-10776: Server crash on query
#