Shoot, now I'm gonna have to go check whether I cut and pasted the right one... The one I used most recently didn't have any syntax errors in it....
-Carol P. --------------------------------------------------------------- Email: [email protected] Twitter: @CarolP222 --------------------------------------------------------------- On Tue, Feb 2, 2016 at 10:13 AM, Anoop Sharma <[email protected]> wrote: > 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 > > --------------------------------------------------------------- >
