Changes - j0ke.net Open Build Service

Changes of Revision 25

[-] [+]	Changed	cego.changes
@@ -1,4 +1,9 @@ ------------------------------------------------------------------- +Sun Apr 8 09:40:30 UTC 2012 - cs@linux-administrator.com + +- Update to version 2.12.6 + +------------------------------------------------------------------- Thu Apr 5 16:59:42 UTC 2012 - cs@linux-administrator.com - Update to version 2.12.5
[-] [+]	Changed	cego.spec ^
@@ -1,5 +1,5 @@ Name: cego -Version: 2.12.5 +Version: 2.12.6 Release: 1 Group: Productivity/Databases Summary: Cego relational database
[-] [+]	Changed	cego-2.12.6.tar.bz2/README ^
@@ -4,7 +4,7 @@ ---- A relational and transactional database system - Version 2.12.5 + Version 2.12.6 (C)opyright 2006,2007,2008,2009,2010,2011,2012 by Bjoern Lemke
[-] [+]	Changed	cego-2.12.6.tar.bz2/samples/chkdb/check010.sql ^
@@ -27,6 +27,8 @@ select distinct category, sname from supplier; select distinct category, sname from supplier order by sname ; select category, sname from supplier order by sname ; + +select count( distinct category ) from supplier; drop table supplier;
[-] [+]	Changed	cego-2.12.6.tar.bz2/samples/chkdb/check031.sql ^
@@ -5,7 +5,9 @@ -- drop if exists table t1; +drop if exists table t2; create table t1 ( a int, b string(30)); +create table t2 ( a int, acopy int, bcopy string(30), c string(10)); drop if exists counter aid; create counter aid; @@ -23,21 +25,37 @@ end; @ + +drop if exists procedure copyTab; +@ +create procedure copyTab () return int +begin + var a int; + :a = nextcount(aid); + insert into t2 select :a, a, b, 'COPY' from t1; + return :a; +end; +@ + drop if exists procedure cleanEntry; @ create procedure cleanEntry () begin delete from t1; + delete from t2; setcount(aid, 0); end; @ - call newEntry('Erwin'); call newEntry('Matha'); call newEntry('Hugo'); +call copyTab(); +call copyTab(); select * from t1; +select * from t2; + call cleanEntry(); @@ -47,4 +65,5 @@ select * from t1; show procedure newEntry; +show procedure copyTab; show procedure cleanEntry;
[-] [+]	Added	cego-2.12.6.tar.bz2/samples/chkdb/check032.sql ^
@@ -0,0 +1,101 @@ +-- +-- ### Advanced Selection checks +-- +-- +-- + +drop if exists table sysmt_user; +create table sysmt_user(uid int not null, + dbuser string(20), + username string(20), + userdesc string(1000), + userright string(10), + usermail string(100)); + + +drop if exists table sysmt_system; +create table sysmt_system(sysid int not null, + sid string(20), + category string(10), + sysdesc string(1000), + pid int, + systype string(10), + mtinfo string(300), + platform string(10), + status string(10), + saptype string(10), + vip string(20), + sysnr string(10), + scs string(10), + javaport string(10), + smdid string(10), + zoneA string(20), + zoneB string(20), + partA string(20), + partB string(20), + partC string(20), + partD string(20), + restartzones string(100), + created datetime default sysdate, + dbtype string(10), + arch string(10), + nfsvip string(30), + vipip string(20), + vipif string(20), + dbversion string(20), + sharedfs string(300), + parthalog string(300), + slaid int, + sapversion string(20), + sdbtype string(10), + dbvip string(20), + dbvA string(20), + dbvB string(20)); + +-- project +drop if exists table sysmt_project; +create table sysmt_project(pid int not null, + prjname string(100), + prjdesc string(1000), + prjmail string(100)); + +-- project 2 group +drop if exists table sysmt_prj2bgrp; +create table sysmt_prj2bgrp(pid int not null, + bgid int not null); + +-- user 2 group +drop if exists table sysmt_usr2bgrp; +create table sysmt_usr2bgrp(uid int not null, + bgid int not null); + + +insert into sysmt_user ( uid, dbuser, username ) values ( 100, 'hugo', 'Hugo Habicht'); +insert into sysmt_system ( sysid, sid, pid, sdbtype ) values ( 100, 'ABC', 100, 'NOSDB'); +insert into sysmt_system ( sysid, sid, pid, sdbtype ) values ( 101, 'XYZ', 100, 'NOSDB'); +insert into sysmt_system ( sysid, sid, pid, sdbtype ) values ( 102, 'WWW', 100, 'NOSDB'); +insert into sysmt_project ( pid, prjname ) values ( 100, 'X-Project'); +insert into sysmt_prj2bgrp values ( 100, 100 ); +insert into sysmt_usr2bgrp values ( 100, 100 ); + +drop if exists view sysmt_usrview; +create view sysmt_usrview as +select + u.uid as uid, + u.dbuser as dbuser, + u.username as username, + u.userright as userright, + (select count( distinct s.sid) from + sysmt_system s, + sysmt_prj2bgrp p2g, + sysmt_usr2bgrp u2g + where ( ( p2g.pid = s.pid and u2g.bgid = p2g.bgid ) and u2g.uid = u.uid ) order by s.sid) as numsys, + (select count( distinct p.pid) from + sysmt_project p, + sysmt_prj2bgrp p2g, + sysmt_usr2bgrp u2g + where ( ( p2g.pid = p.pid and u2g.bgid = p2g.bgid ) and u2g.uid = u.uid ) order by p.pid) as numprj +from + sysmt_user u; + +select * from sysmt_usrview;
[-] [+]	Added	cego-2.12.6.tar.bz2/samples/chkdb/check033.sql ^
@@ -0,0 +1,29 @@ +-- +-- ### Row Limit Checks +-- +-- +-- + +drop if exists table t1; +create table t1 ( a int, b string(30)); + +insert into t1 values ( 1, 'xxx'); +insert into t1 values ( 2, 'yyy'); +insert into t1 values ( 3, 'zzz'); +insert into t1 values ( 4, 'zzz'); +insert into t1 values ( 5, 'zzz'); +insert into t1 values ( 6, 'zzz'); +insert into t1 values ( 7, 'zzz'); +insert into t1 values ( 8, 'zzz'); +insert into t1 values ( 9, 'zzz'); +insert into t1 values ( 10, 'zzz'); +insert into t1 values ( 11, 'zzz'); +insert into t1 values ( 12, 'zzz'); +insert into t1 values ( 13, 'zzz'); +insert into t1 values ( 14, 'zzz'); + +select a from t1 rowlimit 10; + +drop table t1; + +
[-] [+]	Added	cego-2.12.6.tar.bz2/samples/chkdb/check034.sql ^
@@ -0,0 +1,13 @@ +-- +-- ### System Table Checks +-- +-- +-- + +select * from $table; +select * from $index; +select * from $procedure; +select * from $view; +select * from $key; + +
[-] [+]	Changed	cego-2.12.6.tar.bz2/samples/chkdb/db/chkdb.xml ^
@@ -4,10 +4,12 @@ <USER NAME="cgadm" PASSWD="f9d1bb5de113b12009fd4b1672a23cfe" TRACE="OFF" ROLE="admin"></USER> <ROLE NAME="ALL"> <PERM TABLESET="TS1" FILTER="ALL" PERM="ALL" PERMID="TS1_P"></PERM> </ROLE> - <TABLESET NAME="TS1" TSROOT="./db" PRIMARY="dude.local" SECONDARY="dude.local" MEDIATOR="dude.local" RUNSTATE="OFFLINE" SYNCSTATE="SYNCHED" TSTICKET="./db/TS1ticket.xml" TSID="2" TMPFID="31" SYSSIZE="100" TMPSIZE="300" SORTAREASIZE="10000000" LSN="1"> <LOGFILE NAME="./db/TS1redo0.log" SIZE="1000000" STATUS="FREE"></LOGFILE> - <LOGFILE NAME="./db/TS1redo1.log" SIZE="1000000" STATUS="ACTIVE"></LOGFILE> - <LOGFILE NAME="./db/TS1redo2.log" SIZE="1000000" STATUS="FREE"></LOGFILE> + <TABLESET NAME="TS1" TSROOT="./db" PRIMARY="dude.local" SECONDARY="dude.local" MEDIATOR="dude.local" RUNSTATE="OFFLINE" SYNCSTATE="SYNCHED" TSTICKET="./db/TS1ticket.xml" TSID="2" TMPFID="31" SYSSIZE="100" TMPSIZE="300" SORTAREASIZE="10000000" LSN="3280" TID="417"> <LOGFILE NAME="./db/TS1redo0.log" SIZE="1000000" STATUS="FREE"></LOGFILE> + <LOGFILE NAME="./db/TS1redo1.log" SIZE="1000000" STATUS="FREE"></LOGFILE> + <LOGFILE NAME="./db/TS1redo2.log" SIZE="1000000" STATUS="ACTIVE"></LOGFILE> <DATAFILE TYPE="APP" FILEID="32" NAME="./db/TS1data01.dbf" SIZE="2000"></DATAFILE> + <COUNTER NAME="accid" VALUE="10001"></COUNTER> + <COUNTER NAME="aid" VALUE="1"></COUNTER> </TABLESET> <USER NAME="lemke" PASSWD="20eb196673144f5c299ef3d0d7a58bd9" TRACE="OFF" ROLE="ALL"></USER> <NODE HOSTNAME="dude.local" STATUS="ONLINE"></NODE>
[-] [+]	Changed	cego-2.12.6.tar.bz2/src/CegoDefs.h ^
@@ -40,7 +40,7 @@ #endif #define CEGO_PRODUCT "Cego" -#define CEGO_VERSION "2.12.5" +#define CEGO_VERSION "2.12.6" #define CEGO_COPYRIGHT "Copyright (C) 2000-2012 by Bjoern Lemke. All rights reserved" /*******************************/
[-] [+]	Changed	cego-2.12.6.tar.bz2/src/CegoProcedure.cc ^
@@ -102,6 +102,11 @@ { CegoExpr *pExpr = expList.First(); CegoProcVar pVar = _pBlock->getVarList().First(); + + // we just treat the in out param values at the beginning of the param list in the block + if ( pVar ) + if ( pVar->getVarType() == CegoProcVar::BLOCKVAR ) + pVar = 0; int pos=1; while ( pExpr && pVar) @@ -133,7 +138,7 @@ pExpr = expList.Next(); pVar = _pBlock->getVarList().Next(); - // we just treat the in out out param values at the beginning of the param list in the block + // we just treat the in out param values at the beginning of the param list in the block if ( pVar ) if ( pVar->getVarType() == CegoProcVar::BLOCKVAR ) pVar = 0;
[-] [+]	Changed	cego-2.12.6.tar.bz2/src/CegoQuery.cc ^
@@ -478,7 +478,7 @@ int tabSetId = _pGTM->getDBMng()->getTabSetId(_tableSet); - _pSelect->setProcBlock(0); + _pSelect->setProcBlock(pBlock); _pSelect->setTabSetId(tabSetId); _pSelect->prepare(); // _pSelect->getSchema(schema);