1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150
|
use test;
drop table if exists stat_test;
create table stat_test(a int)engine=myisam; -- required b/c test plugin does not commit txn
DROP TABLE IF EXISTS `table_5`;
DROP TABLE IF EXISTS `table_5_dest`;
DROP TABLE IF EXISTS `table_5_copy`;
CREATE TABLE `table_5` (
a date not null,
b int not null,
c varchar(10) not null,
d varchar(50) not null,
e int not null,
f int not null,
g float not null,
h decimal(9,5) not null,
i datetime not null,
PRIMARY KEY (a,b,c,d)
) engine=InnoDB;
CREATE TABLE `table_5_dest` (
a date not null,
b int not null,
c varchar(10) not null,
d varchar(50) not null,
e int not null,
f int not null,
g float not null,
h decimal(9,5) not null,
i datetime not null,
PRIMARY KEY (a,b,c,d)
) engine=InnoDB;
CREATE TABLE `table_5_copy` (
a date not null,
b int not null,
c varchar(10) not null,
d varchar(50) not null,
e int not null,
f int not null,
g float not null,
h decimal(9,5) not null,
i datetime not null,
PRIMARY KEY (a,b,c,d)
) engine=InnoDB;
INSERT INTO `table_5` VALUES (current_date - interval 2 day,581,'m','ga',1,16,0,'0.00402','2007-03-10 18:00:33')
,(current_date - interval 2 day,584,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,584,'m','ga',1,9,0,'0.00226','2007-03-10 18:00:33')
,(current_date - interval 2 day,586,'b','yu',58,76,0,'0.01900','2007-03-10 18:00:33')
,(current_date - interval 2 day,587,'b','uc',261,381,0,'0.95259','2007-03-10 18:00:33')
,(current_date - interval 2 day,587,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,587,'m','ga',1,15,0,'0.00377','2007-03-10 18:00:33')
,(current_date - interval 2 day,588,'b','mb',54,171,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,593,'b','yu',271,422,0,'0.10550','2007-03-10 18:00:33')
,(current_date - interval 2 day,594,'b','uc',328,493,0,'1.23261','2007-03-10 18:00:33')
,(current_date - interval 2 day,594,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,594,'m','ga',1,26,0,'0.00653','2007-03-10 18:00:33')
,(current_date - interval 2 day,595,'b','yu',248,337,0,'0.08425','2007-03-10 18:00:33')
,(current_date - interval 2 day,596,'b','uc',286,367,0,'0.91759','2007-03-10 18:00:33')
,(current_date - interval 2 day,596,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,596,'m','ga',1,32,0,'0.00804','2007-03-10 18:00:33')
,(current_date - interval 2 day,600,'b','mb',64,85,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,603,'b','mb',149,304,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,604,'b','mb',86,112,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,605,'b','mb',60,74,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,619,'b','mb',50,78,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,623,'b','yu',235,300,0,'0.07500','2007-03-10 18:00:33')
,(current_date - interval 2 day,624,'b','mb',57,60,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,625,'b','uc',624,852,0,'2.13020','2007-03-10 18:00:33')
,(current_date - interval 2 day,625,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,625,'m','ga',1,30,0,'0.00753','2007-03-10 18:00:33')
,(current_date - interval 2 day,626,'b','yu',4,4,0,'0.00100','2007-03-10 18:00:33')
,(current_date - interval 2 day,628,'b','uc',28,44,0,'0.11001','2007-03-10 18:00:33')
,(current_date - interval 2 day,628,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,628,'m','ga',1,2,0,'0.00050','2007-03-10 18:00:33')
,(current_date - interval 2 day,629,'b','yu',161,384,0,'0.09600','2007-03-10 18:00:33')
,(current_date - interval 2 day,631,'b','uc',317,788,0,'1.97018','2007-03-10 18:00:33')
,(current_date - interval 2 day,631,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,631,'m','ga',1,136,0,'0.03416','2007-03-10 18:00:33')
,(current_date - interval 2 day,634,'b','yu',173,562,0,'0.14050','2007-03-10 18:00:33')
,(current_date - interval 2 day,635,'b','mb',131,295,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,636,'b','uc',867,2334,0,'5.83554','2007-03-10 18:00:33')
,(current_date - interval 2 day,636,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,636,'m','ga',1,34,0,'0.00854','2007-03-10 18:00:33')
,(current_date - interval 2 day,641,'b','yu',86,119,0,'0.02975','2007-03-10 18:00:33')
,(current_date - interval 2 day,643,'b','uc',103,121,0,'0.30253','2007-03-10 18:00:33')
,(current_date - interval 2 day,643,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,643,'m','ga',1,12,0,'0.00301','2007-03-10 18:00:33')
,(current_date - interval 2 day,647,'b','uc',16,17,0,'0.04250','2007-03-10 18:00:33')
,(current_date - interval 2 day,647,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,647,'m','ga',1,24,0,'0.00603','2007-03-10 18:00:33')
,(current_date - interval 2 day,650,'b','mb',318,490,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,652,'b','mb',36,39,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,653,'b','yu',32,52,0,'0.01300','2007-03-10 18:00:33')
,(current_date - interval 2 day,654,'b','mb',13,21,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,655,'b','uc',62,70,0,'0.17502','2007-03-10 18:00:33')
,(current_date - interval 2 day,655,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,655,'m','ga',1,18,0,'0.00452','2007-03-10 18:00:33')
,(current_date - interval 2 day,657,'b','mb',11,26,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,658,'b','yu',353,397,0,'0.09925','2007-03-10 18:00:33')
,(current_date - interval 2 day,660,'b','mb',319,378,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,661,'b','uc',1043,1655,0,'4.13788','2007-03-10 18:00:33')
,(current_date - interval 2 day,661,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,661,'m','ga',1,49,0,'0.01231','2007-03-10 18:00:33')
,(current_date - interval 2 day,663,'b','mb',18,18,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,676,'b','uc',233,404,0,'1.01009','2007-03-10 18:00:33')
,(current_date - interval 2 day,676,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,676,'m','ga',1,24,0,'0.00603','2007-03-10 18:00:33')
,(current_date - interval 2 day,678,'b','yu',117,178,0,'0.04450','2007-03-10 18:00:33')
,(current_date - interval 2 day,679,'b','mb',29,54,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,683,'b','uc',230,303,0,'0.75757','2007-03-10 18:00:33')
,(current_date - interval 2 day,683,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,683,'m','ga',1,40,0,'0.01005','2007-03-10 18:00:33')
,(current_date - interval 2 day,685,'b','yu',96,134,0,'0.03350','2007-03-10 18:00:33')
,(current_date - interval 2 day,687,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,687,'m','ga',1,27,0,'0.00678','2007-03-10 18:00:33')
,(current_date - interval 2 day,692,'b','mb',7,7,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,697,'b','uc',55,80,0,'0.20002','2007-03-10 18:00:33')
,(current_date - interval 2 day,697,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,697,'m','ga',1,9,0,'0.00226','2007-03-10 18:00:33')
,(current_date - interval 2 day,698,'b','yu',36,43,0,'0.01075','2007-03-10 18:00:33')
,(current_date - interval 2 day,699,'b','mb',17,19,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,702,'b','yu',10,19,0,'0.00475','2007-03-10 18:00:33')
,(current_date - interval 2 day,710,'b','yu',48,238,0,'0.05950','2007-03-10 18:00:33')
,(current_date - interval 2 day,711,'b','uc',33,54,0,'0.13501','2007-03-10 18:00:33')
,(current_date - interval 2 day,711,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,711,'m','ga',1,4,0,'0.00100','2007-03-10 18:00:33')
,(current_date - interval 2 day,712,'b','yu',1509,2930,0,'0.73250','2007-03-10 18:00:33')
,(current_date - interval 2 day,716,'b','uc',153,296,0,'0.74007','2007-03-10 18:00:33')
,(current_date - interval 2 day,716,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,716,'m','ga',1,10,0,'0.00251','2007-03-10 18:00:33')
,(current_date - interval 2 day,717,'b','yu',26,49,0,'0.01225','2007-03-10 18:00:33')
,(current_date - interval 2 day,722,'b','uc',52,70,0,'0.17502','2007-03-10 18:00:33')
,(current_date - interval 2 day,722,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,722,'m','ga',1,9,0,'0.00226','2007-03-10 18:00:33')
,(current_date - interval 2 day,723,'b','yu',76,107,0,'0.02675','2007-03-10 18:00:33')
,(current_date - interval 2 day,724,'b','mb',39,56,0,'0.00000','2007-03-10 18:00:33')
,(current_date - interval 2 day,727,'b','uc',44,65,0,'0.16252','2007-03-10 18:00:33')
,(current_date - interval 2 day,727,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,727,'m','ga',1,30,0,'0.00753','2007-03-10 18:00:33')
,(current_date - interval 2 day,728,'b','yu',3,3,0,'0.00075','2007-03-10 18:00:33')
,(current_date - interval 2 day,730,'b','yu',180,212,0,'0.05300','2007-03-10 18:00:33')
,(current_date - interval 2 day,733,'b','uc',111,191,0,'0.47754','2007-03-10 18:00:33')
,(current_date - interval 2 day,733,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,733,'m','ga',1,3,0,'0.00075','2007-03-10 18:00:33')
,(current_date - interval 2 day,740,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,740,'m','ga',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,741,'c','dr',1,1,0,'0.00025','2007-03-10 18:00:33')
,(current_date - interval 2 day,741,'m','ga',1,3,0,'0.00075','2007-03-10 18:00:33')
,(current_date - interval 2 day,743,'b','yu',137,163,0,'0.04075','2007-03-10 18:00:33');
|