text: --create range partition table with date data type and one partition having maxvalue,then insert data to this table,then delete one record where the separated field value is equal with some value
  
  create table range_test(id int,	
  				test_time time,
  				test_date date,
  				test_timestamp timestamp, primary key(id,test_date))
  		PARTITION BY RANGE (test_date) (
  		PARTITION p0 VALUES LESS THAN MAXVALUE
  	);
  	insert into range_test values(1,'06:00:00','2005-01-01','2005-01-01 09:00:00');
  	insert into range_test values(2,'07:00:00','2005-06-01','2005-06-01 09:00:00');
  	insert into range_test values(3,'08:00:00','2005-12-01','2005-12-01 09:00:00');
  	insert into range_test values(8,NULL,NULL,NULL);
  delete from range_test  where test_date      = '2005-12-01';
  select * from range_test order by 1;
  
  
  drop table range_test;
  