1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
#!/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())
|