Cego ChangeLog

	if ( _tableName == (Chain)pCO->getTabName() )
      

	if ( _tableName == (Chain)pCO->getTabName() || _tableName == (Chain)pCO->getTabAlias() )
      

      update t2 set a = ( select a from t2 where b = 'ZZZ' ) where a = 1000;
      

CGCLT > plan select shortdesc from sysmt_mtview where shortdesc like 'Oracle Patch';
+----------------------------------------------------------------------+
| PLAN                                                                 |
| DESCRIPTION                                                          |
+----------------------------------------------------------------------+
| Execution plan                                                       |
| ---------------                                                      |
| Joining view sysmt_mtview (sysmt_mtview)                             |
|   View plan for sysmt_mtview                                         |
|   ---------------------------                                        |
|   Joining table sysmt_project (prj) with Full table scan             |
|   Joining table sysmt_system (sys) with index trace on pid = prj.pid |
|   Joining table sysmt_mt (mt) with index trace on sysid = sys.sysid  |
+----------------------------------------------------------------------+
ok ( 0.012 s )

	if (pageNE.isFixed())
	_pTM->releaseDataPtrUnlocked(pageNE, true); // was false
      

      void CegoDbThread::unloadObjects(int tabSetId)
      {
         _pTabMng->getTransactionManager()->release(tabSetId); // added
         _pTabMng->removeAllComp(tabSetId);
      }
      

	select * from t1 where a = null;
      

insert into t1 values (1,'xx'), (2,'yy'), (3,'zz');
      

      CGCLT > delete from sysmt_mtlog where sysid in ( select sysid from sysmt_system where pid = 10031 );
      Error : list position exceeded
      Query failed
      ok ( 0.003 s )
      

      CegoSelect *pSelect = pPred->getSelectQuery();
      if ( pSelect )
      {
         pSelect->setParentJoinBuf(&jfl, 1);
      }
      pPred->analyzeSelect();
      

      maxlsn = writeCheckPoint(tableSet, true, false);
      

	if (  _pGTM->distObjectExists(_joinList[i]->getTabName(), 
	                              _joinList[i]->getTabSetId(),
	                              CegoObject::VIEW)
              ||
	      _pGTM->distIndexExists(_joinList[i]->getTabSetId(),
                                     _joinList[i]->getTabName(),
                                     pAC->getAttrName() ) )
      

      select a from t1 where b in ( select t2.d from t2 where t2.c = 2 );
      

      /* BufferPool lock timeout in msec */
      /* this was increased becasue for large bufferpool configurations, timeouts may 
         occur during checkpoint writes */
      #define BP_LOCKTIMEOUT 300000
      

CGADM > start tableset TS1;
+-----------+---------------------+-------------------------------+
| ADM       | ADM                 | ADM                           |
| ROLE      | HOSTNAME            | MSG                           |
+-----------+---------------------+-------------------------------+
| mediator  | dude.local          | Tableset TS1 must be in       |
|                                 | status offline to be started  |
+-----------+---------------------+-------------------------------+
ERROR : Admin action failed

      

alter table xxx add check c1 on length(b) < 10

	select * from t1, t1;
      

	select * from t1 ta, t1 tb;
      

      select sum( date2int(a) )  from t1;
      

      CegoFactor.cc(659) : Unknown attribute field <table.name> 
      
      

CGCLT > select count(*) from dab_mt where shortdesc like 'ACL564%' order by mtfrom;
Error : Orderspace not created, cannot insert tuple
Query failed
ok ( 0.007 s )

CGCLT > select month, count(*) from dab_mtmonth m where year = '2010' and m.pid in  
> ( select pid from dab_prj2bgrp where bgid in
> ( select bgid from dab_usr2bgrp u2g, dab_user u
> where u2g.uid = u.uid and u.dbuser = 'lemke' )) 
> group by month order by month;
+---------------------+---------------------+
|                   m |                AGGR |
|               month |            count(*) |
+---------------------+---------------------+
|                  01 |                  29 |
|                  02 |                  75 |
|                  03 |                  87 |
|                  04 |                  20 |
|                  05 |                  13 |
|                  06 |                  16 |
|                  07 |                  19 |
|                  08 |                  10 |
|                  09 |                  15 |
|                  10 |                  19 |
|                  11 |                  12 |
|                  12 |                  12 |
+---------------------+---------------------+
ok ( 7.349 s )
CGCLT > quit;
ok ( 0.000 s )
      

dude.local > ./dabclt 
CGCLT > select month, count(*) from dab_mtmonth m where year = '2010' and m.pid in 
> ( select pid from dab_prj2bgrp where bgid in  
> ( select bgid from dab_usr2bgrp u2g, dab_user u
> where u2g.uid = u.uid and u.dbuser = 'lemke' ))
> group by month order by month;
+---------------------+---------------------+
|                   m |                AGGR |
|               month |            count(*) |
+---------------------+---------------------+
|                  01 |                  29 |
|                  02 |                  75 |
|                  03 |                  87 |
|                  04 |                  20 |
|                  05 |                  13 |
|                  06 |                  16 |
|                  07 |                  19 |
|                  08 |                  10 |
|                  09 |                  15 |
|                  10 |                  19 |
|                  11 |                  12 |
|                  12 |                  12 |
+---------------------+---------------------+
ok ( 0.645 s )
      

	create table t1 ( primary a int not null, b int);
	insert into t1 ...
	insert into t1 ...
	select * from t1 where a != 12;
      

	select mid from dab_mtview 
	   where sid in ( select sid from dab_systemview where project = 'XXX' ) 
           and ( date2str(mtto, '%m') = '09' 
               or ( date2str(mtfrom, '%m') < '09' and date2str(mtfrom, '%Y') = '2009');
      

	Error : Unknown attribute field 
        Query failed
      

plan select a, ( select l from t6 where k = mv.e ) 
from myview2 mv, t4 
where mv.a = t4.g 
      and t4.h = 'beta' 
      and t4.g in ( select i from t5 where j = 'xxx');
      

+--------------------------------------------------------+
| PLAN                                                   |
| PLAN                                                   |
+--------------------------------------------------------+
| Execution plan                                         |
| ---------------                                        |
| Joining table t4 (t4_2) with index trace on h = 'beta' |
| Joining view myview2 (mv)                              |
|   View plan for mv                                     |
|   -----------------                                    |
|   Joining view myview1 (tx)                            |
|     View plan for tx                                   |
|     -----------------                                  |
|     Joining table t1 (tx) with index trace on a = null |
|     Joining table t2 (ty) with index trace on c = tx.a |
|   Joining table t3 (ty) with index trace on e = tx.a   |
| ##################                                     |
|  Execution subplan                                     |
|  ------------------                                    |
|  Joining table t6 (t6_1) with Full table scan          |
| ##################                                     |
|  Execution subplan                                     |
|  ------------------                                    |
|  Joining table t5 (t5_3) with index trace on j = 'xxx' |
+--------------------------------------------------------+
      

 
create view tv as select date2str(dt, '%Y') as year from t1;
select * from tv where year = '2009';
      

      select mid, date2str(mtfrom,'%d'), 
                  date2str(mtfrom,'%m'), 
                  date2str(mtto,'%d'),
                  date2str(mtto,'%m'), sid, shortdesc, status 
      from dab_mtview 
      where date2str(mtfrom, '%m') = '11' and date2str(mtfrom, '%Y') = '2009'
          or date2str(mtto, '%m') = '11' and date2str(mtto, '%Y') = '2009' 
          or date2str(mtfrom, '%m') < '11' and date2str(mtto, '%m') > '11' 
             and date2str(mtfrom, '%Y') = '2009' and date2str(mtto, '%Y') = '2009';      
      

	select a from t1 inner join t2 on b in ( select c from t3 ) left outer join t4 on d = 0;
      

      void CegoAction::selectGroupClause()
      {
         _groupClauseStack.Push(_pGroupList);
         _pGroupList = 0;
      }
      

	select statdate, sum(numhit) from webstats ws group by ws.statdate order by ws.statdate asc;
      

	putBlob
	getBlob
	delBlob
      

   _procList[tabSetId].Remove(*pProc);
    CegoProcedure *pDelProc = *pProc;
    delete pDelProc;
     

    CegoProcedure *pDelProc = *pProc;
    delete pDelProc;
    _procList[tabSetId].Remove(*pProc);
     

    ...
    if ( _pPred ) 
    {	
	_pPred->analyzeSelect();
    }
    ...
    

    QueryPredicate		:	Expr INTOK LB SelectStatement RB 
    QueryPredicate		:	Expr NOT INTOK LB SelectStatement RB 
    QueryPredicate		:	Expr Comparison Expr
    QueryPredicate		:	Attribute IS NULLTOKEN
    QueryPredicate		:	Attribute IS NOT NULLTOKEN
    QueryPredicate		:	Expr LIKE STRINGVAL
    QueryPredicate		:	Expr NOT LIKE STRINGVAL
    

    ...
    CegoNetHandler **pRequest = _requestQueue.First();
    if ( pRequest )
    {
	_requestQueue.Remove(*pRequest);
	CegoNetHandler *pN = *pRequest;
	unlockQueue();
	return pN; 
    }
    ...
    

    ...
    CegoNetHandler **pRequest = _requestQueue.First();
    if ( pRequest )
    {
	CegoNetHandler *pN = *pRequest;
	_requestQueue.Remove(*pRequest);
        unlockQueue();
	return pN; 
    }
    ...
    

CEGOCLT > plan select * from t1 , t2 where t1.a=42 and t1.a = t2.a;
Execution Plan :
   Joining t1(t1_1) IndexCondition -> a = 42
   Joining t2(t2_2) IndexCondition -> a = t1_1.a

ok ( 0.003 s )

Bug-Notice to the bug from 15.06.2006 :

The issue has been fixes in the meantime. The problem was located in the nextRequest-method of the CegoXThreadPool classes. Code changed from

    ...
    P(); 
    CegoNetHandler **pRequest = _requestQueue.First();
    if ( pRequest )
    {
	_requestQueue.Remove(*pRequest);
	V();
	return *pRequest; 
    }
    ...
    

    ...
    P(); 
    CegoNetHandler **pRequest = _requestQueue.First();
    if ( pRequest )
    {
	_requestQueue.Remove(*pRequest);
	CegoNetHandler *pN = *pRequest;
	V();

	return pN; 
    }
    ...