Re: fragmentation ? (fwd)

note on fragmentation....i've sent this to jonathan for help. the following fragmentation sql statement creates the table but the load fails due to the given error: CREATE TABLE "informix".fragbyexpnorem ( c1 CHAR(1), c2 SERIAL NOT NULL ) FRAGMENT BY EXPRESSION (c1 < 100 ) IN dev_root_dbs, (c1 >= 100 ) IN dev_data_dbs lock mode PAGE ; insert into fragbyexpnorem values ('a',0); insert into fragbyexpnorem values ('b',0); 271: Could not insert new row into the table. 883: Cannot evaluate the fragmentation expression. but if you change the fragmentation expression to : FRAGMENT BY EXPRESSION (c1 < '100' ) IN dev_root_dbs, (c1 >= '100' ) IN dev_data_dbs lock mode PAGE ; it works. but shouldnt the engine check this ahead of time?