> Could you provide structure of tables and some data for testing?
How? I tried to post a couple of zip files (2 mails, 10k each) but it
doesn't work.
Some data (and schema)
CREATE TABLE IF NOT EXISTS PARTITIONED2_1 (
ID int(3) unsigned NOT NULL DEFAULT '0' ,
DATA1 timestamp ,
PRIMARY KEY (ID)
);
INSERT INTO PARTITIONED2_1 VALUES("1","2003-01-13 01:12:27");
INSERT INTO PARTITIONED2_1 VALUES("2","2003-09-08 22:04:41");
INSERT INTO PARTITIONED2_1 VALUES("3","2003-06-06 08:10:28");
INSERT INTO PARTITIONED2_1 VALUES("4","2003-09-03 20:58:29");
INSERT INTO PARTITIONED2_1 VALUES("5","2003-06-11 06:59:17");
INSERT INTO PARTITIONED2_1 VALUES("6","2003-01-19 17:53:23");
INSERT INTO PARTITIONED2_1 VALUES("7","2003-04-20 03:10:52");
CREATE TABLE IF NOT EXISTS PARTITIONED2_2 (
ID int(3) unsigned NOT NULL DEFAULT '0' ,
DATA1 timestamp ,
PRIMARY KEY (ID)
);
INSERT INTO PARTITIONED2_2 VALUES("501","2003-08-10 12:10:53");
INSERT INTO PARTITIONED2_2 VALUES("502","2003-07-09 21:17:49");
INSERT INTO PARTITIONED2_2 VALUES("503","2003-06-25 20:48:16");
INSERT INTO PARTITIONED2_2 VALUES("504","2003-04-29 23:15:19");
INSERT INTO PARTITIONED2_2 VALUES("505","2004-05-19 13:34:10");
INSERT INTO PARTITIONED2_2 VALUES("506","2003-05-01 05:14:06");
INSERT INTO PARTITIONED2_2 VALUES("507","2003-02-17 11:35:42");
INSERT INTO PARTITIONED2_2 VALUES("508","2003-09-12 01:56:10");
INSERT INTO PARTITIONED2_2 VALUES("509","2003-03-14 23:13:25");
INSERT INTO PARTITIONED2_2 VALUES("510","2003-04-09 01:10:04");
INSERT INTO PARTITIONED2_2 VALUES("511","2003-01-30 17:53:46");
INSERT INTO PARTITIONED2_2 VALUES("512","2003-08-04 02:45:48");
CREATE TABLE IF NOT EXISTS PARTITIONED_1_1 (
ID1 int(10) unsigned NOT NULL DEFAULT '0' ,
ID2 datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
DATA1 varchar(10) ,
DATA2 double(5,4) ,
DATA3 datetime ,
PRIMARY KEY (ID1,ID2)
);
INSERT INTO PARTITIONED_1_1 VALUES("1","2003-01-06 07:09:11","tremor
s","3555.5240","2003-01-11 00:04:54");
INSERT INTO PARTITIONED_1_1 VALUES("1","2003-01-08
05:48:18","mecha","5333.7749","2003-01-17 02:11:18");
INSERT INTO PARTITIONED_1_1 VALUES("1","2003-01-10
06:04:51","","5744.7958","2003-01-12 05:46:39");
INSERT INTO PARTITIONED_1_1 VALUES("1","2003-01-11
23:28:40","clon","3341.9492","2003-01-09 08:01:09");
INSERT INTO PARTITIONED_1_1 VALUES("1","2003-01-26
06:36:33","stopping","6437.8025","2003-01-04 20:21:06");
INSERT INTO PARTITIONED_1_1 VALUES("1","2003-02-07
05:56:35","dis","7767.9386","2003-01-15 03:10:04");
etc etc (tables PARTITIONED_*_* have all the same schema but different data)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
