Debian Codegraph @

mysql-test/suite/versioning/common.inc

raw
1 if (!$TEST_VERSIONING_SO)
2 {
3 --skip needs test_versioning plugin
4 }
5 source include/have_innodb.inc;
6 source sys_time.inc;
7 --disable_query_log
8
9 set @@session.time_zone='+00:00';
10 set @@global.time_zone='+00:00';
11 --disable_cursor_protocol
12 select ifnull(max(transaction_id), 0) into @start_trx_id from mysql.transaction_registry;
13 --enable_cursor_protocol
14 set @test_start=now(6);
15
16 delimiter ~~;
17 create procedure if not exists verify_trt()
18 begin
19 set @i= 0;
20 select
21 @i:= @i + 1 as No,
22 transaction_id > 0 as A,
23 commit_id > transaction_id as B,
24 begin_timestamp > @test_start as C,
25 commit_timestamp >= begin_timestamp as D
26 from mysql.transaction_registry
27 where transaction_id > @start_trx_id;
28 select ifnull(max(transaction_id), 0)
29 into @start_trx_id
30 from mysql.transaction_registry;
31 end~~
32
33 create procedure if not exists verify_trt_dummy(recs int)
34 begin
35 declare i int default 1;
36 create temporary table tmp (No int, A bool, B bool, C bool, D bool);
37 while i <= recs do
38 insert into tmp values (i, 1, 1, 1, 1);
39 set i= i + 1;
40 end while;
41 select * from tmp;
42 drop table tmp;
43 end~~
44
45 delimiter ;~~
46
47 let $default_engine= `select @@default_storage_engine`;
48 let $non_default_engine= `select if(@@default_storage_engine = 'InnoDB', 'MyISAM', 'InnoDB')`;
49 let $sys_datatype_expl= timestamp(6);
50 let $sys_datatype_expl_uc= TIMESTAMP(6);
51
52 if ($MTR_COMBINATION_MYISAM)
53 {
54 --let $MTR_COMBINATION_TIMESTAMP= 1
55 }
56 if ($MTR_COMBINATION_TRADITIONAL)
57 {
58 --let $MTR_COMBINATION_TIMESTAMP= 1
59 }
60 if ($MTR_COMBINATION_HEAP)
61 {
62 --let $MTR_COMBINATION_TIMESTAMP= 1
63 }
64 if ($MTR_COMBINATION_TRX_ID)
65 {
66 let $sys_datatype_expl= bigint(20) unsigned;
67 let $sys_datatype_expl_uc= BIGINT(20) UNSIGNED;
68 let $sys_datatype_max= 18446744073709551615;
69 let $current_row= current_row;
70 }
71 if ($MTR_COMBINATION_TIMESTAMP)
72 {
73 let $current_row= current_row_ts;
74 }
75
76 eval create or replace function current_row(sys_trx_end $sys_datatype_expl)
77 returns int
78 deterministic
79 return sys_trx_end = $sys_datatype_max;
80
81 eval create or replace function current_row_ts(sys_trx_end timestamp(6))
82 returns int
83 deterministic
84 return convert_tz(sys_trx_end, @@time_zone, '+00:00') = $sys_time_max;
85
86 delimiter ~~;
87 eval create or replace function check_row(row_start $sys_datatype_expl, row_end $sys_datatype_expl)
88 returns varchar(255)
89 deterministic
90 begin
91 if row_end < row_start then
92 return "ERROR: row_end < row_start";
93 elseif row_end = row_start then
94 return "ERROR: row_end == row_start";
95 elseif $current_row(row_end) then
96 return "CURRENT ROW";
97 end if;
98 return "HISTORICAL ROW";
99 end~~
100 delimiter ;~~
101
102 delimiter ~~;
103 eval create or replace function check_row_slave(row_start $sys_datatype_expl, row_end $sys_datatype_expl)
104 returns varchar(255)
105 deterministic
106 begin
107 if $current_row(row_end) then
108 return "CURRENT ROW";
109 end if;
110 return "HISTORICAL ROW";
111 end~~
112 delimiter ;~~
113
114 delimiter ~~;
115 eval create or replace function check_row_ts(row_start timestamp(6), row_end timestamp(6))
116 returns varchar(255)
117 deterministic
118 begin
119 if row_end < row_start then
120 return "ERROR: row_end < row_start";
121 elseif row_end = row_start then
122 return "ERROR: row_end == row_start";
123 elseif current_row_ts(row_end) then
124 return "CURRENT ROW";
125 end if;
126 return "HISTORICAL ROW";
127 end~~
128 delimiter ;~~
129
130 --enable_query_log