86
86
# Test for load data replace which updates pk
87
87
insert into t1 values (1, 1, 1), (4, 4, 4), (6, 6, 6);
89
89
select * from t1 order by pk;
91
91
# Now test for load data replace which doesn't touch pk
92
92
insert into t1 values (1, 1, 1), (3, 3, 3), (5, 5, 5);
94
94
select * from t1 order by pk;
96
96
# Finally test for both types of replace ... select