FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us

We also have a status page:

non port: databases/cego/distinfo

Number of commits found: 202 (showing only 100 on this page)

1 | 2 | 3  »  

Sun, 19 Nov 2017
[ 09:33 pi ] Original commit   Revision:454483
454483 databases/cego/Makefile
454483 databases/cego/distinfo
databases/cego: update 2.38.0 -> 2.38.1

- Fix in CegoPredDesc::decode, loop variable i for IN/NOTIN case
  was not initialized
- Fix in CegoAction::execCheckCreate, check contraints are checked
  for contained subselects. subselects are ( still ) not supported
  since the CegoCheckOject::decode method can not provide a valid
  tablemanager instance ( it is called from CegoObjectManager )

Submitted by:	Bjoern Lemke <>
Sat, 18 Nov 2017
[ 08:34 pi ] Original commit   Revision:454415
454415 databases/cego/Makefile
454415 databases/cego/distinfo
454415 databases/cegobridge/Makefile
454415 databases/cegobridge/distinfo
databases/cego: update 2.37.3 -> 2.38.0
databases/cegobridge: update 1.2.1 -> 1.3.0

- Fix in CegoSelect::clone, pUnionSelect was not cloned, which might
  lead to seg faults
- Introduced predicate clause for select .. in ( expr, expr, ... ),
  e.g. select * from t1 where a in ( 1, 2, 3 ); This was still not
  implemented but is part of standard SQL.

- Adaptions made for modified cego-2.38.0 API with extended
  CegoDatabaseFormatter::formatPred method ( exprList was added for
  new introduced select in ( expr list ) predicate )

Submitted by:	Bjoern Lemke <>
Wed, 15 Nov 2017
[ 12:32 pi ] Original commit   Revision:454234
454234 databases/cego/Makefile
454234 databases/cego/distinfo
databases/cego: update 2.37.1 -> 2.37.3

- Fix in CegoClient, the new comment logic by using Tokenizer does
  not work ( '-' characters are detected as comment tokens ). Code
  replaced by using posStr chain function
- Adaption in CegoMain to also parse comment lines in a more
  sophisticated way ( same as in CegoMain ), just relevant for server
  batch mode
- Optimization in CegoDistCuror::joinSetup, the join predicate is
  now analysed in a way, that a condition list is created ( via makeCNF
  and createCondition methods in CegoQueryHelper ). The condition
  list then is analysed to achieve a better cursor condition which
  results in improved index usage

Submitted by:	Bjoern Lemke <>
Fri, 10 Nov 2017
[ 19:09 pi ] Original commit   Revision:453921
453921 databases/cego/Makefile
453921 databases/cego/distinfo
453921 databases/cegobridge/Makefile
453921 databases/cegobridge/distinfo
453921 devel/lfcbase/Makefile
453921 devel/lfcbase/distinfo
453921 devel/lfcxml/Makefile
453921 devel/lfcxml/distinfo
devel/lfcbase: update 1.11.0 -> 1.11.1
devel/lfcxml: update 1.2.5 -> 1.2.6
databases/cego: update 2.37.0 -> 2.37.1
databases/cegobridge: update 1.2.0 -> 1.2.1

- New generated configure script with libtool-2.4.6

Submitted by:	Bjoern Lemke <>
Wed, 8 Nov 2017
[ 10:23 pi ] Original commit   Revision:453728
453728 databases/cego/Makefile
453728 databases/cego/distinfo
453728 databases/cegobridge/Makefile
453728 databases/cegobridge/distinfo
453728 databases/p5-DBD-cego/Makefile
453728 databases/p5-DBD-cego/distinfo
453728 devel/lfcbase/Makefile
453728 devel/lfcbase/distinfo
devel/lfcbase: update 1.10.3 -> 1.11.0
databases/cego: update 2.36.4 -> 2.37.0
databases/p5-DBD-cego: update 1.3.0 -> 1.4.0
databases/cegobridge: update 1.1.6 -> 1.2.0

- Layout improvements in Pager class
- Changed constructor for Net and NetHandler class to setup maxSendLen.
  Since this changes the API, minor release level has been increased

- Improvements for cgblow simulation mode added
- Improvements for cgclt, added pipe mode to read input from stdin
  Now comments are allowed also after delimiter token, e.g.
  create table t1(a int); -- a sample table
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Wed, 1 Nov 2017
[ 17:42 pi ] Original commit   Revision:453310
453310 databases/cego/Makefile
453310 databases/cego/distinfo
453310 databases/cegobridge/Makefile
453310 databases/cegobridge/distinfo
453310 devel/lfcbase/Makefile
453310 devel/lfcbase/distinfo
devel/lfcbase: update 1.10.1 -> 1.10.2
databases/cego: update 2.36.3 -> 2.36.4
databases/cegobridge: update 1.1.5 -> 1.1.6

- Fix in CegoSelect::nextTuple, before adding an entry to the query
  cache, it has to be checked, if any tables from foreign tableset
  are referenced in the query. If so, no cache entry is made, since
  table changes for foreign tables are not detected.
- Improved error messages for invalid database objects
- Decreased shutdown delay time by reducing net delays for all
  thread pools and optimized mediator thread wait procedure
- Completely removed the nologging option for import actions.
  Logging is disabled in any case now.
- Optimization added for log handling. During ( xml ) import,
  logging is completely deactivated, after import is completed,
  log is started again and a checkpoint is written.
  Since import can be repeated in case of a system during import,
  nothing gets lost. Deactivating logging increases import speed and
  avoids side effects

- Speed up imports by changing the way the parser reads the input

Submitted by:	Bjoern Lemke <>
[ 06:44 pi ] Original commit   Revision:453262
453262 databases/cego/Makefile
453262 databases/cego/distinfo
databases/cego: update 2.36.2 -> 2.36.3

- Changed recovery strategy for existing btree / avl index objects.
  Before creating an index object, it is checked if exists. If exists,
  it is dropped and recreated. This seems to be a more stable strategy,
  since it may occur, that index objects still exist for several

Submitted by:	Bjoern Lemke <>
Mon, 30 Oct 2017
[ 19:36 pi ] Original commit   Revision:453209
453209 databases/cego/Makefile
453209 databases/cego/distinfo
databases/cego: update 2.36.1 -> 2.36.2

- Fix in CegoFactor::setFieldListArray, the _flaCached variable has
  to be set to false, if _pFLA is set to a different value. Otherwise,
  we might refer to invalid memory, which results in core dump

Submitted by:	Bjoern Lemke <>
Sun, 29 Oct 2017
[ 10:42 pi ] Original commit   Revision:453106
453106 databases/cego/Makefile
453106 databases/cego/distinfo
databases/cego: update 2.36.0 -> 2.36.1

- Added signal handler to CegoAdmAction. Now, ( long ) running
  tableset export and import requests can be aborted in a controlled
  way via Ctrl-C command.
- Fix in CegoXPorter, export file will be removed, if any exception
  occurs. So it is ensured, that the written export file is consistent
  and complete
- fixes in CegoXPorter for CLOB handling ( was not checked for plain exports )

Submitted by:	Bjoern Lemke <>
Sat, 30 Sep 2017
[ 06:17 pi ] Original commit   Revision:450945
450945 databases/cego/Makefile
450945 databases/cego/distinfo
databases/cego: 2.35.10 -> 2.36.0

- Completed pointer cleanup in CegoQueryHelper::evalPredicate, added
  check061 to check pointer cleanup
- Fix in CegoTableManager::createBTree, pC object cursor has to be
  set to 0, otherwise in case of abortion a seg fault occurs
- Changed default value for btree cache enabling to false
- Improvement in CegoBufferPool::calcSegment for segid calculation.
  It has been recognized, that with the current calculation
  ( pageid % numsegment ) not all slots can be reached for
  special buffer pool configurations.
  The formula has been changed ( to ( pageid / numpages ) % numsegment )
- Adding missing export / import messages to CegoXPorter
- Changed btree cache enabling syntax. Instead of a dedicated switch
  command ( set btree cache on / off ), the cache option now is
  directly given with the create btree command ( e.g. create btree
  b1 on t1(a) cached )

Submitted by:	Bjoern Lemke <>
Sun, 17 Sep 2017
[ 18:23 pi ] Original commit   Revision:450018
450018 databases/cego/Makefile
450018 databases/cego/distinfo
databases/cego: update 2.35.8 -> 2.35.10

- Fix in CegoBufferpool::writeCheckpoint, in case of an locking
  exception ( lockBufferPool ), the pool must be released in any case.
  For this the CegoLockManager::lockBufferPool and
  CegoLockManager::unlockBufferPool have been modified in a way,
  that lockBufferPool saves the current sema index ( _poolRangeLock )
  which is later used for the unlocking call.
- Timeout parameter for bufferpool lock reduced to 60 seconds.
- Optimization in CegoBufferPool:bufferfix for minHashId calculation
  in step 2, there was an unneeded locking operation for the
  minhashId, which was already locked by the main loop
- Small format fix in CegoProcCreateStmt ( missing indent )
- Add header row out put for client raw mode ( attribute names )
- Fix in CegoQueryHelper::evalPredicate, for all predicate types,
  the field array value has to be reset to 0, otherwise seg fault my
  occur since invalid references might be used

Submitted by:	Bjoern Lemke <>
Sat, 9 Sep 2017
[ 20:38 pi ] Original commit   Revision:449509
449509 databases/cego/Makefile
449509 databases/cego/distinfo
databases/cego: update 2.35.4 -> 2.35.8

- Fix in CegoQueryHelper::aggregateTuple, in case of min-Aggregation,
  wrong results may occur, if null values have to be treated. Since
  null value handling is now treated inside CegoFieldValue, some code
  here was obsolete.
- Fix in CegoPredDesc for INSUB and NOTINSUB constructor + clone
  method. There was a confusing with the isNegated flag which has
  been corrected ( also in using class CegoAction ) The wrong negation
  might lead to wrong query result for views using subselect with in
  or not in subselects
- Bug fix in CegoDistCursor::getTuple, for the LEFTOUTER case and
  moreRight conditions, the right table cursor was called double time
  ( native and with nextRight ). The native call has to be removed
  since this may lead to strange effects actually just observed for
  mingw compiles

Submitted by:	Bjoern Lemke <>
Sun, 3 Sep 2017
[ 09:44 pi ] Original commit   Revision:449192
449192 databases/cego/Makefile
449192 databases/cego/distinfo
databases/cego: update 2.35.3 -> 2.35.4

- Added tuple information command tupleinfo to indicate
  tuple state information for a given table
- Fix in CegoTransactionManager::commitTransaction and
  CegoTransactionManager::rollbackTransaction, in case of a crash recovery
  the taList does not contain any transaction entries, but the rollback
  segments have to be checked in any case for entries to process. Otherwise,
  the transaction will not be completed

Submitted by:	Bjoern Lemke <>
Sat, 2 Sep 2017
[ 10:08 pi ] Original commit   Revision:449117
449117 databases/cego/Makefile
449117 databases/cego/distinfo
449117 devel/lfcxml/Makefile
449117 devel/lfcxml/distinfo
devel/lfcxml: update 1.2.4 -> 1.2.5
databases/cego: update 2.35.2 -> 2.35.3

- Small improvement in XMLSuite::nextChar to check for non-ASCII characters

- Fix in CegoTableManager::finishOpenTransaction, the transaction id for
  the corresponding tableset must be set to zero, otherwise in case of crash
  recovery procedures a transaction id might be active and the open
  transactions are not completed correctly

Submitted by:	Bjoern Lemke <>
Fri, 25 Aug 2017
[ 19:50 pi ] Original commit   Revision:448737
448737 databases/cego/Makefile
448737 databases/cego/distinfo
databases/cego: update 2.35.1 -> 2.35.2

- Fix for a bad patch
  In CegoSelect::clone also the pCache variable has to be copied
  ( was previously done by calling setTabSetId )

Submitted by:	Bjoern Lemke <>
Thu, 24 Aug 2017
[ 17:20 pi ] Original commit   Revision:448698
448698 databases/cego/Makefile
448698 databases/cego/distinfo
databases/cego: update 2.35.0 -> 2.35.1

- Fix in CegoSelect::setProcBlock, pBlock was not setup for _pPred
  This might result in wrong query results within stored procedures
  with select statements which refer to procedure variables
- Changed index recovery handling in a way, that index and btree
  objects are rebuild immediately instead of invalidating them. This
  leads to a much better recovery performance in case of expensive
  queries where index use is needed for fast evaluation

Submitted by:	Bjoern Lemke <>
Wed, 23 Aug 2017
[ 14:32 pi ] Original commit   Revision:448624
448624 databases/cego/Makefile
448624 databases/cego/distinfo
databases/cego: update 2.34.0 -> 2.35.0

- Fix in CegoDistManager::checkKey ( used for verify tableset admin
  commend ). Check for foreign key has been redesigned
- Fix in CegoBTreeCursor::getFirst, _pAttrCond has to be checked
  for 0, otherwise a core dump may occur ( detected with verify
  tableset admin command )
- In CegoViewObject::toChain() the view object reference string has
  to return complete information including the tableset. Otherwise,
  references to foreign tableset objects with the view will not work
- Fix in CegoDistCursor to support multiple view references in a
  query ( e.g. select a from v1 where exists select * from v1 ... )
  In the past, this might lead to infinite loops, since just the view
  select reference was used. Now the reference is cloned.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sat, 12 Aug 2017
[ 12:21 pi ] Original commit   Revision:447824
447824 databases/cego/Makefile
447824 databases/cego/distinfo
447824 devel/lfcbase/Makefile
447824 devel/lfcbase/distinfo
devel/lfcbase: update 1.9.7 -> 1.10.0
databases/cego: update 2.33.22 -> 2.34.0

- Adoptions made in CommandExecuter and Outstream for MINGW builds
- Added Datetime advanced constructor for more efficient datetime construction

- Small fix in CegoAttrCond::operator = , compare Find result
  with 0 instead of false. A compile error occured for MINGW compiles
- Use of new introduced lfcbase datetime constructor to create
  datetime values with numeric input ( year, month, day, hour, minute
  and second ) for more efficient value handling
- Fix in CegoTypeConverter::getTypeLen for LONG_TYPE values, it
  should be size of(long long) instead of sizeof(long). This impacts
  MINGW compiles, since sizeof(long) ist just 4 bytes
- Changed CegoTypeConverter methods to static
- Introduced new date function newdate with optional numeric input.
  If used with year and month input, this can double the speed for
  date construction ( no string parsing required )

Submitted by:	Bjoern Lemke <>
Sat, 5 Aug 2017
[ 12:12 pi ] Original commit   Revision:447401
447401 databases/cego/Makefile
447401 databases/cego/distinfo
databases/cego: update 2.33.21 -> 2.33.22

- More fixes in CegoTableManager::keyReferenceExists and
  CegoTableManager::createForeignKey, there still were missing some
  adpotions for TableCursor::setup return code and other case handling

Submitted by:	Bjoern Lemke <>
Sat, 29 Jul 2017
[ 07:01 pi ] Original commit   Revision:446869
446869 databases/cego/Makefile
446869 databases/cego/distinfo
databases/cego: update 2.33.20 -> 2.33.21

- Added further constraint check in CegoTableManager::dropObjectSynced.
  Primary objects just allowed to be removed, if no foreign key
  reference exists
- More fixes on foreign key contraint handling in
  CegoTableManager::checkKeyIntegrity and CegoTableManager::insertDataTable
- Fix in CegoTableManager::checkKeyIntegrity. The implementation
  of the mehod has been completly reworked, since not all violation
  cases have been treated.

Submitted by:	Bjoern Lemke <>
Sat, 22 Jul 2017
[ 08:34 pi ] Original commit   Revision:446373
446373 databases/cego/Makefile
446373 databases/cego/distinfo
databases/cego: update 2.33.19 -> 2.33.20

Fix in CegoDistCursor to support advanced left and right outer
join queries of the form

SELECT tx.a AS xa, ty.a AS ya FROM t1 tx
LEFT OUTER JOIN t2 ty ON tx.a = ty.a + 1;

For this, the evaluation of the predicate has to be done in a
different way to get complete row set

Submitted by:	Bjoern Lemke <>
Sun, 16 Jul 2017
[ 13:47 pi ] Original commit   Revision:446004
446004 databases/cego/Makefile
446004 databases/cego/distinfo
databases/cego: update 2.33.18 -> 2.33.19

- Fix in CegoOrderSpace::insertTuple, for the localTuple variable,
  also a dedicated copy has to be allocated, otherwise it may happen
  that invalid tuple references ( caused be page relocation ) lead
  to invalid order results
- Added performance optimization to CegoTableManager::updateTuple.
  The already evaluated index, key and checklist are also provided
  to checkIntegrity method now ( instead of retrieving the lists again).
  The improves performance for updates with many tuples significantly

Submitted by:	Bjoern Lemke <>
Fri, 14 Jul 2017
[ 06:22 pi ] Original commit   Revision:445730
445730 databases/cego/Makefile
445730 databases/cego/distinfo
databases/cego: update 2.33.16 -> 2.33.18

- Method cleanup in, also some irrelevant case is
  treated for grouping clauses in combination with distinct operator
- Added tablemanager parameter to CegoProcWhileStmt to catch query
  abort. In case of infinite while loops, this enables the db admin
  to abort procedure execution
- Optimization for CegoFunction::SETCOUNT procedure implementation
  added. Now this is an atomic operation, instead of calling
- For this, also the CegoXMLSpace::setCounterValue method has been
  changed to return the current counter value return the current
  counter value

Submitted by:	Bjoern Lemke <>
Thu, 29 Jun 2017
[ 05:38 pi ] Original commit   Revision:444621
444621 databases/cego/Makefile
444621 databases/cego/distinfo
databases/cego: update 2.33.14 -> 2.33.16

- Completion for admin help backup section, some commands were still missing
  Improvements for procedure indent formatting. All sugar, nothing functional
- Fix in CegoAction::execute, missing break added after calling execListView
- Fix in CegoQueryHelper::evalPredicate. In case of subselects, the
  parent join buf also has to reset after performing the subselect,
  otherwise invalid pointer references are still active for the next
- Seg faults have been experienced for delete with double nested
  subselect conditions ( see check055 )

Submitted by:	Bjoern Lemke <>
Sat, 3 Jun 2017
[ 18:48 pi ] Original commit   Revision:442514
442514 databases/cego/Makefile
442514 databases/cego/distinfo
databases/cego: 2.33.12 -> 2.33.14

- Design modification in CegoAction for semantic action ( execXXX methods )
  An analysed statement is now just executed after complete succesful
  parsing of the given input. This avoid protocol effects for queries
  like "select * from t1;;" where the query is executed but the
  second semicolon is detected as an parse error which also is sent
  to the client.
  For this the new method CegoAction::execute has introduced which
  is ( explicitly ) called after successful CegoAction::parse
- Fix for distinct handling in CegoAggreation
  Fix for alias handling regarding view creates. Alias definitions
  are mandatory now for aggregated attribute definitions, e.g.
  create view v1 as select count(*) from t1;
  => returns now
  ERROR: Missing alias reference for view create
  and must be written as
  create view v1 as select count(*) as c from t1;

Submitted by:	Bjoern Lemke <>
Sat, 27 May 2017
[ 07:39 pi ] Original commit   Revision:441829
441829 databases/cego/Makefile
441829 databases/cego/distinfo
databases/cego: update 2.33.11 -> 2.33.12

- Fix in CegoAttrComp::reset, case VALUE2VALUE still was not treated,
  which lead to wrong index handling for between clauses with native values

Submitted by:	Bjoern Lemke <>
Thu, 25 May 2017
[ 20:03 pi ] Original commit   Revision:441713
441713 databases/cego/Makefile
441713 databases/cego/distinfo
databases/cego: update 2.33.9 -> 2.33.11

- Fix in CegoObjectManager::createBTreeObject to avoid some duplicate btree
- Added space character in CegoSelect::toChain after distinct keyword
  to avoid certain errors
- Fix in CegoAttrComp::operator== The values should NOT be compared,
  since they are set up by the calling CegoAttrCond::update method
  Otherwise, the error "Cannot set up diff for attribute condition"
  basecheck54 added to test for the this problem
- Fix in CegoQueryHelper::evalAttrCond, comparison modulation was
  missing for one case whihc leads to wrong query results for comparisons
  like 3 < a ( constant left )
- Optimization added for between clause, indexes were just used for
  constant values in between clause ( eg. a between 10 and 20 )
  This has been expanded, that also indexes are used, if attribute
  references are contained ( eg. a between t2.x and t3.y )

Submitted by:	Bjoern Lemke <>
Sun, 7 May 2017
[ 11:50 pi ] Original commit   Revision:440333
440333 databases/cego/Makefile
440333 databases/cego/distinfo
databases/cego: update 2.33.8 -> 2.33.9

- in CegoTableManager::getClobData added termination character to
  ensure clob values are terminated with 0 character
- Small fixes for fixed value handling
- Small fixes for quote escape handling in cgclt batch mode
- In CegoAction::selectionList1 added alias check for non unique
  alias definitions
- Stored Procedure formatting improvements regarding indent handling

Submitted by:	Bjoern Lemke <>
Sat, 22 Apr 2017
[ 15:29 pi ] Original commit   Revision:439178
439178 databases/cego/Makefile
439178 databases/cego/distinfo
databases/cego: update 2.33.6 -> 2.33.8

- Fix in CegoSelect::buildJoinConditions, the _attrPred array has
  to be set up. Otherwise it may occur, that the predicate is not
  evaluated, if it could not been evaluated by the table curser
- Furthermore, a setup method has been introduced for CegoAttrCond
  to evalute joinBuf and parentJoinBuf ( if both references occur in
  a condition this is needed )
- Optimization in CegoCheckpoint::checkpointReached, if interval
  was reduced, we set up the new interval
- Fix in CegoTableManager::removeAllComp, first we have to remove
  from the list, the we can free the memory. On Linux system with
  g++, the previous sequence might lead to memory faults
- Fix in CegoRecoveryManager::recoverTableSet, after regDataFiles,
  als registerObjects method must be called, otherwise recovery could
  fail in case of table view recoveries
- Optimization in CegoDistManager::stopDistTableSet, the new
  introduced method CegoDatabaseManager::removeAllObjects is called,
  the ensure object cache cleaning
- Added prompt command line option to cgadm to set up specific prompt value
- Adding formating improvements to CegoAdminHandler for show logmng
  and show backupmng commands

Submitted by:	Bjoern Lemke <>
Fri, 14 Apr 2017
[ 14:30 pi ] Original commit   Revision:438516
438516 databases/cego/Makefile
438516 databases/cego/distinfo
438516 devel/lfcbase/Makefile
438516 devel/lfcbase/distinfo
devel/lfcbase: update 1.9.3 -> 1.9.6
databases/cego: update 2.33.5 -> 2.33.6

- Small correction in OutStream, include required by FreeBSD
  ( for definition of WEXISTATUS )
- Added method getErrorCode to OutStream class
- Cleanup of OutStream implementation ( removed some includes,
  removed ifdef for MINGW)

- Small improvements for utility scripts cgmkdb, logManager and backupManager

Submitted by:	Bjoern Lemke <>
Fri, 7 Apr 2017
[ 19:56 pi ] Original commit   Revision:437955
437955 databases/cego/Makefile
437955 databases/cego/distinfo
databases/cego: update 2.33.4 -> 2.33.5

- Fix in CegoSelect and friends for query cleanup. The cleanUp
  method did not cleanup all field value references which might lead
  to invalid memory access in case of repeated view calls ( Variable
  pParentJoinBuf ).
  Corresponding cleanUp method have been introduced or CegoExpr,
  CegoTerm, CegoFactor and friends.
- Check052 has been introduced to verify the previous described behaviour

Submitted by:	Bjoern Lemke <>
Sun, 2 Apr 2017
[ 08:01 pi ] Original commit   Revision:437530
437530 databases/cego/Makefile
437530 databases/cego/distinfo
databases/cego: update 2.33.3 -> 2.33.4

- Fix in CegoTableManager::insertDataTable, the newRBEntry method
  call for the transactions manager also must be catched by the
  exception. Otherwise, the index might be corrupted if any exception
  occur ( e.g. out of temp space )

Submitted by:	Bjoern Lemke <>
Sat, 1 Apr 2017
[ 08:18 pi ] Original commit   Revision:437396
437396 databases/cego/Makefile
437396 databases/cego/distinfo
437396 devel/lfcbase/Makefile
437396 devel/lfcbase/distinfo
devel/lfcbase: update 1.9.2 -> 1.9.3
databases/cego: update 2.33.1 -> 2.33.3

- Small fixes for Monitor and Pager class, adding missing ifdef for
  curses option in Pager class, replaced CGNOCURSES with LFCNOCURSES

- Fix in CegoRecoveryManager::recoverTableSet, before calling
  transactionRecovery, we have to set flag setIgnoreInvalid to true.
  During transaction recovery phase, we must ignore invalid btrees/index
  objects since these objects could be invalidated but Log data
  integrity and consistency is ensured
- Added implizit tableset btree and index correction to recovery procedure
  ( CegoRecoveryManager::recoverTableSet )
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sun, 26 Mar 2017
[ 09:02 pi ] Original commit   Revision:436943
436943 databases/cego/Makefile
436943 databases/cego/distinfo
databases/cego: update 2.33.0 -> 2.33.1

- Some cosmetic changes for backup manager handlng
  ( change nameing from archmng to backupmng )

Submitted by:	Bjoern Lemke <>
Sat, 25 Mar 2017
[ 18:06 pi ] Original commit   Revision:436911
436911 databases/cego/Makefile
436911 databases/cego/distinfo
436911 databases/cego/pkg-plist
436911 devel/lfcbase/Makefile
436911 devel/lfcbase/distinfo
436911 devel/lfcbase/pkg-plist
devel/lfcbase: update 1.9.1 -> 1.9.2
databases/cego: update 2.32.14 -> 2.33.0

- Added CommandExecuter::executeStream method to catch stdout for
  any forked process
- Added class OutStream to catch stdout from forked programs via popen

- Added database verify006 to check multidimensional btrees also in
  combination of null value handling.
- Fix in CegoObjectCursor::getNext, double method call for unlockData removed
- Small grammar correction to treat distinct flag for select-star statement
- Fix in CegoBTreeCursor::compValue, null values have not been handled
  correctly. For string values, string termination was not clean, which
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sat, 11 Mar 2017
[ 19:33 pi ] Original commit   Revision:435953
435953 databases/cego/Makefile
435953 databases/cego/distinfo
435953 devel/lfcbase/Makefile
435953 devel/lfcbase/distinfo
devel/lfcbase: update 1.9.0 -> 1.9.1
databases/cego: update 2.32.11 -> 2.32.14

- Small fix for Monitor::showFormBox, in case of menu elements,
  delete key is disabled

- Correstion for distinct clause. With the current grammar implemention,
  queries with nested selects and using the distinct operator might
  fail. Cego.def grammar and CegoAction implementation has been changed
  in way, that distinct option is just allowed at the beginning ( e.g.
  select distinct count(a) from t1 and NOT select count(distinct a) from t1 )
  This should simplify usage, since by using the distinct clause,
  distinct tuples are retrieved either for plain queries or for
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sun, 5 Mar 2017
[ 11:08 pi ] Original commit   Revision:435469
435469 databases/cego/Makefile
435469 databases/cego/distinfo
435469 databases/cegobridge/Makefile
435469 databases/cegobridge/distinfo
435469 devel/lfcbase/Makefile
435469 devel/lfcbase/distinfo
435469 devel/lfcbase/pkg-plist
devel/lfcbase: update 1.8.12 -> 1.9.0
databases/cego: update 2.32.8 -> 2.32.11
databases/cegobridge: update 1.1.2 -> 1.1.3, fix build with clang 4.0

- Added Monitor class for ncurses based GUI utility implementation.
  This class provides GUI layout and event handling to simply ncurses
  based GUI tool implementaton.
- Added class Pager for curses based pager implementation

- Include stdlib.h added in CegoNet ( still missing forLinux compiles )
- Added CegoFieldValue::getDim method required for arithmetic operations
  on fixed values
- Fix in CegoTableManager::getPoolInfo, readdelay and writedelay was
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sun, 29 Jan 2017
[ 09:36 pi ] Original commit   Revision:432707
432707 databases/cego/Makefile
432707 databases/cego/distinfo
432707 devel/lfcbase/Makefile
432707 devel/lfcbase/distinfo
devel/lfcebase: update 1.8.11 -> 1.8.12
databases/cego: update 2.32.7 -> 2.32.8

- Changed methods for class Sleeper to static. Added Sleeper class
  test to test suite
- Added include file limits.h in For Linux compiles, this
  include is required ( definition of INT_MAX and INT_MIN )

- Small improvements for CegoAdmMon curses based admin console

Submitted by:	Bjoern Lemke <>
Sat, 21 Jan 2017
[ 15:10 pi ] Original commit   Revision:432049
432049 databases/cego/Makefile
432049 databases/cego/distinfo
databases/cego: update 2.32.6 -> 2.32.7

- Fix in CegoFileHandler::releaseFiles.
  _tabSetId and _isReg vars have to be set to zero/false in any case.
  Otherwise, it might happen that old entries are still visible and in case
  of a tableset recreation obsolete file handle information is provided
- Method CegoTransactionManager::hasOpenTransaction added to check for open
  transaction for a spedific table. This method is called now before a table
  can be dropped to ensure there are no open transaction for this table.

Submitted by:	Bjoern Lemke <>
Wed, 4 Jan 2017
[ 19:37 pi ] Original commit   Revision:430589
430589 databases/cego/Makefile
430589 databases/cego/distinfo
databases/cego: update 2.32.5 -> 2.32.6

- Small performance improvement in CegoBufferPool::bufferFix
  Instead of copying the buffer head data to a local variable via
  memcpy, a pointer variable is used to access the data directly
  Performance improvement: just a few percent ...

Submitted by:	Bjoern Lemke <>
Sun, 1 Jan 2017
[ 15:43 pi ] Original commit   Revision:430257
430257 databases/cego/Makefile
430257 databases/cego/distinfo
databases/cego: update 2.32.4 -> 2.32.5

- Added another performance patch to CegoBTreeCursor.
  The method compValue has been redesigned in a way, that comparison
  is prepared at cursor creation time and so could be executed in
  a optimized and faster way
  This speeds up queries with joined tables, where the joined table
  is traced many times ( e.g. select count(*) from t1, t2 where
  t1.a = t2.a )

Submitted by:	Bjoern Lemke <>
Sat, 31 Dec 2016
[ 18:14 pi ] Original commit   Revision:430149
430149 databases/cego/Makefile
430149 databases/cego/distinfo
databases/cego: update 2.32.3 -> 2.32.4

- Fixes and improvements for table export added
  In CegoXPorter::xmlExportable, the pOutStream pointer was deleted,
  which lead to a core dump ( pointer is already deleted by Element )
  Row counter handling and messages have been improved
- Change back to memove call in CegoBTreeNode:shiftEntries. Copying manually
  and bytewise decreased performance about two times for building
  up btree objects. This has been observed on native POSIX ( FreeBSD 11 )
  but also on MSYS64 compiles
- Improvements for CegoBTreeCursor. With the new introduced methods
  CegoBTreeNode::getMedPage and CegoBTreeNode::rightValue, the search
  for the appropriate subnode can be made with logarithmic efforts
  instead of linear search. To validate this improvement, the following
  query has been setup for a random filled table t1
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sat, 24 Dec 2016
[ 10:03 pi ] Original commit   Revision:429319
429319 databases/cego/Makefile
429319 databases/cego/distinfo
databases/cego: update 2.32.2 -> 2.32.3

- Fix in CegoAction::insertStore and CegoAction::insertValueSpecStore;
  for value array inserts via network, the ack for the protocol was
  no satisfied ( e.g. insert into t1 values ( 1, 'XXX'),(2,'YYY'),...)
  which leads to a hanging database client. Since class CegoQuey
  was already prepared for bulk inserts, this was a simple fix,
  just calling execQuery via insertStore parser method just one time.
- Code cleanup in CegoBTReeManager and CegoBTreeNode, use of static
  method CegoDataPointer::getEncodingLength, (define of DPENCODINGLENGTH)
- Fix in CegoFileHandler::CleanDataFile,pageId was not calculated
  correctly ( missing offset )

Submitted by:	Bjoern Lemke <>
Thu, 22 Dec 2016
[ 06:24 pi ] Original commit   Revision:429143
429143 databases/cego/Makefile
429143 databases/cego/distinfo
databases/cego: update 2.32.1 -> 2.32.2

- Fix in CegoTranactionManager, replaced LONG_TYPE with PAGEID_TYPE,
  since this is the correct type for page entries. This was detected
  on MinGW64 compiles (seg fault occured), since the type size differs
  on this platform.

Submitted by:	Bjoern Lemke <>
Sun, 18 Dec 2016
[ 16:57 pi ] Original commit   Revision:428881
428881 databases/cego/Makefile
428881 databases/cego/distinfo
databases/cego: update 2.32.0 -> 2.32.1

- Fixes for CegoBTreeManager::deleteBTree ( changed int type to
  PageIdType for page vars )
  and CegoBTreeManager::insertBTree ( propValue was not setup correctly
  for root node propagation in some cases, which might lead to corrupt
  btree structure )

Submitted by:	Bjoern Lemke <>
Fri, 16 Dec 2016
[ 18:24 pi ] Original commit   Revision:428690
428690 databases/cego/Makefile
428690 databases/cego/distinfo
428690 devel/lfcbase/Makefile
428690 devel/lfcbase/distinfo
devel/lfcbase: update 1.8.10 -> 1.8.11

- Added range check to Chain::toInteger method to catch overflow exception

- This version brings a complete redesign of low level page handling.
  Instead of page references identified by fileId and pageid, a
  database unique pageid is used now
  This results in a complete reimplemtation of several low level
  classes like CegoFileHandler, CegoBufferPool, Blob handling, etc.
  Since pages are references by a single ( 64 bit ) id now, I expect
  an increased performance behaviour over all database operations.
  Most code modifications are done, code complies and basic
  functionally works ( create tableset, create table, insert table )
- First performance analysis indicates a speedup of about 10% for
  btree creation, so significant speedup for full table scans.
- All base checks passed, but there is still a page allocation leak
  for table drops
- Functional tests with SysMT successful completed

Submitted by:	Bjoern Lemke <>
Sun, 4 Dec 2016
[ 10:54 pi ] Original commit   Revision:427773
427773 databases/cego/Makefile
427773 databases/cego/distinfo
databases/cego: update 2.31.6 -> 2.31.7

- Fix in CegoFieldValue for fixed value handling.
  In case of fixed value aggregations, the specified fixed dimension
  should be kept. This has been done be analysing the value dimension
  in the CegoFieldValue:add/sub/mu/div methods.
  In CegoQueryHelper::prepareFieldValue, fixed values are checked now
  for right dimension

Submitted by:	Bjoern Lemke <>
Sat, 26 Nov 2016
[ 10:24 pi ] Original commit   Revision:427137
427137 databases/cego/Makefile
427137 databases/cego/distinfo
databases/cego: 2.31.5 -> 2.31.6

- Fix in CegoSelect::getQueyId added, for the ordering clause asc
  and desc ordering attributes were missing. This might lead to wrong
  ordering results if query caching is used

Submitted by:	Bjoern Lemke <>
Mon, 21 Nov 2016
[ 06:41 pi ] Original commit   Revision:426691
426691 databases/cego/Makefile
426691 databases/cego/distinfo
databases/cego: update 2.31.4 -> 2.31.5

- Changed CegoQueryHelper methods to static
- Fix for CegoBTreeManager and friends regarding small string values
  ( string(1) )
- Please note, that this fix invalidates btree format.
  Btrees have to be recreated after this fix, databases need to
  be exported and imported.

Submitted by:	Bjoern Lemke <>
Sat, 19 Nov 2016
[ 08:26 pi ] Original commit   Revision:426353
426353 databases/cego/Makefile
426353 databases/cego/distinfo
databases/cego: update 2.31.3 -> 2.31.4

- Fix some leaks in CegoXPorter regarding file handles and memory
  allocation ( improved exception handling )

Submitted by:	Bjoern Lemke <>
Wed, 16 Nov 2016
[ 08:44 pi ] Original commit   Revision:426221
426221 databases/cego/Makefile
426221 databases/cego/distinfo
databases/cego: update 2.31.2 -> 2.31.3

- Fixed a file handle leak for datafiles and logfiles ( CegoFileHandler,
  CegoTableManager and CegoLogManager ) After tableset creation (
  or start and stop ), file handles have not cleaned up properly.
  This lead to file remove problems in case of a tableset drop.
  This effect was detected by building and testing the MinGW64 port

Submitted by:
Sun, 13 Nov 2016
[ 14:35 pi ] Original commit   Revision:426054
426054 databases/cego/Makefile
426054 databases/cego/distinfo
databases/cego: update 2.31.1 -> 2.31.2

- Fix in CegoClient for escape character handling in batch mode
- Fix in CegoClient for dumpfile generation. Default values handling corrected
- Join optimizer fix in CegoSelect, CegoAttrCond and CegoBtreeCursor.
  join attributes are checked now in a more sophisticed way, which
  leads to improved execution performace for advanced joins

PR:		Bjoern Lemke <>
Thu, 10 Nov 2016
[ 20:19 pi ] Original commit   Revision:425854
425854 databases/cego/Makefile
425854 databases/cego/distinfo
databases/cego: update 2.31.0 -> 2.31.1

- Fix in CegoBTreeManager::insertBTree, in case of a duplicate
  exception, a bufferpool leak occured ( buffer is not unfixed ).
Sat, 10 Sep 2016
[ 12:46 pi ] Original commit   Revision:421688
421688 databases/cego/Makefile
421688 databases/cego/distinfo
databases/cego: 2.30.26 -> 2.31.0

- Added database flag DUPLICATENULL to allow duplicate null values
  for unique btree objects

Submitted by:	Bjoern Lemke <>
Sun, 21 Aug 2016
[ 19:03 pi ] Original commit   Revision:420577
420577 databases/cego/Makefile
420577 databases/cego/distinfo
databases/cego: 2.30.24 -> 2.30.26

- Fix in CegoFunction::evalFieldValue, for functions date2str,
  date2int, int2date, type casting to appropriate type has been added.
  Without the cast, the functions might return wrong results
- Adaptions for CegoBlowTab to use CegoNet API
- Completion for blob methods in CegoNet
- Improved flow control in CegoClient ( based on ncurses )
- Optimization in CegoClient, just high level CegoNet API methods
  are used now for client implementation. Missing methods have been
  added to CegoNet API

Submitted by:	Bjoern Lemke <>
Thu, 11 Aug 2016
[ 18:07 pi ] Original commit   Revision:420092
420092 databases/cego/Makefile
420092 databases/cego/distinfo
databases/cego: 2.30.23 -> 2.30.24

- Fix in CegoNet::connect, the global vars __dateTimeFormat,
  __currencySymbol and __decimalPoint are set up now to appropriate

Submitted by:	Bjoern Lemke <>
[ 10:54 pi ] Original commit   Revision:420058
420058 databases/cego/Makefile
420058 databases/cego/distinfo
420058 devel/lfcbase/Makefile
420058 devel/lfcbase/distinfo
devel/lfcbase: 1.8.9 -> 1.8.10
databases/cego: 2.30.21 -> 2.30.23

- Improvements for BigDecimal class
  All values are normalized now and stored now with non trailing zeros

- Fixes for cast operations regarding values for type fixed
- Fix in CegoClient, global vars __currencySymbol and __decimalPoint
  still have not been set up correctly, done in the same way as for
  CegoMain on server side
- Added verify005.sql to dbcheck suite to verify cast operations

Submitted by:	Bjoern Lemke <>
Mon, 25 Jul 2016
[ 13:02 pi ] Original commit   Revision:419038
419038 databases/cego/Makefile
419038 databases/cego/distinfo
databases/cego: 2.30.19 -> 2.30.21

- Fix in CegoProcedure::execute and CegoProcedure::getRetVal In the
  castTo method, the type dimension was still not treated. This might
  lead to wrong cast results especially for fixed values
- Fixed cgadm online help for import command, the nologging option
  was not documented
- In CegoRecoveryManager, added tableset argument line argument for
  calling the external log manager.
  This makes it more easy in the log manager code, to implement
  tableset dependent restore strategies

Submitted by:	Bjoern Lemke <>
Wed, 20 Jul 2016
[ 07:30 pi ] Original commit   Revision:418822
418822 databases/cego/Makefile
418822 databases/cego/distinfo
418822 devel/lfcbase/Makefile
418822 devel/lfcbase/distinfo
devel/lfcbase: 1.8.7 -> 1.8.9
databases/cego: 2.30.17 -> 2.30.19

- Added File::rename method to be able to move files via file class
- Patch file File class, operator= and operator+= did not close the
  file descriptor after copying / appending. This may cause a problem
  for subsequent method calls on the instance. ( e.g. renaming or
  removing )
  This effect actually has just been observed for MinGW64 compiles

- Catched server termination in CegoTableManager::writeCheckpoint.
  If log files could not be archived, the method does not recognized
  server termination ( runstate = OFFLINE )
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Fri, 15 Jul 2016
[ 17:34 pi ] Original commit   Revision:418597
418597 databases/cego/Makefile
418597 databases/cego/distinfo
databases/cego: 2.30.15 -> 2.30.17

- Fixed for point-in-time recovery, Date format handling was not
  done correectly
- Elimination of BUFFERPOOLHASHKEY. The bufferpool position is now
  calculated based on the page offset of the corresponding datafile
  ( this information is provided by CegoFileHandler::getRegPageOffset )
  This leads to a much better distribution and usage of the available
  buffer pool pages
- Fix in CegoTableManager::createBTree, the creation of the btree object
  must be done in a dedicated exception block, otherwise the btree
  object is dropped, if it already exists.

Submitted by:	Bjoern Lemke <>
Sun, 10 Jul 2016
[ 12:39 pi ] Original commit   Revision:418314
418314 databases/cego/Makefile
418314 databases/cego/distinfo
418314 devel/lfcbase/Makefile
418314 devel/lfcbase/distinfo
devel/lfcbase: 1.8.4 -> 1.8.5
databases/cego: 2.30.14 -> 2.30.15

- Added statlock mutex in ThreadLock class for protecting statistic
  counters. It seems, increment and decrement operators on atomic
  values are no more thread safe ( Once it was, but I guess this is
  a compiler issue )
  Since the lock statistics can be disabled for production mode,
  there is not performance impact caused by the additional mutex

- Made __dateFormatList in CegoMain threadsafe
  For the point-in-time recovery timestamp format, now the server
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Thu, 7 Jul 2016
[ 13:30 pi ] Original commit   Revision:418182
418182 databases/cego/Makefile
418182 databases/cego/distinfo
databases/cego: 2.30.12 -> 2.30.14

- Added alter table modify command just for default values.
    alter table t1 modify column a default 42;
- Improvement for hash calculation in CegoBufferPool::calcSegement.
  For a better page spreading, the segment calculation was changed
  to a more linear approach
- Added more cast cases to CegoField::castTo, still not completed
- Cast handling in CegoFieldValue::castTo completed.
  This allows an any to any value casting, except lob values and
  some unsupported datetime casts ( e.g. bool to datetime really
  makes no sense )
- Fix in CegoBufferPool::poolInfo, the spread rate calculation was
  not done correctly

Submitted by:	Bjoern Lemke <>
Mon, 27 Jun 2016
[ 05:36 pi ] Original commit   Revision:417633
417633 databases/cego/Makefile
417633 databases/cego/distinfo
databases/cego: 2.30.11 -> 2.30.12

- Added cast improvements to CegoFieldValue::castTo method, which are
  also checked now with check050
- Evaluation of locale to find out decimal point character. E.g.
  for english locales this is ., for german this is ,. The character
  is used for float value handling in CegoFieldValue methods.

Submitted by:	Bjoern Lemke <>
Thu, 23 Jun 2016
[ 05:20 pi ] Original commit   Revision:417343
417343 databases/cego/Makefile
417343 databases/cego/distinfo
databases/cego: 2.30.7 -> 2.30.11

- Fix in CegoRecoveryManager::recoverTableSet, the lsn was incremented
  which lead to leaks in the transaction log. This could result in
  an incomplete recovery procedure
- Improvements for tableset recovery, external log manage field is
  checked in CegoAdminThread::medRecover before restore procedure is
- Fix in CegoLogManager::logAction, if online redo log is full, the
  current log entry has to be written anyway, otherwise a checkpoint
  is written and subsequent logAction call in CegoTableManager::logIt
  might lead to duplicate entries in case of a crash recovery
- Fixes for query and table cache added (addEntry method was still not clean)
- Added tableset runstate CHECKPOINT to be set during a tableset
  checkpoint is performed.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sat, 11 Jun 2016
[ 06:35 pi ] Original commit   Revision:416704
416704 databases/cego/Makefile
416704 databases/cego/distinfo
databases/cego: 2.30.6 -> 2.30.7

- Fixed memory leak in CegoSelect::nextTuple.
  Since the querycache is allocated by the CegoQueryCache instance, the
  pCacheList variable has to be freed after calling the addEntry method.
  Actually, the logic is not very smart, since the cache element is build up
  two times...

Submitted by:	Bjoern Lemke <>
Sat, 4 Jun 2016
[ 06:31 pi ] Original commit   Revision:416345
416345 databases/cego/Makefile
416345 databases/cego/distinfo
databases/cego: 2.30.5 -> 2.30.6

The following query can cause a core dump
  create table t1(a string(100));
  insert into t1 values ( 'Hugo Habicht');
  insert into t1 values ( 'Kim Kaiser');
  select substr(a, 1, getpos(a, ' ')) from t1;

For return value length evaluation, the method CegoFieldValue::asInteger
is called on a null value which causes the dump. A fix has been
added, so the method returns a value of 0 in case of null values.

Submitted by:	Bjoern Lemke <>
Mon, 16 May 2016
[ 08:19 pi ] Original commit   Revision:415313
415313 databases/cego/Makefile
415313 databases/cego/distinfo
415313 devel/lfcbase/Makefile
415313 devel/lfcbase/distinfo
415313 devel/lfcxml/Makefile
415313 devel/lfcxml/distinfo
devel/lfcbase: 1.8.2 -> 1.8.3
devel/lfcxml: 1.2.3 -> 1.2.4
databases/cego: 2.30.3 -> 2.30.5

- code format cleanup

- code format cleanup

- Code optimizations tested. The performance improvements on
  subselects are achieved as expected.
- Code optimization for join buffer handling. Now a double pointer
  list is used to just keep references on CegoField lists. This should
  avoid expensive memory copies in case of creating parent join buffers
  for sub selects.
- code format cleanup
- Fix in CegoAdmMon, CGNOMONITOR definition was fixed, now defined
  via configure

Submitted by:	Bjoern Lemke <>
Sat, 30 Apr 2016
[ 19:09 pi ] Original commit   Revision:414359
414359 databases/cego/Makefile
414359 databases/cego/distinfo
databases/cego: 2.30.2 -> 2.30.3

- Fix in CegoBufferPool::bufferFix. Small leak, since last page for each
  pool segment never could be used ( hashId calculation )
- Cosmetic syntax change for set permission and remove permission admin
- Small information fix for query cache information in show tableset
  admin command

Submitted by:	Bjoern Lemke <>
Sun, 3 Apr 2016
[ 07:52 pi ] Original commit   Revision:412452
412452 databases/cego/Makefile
412452 databases/cego/distinfo
412452 devel/lfcbase/Makefile
412452 devel/lfcbase/distinfo
412452 devel/lfcbase/pkg-plist
devel/lfcbase: 1.8.0 -> 1.8.1
databases/cego: 2.29.3 -> 2.30.2

- Fix in CegoAction and CegoDbHandler to handle query abort requests correctly
  ( initiated by cgadm via abort db thread command )
- Fix in CegoDistCursor for query plan calculation ( join objects )
- Fix in CegoAdminThreadPool and CegoLogThreadPool for thread load
- Major change for tablecache and querycache management,
  for both dedicated tableset entries are managed. Cache enabling,
  cache size and num entries can be controlled now on tableset level.
- Fixes for date format handling. The format string whihc is specified
  for the server is also used now for client formatting. This results
  in some network protocol fixes for serial but also xml network
- Changed default protocol from xml to serial. Date format handling
  completely implemented

Submitted by:	Bjoern Lemke <>
Sun, 6 Mar 2016
[ 16:21 pi ] Original commit   Revision:410465
410465 databases/cego/Makefile
410465 databases/cego/distinfo
410465 devel/lfcbase/Makefile
410465 devel/lfcbase/distinfo
devel/lfcbase: 1.7.2 -> 1.8.0
databases/cego: 2.29.1 -> 2.29.3

Changes to lfcbase:
- Fix in Chain for truncleft, truncRight and cutTrailing. In case
  of single character strings, the methods might return wrong results.
- Started with implementation of TextIndex class ( utility class
  for full text index creation )

Changes to cego:
- Fixes for table and query cache handling
- Fix in CegoDistManager::dropDistObject, table and query cache
  have been checked for cleanup, if a table is dropped
- Fix in, added table and query cache cleanup for alter
  and rename queries
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sat, 6 Feb 2016
[ 15:59 pi ] Original commit   Revision:408300
408300 databases/cego/Makefile
408300 databases/cego/distinfo
408300 databases/cego/pkg-plist
408300 databases/cegobridge/Makefile
408300 databases/cegobridge/distinfo
408300 databases/cegobridge/files
408300 devel/lfcbase/Makefile
408300 devel/lfcbase/distinfo
408300 devel/lfcbase/files
devel/lfcbase: 1.7.0 -> 1.7.2
databases/cego: 2.28.3 -> 2.29.1
databases/cegobridge: 1.1.1 -> 1.1.2

Please note: Updating cego databases needs an export/import
             cycle for 2.28 -> 2.29

- Fix in, added include config.h, otherwiese the local
  implementation of strptime ist used. This should just be done, if
  the system API does not provide this call ( e.g. MINGW ) .
- Memory leak fixed in File::readLine

- Started with clob datatype implementation
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Mon, 11 Jan 2016
[ 12:30 pi ] Original commit   Revision:405781
405781 databases/cego/Makefile
405781 databases/cego/distinfo
405781 databases/cegobridge/Makefile
405781 databases/p5-DBD-cego/Makefile
405781 devel/lfcbase/Makefile
405781 devel/lfcbase/distinfo
405781 devel/lfcxml/Makefile
405781 devel/lfcxml/distinfo
devel/lfcbase: 1.6.7 -> 1.7.0
devel/lfcxml: 1.1.8 -> 1.2.2
databases/cego: 2.27.2 -> 2.28.3
databases/p5-DBD-cego: bump portrevision
databases/cegobridge: bump portrevision

IMPORTANT: Upgrades of cego 2.27.x to 2.28.x databases has to be done by
export and import.

- Adaptions made for build with msys2 / mingw64. Many windows
  specific stuff could be eliminated, since mingw64 provides better
  POSIX support ( e.g. pthreads, timer functions .. )

(Only the first 15 lines of the commit message are shown above View all of this commit message)
Mon, 14 Dec 2015
[ 06:42 pi ] Original commit   Revision:403707
403707 databases/cego/Makefile
403707 databases/cego/distinfo
databases/cego: 2.27.0 -> 2.27.2

- Fix for system tables in CegoAttrDesc::evalReferences, for system
  tables the evalTableReferences method has to be called, otherwise
  attributes for system tables can not be accessed
- Add dbCheck for Fetch & Cache ( check047 ), all base checks are
  run now with querycache ON and OFF
- Fix in CegoSelect::nextTuple, the cache schema was not set up
  properly, if nextTuple was just called with empty jfl. This happens
  in case of procedure cursors, ( CegoProcFetch ), where the field
  value list is for all method calls empty
- Fix for CegoExpr::getAggregationList(), missing break operations
  in switch block. This bug might lead to error messages regarding
  aggregation queries like
  CGCLT > select sum(a) + 0 from t1;
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sat, 5 Dec 2015
[ 18:14 pi ] Original commit   Revision:403072
403072 databases/cego/Makefile
403072 databases/cego/distinfo
databases/cego: 2.26.16 -> 2.27.0

- Introduced BTree Cache to speed up the creating of large btree
  indizes. A BTree Cache test done with 100 million tuples went
  from 20h to 2.6h to create the index.

Submitted by:	Bjoern Lemke <>
Tue, 1 Dec 2015
[ 20:33 pi ] Original commit   Revision:402783
402783 databases/cego/Makefile
402783 databases/cego/distinfo
402783 devel/lfcbase/Makefile
402783 devel/lfcbase/distinfo
402783 devel/lfcbase/files
devel/lfcbase: 1.6.5 -> 1.6.7
databases/cego: 2.26.14 -> 2.26.16

- Improvement for ListT template class. The end of the list is now
  stored int _listEnd variable. This improves Insert performance,
  since the end of the list can immediately accesed instead of tracking
  through the whole list until the end is reached.
- Patch in ThreadLock, the mutex for lock statistics has been
  removed, since there is no need for synchronization. Also errors
  have not been checked for the pthread_rwlock_wrlock, which might
  cause some deadlocks.

- Ugly bug fixed in CegoObjectManager::releaseDataPtrUnlocked.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Wed, 25 Nov 2015
[ 18:55 pi ] Original commit   Revision:402406
402406 databases/cego/Makefile
402406 databases/cego/distinfo
402406 devel/lfcbase/Makefile
402406 devel/lfcbase/distinfo
402406 devel/lfcxml/Makefile
402406 devel/lfcxml/distinfo
devel/lfcbase: 1.6.3 -> 1.6.5
devel/lfcxml: 1.1.7 -> 1.1.8
databases/cego: 2.26.13 -> 2.26.14

- Added kill method to class Process, added SigTest check program to
  basecheck suite
- Fix in BigDecimal::operator < and > .. comparison was not done correctly.
- Added automake check suite in baseecheck directory ( derived from samples )

- Added automake check suite to package
- Small fix for XMLSuite constructor for pInStream initialization

- Added encoding implementation for CegoCaseCond to allow case
  conditions also for update operations like
  update erp_disk
  set location = case when substr(wwn,20,1) = '1' then 'MD' else 'GV' end;
- Cosmetic changes in CegoDefs, increased FILEMNG_MAXDATAFILE to 5000

Submitted by:	Bjoern Lemke <>
Sun, 15 Nov 2015
[ 08:05 pi ] Original commit   Revision:401682
401682 databases/cego/Makefile
401682 databases/cego/distinfo
databases/cego: 2.26.12 -> 2.26.13

- Fix in CegoAttrDesc::evalReferences. In case of join objects, the
  refCount was not calculated correcty, since just the join object
  was analysed but not the sub content object. For this, a new method
  was introduced ( evalTableReferences ) and in case of join object,
  evalReferences is called recursive for all sub content objects

Submitted by:	Bjoern Lemke <>
Fri, 13 Nov 2015
[ 06:35 pi ] Original commit   Revision:401478
401478 databases/cego/Makefile
401478 databases/cego/distinfo
databases/cego: 2.26.11 -> 2.26.12

- cgsimload with 3 mio ops and 2 processes passed
- Fix in CegoBTreeCursor::getFirst, if pAttrCond == 0 and btree is empty,
  the method call tries to claim a zero datapointer
- Reorganization of CegoDistManager and CegoTabelManager, all
  methods, which are calling useObject/unuseObject are located in
  CegoTableManager class now.

Submitted by:	Bjoern Lemke <>
Sun, 8 Nov 2015
[ 15:57 pi ] Original commit   Revision:401062
401062 databases/cego/Makefile
401062 databases/cego/distinfo
databases/cego: 2.26.10 -> 2.26.11

- Added more sophisticated corruption check for btrees
  ( CegoBTreeManager::verfiyBTree ), which also checks for any structure
  corructions in all btree nodes
- Added btree check to CegoDistManager::verifyTable

Submitted by:	Bjoern Lemke <>
[ 10:56 pi ] Original commit   Revision:401048
401048 databases/cego/Makefile
401048 databases/cego/distinfo
databases/cego: 2.26.9 -> 2.26.10

- Added make check feature for basic and gate tests
Sat, 7 Nov 2015
[ 09:28 pi ] Original commit   Revision:400974
400974 databases/cego/Makefile
400974 databases/cego/distinfo
400974 databases/cego/pkg-plist
databases/cego: 2.26.7 -> 2.26.9

- Version passed concurrent load test with 10 million concurrent
  operations ( random insert, update and delete on one table with 2
  processes )
- Fix in CegoFileHandler::allocatePage, In case of page exceed with
  appendMode = true, a second try is done with appendMode = false
- Small fix in CegoObjectManager::reorgObject, ref page id information
  for append mode is set to new last page id
- Small fix in CegoSelect::filterRefs, allow expressions with constant
  values ( getAttrRefList= 0 ) in aggregation
- Locking improvements for delete and update operations.
  All delete operations are done now via transactions ( introduced
  CegoTableManager::deleteDataTableAtomic ). This allows to use a
  shared lock as the table lock for using the table
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sat, 31 Oct 2015
[ 21:27 pi ] Original commit   Revision:400587
400587 databases/cego/Makefile
400587 databases/cego/distinfo
databases/cego: 2.26.2 -> 2.26.7

- Improvements for query execution plan retrieval
- Fix in CegoOutput for multline format
  ( e.g. execution plans have been cut off )
- Performance patch in CegoTableCursor::setup. The getObjectListByTable
  method was called every time, when the attribute condition has been
  changed. Since this operation is pretty expensive, it was useful
  to cache the retrieved index/btree objet in a local class variables.
  This change results in significant query speedup for joins, where
  the table cursor has to be setup very often
- Small fix in CegoAction::readChain, treating backslashes for
  quoteEscapeFlag=false was commented, reactivated
- Small fix in CegoMain, default for csmode changed to value "ID"
- Fix for CegoBtreeManager::insertBTree. Duplicate handling did not
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sun, 4 Oct 2015
[ 12:31 pi ] Original commit   Revision:398572
398572 databases/cego/Makefile
398572 databases/cego/distinfo
databases/cego: 2.25.3 -> 2.26.2

- Fix in CegoBufferPool::calcHas and CegoBufferPool::calcSegement
  For large file id's the integer range for the hash key might be
  exceeded, which lead to wrong address calculation.
  The hash key now is calculated in long based values
- Introduced server mode with same behaviour as daemon mode, but
  no child process is forked and server can be terminated with Ctrl-C
- Small formatting fix in CegoOutput
- Fix in CegoDistCursor for inner and outer joins
  Inner or outer joins with additional where condition might return
  incorrect result set since the condition was just evaluated inside
  the join.
  To correct this, the WHERE condition is also checked via evalCondition.
  This required also a fix in the evalCondition method.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Sun, 20 Sep 2015
[ 17:04 pi ] Original commit   Revision:397379
397379 databases/cego/Makefile
397379 databases/cego/distinfo
databases/cego: 2.25.1 -> 2.25.3

- Decreased default cache size values to 100k ( query + table )
- Next fileId (CegoXMLSpace::nextFID ) calculation now analyses the
  existing fileId and uses the lowest available. The MAXFID attribute
  in the database xml file is no more used. This avoids, that file
  id exceeds in case of frequent creation and removement of tablesets.
- Some format correction in CegoAdminHandler
- Increased parameter FILMNG_MAXDATAFILE to 10000 and
- Optimization added in CegoDisCursor::distSetup(CegoAttrCond)
  If the native table cursor could not set up either FULL or PART, the
  table cursor retrieved all available rows from the corresponding table.
  In this case, the table also can be cached to improve subsequent
  queries for this table. This fix is relevant for queries like
  select * from t1 where b like '%X%', since the like condition
  cannot be used by the table cursor

Submitted by:	Bjoern Lemke <>
Sun, 13 Sep 2015
[ 10:08 pi ] Original commit   Revision:396804
396804 databases/cego/Makefile
396804 databases/cego/distinfo
databases/cego: 2.25.0 -> 2.25.1

- Fix in CegoSelect::nextTuple : in case of rowlimit > 0,
  the cached entry was not added to query cache
- Added many columns sample to base test
  ( create, insert and select for table with 60 columns )

Submitted by:	Bjoern Lemke <>
Fri, 11 Sep 2015
[ 06:19 pi ] Original commit   Revision:396648
396648 databases/cego/Makefile
396648 databases/cego/distinfo
396648 databases/cego/pkg-plist
databases/cego: 2.24.4 -> 2.25.0

- Added throw statement for stored procedures. This allows to throw
  exceptions on application level

Submitted by:	Bjoern Lemke <>
Sun, 30 Aug 2015
[ 08:39 pi ] Original commit   Revision:395602
395602 databases/cego/Makefile
395602 databases/cego/distinfo
databases/cego: 2.24.3 -> 2.24.4

- Fix in CegoAction::execViewCreate.
  Views must be compiled successful now immediately after creation.
  Otherwise, the calculated schema is not stored correctly into
- Fix in CegoFactor::getId.
  If sysdate is used in queries, it should be resolved, otherwise
  query couldbe used from cache which returns invalid result

Submitted by:	Bjoern Lemke <>
Sat, 29 Aug 2015
[ 08:37 pi ] Original commit   Revision:395533
395533 databases/cego/Makefile
395533 databases/cego/distinfo
395533 databases/cego/pkg-plist
databases/cego: 2.23.12 -> 2.24.3

- Implemented query cache
- SQL keywords can now be used case-insensitive, with proper CSMODE

Submitted by:	Bjoern Lemke <>
Sat, 25 Jul 2015
[ 17:11 pi ] Original commit   Revision:392901
392901 databases/cego/Makefile
392901 databases/cego/distinfo
databases/cego: 2.23.11 -> 2.23.12

- In CegoQueryHelper::evalPredicate fixed termination for INSUB- and
  NOTINB queries. There was no reset at the end of the evaluation, which
  might lead to open table cursors. In case of procedure queries, this
  might lead to locking problems.
  Since the query is reset after evaluation, query caching is no more
  useful. This must be treated in an advanced way.
- Further patches in CegoTableManager::deleteDataTable,
  CegoFactor::evalReferences and CegoSelect::nextTuple for advanced
  query cache handling. All patches have impact on queries of the form

Submitted by:	Bjorn Lemke <>
Tue, 21 Jul 2015
[ 07:39 pi ] Original commit   Revision:392613
392613 databases/cego/Makefile
392613 databases/cego/distinfo
databases/cego: 2.23.10 -> 2.23.11

- Added performance patch in CegoFieldValue.
  Values with a length up to STATICFIELDBUF size ( 100 bytes ) are handled
  using a static byte array. This saves expensive memory allocation
  calls in most cases. First very rough performances analysis has
  shown a performance improvement of about 5-10 percent
- The local copy logic was shifted from CegoSelect::nextGroupedTuple
  to CegoGroupSpace::insertTuple.

Submitted by:	Bjorn Lemke <>
Sun, 19 Jul 2015
[ 08:28 pi ] Original commit   Revision:392489
392489 databases/cego/Makefile
392489 databases/cego/distinfo
databases/cego: 2.23.9 -> 2.23.10

- Fix in CegoSelect::nextGroupedTuple.
  For the 'grouping key' values, a local copy of CegoFieldValue has to be
  created. Otherwise, grouping references might be invalidated, which result
  in aborted grouping queries with strange error message ( No token
  available ) on client side.
  For local copy creation, the CegoFieldValue::getLocalCopy method has
  been modified ( was not used until now ).
  This effect was observed with small buffer poolsizes in
  combination with grouping queries on large tables. The probability
  of grouping key invalidation is higher in that case, because
  buffer pool pages are reloaded more often.

Submitted by:	Bjorn Lemke <>
Sun, 12 Jul 2015
[ 10:11 pi ] Original commit   Revision:391775
391775 databases/cego/Makefile
391775 databases/cego/distinfo
databases/cego: 2.23.8 -> 2.23.9

- Performance fix in CegoSelect::consolidateConjunctionList
  Inappropriate predicates are filtered and added to stack first.
  As a result, predicates are used for table join binding,
  so that efficient tuple retrievel is ensured.
- The fix also avoids infinite query loops for non-reference conditions,
  e.g. select a from t1 where 1 = 1;

Submitted by:	Bjorn Lemke <>
Sun, 14 Jun 2015
[ 13:48 pi ] Original commit   Revision:389632
389632 databases/cego/Makefile
389632 databases/cego/distinfo
databases/cego: 2.23.7 -> 2.23.8

- Simplification in CegoBTreeManager and CegoBTreeNode.
  Calculation of leaf node chain is now much simpler. This ensures
  consistency and improves btree build up performance.
- Fix for btree page count and btree page release. Some of the btree
  nodes have double references, which was not treated in the page count
  and page release algorithm.
- Changed default primary and secondary values for tableset definition
  command to the configured hostname. This simplifies the define command
  in case of single node tableset configurations.

Submitted by:	Bjorn Lemke <>
Tue, 9 Jun 2015
[ 21:34 pi ] Original commit   Revision:389004
389004 databases/cego/Makefile
389004 databases/cego/distinfo
389004 devel/lfcbase/Makefile
389004 devel/lfcbase/distinfo
devel/lfcbase: 1.6.1 -> 1.6.2
databases/cego: 2.23.6 -> 2.23.7

lfcbase: Fix in Chain::visibleLength.
	Calculation may result in an infiite loop, if mbtowc returns zero.

- Fix in CegoFieldValue for VARCHAR comparison. In case of exceeded
  string length for index values, the CegoFieldValue did not work
- Fix in CegoClient for dump mode. BTrees habe not been dumped with
  the correct type ( primary, unique, normal )

Submitted by:	Bjorn Lemke <>
Sat, 6 Jun 2015
[ 03:25 pi ] Original commit   Revision:388652
388652 databases/cego/Makefile
388652 databases/cego/distinfo
databases/cego: 2.23.3 -> 2.23.6

- Fix in CegoSelect::buildJoinTables.
  After growStep match, growStep is now reset to 1.
  This avoids to add tables to the joinlist, which are still not
  treated for any appropriate join condition. As an effect of this
  bug, execution plan is not evaluated in an optimal manner, which
  might lead to long execution times
- Fix in CegoTableManager::insertDataTable, in case of constraint
  violation, btrees have not been cleaned up. This may result in
  inconsistent btree objects.
- Added a fix in CegoTableManager::updateTuple.
  The core operation consists of a deleteDataTable and a
  insertDataTable method call. For the insertDataTable method call,
  the logging still was enabled. So in addition to an update
  operation, also an insert operation was done. In case of recovery
  operations, this lead to duplicate entries. Fix:
  just change isLogging parameter value for insertDataTable method
  from true to false.

Submitted by:	Bjorn Lemke <>
Mon, 1 Jun 2015
[ 20:12 pi ] Original commit   Revision:388273
388273 databases/cego/Makefile
388273 databases/cego/distinfo
databases/cego: 2.23.2 -> 2.23.3

- Added uptime command for cgclt to show database uptime
- Added pool uptime to buffer pool information, this indicates the
  database uptime
- Several fixes for cgmkdb utility

Submitted by:
Tue, 19 May 2015
[ 05:31 pi ] Original commit   Revision:386741
386741 databases/cego/Makefile
386741 databases/cego/distinfo
databases/cego: 2.23.1 -> 2.23.2

- Added rowlimit argument to CegoDatabaseFormater::formatSelect method

Submitted by:	Bjorn Lemke <>
Fri, 15 May 2015
[ 20:48 pi ] Original commit   Revision:386483
386483 databases/cego/Makefile
386483 databases/cego/distinfo
386483 databases/cego/pkg-plist
databases/cego: 2.23.0 -> 2.23.1

Added some missing include files to be installed

Submitted by:	Bjorn Lemke <>
Thu, 14 May 2015
[ 06:01 pi ] Original commit   Revision:386290
386290 databases/cego/Makefile
386290 databases/cego/distinfo
386290 databases/cego/pkg-plist
databases/cego: 2.22.0 -> 2.23.0

- Introduced CegoDatabaseFormater.
  Since the API has changed (proagation of database formatting methods),
  this is 2.23.0

Submitted by:	Bjorn Lemke <>
Fri, 1 May 2015
[ 17:21 pi ] Original commit   Revision:385129
385129 databases/cego/Makefile
385129 databases/cego/distinfo
385129 databases/p5-DBD-cego/Makefile
385129 databases/p5-DBD-cego/distinfo
385129 databases/p5-DBD-cego/files/patch-CegoXS.h
385129 databases/p5-DBD-cego/files/patch-Makefile.PL
385129 databases/p5-DBD-cego/files/patch-makefile-pl
385129 devel/lfcbase/Makefile
385129 devel/lfcbase/distinfo
385129 devel/lfcbase/pkg-plist
devel/lfcbase: 1.5.11 -> 1.6.1
databases/cego: 2.21.1 -> 2.22.0
databases/p5-DBD-cego: 1.2.9 -> 1.3.0

- Added syslog support
- syslog is enabled per default

- fix in CegoFieldValue::comp for correct null value ordering
- adapt to lfcbase 1.6 with syslog support

- adapt to lfcbase 1.6 with syslog support

Submitted by:	Bjorn Lemke <>

Number of commits found: 202 (showing only 100 on this page)

1 | 2 | 3  »  

User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
How big is it?
The latest upgrade!

Enter Keywords:

Latest Vulnerabilities
opensslNov 02
openssl-develNov 02
wordpressNov 01
php56Oct 30
php70Oct 30
php71Oct 30
wiresharkOct 30
chromiumOct 28
wgetOct 27
wgetOct 27
openoffice-4*Oct 26
openoffice-devel*Oct 26
gitlabOct 25
nodeOct 25
node4Oct 25

No vulnerabilities have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Deleted ports
Sanity Test Failures

NEW Graphs (Javascript)

Calculated hourly:
Port count 31886
Broken 126
Deprecated 57
Ignore 364
Forbidden 0
Restricted 175
Vulnerable 50
Expired 24
Set to expire 49
Interactive 0
new 24 hours 2
new 48 hours13
new 7 days3156
new fortnight3236
new month3395

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2017 Dan Langille. All rights reserved.