devel/lfcbase1.23.7

devel/lfcbase: 1.23.6 -> 1.23.7, databases/cego: 2.54.39 -> 2.54.41

lfcbase:
- in BigDecimal::scaleTo, rounding mode HALFUP was not treated correctly

cego:
- cgclt
  show systemspace
  now aggregates space type and indicate usage in percent for each space
- Added flag _stdNullComp to support standard SQL Null value
  comparison behaviour ( comparison returns false in any case )
  As default, cego specific comparison is enabled, where null values
  are the lowest values ( e.g. -1 > null returns true )
  Note : This ordering is also used for btree value sorting,
  where a well defined ordering for null values is needed.
  This SQL standard behaviour can be enabled be setting
  STDNULLCOMP=ON in the database xml file

databases/cego: 2.54.29 -> 2.54.38, devel/lfcbase: 1.23.5 -> 1.23.6

lfcbase:
- compiler warnings fixed for class Chain::toUpper and toLower
  ( dynamic wText allocation )

cego:
- procedure cache
- Added admin command set maxpagedelete to set up maximum number
  of pages marked for delete before forcing a checkpoint.
- CegoQueryManager: _authUser has to be stored locally,
  otherwise setUser method looses user information, if auth was not enabled
- new admin command object usage to show usage of tableset objects
  to detect any usage leaks and to get an overview of objects in
  use by running database threads
- backupManager: indicate number of logs to recover up to crash
  for the corresponding backup id.
- Fix added in CegoRecoveryManager::recoverCurrentTransactionLog
- Added list transaction command
- Added cgclt command show transaction to indicate detailed
  transaction information
- in CegoPredicate::Constructor, for LIKE-Constructor, the case
  ISNOTLIKE was not treated with the right condition
  ( ! isNegated && isCaseSensitive => isNegated && isCaseSensitive )

devel/lfcbase,databases/cego: 1.23.3 -> 1.23.5, 2.54.16 -> 2.54.23

lfcbase:
- Improved error message for File::open with strerror details added
- In File::operator = and File:operator +=, after file copy operation,
  source file descriptor was not closed.
  This might lead to file descriptor leaks.

cego:
- Many fixes for crash recovery and startup, write logs, etc.

devel/lfcbase,databases/cego: update 1.23.2 -> 1.23.3, 2.54.2 -> 2.54.7

lfcbase:
- Screen class regarding, some int to unsigned fixes

cego:
- patch in CegoAction::execProcCall and CegoAction::execFuncCall,
  fix locking in case of exceptions
- CegoAdmScreen to support current backup and restore features.
  Also added online help
- added dbcheck/failcheck to also check correct handling of failed queries
- Fixes added for CegoFieldValue:castTo. In case of thrown data
  conversion exceptions, is is ensured, that _pV is set to _staticBuf
  after freed, otherwise memory fault cause by double free in desctructor
  may occur
- initfile handling fixed
- CegoAdminThread::executeRestore improvements
  with online docs updated for the restore procedures
- Added patches to CegoBufferPool, CegoLogManager and CegoArchiveThread.
- database xml file will be updated during checkpointing runs.

devel/lfcbase: update 1.23.1 -> 1.23.2

- Added out of range handling for integer and long values
  in Chain::asInteger and friend methods

databases/cego,devel/lfcbase: update 2.53.2 -> 2.53.3, 1.23.0 -> 1.23.1

lfcbase:
- Completed integer cleanup for Pager class,
  replacement of some asInteger with asUnsigned method calls
  ( BigInteger, NetHandler, etc. )

cego:
- Added several patches for trigger objects
  ( check self refering tables in trigger block to avoid recursion,
  object invalidation handling fixed )
- In CegoRecoveryManager::recoverCurrentTransactionLog,
  completed recovery procedure for trigger and alias objects.
  For drop operations, added CegoDatabaseManager::removeObject calls,
  to remove corresponding objects from object cache

databases/cego: update 2.52.44 -> 2.53.2

- integer cleanup, all int values will be replaced by unsigned
  or unsigned long, where is no need of nagative values
- for those ports:
  devel/lfcbase
  devel/lfcxml
  databases/cego
  databases/cegobridge
  databases/p5-DBD-cego

cego:
- Fix added in CegoDbHander::acceptSession and CegoSerial::readChain
  to treat empty or invalid session requests
- fix in CegoDbThreadPool for bad message handling

p5-DBD-cego:
- Fix added for execute return value and $sth->rows value to
  return affected rows for update statements

devel/lfcbase: update 1.22.4 -> 1.22.5

- Chain::truncRight was broken in case to trunc to empty string.
  This occured with the change of some local variable from int to unsigned long

devel/lfcbase: 1.22.3 -> 1.22.4, databases/cego: 2.52.43 -> 2.52.44

- Warning elimination for G++ based compiles

devel/lfcbase: 1.22.2 -> 1.22.3, databases/cego: 2.52.42 -> 2.52.43

lfcbase:
- Warning elimination in several code modules.
  -Wall should print no warnings anymore (with clang)

cego:
- Added patch for CegoJoinObject for correct and complete decoding.
  This is needed for database recovery procedure if nested join select
  occurs in update statement, e.g.
  update t1 set b1 = ( select max(b2) from t2 inner join t3 on t2.a2 = t3.a3 );
- Warning elimination for several code modules.
  In CegoContentObject encoding and decoding method,
  the obsolete key flag in the schema information was removed.
  This leads to a incompatibel datastructure and requires tableset
  export/import for an uplift ot this version
- To toChain method of CegoTableObject, CegoJoinObject and
  CegoAliasObject has been improved to treat undefined tabSetId
  argument ( defTabSetId = 0 ).

devel/lfcbase: 1.22.1 -> 1.22.2, databases/cego: 2.52.40 -> 2.52.42

lfcbase:
- Added patch in File::hasData to check return code of pool library call
- Added fix in basecheck ReplaceTest to return valid results

cego:
- For CegoClient and CegoAdmin changed argument evaluation to handle
  pipe input data in a better way.
  Pipe mode is just used, if no batch or command mode ist setup and
  if data is available at stdin.
- This should also work for FreeBSD, when cgclt or cgadm is used
  via cronjob. It has been observed, that if a program is called by
  cron, poll returns data available at stdin also if there is no data
  available.
- In CegoAdminThread, for tableset and table import procedure added
  switch to next backup branch.
  This is required, since during import, logging is disabled.
  So after import, a new backup is needed.

devel/lfcbase,databases/cego: update 1.21.8 -> 1.22.1, 2.52.19 -> 2.52.20

lfcbase:
- Fixed BigDecimal class for internal constructor to
  normalize zero values to "0" and in scaleTo method to treat
  zero values correctly
- Added class Replacer to support string replacement based
  on regular expressions ( like unix sed )
- Fixed BigDecimal, scale handling still not correct for some cases
- Replacer: The match token has been changed to $ char to treat
  database integration

cego:
- Performance optimization added in CegoSelect and CegoDistCursor
  for or-condition handling:
  If an or-condition is recognized, the predicate is propagateed
  to the corresponding join level cursor and the evaluation is handled
  by the cursor.
  This can avoid large table cursor result sets for the embedding
  join and might improve overall performance of the query.
- For the new introduced query optimization, several code extensions
  have been added. In CegoPredicate, new methods map, getReduced,
  mapExpr and reduceExpr have been added to convert the "master"
  predicate to an appropriate form, which can be handled by CegoDistCursor.
  Also for for CegoDistCursor, the distSetup methods have been expanded
  to propagate the master predicate
- Added fix in CegoAction for the following query:
  select invid from invoice where status = ( select 'OPEN' );
  In CegoAction::noFromOption, for _coListStack has to be pushed empty coList
- Added verify010 db check with a small invoice er model. This is
  used for advanced query verification with multilevel nested views
  and other dynamic stuff which is also relevant to proof valid results
  from query cache

databases/cego,devel/lfcbase: update 2.52.17 -> 2.52.18, 1.21.7 -> 1.21.8

lfcbase:
- BigDecimal::scaleTo: added RoundMode parameter which can either be
  UP ( round up )
  DOWN ( round down )
  HALFUP ( round up if neigbours equidistant or higher ) or
  HALFDOWN ( rond down if neighbors are equidistant or lower )

cego:
- Added support for lfcbase-1.21.8 ( BigDecimal::RoundMode ),
  Round mode ist setup in dbxml via database ROUNDMODE attribute
  ( either UP, DOWN, HALFUP, HALFDOWN )

databases/cego,devel/lfcbase: update 2.52.4 -> 2.52.6, 1.21.6 -> 1.21.7

lfcbase:
- Added improvements to Pager class, e.g. case insensitive search and
  message box at end of search

cego:
- Small adaptions made for Debian
  ( in cgwtest.c, cast added to malloc for CGClob and CGBlob allocation ).
  There are still required some changes for the testsuite shell scripts
  to satisfy Debian flavour ( expimpcheck )
- Patch added in CegoCondition and CegoPredicate for arithmetic
  expression evaluation. The recent grammar modification limits
  enclosed arithmetic expression to logic expressions. This leads
  confusing results e.g. for
  select ( a + b ) / 2 from t1 since ( a + b )
  is evaluated as a condition with a logical value as the result
  ( true or false )
  ( caused by grammar production : Factor -> LB Condition RB )
  Arithmetic expressions are just parsed with grammar production
  Predicate -> Expr ( expression only ), so for this case now a
  special handling has been added
  ( with new introduced method CegoPredicate::getExprOnlyValue )

databases/cego,devel/lfcbase: 2.52.2 -> 2.52.4, 1.21.3 -> 1.21.6

lfcbase:
- To support several keyboard layouts, changed some window control
  sequences from Cntrl-Key to ESC key
- Added virtual method hasData to Pager class. The method must be
  implemented to indicate, if an execution returns a result set. If
  no result set is returned, just a message box is shown and edit
  mode is left ). This seems to be useful for DML queries ( insert,
  udate, delete, create, drop, ...)
- In Pager class, added buffer scrolling in editor part. Preparation
  started for Pager command history management
- Added history feature to Pager class. Command history can be loaded
  and saved with readHistory and writeHistory methods.
  Navigation through command history in Edit mode with Cntrl-P and Cntrl-N

cego:
- Adaptions made for pager and pager history feature

databases/cego: update 2.51.9 -> 2.25.2, devel/lfcbase: 1.20.1 -> 1.21.3

lfcbase:
- more patches for the Pager class
  Removed init_color with custom color for select cursor since the
  custom color seems to be poor supported for curses. Fixes added
  to Pager::writeFooter
- edit-feature in Pager (must discuss this with Bjoern 8-)
- ignore SIGINT in Pager
- change from unsigned long long to long long value in Datetime class
- pattern search feature for Pager class

cego:
- Small fix in CegoBufferPool.h
- CegoClient adapted to new Pager API
- Queries now can be interrupted with Cntrl-C also in pager mode
- adapt to Datetime long long values ( e.g. date2str from int to long long )

devel/lfcbase: update 1.20.0 -> 1.20.1

- Pager class ( windows resizing, added start of page and end of page option )

devel/lfcbase,databases/cego: update 1.19.1 -> 1.20.0, 2.51.8 -> 2.51.9

lfcbase:
- Rework of Pager class, which is a API change

cego:
- Made some adaptions for reworked lfcbase Pager class
  rows with multiline entries are more readable

databases/cego: update 2.51.1 -> 2.51.3, devel/lfcbase: update 1.19.0 -> 1.19.1

lfcbase:
- BigDecimal::div null value check

cego:
- CegoFactor::toChain to add braces for condition case
- CegoSelect::initAggregation, for sum and avg aggregation, aggregation
  value is initialized with 0 and appropriate datatype ( instead of
  null value ). This leads to numeric result 0 in case of empty result
  sets ( instead of null value )

*/*: update several cego related ports

devel/lfcbase 1.18.11 -> 1.19.0
- Changed Datetime::asLong to return signed long values ( long long ).
  This is needed to support timestamp values before 01.01.1970,
  which are signed negative

databases/cego 2.50.6 -> 2.51.0
- consolidate grammar productions for query conditions and
  procedure conditions
- Since CegoPredicate::CompType has received new type EXPRONLY,
  this requires a tableset export/import for upgrading to this version
  ( for predicate encoding / decoding )
- Several changed in CegoFieldValue to switch from Datetime integer
  type unsigned long long to long long. This is required to support
  datetime comparison for values before 01.01.1970

databases/cegobridge 1.8.1 -> 1.9.0
- adapt to cego 2.51.0

devel/lfcbase: update 1.18.8 -> 1.18.11

- patch for Screen2::Message class, since width and height may change
  for messages, window should be allocated new after each setInfo method call
- patch for Screen2::Grid class to support left and right alignment
  for data cols
- Added Net::serve6 method to handle v46 protocol an any adress.
- In new method Net::serve6, added setsockopt to disable IPV6_V6ONLY.
  This is required for FreeBSD build, since as default FreeBSD binds
  single stack

databases/cego: 2.49.9 -> 2.49.10, devel/lfcbase: 1.18.7 -> 1.18.8

lfcbase:
- patch to Screen2::Form::handleKey to treat pipe character ( | )
- patch to Screen2::Attribute::setAttrList for refresh window
  after attrlist has been updated
- Change in Screen2::Attribute class.
  The class now provides three layout modes : HORIZONTAL, VERTICAL, OVERLAY.
  In OVERLAY mode, with left and right cursor key it is switched
  to visible attribute list. For this, the Screen2::Attribute constructor
  has been changed

cego:
- For CegoAdmScreen, added QueryCacheInfo to tableset menu
- daptions made for CegoAdmScreen to
  handle lfcbase-1.18.8 API change for Screen2::Attribute

databases/cego: update 2.49.8 -> 2.49.9, devel/lfcbase: 1.18.6 -> 1.18.7

lfcbase:
- Added patch in Matcher.cc to support extended regular expression
  (added REG_EXTENDED flag to regcomp call )

cego:
- Added dedicated admin command to show query cache information
  including hit rate ( show querycache for tableset )
  This will replace the querycache information shown with general
  show tableset admin
  command
- Added patch for memory leak in CegoSelect. Within
  CegoSelect::consolidateConjunctionList method, predicate and condition
  instances are created for conjunction organisation. These instances
  have to be registered and freed later within CegoSelect::cleanUp
- Rework of table cache logic, which is still experimental. A table
  filter now can be defined to just cache a specified subset of tables.
  Since table cache is just useful for specific tables with read only
  flavor and medium size, this extension seems to makes sense. Cached
  table rows can be accessed directly without accessing buffer pool
  pages and without decoding. This might accelerate some database
  configurations, where query cache is not appropriate and hot spot
  readonly tables have to access very often and very fast.

devel/lfcbase: update 1.18.5 -> 1.18.6 and databases/cego: 2.48.29 -> 2.48.32

lfcbase:
- Patch added in Sleeper class to support larger values for milliSleep
  and microSleep. For this, also input parameter type has changed from
  int to unsigned long

cego:
- Patch added for CegoCaseCond::evalField to eval appropriate datatype.
  If the case condition contains null type this was not done correctly
- Added patch in CegoSelect::evalSchema. At the end of the method,
  schema ids are calculated to provide unique attribute ids for views
- support nested case conditions

Author:    Björn Lemke <lemke@lemke-it.com>

devel/lfcbase,databases/cego: update 1.18.3 -> 1.18.5, 2.48.19 -> 2.48.23

lfcbase:
- Added scrollable feature to Screen2::Message, so longer messages can
  now be handled by the panel
- improvements for Screen2:Message panel

cego:
- Added default append mode setting for tableset.
  WIth cgadm the appendmode can be setup ( e.g. enable appendmode for TS1 )
  It may be useful to have enabled appendmode at default for insert
  intensive tableset configurations
- Fix added for CegoAdmScreen in tableset parameter panel.
  Initfile was not setup correctly
  ( null value indicated, should be empty string )
- Changes in CegoAdmScreen::DBThread panel to show long queries
  with new Screen2::Message panel
- Patch added in CegoTableManager::updateTuple,
  reactivated evalExtTableReferences method call,
  since this is needed for update with nested selects,
  where external attributes are referenced
  in combination with enabled query cache
  ( e.g. update t1 set a = ( select a from t2 where t1.b = t2.b ) )

devel/lfcbase,databases/cego: update

lfcbase: 1.18.0 -> 1.18.3
- Opimization in Screen2 to customize screen refreshes
  ( introduced virtual method Panel::doRefresh )

cego: 2.48.15 -> 2.48.19
- Fix added for CegoAdmScreen, the data file root path was not added
  to new datafiles in the 'tableset add datafile mask'
- Fixes added for CegoAdmScreen, to avoid too many admin requests,
  backup panel and data file panel are just refreshed initially and
  after add objects.
- Fix added in CegoObjectManager::alterObject, the getNewFilePage has
  been changed to type CegoObject::SYSTEM. Otherwise, a page from a
  tuple datafile is allocated, which results in strange effects
- Some adaptions for extended Screen2 interface with refresh customizing.

devel/lfcbase: update 1.17.2 -> 1.18.0

- Fix for some geometries in Screen::showFormBox
- Further improvements for Screen::showFormBox and showInfoBox
  ( selected rows and newline treatment )
- integrate Screen2 interface

databases/cego: update 2.48.2 -> 2.48.10

- Introduced Backup branch id for online backup verification. Due
  to datafile page id constraints, just online backups can be recovered
  inside one backup branch. Creation of a tableset and adding a
  datafile to a tableset violates this contraint, so a new backup
  branch is created.
- Added backup branch option for backup manager. So just valid
  backup files can be treated by the manager. New sample backup manager
  available in samples/chkdb
- Further improvements for cgadm screen mode. confirm dialogs added
  and backup log history indicated for online backups in case of errors
- More improvements for online backup / restore. Branch id is now
  added to archive log filename, so in case of new created or data
  file modified tablesets, the corresponding logfiles can be filtered.
  Archive logfile information for ready-for-archive and archived
  logfiles has been added to archive log information
- Fixes added in CegoClient for dump mode. Some attribute and
  attribute values have not treated correctly ( default values,
  dimension for fixed attributes, clob values )
- Fixes added for CegoClient dump and batch mode, has been tested
  with more complex acc application
- Introduced grace mode for graceful object creation. Using this
  mode, views and procedures can refer to objects, which still not
  exist. This mode might be useful for initial loads ( e.g. from a
  dump file ) to avoid dependency errors
- Fix for CegoSelect::nextTuple, _cacheSchema was not setup for
  union selects in case of empty result of the first union entry.
  This leads to an exception with cache claim leak. The claim leak
  has also been fixed by adding a cleanUp call to CegoSelect destructor
- Fix added in CegoAction::execViewCreate(), in case of grace mode,
  empty schema must be stored with created view to force recompile
  via CegoDistManager::reloadView
- Added defTabSetId parameter to several toChain methods to write
  views, procedures and triggers without explizit tableset references.
  This might be useful, if a tableset dump just references objects
  for a single tableset and it should be loaded to a tableset with a
  different name. ( e.g. select a from t1@TS1 is written as select a
  from t1, if active tableset is TS1 )
- Fixes added for alias object usage ( e.g. in combination with views )
- Added lfcbase Screen2 support to CegoAdmScreen

databases/cegobridge: update 1.6.2 -> 1.6.3

- Build fixes added

Author:    Björn Lemke <lemke@lemke-it.com>

devel/lfcbase: update 1.16.6 -> 1.17.2, databases/cego: 2.47.31 -> 2.48.2

lfcbase:
- Improvements done for ncurses based Monitor class.
  Added confirm box and improved form box
- many changed have been made to Screen class ( was Monitor ).
  The changes require a recompile for consuming packages ( here : cego )
- Improvements done for Screen::showFormBox ( scrolling content in input mask )

cego:
- Fix added in CegoFactor and CegoFieldValue.
  To get the factor id for query cache management, a dedicated
  method was introduced in CegoFieldValue ( getId ) This method
  uses for DATETIME values valAsChain(true) ( to evaluate current
  timestamp in case of sysdate values ) and for all others toChain()
  ( to distinguish x = null and x = 'null' )
- Fix in CegoFunction::getId, the GETCOUNT function still was not
  treated
- Some cleanup of source file was done (removed tilde files)
- Added join optimization fix in CegoSelect::buildJoinTables.
  Inadequate predicates ( e.g. not equal compare ) are not priorized
  for table join order any more. For this the method
  CegoPredDesc::prioOnJoin has been introduced
- Grammar fix in Cego.def to ensure _returnOnFirst variable
  is set to false for non return update statements
  ( added production NoUpdateReturnOpt )
- Fix added in CegoTableManager::updateTuple,
  for the given expression list, contained subqueries must be
  retrieved and analyzed for external table references.
  Since the external count was not evaluated correctly, this led
  to a incomplete CegoSelect::getQueryId result.
  With enabled query cache, the following update did not work correct:
  UPDATE posrule pr SET artid =
    ( SELECT artid FROM article a WHERE a.artnr = pr.artnr );
- Fix added in CegoXMLSpace for user and role create routines.
  In case of already defined entities, exception was thrown
  before xml lock release
  Fix added in CegoXMLSpace::getActiveTableSet to also retrieve
  offline tablesets via includeOffline flag.
  This is needed for CegoLogThreadPool to archive occupied logfiles
  for tablesets in status offline ( for other reasons, runstate is
  set now at the beginning of the tableset stop procedure )
- many changes made in CegoAdmScreen class ( was CegoAdmMon )
  Several stabilization fixes also have been added. For database
  xml file, a unique database id has been introduced to validate
  ticket file from performed online backups ( db id must match )
- Small adaptions for cgadm screen mode window sizes
  ( corresponds to lfcbase-1.17.2 )

devel/lfcbase,databases/cego: update 1.16.5 -> 1.16.6, 2.47.27 -> 2.47.29

lfcbase:
- Added new method BigDecimal::scaleTo to change scaling for an instance.
  This includes an appropriate rounding, if scaling is reduced

cego:
- In CegoFieldValue::castTo, cast from varchar to fixed is done
  now with newly introduced BigDecimal::scaleTo method
  This includes an appropriate rounding in case of precision reduction.
- Fix in CegoCaseCondition to allow null types in condition
  see dbcheck/check106.sql for a sample

Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)

Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

This commit implements such a proposal and moves one of the WWW: entries
of each pkg-descr file into the respective port's Makefile. A heuristic
attempts to identify the most relevant URL in case there is more than
one WWW: entry in some pkg-descr file. URLs that are not moved into the
Makefile are prefixed with "See also:" instead of "WWW:" in the pkg-descr
files in order to preserve them.

There are 1256 ports that had no WWW: entries in pkg-descr files. These
ports will not be touched in this commit.

The portlint port has been adjusted to expect a WWW entry in each port
Makefile, and to flag any remaining "WWW:" lines in pkg-descr files as
deprecated.

Approved by:		portmgr (tcberner)

devel/lfcbase,databases/cego: update 1.16.4 -> 1.16.5, 2.47.26 -> 2.47.27

lfcbase:
- Fix in BigDecimal::operator ==, if _val, _scale and _isPositive
  do not match, we still have to call further checks

cego:
- Fix in CegoProcBlock::toChain, dimension has still not been
  treated for fixed procedure variables

devel/lfcbase: 1.16.3 -> 1.16.4, databases/cego: 2.47.24 -> 2.47.25

lfcbase:
- Fix added for BigDecimal to avoid rounding for zero trailing values,
  e.g. 119.00 / 100.00 was 1.1, should be 1.19

cego:
- Added small patch for verification check to meet new BigDecimal patch
  in lfcbase

devel/lfcbase: update 1.16.2 -> 1.16.3

- Added fix for BigDecimal comparison regarding negative values.
  For this, the private method compAbs has been introduced

devel/lfcbase: add missing USES=ncurses

While here, drop the regeneration of the configure script which is not
necessary, use INSTALL_TARGET to call the install-strip target provided
by the autotools, instead of manually stripping.

databases/cego: update 2.47.3 -> 2.47.6 and devel/lfcbase: 1.16.1 -> 1.16.2

lfcbase:
- Added HashT::getRangePos and HashT::RemovePos for more efficient
  hash array manipulation

cego:
- Fix in CegoQueryCacheEntry::cleanCache, reset of all relevant
  variables. Furthermore, in CegoQueryCache methods, remove from
  hasharray is checked for return code true
- Usage of new HashT methods ( getRangePos and RemovePos ) for
  CegoQueryCache to remove entries from query cache array more efficient
- Fix in CegoFactor::evalFieldValue(), for case CegoFactor::QUERY,
  the fetched value must be saved to a local copy, otherwise the
  buffer could be overwritten by the subsequent nextTuple method call
  to complete the query for query cache. As a result, wrong values
  are returned in case of heavy buffer cache relocation.

devel/lfcbase: update 1.16.0 -> 1.16.1

- Added HastT::FirstInRange and HashT::NextInRange methods to
  retrieve hash value range

One more small cleanup, forgotten yesterday. Reported by:	lwhsu

Remove # $FreeBSD$ from Makefiles.

devel/lfcbase: update 1.15.1 -> 1.16.0 databases/cego: update 2.46.8 -> 2.47.0

lfcbase:
- Introduction of template class HashT

cego:
- Integration of HashT into QueryCache for faster access of cached
  query entries
- Fix in CegoClient and CegoAction for comment parsing. Comment token
  in string are treated now. For this, a new method
  CegoQueryHelper::skipComment has been introduced
- Improvements done for query cache handling
  ( more support for nested queries, stabilization fixes )

Submitted by:	Björn Lemke <lemke@lemke-it.com>

devel/lfcbase: update 1.15.0 -> 1.15.1

- Fix in BigDecimal::div to treat negative values correctly
  ( for corScale calculation, the absolute values have to be used )

Submitted by:	Björn Lemke <lemke@lemke-it.com>

devel/lfcbase: update 1.14.6 -> 1.15.0 devel/lfcxml: update 1.2.11 -> 1.3.0 databases/cego: update 2.45.35 -> 2.46.0 databases/cegobridge: update 1.5.4 -> 1.6.0

Please note: database updates from 2.45.x to version 2.46.x require
a xml tableset export and import, since table structure information
has been changed!

lfcbase:
- Added template class GraphT for dependency graph implementations
- Fix in BigInteger::mul and BigInteger::div, signing was not treated
  ( e.g. -12 * 12 => -144 ( was 144 ) )

lfcxml: get in sync with lfcbase

cego:
- Added fix in CegoViewObject::getId. Since it cannot be decided,
  if the underlying query result has been changed, we have to
  throw MOD_QUERY_ID
- Another query cache fix in CegoFunction:getId, rand and liob
  functions have been added to throw MOD_QUERY_ID exception, since
  for those function it can not be ad hoc decided, if the result is
  modified
- Added type dimension information for CegoField class. This enables the
  database to define length and dim information for fixed and decimal
  data types. For this the syntax has been expanded. Instead of storing
  RESERVED_BTREE_FLOATLEN for btrees on fixed or decimal columns,
  the specified length information is used now.

Submitted by:	Björn Lemke <lemke@lemke-it.com>

devel/lfcbase: update 1.14.5 -> 1.14.6

- small changes for linux compat

Submitted by:	Björn Lemke <lemke@lemke-it.com>

devel/lfcbase: update 1.14.4 -> 1.14.5

- Fix added in BigDecimal::div method.
  Dividend has to be checked for zero value, otherwise the method ends
  in an infinite loop by evaluating corScale value

Submitted by:	Björn Lemke <lemke@lemke-it.com>

devel/lfcbase: upgrade 1.14.3 -> 1.14.4

- in basecheck/FileTest.cc remove include ioctl.h

Submitted by:	Björn Lemke <lemke@lemke-it.com>

devel/lfcbase: update 1.14.2 -> 1.14.3

- Increased in class Chain STATICBUFSIZE from
  50 to 100 and TMPBUFSIZE from 30 to 100
- Fix in Chain, replacement of sprintf with snprintf to avoid buffer
  overflow

Submitted by:	Björn Lemke <lemke@lemke-it.com>

devel/lfcbase: upgrade 1.14.0 -> 1.14.2 databases/cego: upgrade 2.45.5 -> 2.45.6

lfcbase:
- In configure.ac added check for darwin. This is required, since
  for File::flush implemention, darwin rather requires a fcntl call
  with option F_FULLFSYNC instead of fsync ( see OSX man page for
  fsync )

cego:
- Added command line option --fsync to enable physical disk synchronisation
  for logging and checkpointing. This options slows down database
  significantly but ensures consistent data in case of an operating
  system crash

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

devel/lfcbase: upgrade 1.13.1 -> 1.14.0

- Added File::hasData method to check for available input data from
  file descriptor ( implemented with POSIX poll function )

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

devel/lfcbase: upgrade 1.13.0 -> 1.13.1

- Stability patch in Datetime::asChain methods.
  The result of localtime is checked for null pointer ( may occur
  in case of very large long values, for which the instance has been
  created ) and in this case, an exception is thrown.

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

devel/lfcbase: update 1.11.9 -> 1.13.0 devel/lfcxml: update 1.2.6 -> 1.2.10 databases/cego: update 2.39.16 -> 2.44.1 databases/cegobridge: update 1.4.0 -> 1.5.0 databases/p5-DBD-cego: update 14.0 -> 1.5.0

- Warning: storage format has changed
  Export to xml format before upgrade and re-import after the upgrade
  See UPDATING
- recompile all applications linked to libcego
- Lots of changes, among them:
  o improved crash recovery
  o fixes to SQL expected behaviour
  o better CDATA handling
  o fixes primary key handling design issue
  o changes to serialisation for export/import, XML export/import is still
    possible

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Changelog:	http://www.lemke-it.com/litexec?request=pubnews&user=&lang=en&numlog=1000