blob: 1955c1632d2ce1893b892ed09367542cc1b88071 (plain)

ofs	hex dump	ascii
0000	73 65 74 20 74 6f 6b 75 64 62 5f 65 6e 61 62 6c 65 5f 66 61 73 74 5f 75 70 73 65 72 74 3d 31 3b	set.tokudb_enable_fast_upsert=1;
0020	0a 73 65 74 20 73 65 73 73 69 6f 6e 20 73 71 6c 5f 6d 6f 64 65 3d 28 73 65 6c 65 63 74 20 72 65	.set.session.sql_mode=(select.re
0040	70 6c 61 63 65 28 40 40 73 71 6c 5f 6d 6f 64 65 2c 27 53 54 52 49 43 54 5f 54 52 41 4e 53 5f 54	place(@@sql_mode,'STRICT_TRANS_T
0060	41 42 4c 45 53 27 2c 27 27 29 29 3b 0a 73 65 74 20 73 65 73 73 69 6f 6e 20 73 71 6c 5f 6d 6f 64	ABLES',''));.set.session.sql_mod
0080	65 3d 28 73 65 6c 65 63 74 20 72 65 70 6c 61 63 65 28 40 40 73 71 6c 5f 6d 6f 64 65 2c 27 53 54	e=(select.replace(@@sql_mode,'ST
00a0	52 49 43 54 5f 41 4c 4c 5f 54 41 42 4c 45 53 27 2c 27 27 29 29 3b 0a 63 72 65 61 74 65 20 74 61	RICT_ALL_TABLES',''));.create.ta
00c0	62 6c 65 20 74 30 20 28 69 64 20 69 6e 74 20 70 72 69 6d 61 72 79 20 6b 65 79 2c 20 62 20 62 69	ble.t0.(id.int.primary.key,.b.bi
00e0	6e 61 72 79 28 33 32 29 29 20 65 6e 67 69 6e 65 20 3d 20 74 6f 6b 75 64 62 3b 0a 63 72 65 61 74	nary(32)).engine.=.tokudb;.creat
0100	65 20 74 61 62 6c 65 20 74 31 20 6c 69 6b 65 20 74 30 3b 0a 69 6e 73 65 72 74 20 69 6e 74 6f 20	e.table.t1.like.t0;.insert.into.
0120	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 3b 0a	t0.values.(1,'hi'),(2,'there');.
0140	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 00 00	select.*.from.t0;.id.b.1.hi.....
0160	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 65 72	..........................2.ther
0180	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 6e 73	e............................ins
01a0	65 72 74 20 69 6e 74 6f 20 74 31 20 76 61 6c 75 65 73 20 28 31 2c 6e 75 6c 6c 29 2c 28 32 2c 6e	ert.into.t1.values.(1,null),(2,n
01c0	75 6c 6c 29 3b 0a 69 6e 73 65 72 74 20 69 6e 74 6f 20 74 31 20 76 61 6c 75 65 73 20 28 31 2c 6e	ull);.insert.into.t1.values.(1,n
01e0	75 6c 6c 29 20 6f 6e 20 64 75 70 6c 69 63 61 74 65 20 6b 65 79 20 75 70 64 61 74 65 20 62 3d 27	ull).on.duplicate.key.update.b='
0200	68 69 27 3b 0a 69 6e 73 65 72 74 20 69 6e 74 6f 20 74 31 20 76 61 6c 75 65 73 20 28 32 2c 6e 75	hi';.insert.into.t1.values.(2,nu
0220	6c 6c 29 20 6f 6e 20 64 75 70 6c 69 63 61 74 65 20 6b 65 79 20 75 70 64 61 74 65 20 62 3d 27 74	ll).on.duplicate.key.update.b='t
0240	68 65 72 65 27 3b 0a 73 65 6c 65 63 74 20 2a 20 66 72 6f 6d 20 74 31 3b 0a 69 64 09 62 0a 31 09	here';.select.*.from.t1;.id.b.1.
0260	68 69 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 00 00 00	hi..............................
0280	0a 32 09 74 68 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	.2.there........................
02a0	00 00 00 0a 69 6e 63 6c 75 64 65 2f 64 69 66 66 5f 74 61 62 6c 65 73 2e 69 6e 63 20 5b 74 65 73	....include/diff_tables.inc.[tes
02c0	74 2e 74 30 2c 20 74 65 73 74 2e 74 31 5d 0a 64 72 6f 70 20 74 61 62 6c 65 20 74 30 2c 20 74 31	t.t0,.test.t1].drop.table.t0,.t1
02e0	3b 0a	;.