hey did you run this script? Coz there is a syntax error in it.
Now run it and find out which stmt has syntax error J anoop *From:* Carol Pearson [mailto:[email protected]] *Sent:* Tuesday, February 2, 2016 10:12 AM *To:* [email protected] *Subject:* Basic Is-it-working? Test 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 ---------------------------------------------------------------
