FRAGMENTATION ? (FWD)

I> From: inf_bb@hermes1.sps.mot.com (Bob Baskett) I> the following fragmentation sql statement creates the table but the load > fails due to the given error: I> 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 I> lock mode PAGE > ; I> insert into fragbyexpnorem values ('a',0); > insert into fragbyexpnorem values ('b',0); I> 271: Could not insert new row into the table. > 883: Cannot evaluate the fragmentation expression. I> but if you change the fragmentation expression to : I> FRAGMENT BY EXPRESSION > (c1 < '100' ) IN dev_root_dbs, (c1 >= '100' ) IN dev_data_dbs I> lock mode PAGE > ; I> it works. but shouldnt the engine check this ahead of time? Technically, yes, but there are several additional cases where thing slip by in compiling but bomb on execution. A real bummer I've hated was how you can't drop and create a table in the same executable (.4go/i or .4ge). You'd think the program would know about that, too. We could start a thread of things the compiler should throw out but doesn't until the program bombs. Tim --- ~ SPEED 1.40 [NR] ~