1SET DEFAULT_STORAGE_ENGINE = 'tokudb'; 2# Establish connection conn1 (user = root) 3connect conn1,localhost,root,,; 4connect conn2,localhost,root,,; 5connect conn3,localhost,root,,; 6connect conn4,localhost,root,,; 7connect conn5,localhost,root,,; 8DROP TABLE IF EXISTS foo; 9connection default; 10create table foo (a int, b varchar (100), primary key (a)) engine=TokuDB; 11show create table foo; 12Table Create Table 13foo CREATE TABLE `foo` ( 14 `a` int(11) NOT NULL, 15 `b` varchar(100) DEFAULT NULL, 16 PRIMARY KEY (`a`) 17) ENGINE=TokuDB DEFAULT CHARSET=latin1 18connection conn1; 19set session transaction isolation level repeatable read; 20begin; 21select * from foo; 22a b 23connection default; 24replace into foo values (1, "a"); 25connection conn2; 26set session transaction isolation level repeatable read; 27begin; 28select * from foo; 29a b 301 a 31connection default; 32replace into foo values (1,"abGARBAGE"), (2, "abGARBAGE"); 33replace into foo values (1,"ab"), (2, "ab"); 34connection conn3; 35set session transaction isolation level repeatable read; 36begin; 37select * from foo; 38a b 391 ab 402 ab 41connection default; 42replace into foo values (1,"abcGARBAGE"),(2,"abcGARBAGE"),(3, "abcGARBAGE"); 43replace into foo values (1,"abc"),(2,"abc"),(3, "abc"); 44connection conn4; 45set session transaction isolation level repeatable read; 46begin; 47select * from foo; 48a b 491 abc 502 abc 513 abc 52connection default; 53replace into foo values (1,"abcdGARBAGE"),(2,"abcdGARBAGE"),(3, "abcdGARBAGE"),(4, "abcdGARBAGE"); 54replace into foo values (1,"abcd"),(2,"abcd"),(3, "abcd"),(4, "abcd"); 55connection conn5; 56set session transaction isolation level repeatable read; 57begin; 58select * from foo; 59a b 601 abcd 612 abcd 623 abcd 634 abcd 64connection conn1; 65select * from foo; 66a b 67commit; 68connection conn2; 69select * from foo; 70a b 711 a 72commit; 73connection conn3; 74select * from foo; 75a b 761 ab 772 ab 78commit; 79connection conn4; 80select * from foo; 81a b 821 abc 832 abc 843 abc 85commit; 86connection conn5; 87select * from foo; 88a b 891 abcd 902 abcd 913 abcd 924 abcd 93commit; 94connection default; 95select * from foo; 96a b 971 abcd 982 abcd 993 abcd 1004 abcd 101replace into foo values (1,"1"),(2,"2"),(3,"3"),(4,"4"); 102select * from foo; 103a b 1041 1 1052 2 1063 3 1074 4 108disconnect conn1; 109disconnect conn2; 110disconnect conn3; 111disconnect conn4; 112disconnect conn5; 113connection default; 114set session transaction isolation level serializable; 115DROP TABLE foo; 116