blob: 44cf18a79b20f83cfac349ad638637f260638fb8 (plain)

ofs	hex dump	ascii
0000	73 65 74 20 64 65 66 61 75 6c 74 5f 73 74 6f 72 61 67 65 5f 65 6e 67 69 6e 65 3d 27 74 6f 6b 75	set.default_storage_engine='toku
0020	64 62 27 3b 0a 64 72 6f 70 20 74 61 62 6c 65 20 69 66 20 65 78 69 73 74 73 20 74 30 2c 20 74 31	db';.drop.table.if.exists.t0,.t1
0040	3b 0a 73 65 74 20 74 6f 6b 75 64 62 5f 64 69 73 61 62 6c 65 5f 73 6c 6f 77 5f 75 70 73 65 72 74	;.set.tokudb_disable_slow_upsert
0060	3d 31 3b 0a 63 72 65 61 74 65 20 74 61 62 6c 65 20 74 30 20 28 69 64 20 69 6e 74 20 70 72 69 6d	=1;.create.table.t0.(id.int.prim
0080	61 72 79 20 6b 65 79 2c 20 62 20 62 69 6e 61 72 79 28 33 32 29 29 3b 0a 63 72 65 61 74 65 20 74	ary.key,.b.binary(32));.create.t
00a0	61 62 6c 65 20 74 31 20 6c 69 6b 65 20 74 30 3b 0a 69 6e 73 65 72 74 20 6e 6f 61 72 20 69 6e 74	able.t1.like.t0;.insert.noar.int
00c0	6f 20 74 30 20 76 61 6c 75 65 73 20 28 31 2c 27 68 69 27 29 2c 28 32 2c 27 74 68 65 72 65 27 29	o.t0.values.(1,'hi'),(2,'there')
00e0	3b 0a 73 65 6c 65 63 74 20 2a 20 66 72 6f 6d 20 74 30 3b 0a 69 64 09 62 0a 31 09 68 69 00 00 00	;.select.*.from.t0;.id.b.1.hi...
0100	00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0a 32 09 74 68	............................2.th
0120	65 72 65 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0a 69	ere............................i
0140	6e 73 65 72 74 20 6e 6f 61 72 20 69 6e 74 6f 20 74 31 20 76 61 6c 75 65 73 20 28 31 2c 6e 75 6c	nsert.noar.into.t1.values.(1,nul
0160	6c 29 2c 28 32 2c 6e 75 6c 6c 29 3b 0a 69 6e 73 65 72 74 20 6e 6f 61 72 20 69 6e 74 6f 20 74 31	l),(2,null);.insert.noar.into.t1
0180	20 76 61 6c 75 65 73 20 28 31 2c 6e 75 6c 6c 29 20 6f 6e 20 64 75 70 6c 69 63 61 74 65 20 6b 65	.values.(1,null).on.duplicate.ke
01a0	79 20 75 70 64 61 74 65 20 62 3d 27 68 69 27 3b 0a 69 6e 73 65 72 74 20 6e 6f 61 72 20 69 6e 74	y.update.b='hi';.insert.noar.int
01c0	6f 20 74 31 20 76 61 6c 75 65 73 20 28 32 2c 6e 75 6c 6c 29 20 6f 6e 20 64 75 70 6c 69 63 61 74	o.t1.values.(2,null).on.duplicat
01e0	65 20 6b 65 79 20 75 70 64 61 74 65 20 62 3d 27 74 68 65 72 65 27 3b 0a 73 65 6c 65 63 74 20 2a	e.key.update.b='there';.select.*
0200	20 66 72 6f 6d 20 74 31 3b 0a 69 64 09 62 0a 31 09 68 69 00 00 00 00 00 00 00 00 00 00 00 00 00	.from.t1;.id.b.1.hi.............
0220	00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0a 32 09 74 68 65 72 65 00 00 00 00 00 00 00	..................2.there.......
0240	00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0a 69 6e 63 6c 75 64 65 2f 64 69 66	.....................include/dif
0260	66 5f 74 61 62 6c 65 73 2e 69 6e 63 20 5b 74 65 73 74 2e 74 30 2c 20 74 65 73 74 2e 74 31 5d 0a	f_tables.inc.[test.t0,.test.t1].
0280	64 72 6f 70 20 74 61 62 6c 65 20 74 30 2c 20 74 31 3b 0a	drop.table.t0,.t1;.