Hi Trafodion Fans, I wrote a little one-minute acid test script to make sure that my Trafodion basic piece-parts are in working order before doing more complex testing. Whenever I do an installation or an sqstart after changing configuration, I run this script just to make sure that nothing is horribly broken. If I get errors, I know there's no point in going further because something basic went wrong.
------------------------------------------- -- -- Acid test script to make sure SQL has installed -- ------------------------------------------ create schema test_sandbox_schema; set schema test_sandbox_schema; create table t (c1 int not null, c2 int not null, primary key (c1)); insert into t values (1,1); insert into t values (2,3); insert into t values (3,2); begin work; insert into t values (4,5); insert into t values (5,2); commit work; insert into t values (7,3); select * from t order by c2; create index tix on t (c2); create view tview as select c1, c2 from t where c2 > 3; select * from tview where c2 < 3; select * from tview where c2 > 2; update statistics on t; explain select * from t order by c2; select * from t order by c2; drop view tview; drop table t; drop schema test_sandbox_schema; I put emphasis on sorting and indexes because of my long history with those (old habits die hard). And my goal is only basic success (no errors) and I don't mind repeating the same query multiple times and I do expect the same results.... I don't want a huge complex script and automated validation (those come next, depending on what I'm trying to do). Really, my goal is to get a fast warm fuzzy feeling that it's worth it for me to actually do real work. Anyone have suggestions on other things I might check as part of a simple, less than one-minute test? Is this (incredibly basic) script worth contributing to Trafodion? Thanks! -Carol P. --------------------------------------------------------------- Email: [email protected] Twitter: @CarolP222 ---------------------------------------------------------------
