Content Comparison

create tagdata table TAG (name varchar(20) primary key, time datetime basetime, value double summarized)
metadata
(type short, create_date datetime, srcip ipv4) ;

Mach> desc tag;
[ COLUMN ]                              
----------------------------------------------------------------
NAME                          TYPE                LENGTH        
----------------------------------------------------------------
NAME                          varchar             20                  
TIME                          datetime            31              
VALUE                         double              17                  
[ META-COLUMN ]                              
----------------------------------------------------------------
NAME                          TYPE                LENGTH        
----------------------------------------------------------------
TYPE                          short               6               
CREATE_DATE                   datetime            31              
SRCIP                         ipv4                15                  

insert into t1 metadata values ('TAG_0001');

insert into tag values ('TAG_0001', '2010-01-01', 1.1);


insert into tag metadata values ('TAG_0001', 99, '2010-01-01', '1.1.1.1');

update tag metadata set name = 'TAG_0000001' where name = 'TAG_0001';

delete from tag metadata where name = 'TAG_0001'