Debian Codegraph @

mysql-test/suite/federated/federatedx_versioning.test

raw
1 --source include/not_embedded.inc
2 --source have_federatedx.inc
3 --source suite/versioning/engines.inc
4 --source suite/versioning/common.inc
5
6 --replace_result $sys_datatype_expl SYS_TYPE
7 eval create or replace table t1 (
8 x int,
9 row_start $sys_datatype_expl as row start invisible,
10 row_end $sys_datatype_expl as row end invisible,
11 period for system_time (row_start, row_end))
12 with system versioning;
13 --replace_result $MASTER_MYPORT MASTER_MYPORT
14 eval create or replace table tf engine=FEDERATED connection='mysql://[email protected]:$MASTER_MYPORT/test/t1';
15 --replace_result $MASTER_MYPORT MASTER_MYPORT $sys_datatype_expl SYS_TYPE 19710101000000 "'1971-01-01 00:00:00.000000'" "NOT NULL " ""
16 show create table tf;
17 --echo # INSERT
18 insert into t1 values (1);
19 select * from tf;
20 insert into tf (x) values (2);
21 select * from t1;
22 select * from tf;
23
24 --echo # UPDATE
25 update tf set x= x + 2;
26 select *, check_row(row_start, row_end) from t1 for system_time all
27 order by x;
28
29 --echo # DELETE
30 delete from tf;
31 select *, check_row(row_start, row_end) from t1 for system_time all
32 order by x;
33 select * from tf;
34
35 --echo # MDEV-15966: Behavior for TRUNCATE versioned table is not documented
36 --echo # and not covered by tests
37 --echo # As of standard, TRUNCATE on versioned tables is forbidden
38 --error ER_GET_ERRMSG
39 truncate tf;
40
41 delete history from t1;
42 select * from t1 for system_time all;
43
44 --echo # REPLACE
45 --replace_result $sys_datatype_expl SYS_TYPE
46 eval create or replace table t2 (
47 id int primary key, y int,
48 row_start $sys_datatype_expl as row start invisible,
49 row_end $sys_datatype_expl as row end invisible,
50 period for system_time (row_start, row_end))
51 with system versioning;
52 --replace_result $MASTER_MYPORT MASTER_MYPORT
53 eval create or replace table t2f engine=FEDERATED connection='mysql://[email protected]:$MASTER_MYPORT/test/t2';
54 insert t2f (id, y) values (1, 2);
55 replace t2f (id, y) values (1, 3);
56 select *, check_row(row_start, row_end) from t2 for system_time all
57 order by y;
58
59 --echo # VIEW
60 create or replace view vt1 as select * from tf;
61 insert into vt1 values (3);
62 update vt1 set x= x + 1;
63 select *, check_row(row_start, row_end) from t1 for system_time all
64 order by x;
65 delete from vt1;
66 select *, check_row(row_start, row_end) from t1 for system_time all
67 order by x;
68
69 --echo # multi-UPDATE
70 delete from t1;
71 delete history from t1;
72 delete from t2;
73 delete history from t2;
74 insert into t1 values (1);
75 insert into t2 values (2, 2);
76 update tf, t2f set tf.x= 11, t2f.y= 22;
77 select *, check_row(row_start, row_end) from t1 for system_time all
78 order by x;
79 select *, check_row(row_start, row_end) from t2 for system_time all
80 order by y;
81
82 drop view vt1;
83 drop tables t1, t2, t2f, tf;
84
85 --source suite/versioning/common_finish.inc