diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/t/fast_upsert_int.py')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/t/fast_upsert_int.py | 50 |
1 files changed, 0 insertions, 50 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/fast_upsert_int.py b/storage/tokudb/mysql-test/tokudb/t/fast_upsert_int.py deleted file mode 100644 index a19227ec20d..00000000000 --- a/storage/tokudb/mysql-test/tokudb/t/fast_upsert_int.py +++ /dev/null @@ -1,50 +0,0 @@ -#!/usr/bin/env python - -import sys - -def main(): - print "# generated by tokudb_upsert_int.py" - print "source include/have_tokudb.inc;" - print "source include/have_innodb.inc;" - print "set default_storage_engine='tokudb';" - print "disable_warnings;" - print "drop table if exists tt, ti;" - print "enable_warnings;" - - print "set tokudb_disable_slow_update=1;" - - for t in [ 'tinyint', 'smallint', 'mediumint', 'int', 'bigint' ]: - for u in [ '', 'unsigned' ]: - for n in [ 'null', 'not null' ]: - test_upsert_int(t, u, n) - return 0 - -def test_upsert_int(t, u, n): - print "create table tt (" - print " id %s %s %s primary key," % (t, u, n) - if n == 'not null': n += ' default 0' - print " x %s %s %s," % (t, u, n) - print " y %s %s %s," % (t, u, n) - print " z %s %s %s," % (t, u, n) - print " a char(32), aa varchar(32)" - print ");" - print "insert noar into tt (id) values (1),(2),(3) on duplicate key update x=0;" - print "insert noar into tt (id) values (1) on duplicate key update y=0,z=42;" - print "insert noar into tt (id) values (1) on duplicate key update y=y+1,z=z+100;" - print "insert noar into tt (id) values (1) on duplicate key update y=y-1;" - print "insert noar into tt (id) values (1) on duplicate key update z=z-100;" - - print "create table ti like tt;" - print "alter table ti engine=innodb;" - print "insert noar into ti (id) values (1),(2),(3) on duplicate key update x=0;" - print "insert noar into ti (id) values (1) on duplicate key update y=0,z=42;" - print "insert noar into ti (id) values (1) on duplicate key update y=y+1,z=z+100;" - print "insert noar into ti (id) values (1) on duplicate key update y=y-1;" - print "insert noar into ti (id) values (1) on duplicate key update z=z-100;" - - print "let $diff_tables = test.tt, test.ti;" - print "source include/diff_tables.inc;" - - print "drop table tt, ti;" - -sys.exit(main()) |