diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/t/fast_update_int.test')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/t/fast_update_int.test | 682 |
1 files changed, 35 insertions, 647 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/fast_update_int.test b/storage/tokudb/mysql-test/tokudb/t/fast_update_int.test index e663cbfb8fd..699fc9dacba 100644 --- a/storage/tokudb/mysql-test/tokudb/t/fast_update_int.test +++ b/storage/tokudb/mysql-test/tokudb/t/fast_update_int.test @@ -1,647 +1,35 @@ -# generated by tokudb_fast_update_int.py -source include/have_tokudb.inc; -source include/have_innodb.inc; -set default_storage_engine='tokudb'; -disable_warnings; -drop table if exists t; -enable_warnings; -create table t ( - id tinyint null primary key, - x tinyint null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id tinyint not null primary key, - x tinyint not null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id tinyint unsigned null primary key, - x tinyint unsigned null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id tinyint unsigned not null primary key, - x tinyint unsigned not null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id smallint null primary key, - x smallint null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id smallint not null primary key, - x smallint not null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id smallint unsigned null primary key, - x smallint unsigned null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id smallint unsigned not null primary key, - x smallint unsigned not null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id mediumint null primary key, - x mediumint null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id mediumint not null primary key, - x mediumint not null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id mediumint unsigned null primary key, - x mediumint unsigned null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id mediumint unsigned not null primary key, - x mediumint unsigned not null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id int null primary key, - x int null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id int not null primary key, - x int not null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id int unsigned null primary key, - x int unsigned null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id int unsigned not null primary key, - x int unsigned not null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id bigint null primary key, - x bigint null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id bigint not null primary key, - x bigint not null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id bigint unsigned null primary key, - x bigint unsigned null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; -create table t ( - id bigint unsigned not null primary key, - x bigint unsigned not null -); -insert into t values (1,0),(2,0),(3,0); -select * from t; -set tokudb_disable_slow_update=1; -update noar t set x=100 where id=2; -select * from t; -update noar t set x=x+1 where id=3; -select * from t; -update noar t set x=x-1 where id=3; -select * from t; -update noar t set x=x+100 where id=3; -select * from t; -update noar t set x=x-100 where id=3; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=1+x where id=1; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=-x where id=1; -update noar t set x=x+1 where id=100; -select * from t; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where 1 <= id and id < 100; -replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; -error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1; -drop table t; +--source ../include/fast_update_gen_header.inc + +--let GENERATED=$MYSQL_TMP_DIR/generated_fast_update_int.inc + +--perl + + my $mysql_current_test_dir = $ENV{MYSQL_CURRENT_TEST_DIR}; + open(FILE, '>', "$ENV{GENERATED}") or die; + foreach my $t ('tinyint', 'smallint', 'mediumint', 'int', 'bigint') { + foreach my $u ('', 'unsigned') { + foreach my $n ('null', 'not null') { + print FILE "--echo ### Test int for: $t, $u, $n\n"; + test_int($t, $u, $n); + } + } + } + close FILE; + + sub test_int { + my $t = shift; + my $u = shift; + my $n = shift; + + print FILE "create table t (\n"; + print FILE " id $t $u primary key,\n"; + print FILE " x $t $u $n\n"; + print FILE ") engine = tokudb;\n"; + + print FILE "--source $ENV{MYSQL_CURRENT_TEST_DIR}/../include/". + "fast_update_int.inc\n\n"; + } + +EOF + +--source ../include/fast_update_gen_footer.inc |