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