cleanup: vers tests, remove create_table procedure

1 files changed, 23 insertions, 3 deletions

diff --git a/mysql-test/suite/versioning/r/replace.result b/mysql-test/suite/versioning/r/replace.result
index 54ab5b49c2a..a3bd3239a5e 100644
--- a/mysql-test/suite/versioning/r/replace.result
+++ b/mysql-test/suite/versioning/r/replace.result
@@ -1,4 +1,10 @@
-call create_table('t', 'x int');
+create table t (
+id int primary key,
+x int,
+row_start SYS_DATATYPE as row start invisible,
+row_end SYS_DATATYPE as row end invisible,
+period for system_time (row_start, row_end)
+) with system versioning;
 insert t values (1, 2);
 replace t values (1, 3);
 select *, row_end>TIMESTAMP'2038-01-01 00:00:00' as current from t for system_time all
@@ -6,5 +12,19 @@ order by x;
 id	x	current
 1	2	0
 1	3	1
-drop database test;
-create database test;
+drop table t;
+create table t (
+id int unique,
+x int,
+row_start SYS_DATATYPE as row start invisible,
+row_end SYS_DATATYPE as row end invisible,
+period for system_time (row_start, row_end)
+) with system versioning;
+insert t values (1, 2);
+replace t values (1, 3);
+select *, row_end>TIMESTAMP'2038-01-01 00:00:00' as current from t for system_time all
+order by x;
+id	x	current
+1	2	0
+1	3	1
+drop table t;