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;. |