| 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 |