summaryrefslogtreecommitdiff
path: root/mysql-test/suite/pbxt/r/range.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/pbxt/r/range.result')
-rw-r--r--mysql-test/suite/pbxt/r/range.result2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/suite/pbxt/r/range.result b/mysql-test/suite/pbxt/r/range.result
index 3dd496f65b9..41e2d1591a0 100644
--- a/mysql-test/suite/pbxt/r/range.result
+++ b/mysql-test/suite/pbxt/r/range.result
@@ -362,6 +362,7 @@ name char(1) not null,
uid int not null,
primary key (id),
index uid_index (uid));
+begin;
insert into t1(id, uid, name) values(1, 0, ' ');
insert into t1(uid, name) values(0, ' ');
insert into t2(uid, name) select uid, name from t1;
@@ -410,6 +411,7 @@ insert into t2(uid, name) values
insert into t1(uid, name) select uid, name from t2 order by uid;
delete from t2;
insert into t2(id, uid, name) select id, uid, name from t1;
+commit;
select count(*) from t1;
count(*)
1026