--disable_warnings
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
--enable_warnings

CREATE TABLE `t1` (
  `id` int(11) NOT NULL auto_increment,
  `target_id` int(11) NOT NULL default '0',
  `end_user_operation_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `carrier_id` int(11) NOT NULL default '0',
  `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `target_type_id` int(11) NOT NULL default '0',
  `status` int(2) NOT NULL default '0',
  `interface_type` int(2) NOT NULL default '0',
  `interface_code` int(11) default NULL,
  `la_id` int(11) default NULL,
  `parent_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `eua_carrier_id_target_id_timestamp`
(`timestamp`,`carrier_id`,`target_id`),
  KEY `eua_user_id_timestamp` (`user_id`,`timestamp`),
  KEY `eua_timestamp` (`timestamp`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;

CREATE TABLE `t2` (
  `id` int(11) NOT NULL auto_increment,
  `target_id` int(11) NOT NULL default '0',
  `end_user_operation_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `carrier_id` int(11) NOT NULL default '0',
  `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `target_type_id` int(11) NOT NULL default '0',
  `status` int(2) NOT NULL default '0',
  `interface_type` int(2) NOT NULL default '0',
  `interface_code` int(11) default NULL,
  `la_id` int(11) default NULL,
  `parent_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `eua_carrier_id_target_id_timestamp`
(`timestamp`,`carrier_id`,`target_id`),
  KEY `eua_user_id_timestamp` (`user_id`,`timestamp`),
  KEY `eua_timestamp` (`timestamp`)
) ENGINE=innodb DEFAULT CHARSET=latin1;

SET GLOBAL ndb_use_exact_count = 0;

show variables;

--disable_query_log
source ./std_data/index.dat;
source ./std_data/index2.dat;
--enable_query_log

explain select id from t1 where timestamp >='2005-12-18 02:00:00' and timestamp <'2006-01-01 00:00:00';

explain select id from t1 FORCE INDEX (eua_timestamp) where timestamp >='2005-12-18 02:00:00' and timestamp <'2006-01-01 00:00:00';

explain select id from t2 where timestamp >='2005-12-18 02:00:00' and timestamp <'2006-01-01 00:00:00';

explain select id from t2 FORCE INDEX (eua_timestamp) where timestamp >='2005-12-18 02:00:00' and timestamp <'2006-01-01 00:00:00';


DROP TABLE t2;
DROP TABLE t1;