diff options
author | Aleksey Midenkov <midenok@gmail.com> | 2017-12-03 23:06:24 +0300 |
---|---|---|
committer | Aleksey Midenkov <midenok@gmail.com> | 2017-12-04 00:49:44 +0300 |
commit | 68e160fb25e09df3ae2a63f944f9ee77bd50ee11 (patch) | |
tree | b8701b5d65778ac8ebb5888a4d02955ff6ddc93d /mysql-test/suite/versioning/r/create.result | |
parent | ce78bafe7a19bc3028d7da708816fef9b573fbe0 (diff) | |
download | mariadb-git-68e160fb25e09df3ae2a63f944f9ee77bd50ee11.tar.gz |
Tests: removed common.inc from results
Diffstat (limited to 'mysql-test/suite/versioning/r/create.result')
-rw-r--r-- | mysql-test/suite/versioning/r/create.result | 75 |
1 files changed, 0 insertions, 75 deletions
diff --git a/mysql-test/suite/versioning/r/create.result b/mysql-test/suite/versioning/r/create.result index b0003bf46ac..857b283fbaa 100644 --- a/mysql-test/suite/versioning/r/create.result +++ b/mysql-test/suite/versioning/r/create.result @@ -1,78 +1,3 @@ -set @@session.time_zone='+00:00'; -select ifnull(max(transaction_id), 0) into @start_trx_id from mysql.transaction_registry; -set @test_start=now(6); -create procedure if not exists verify_vtq() -begin -set @i= 0; -select -@i:= @i + 1 as No, -transaction_id > 0 as A, -commit_id > transaction_id as B, -begin_timestamp > @test_start as C, -commit_timestamp >= begin_timestamp as D -from mysql.transaction_registry -where transaction_id > @start_trx_id; -select ifnull(max(transaction_id), 0) -into @start_trx_id -from mysql.transaction_registry; -end~~ -create function if not exists default_engine() -returns varchar(255) -deterministic -begin -declare e varchar(255); -select lower(engine) from information_schema.engines where support='DEFAULT' into e; -return e; -end~~ -create function if not exists sys_datatype() -returns varchar(255) -deterministic -begin -if default_engine() = 'innodb' then -return 'bigint unsigned'; -elseif default_engine() = 'myisam' then -return 'timestamp(6)'; -end if; -return NULL; -end~~ -create function if not exists sys_commit_ts(sys_field varchar(255)) -returns varchar(255) -deterministic -begin -if default_engine() = 'innodb' then -return concat('vtq_commit_ts(', sys_field, ')'); -elseif default_engine() = 'myisam' then -return sys_field; -end if; -return NULL; -end~~ -create procedure if not exists innodb_verify_vtq(recs int) -begin -declare i int default 1; -if default_engine() = 'innodb' then -call verify_vtq; -elseif default_engine() = 'myisam' then -create temporary table tmp (No int, A bool, B bool, C bool, D bool); -while i <= recs do -insert into tmp values (i, 1, 1, 1, 1); -set i= i + 1; -end while; -select * from tmp; -drop table tmp; -end if; -end~~ -create procedure concat_exec2(a varchar(255), b varchar(255)) -begin -prepare stmt from concat(a, b); -execute stmt; -deallocate prepare stmt; -end~~ -create procedure concat_exec3(a varchar(255), b varchar(255), c varchar(255)) -begin -prepare stmt from concat(a, b, c); -execute stmt; -deallocate prepare stmt; -end~~ drop table if exists t1; create function if not exists non_default_engine() returns varchar(255) |