summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/insert_select.result
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--mysql-test/main/insert_select.result8
1 files changed, 3 insertions, 5 deletions
diff --git a/mysql-test/main/insert_select.result b/mysql-test/main/insert_select.result
index 29618c6d..463f571b 100644
--- a/mysql-test/main/insert_select.result
+++ b/mysql-test/main/insert_select.result
@@ -973,7 +973,6 @@ select * from t1;
a
3
1
-2
delete from t1;
insert into t1 values (3), (1);
insert into t1
@@ -984,8 +983,6 @@ select * from t1;
a
3
1
-3
-2
delete from t1;
insert into t1 values (3), (1);
insert into t1
@@ -996,6 +993,7 @@ select * from t1;
a
3
1
+3
2
delete from t1;
insert into t1 values (3), (1);
@@ -1022,7 +1020,6 @@ select * from t1;
a
3
1
-2
delete from t1;
insert into t1 values (3), (1);
execute stmt;
@@ -1030,7 +1027,6 @@ select * from t1;
a
3
1
-2
delete from t1;
insert into t1 values (3), (1);
delete from t1
@@ -1040,6 +1036,8 @@ group by (select * from (select a from t1) dt
where a = 1)));
select * from t1;
a
+3
+1
deallocate prepare stmt;
drop table t1,t2,t3;
#