Commit History - (may be incomplete: see SVNWeb link above for full details) |
Date | By | Description |
05 Dec 2020 20:24:59
2.46.5

|
pi  |
databases/cego: update 2.46.0 -> 2.46.5
- Fix in CegoExpr::evalField, fixed dimension was still not handled
here for ADD and SUB cases
- Added error msg improvement in CegoProcBlock
- Added MAXDELETEPAGE parameter to show parameter admin command
- set default checkpoint value for new defined tablesets
- added function check in CegoFunction::evalFieldValue to ensure, this is
not a procedure without return value
- Fix in CegoTableManager for table altering. No type conversion
allowed with alter modify and no length shrinking
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
28 Nov 2020 19:28:22
2.46.0

|
pi  |
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 (Only the first 15 lines of the commit message are shown above ) |
18 Nov 2020 17:01:47
2.45.35

|
pi  |
databases/cego: update 2.45.34 -> 2.45.35
- Added noinit option to cgadm tableset start command. With the
noinit option, the configured init file will not be processed after
tableset startup, otherwise this will be processed now ( if any
configured ) All output messages are written to main log file.
- Redirected output for CegoAction and CegoOutput added to print output
to logfile. This is useful in case of tableset init file, where
several SQL action could be performed
- Fix in CegoAction::execSetCounter, new value must be checked for
null value and if so, set counter to 0. The bug caused a seg fault ..
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
17 Nov 2020 20:22:20
2.45.34

|
pi  |
databases/cego: update 2.45.32 -> 2.45.34
- Improved runstate handling in CegoDistManager
- Further fix in CegoPredDesc::getFieldList, case CegoPredDesc::NULLCOMP,
getFieldList method call added for pExpr1,
in CegoPredDesc::setFieldListArray method calls added for
_pC and _pNotPred. For this, setFieldListArray method has been
introduced in CegoCondDesc. This fixes should complete case
cond handling e.g. for aggregation queries.
check097 has been expanded for this
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
16 Nov 2020 21:15:56
2.45.32

|
pi  |
databases/cego: 2.45.31 -> 2.45.32
- CegoObjectManager has been modified to check tableset run state
for several methods. For this, method
CegoObjectManager::checkTableSetRunState has been introduced.
- Added check in CegoDatabaseManager::objectExists to verify, if
corresponding tableset is online. So instead of "invalid object"
exception, a tableset offline exception is thrown, which might be
more useful
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
14 Nov 2020 15:46:09
2.45.31

|
pi  |
databases/cego: update 2.45.28 -> 2.45.31
- Added case-cond support for aggregation queries
- Fix in CegoCaseCond::evalField, all expression are evaluated now
and are checked for type mismatch. Expressions must return the same
type, otherwise this might lead to value evaluation problems. This
fix also leads to fix in CegoFieldValue::getDim() and CegoFactor::evalField
since now getDim ist used for field length specification which is
also compared by CegoCaseCond::evalField
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
25 Oct 2020 20:53:43
2.45.28

|
pi  |
databases/cego: update 2.45.25 -> 2.45.28
- Fix in CegoTableManager::insertDataTable, before call
getObjectListByTable, type must be checked ( must be CegoObject::TABLE
), otherwise ( for system objects ) not found exception arises.
This error may appear with the admin commands begin backup and end
back ( stat information is written to bustat system table )
- Added format fix to CegoAction::formatTableInfo, to treat very
long object names, max name length of all corresponding objects is
now calculated and output is printed in appropriate format
- Change in CegoAction::execProcCall and CegoAction::execFuncCall,
procedure/function arguments are evaluated and cast in this methods
now. This is needed, to support string to clob casting for procedure
arguments. As a consequence the CegoProcedure::execute method has
been changed to receive ListT instead of ListT.
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
18 Sep 2020 08:01:38
2.45.25

|
pi  |
databases/cego: update 2.45.23 -> 2.45.25
- Typo fix in CegoTerm::evalField and CegoExpr::evalField
- More rework on CegoFieldValue for improved cast handling
( especially on fixed values )
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
17 Sep 2020 07:25:44
2.45.23

|
pi  |
devel/lfcxml: update 1.2.10 -> 1.2.11
databases/cego: update 2.45.19 -> 2.45.23
lfcxml:
- Sync patch for MinGW package build
cego:
- Fix in CegoFieldValue::castTo, case VARCHAR_TYPE to FIXED_TYPE,
plain integers have not been accepted. check091 added for this
- Fix in CegoTerm::evalField and CegoExpr::evalField, type and
length calculation must correspond to cast logic in CegoFieldValue
( corresponding operators for mul, div, add and sub )
- Fix in CegoProcVar::setValue, a castTo has been added to cast to
appropriate target type
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
25 Aug 2020 09:16:17
2.45.19

|
pi  |
databases/cego: update 2.45.18 -> 2.45.19
- Fix in CegoAction::insertArg to check for duplicate attribute
specification in insert statement, e.g.
INSERT INTO t1 ( a, a ) VALUES ...
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
14 Aug 2020 07:20:38
2.45.18

|
pi  |
databases/cego: 2.45.16 -> 2.45.18
- Fix in CegoClient for treating interactive input. Ctl-D input
lead to segmentation fault, if used in multiline statements.
- Patch in CegoAction::formatTableInfo. For size calculation of
btree objects, null value must be used instead of INVALID, otherwise,
wrong values are indicated during btree build
- Patch in CegoLogManager::switchLogFile, we first have to switch log
file and then change the status to OCCUPIED. Otherwise, the logfile
archiver ( CegoLogThreadPool::shiftRedoLogs ) might access occupied
logfile in parallel. Since this is a different thread and File::open
seems to be not thread safe, bad things might happen ...
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
05 Jun 2020 18:05:04
2.45.16

|
pi  |
databases/cego: update 2.45.9 -> 2.45.16
- Fix in CegoBtreeManager for duplicate null handling. The corresponding
btree value has to be checked to be null. For this, the method
CegoBTreeValue::isNull has been introduced
- Fix in CegoFieldValue::negate, for FIXED_TYPE values, trailing
zeros have to be treated. Otherwise, select null - a from t1 where
a = 0.10 will result in 0.1
- Patch in 'update with return' clause. It seems to be useful, that
in combination with return, update should return after first matching
tuple providing the updated tuple in the return clause. So the
values for the tuple can be stored in procedure variables.
create table t1 ( a int, b string(30));
insert into t1 values ( 1, 'DONE');
insert into t1 values ( 2, 'DONE'); (Only the first 15 lines of the commit message are shown above ) |
01 Dec 2019 20:16:59
2.45.9

|
pi  |
databases/cego: upgrade 2.45.8 -> 2.45.9
- Fix in CegoBTreeManager, the allowDuplicateNull flag was not
treated any more. The duplicate handling has been moved from
CegoBtreeNode to CegoBtreeManager
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
24 Nov 2019 17:29:30
2.45.8

|
pi  |
databases/cego: upgrade 2.45.6 -> 2.45.8
- Fix in CegoSelect::setVIewCond, a view condition id has to be
calculated which is later used for getQueryId(). Otherwise, wrong
query cache entries are used in case of views with outer conditions
- Added method CegoBTreeNode::verifyLeafFull for full btree
verification in a sense, that each btree value is compared with the
corresponding table data entry via datapointer reference
- Improvement in CegoAdmAction for input handling. Used the same
methods for nextChar and friends as in CegoAction
- In CegoXMLSpace, changed access methods for mediator, primary and
secondary in a way, that the default value ist the current hostname.
In this case, no attribute values are set up. This reduces complexity
and avoids to change the entries manually, if the hostname changes
(do not edit the database xml without any deeper knowledge).
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
18 Aug 2019 17:22:45
2.45.6

|
pi  |
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> |
14 Jul 2019 07:48:02
2.45.5

|
pi  |
databases/cego: upgrade 2.45.1 -> 2.45.5
- Fix in CegoQuery::execute for INSERTBYSELECT_QUERY case.
Since the selected tuples are clustered ( MAX_CLUSTERED_INSERT) we have
to create a local copy for the corresponding field values.
Otherwise, tuple information could be invalidated by relocated
buffer pool pages
- Fix in CegoFieldValue::fastComp, the castTo method calls for t1
and t2 have to be switched, since first ist has to be checked to
cast to native btree datatype ( used in CegoBTreeCursor::traceLog,
inRange and fullMatch )
example:
create table t1 ( a int, d datetime);
create btree b1 on t1(b);
select a from t1 where b = '12.07.2019'; -- should be casted
-- from string to datetime
- Code cleanup to avoid warnings with -Wswitch-enum
- In CegoClient, added input data check via File::hasData ( available
with lfcbase 1.14.0 ). Now, pipe input is autodetected, so the
command line argument "--pipe" has been removed
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
07 Jul 2019 08:53:28
2.45.1

|
pi  |
databases/cego: upgrade 2.45.0 -> 2.45.1
- Treated alias insert queries with empty schema, e.g.
insert into a1 values ( 1, 'XXX');
- Some patches added for alias management to allow alias defintions
as a subset of the original table, e.g.
create table t1 ( a int, b string(10), c string(30))
create alias a1 on t1 ( a as ax, b as bx);
This has required some fixes in CegoAliasObject::mapSchema and
CegoQueryHelper::mapFLA
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
04 Jul 2019 19:13:00
2.45.0

|
pi  |
databases/cego: upgrade 2.44.14 -> 2.45.0
- Added table alias feature to grammar definition. Table aliases
allow alternate table name and attribute name definitions for a
table ( create alias ... )
- Added classes CegoAliasObject and CegoAttrAlias for table alias handling
- Implemented base semantic actions for creating, listing and
describe alias objects ( still no usage )
- In CegoDistManager::registerObjects, added registration for fkey,
check, trigger and alias
- Added alias mapping for insert, update and delete queries (
CegoQueryHelper::mapAliasPredicate still to implement )
- Basic alias mapping for select works, here's a sample SQL script
drop if exists table t1;
list alias; (Only the first 15 lines of the commit message are shown above ) |
19 Jun 2019 11:57:36
2.44.14

|
pi  |
databases/cego: upgrade 2.44.13 -> 2.44.14
- Some improved exception handling in CegoTableManager::checkIntegrity
( more detail information about violated object )
- Code cleanup CegoTableManager, drop/create/alter operations inside
a transaction no more allowed
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
14 May 2019 05:23:19
2.44.13

|
pi  |
databases/cego: upgrade 2.44.12 -> 2.44.13
- Further recovery fix in CegoTableManager::insertDataTable In case
of an insert exception ( e.g. duplicate pkey ), a checkpoint is
forced now after deleteData to ensure file consistency
In CegoObjectManager::insertPageData a second checkpoint is forced
after data copy, if a previous checkpoint has occured. Otherwise
this insert might be ignored during recovery because of lower LSN
- Fix in CegoBTreeManager::checkDuplicate, the check for uflag (
returned CegoBTreeNode::valueExists ) to check for high value is
not enough if, entries have been deleted from node.
Instead, all subsequent pages have to be checked until a value higher is found
- Introduced CegoBufferPool::getCPCount() to return to current
checkpoint count. This method is used by CegoTableManager,
CegoObjectManager and CegoTransactionManager to decide, if a (Only the first 15 lines of the commit message are shown above ) |
11 May 2019 07:44:38
2.44.12

|
pi  |
databases/cego: upgrade 2.44.11 -> 2.44.12
- Fix added in CegoTransactionManager::commitUpdate, btree must be
inserted with insertBTreeWithCommit
- Fix added in CegoTransactionManager::getCrashAffectedTables,
schema entry must be searched with Find(CegoField(Chain(),
SYS_RB_TABLE))
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
10 May 2019 09:19:07
2.44.11

|
pi  |
databases/cego: upgrade 2.44.10 -> 2.44.11
- Fix in CegoRecovery:::recoverCurrentTransactionLog, for LOGREC_INSERT
and LOGREC_DELETE, the corresponding index have to be invalidated
with CegoTableManager::invalidateIndexForTable. This logic was
already implemented but removed in context of more sophisticated
transaction handling ( patch 2.39.11 and around )
- Small fix in CegoObjectCursor constructor, changed _isEOC = false
to _isEOC = ( pageId == 0 ). This causes getFirst to return false
in case of truncated objects ( can occur for RBSEG objects )
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
04 May 2019 15:34:35
2.44.10

|
pi  |
databases/cego: upgrade 2.44.9 -> 2.44.10
- Fix in CegoAction::readChain() to support "\r" escape character
Fix in CegoBTreeCursor::getFirst, in case of pAttrCond = 0, getNext
has to be called if current leaf page is empty, otherwise cursor
trace is incomplete ( just used for CegoDistManager::verifyTable )
- Fix in CegoBTreeNode::getChildPage, parameter traceMin has been
introduced, which is needed to trace btree with
CegoBTreeManager::deleteBTree.
Otherwise, it might happen that non-unique btree objects are not found
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
02 May 2019 12:50:47
2.44.9

|
pi  |
databases/cego: upgrade 2.44.8 -> 2.44.9
- Removed legacy method CegoAggregation::setInit/isInit
- Fix in CegoQueryHelper::aggregateTuple, since the field value
reference for aggregation field value might be no more valid during
the aggregation run, a local copy is created via
CegoFieldValue::getLocalCopy.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
28 Apr 2019 08:35:47
2.44.8

|
pi  |
databases/cego: upgrade 2.44.7 -> 2.44.8
- Added method CegoClient::treateEscape to handle escacpe charaters
in command strings for interactive and batch mode ( newline, carriage
return und tab )
- Further optimization in CegoFunction::getReturnTypeLen, if the
length argument in left, right substr function is a constant, this
value is used for schema definition, otherwise the length of the
source is used. Example:
select left(a,3) from t1 => length 3 is used for schema
select left(a,b) from t1 => definition of a is used for schema
Further optimization done in CegoSelect and CegoAction for schema
evaluation.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
26 Apr 2019 07:35:55
2.44.7

|
pi  |
databases/cego: update 2.44.6 -> 2.44.7
- In CegoSelect::evalSelection, optimization provided in a way,
that schema is not evaluated explizit anymore. Rather the previous
analysed schema ( prepare method, _evalSchema ) is used. Since for
dynamic field length, the resulting schema must be estiamated, this
approach is ok.
- Fix added in CegoFunction::getReturnTypeLen, evalFieldValue for
expression values could fail, since FLA ist still not set up. For
this case, now the cont value RETVAL_LEN is returned as an estimation.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
23 Apr 2019 11:56:47
2.44.6

|
pi  |
databases/cego: update 2.44.5 -> 2.44.6
- Added some code cleanup and additional checks ( check082 and check083 )
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
22 Apr 2019 14:11:46
2.44.5

|
pi  |
databases/cego: update 2.44.4 -> 2.44.5
- Added fix in CegoAttrComp::setup, _posSetup variable was not setup
correctly for case BTWN / VALUE2VALUE which might lead to invalid
join array access.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
22 Apr 2019 12:16:56
2.44.4

|
pi  |
databases/cego: update 2.44.3 -> 2.44.4
- Added fix in CegoExpr::evalField and CegoTerm::evalField to provide
correct result type. This is required for fastserial protocol usage.
- Also added fix in CegoFieldValue::operators +-*/ to cast to the
largest value
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
22 Apr 2019 06:57:54
2.44.3

|
pi  |
databases/cego: update 2.44.1 -> 2.44.3
- Fix in CegoTableManager::deleteDataTable, before resolving external
table references via evalExtTableReferences, the subquery must be
prepared, to resolve local attributes first
- Optimization added in CegoBufferPool::bufferFix. If there is no
available slot in the bufferpool, a checkpoint is forced for the
corresponding tableset ( already implemented ). Now if still no
available slot, we force checkpoint for all other online tableset
of the database. This might be useful, if the bufferpool is heavily
occupied by other tablesets with dirty pages.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
21 Apr 2019 13:31:25
2.44.1

|
pi  |
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 |
09 Apr 2019 14:04:50
2.39.16_1

|
sunpoet  |
Update devel/readline to 8.0
- Bump PORTREVISION of dependent ports for shlib change
Changes: https://tiswww.case.edu/php/chet/readline/CHANGES
PR: 236156
Exp-run by: antoine |
24 Apr 2018 05:22:57
2.39.16

|
pi  |
devel/lfcbase: update 1.11.8 -> 1.11.9
databases/cego: update 2.39.15 -> 2.39.16
lfcbase:
- Introduced new method File::flush to force synchronization of data to disk
cego:
- Fix in CegoObjectManager::insertPageData, new data entry is checked
now for maximum available space in page. This is done if a new
data page has to be allocated and the data entry still fits not
into page
- Added File::flush method to CegoLogManager and CegoFileHandler
to synchronize log data and datafile data to disk
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
11 Apr 2018 11:24:41
2.39.15

|
pi  |
databases/cego: update 2.39.14 -> 2.39.15
- Fix in dbcheck/expimpcheck, test plan was not set up correctly
In CegoXPorter and CegoExpImpStream, row export information was
added again to indicate overall row export for each table
- Fix added in CegoDbThread::serveRequest ( GETBLOB and GETCLOB case ) and
CegoTableManager::getBlobData / getClobData chunkSize calculation. The
existing calculation did not treat every boundary case.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
09 Apr 2018 17:56:15
2.39.14

|
pi  |
databases/cego: update 2.39.13 -> 2.39.14
- Fix in CegoXPorter::writeRow and CegoXPorter::readRow for binary
export and import of tables containing lob null values. lob null
values must be identified by colLen unsigned long long = 0 instead
of integer = 0
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
07 Apr 2018 17:22:23
2.39.13

|
pi  |
databases/cego: update 2.39.12 -> 2.39.13
- Introduced CegoTransactionManager::getCrashAffectedTables method.
In case of a crash recovery, all transaction affected tables have
to be analysed for index objects. Before finishing transactions,
the index objects have to be invalidated ( since they might be
corrupted ) and after completion of transactions they have to be
recreated. This is done now in CegoTableManager::finishOpenTransaction
- Fixes in CegoLogManager, CegoRecoveryManager, CegoDistManager and
CegoTableManager for LSN handling. Instead of saving the next LSN,
now the current written LSN is recorded in CegoLogManager. This
seems to be more natural, since a lot of methods set up the LSN to
a value + 1. Also this fixes a mismatch between commited lsn and
current lsn, which leads to a tableset recovery during startup in
any case ( occured with version 2.39.9 )
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
05 Apr 2018 17:10:43
2.39.12

|
pi  |
databases/cego: update 2.39.11 -> 2.39.12
- Patch in CegoClient to catch format exceptions like
"Invalid datetime string <0> for format <%d.%m.%Y %H:%M:%S>"
This may happen, if on server side bad union selects are defined like
create view v1 as
select a as a, b as b from t1
union all
select a as a, 0 as b from t2;
where b is a datetime data type. In this case, invalid formatted
strings occur on the client side, which are catched now.
- Patch in CegoDatabaseManager::useObject to support lock
delay values > 1 sec. The DBM_LOCKDELAY value in CegoDefs has now
increased to 2500 msec. In some cases for heavy updates
( e.g. clob updates ) this might be useful to avoid ugly exclusive
lock delay messages in database log file
- Fix in CegoTableManager::updateTuple. If the update fails ( this
might happen, if another transaction actually updates the corresponding
tuple ), any allocated lob values are freed now. Otherwise the
data pages for the lob values were allocated with no more references.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
01 Apr 2018 14:00:47
2.39.11

|
pi  |
databases/cego: update 2.39.9 -> 2.39.11
- Improvements for log handling, the logIt method was moved from
CegoTableManager to CegoBufferPool. This allows a more adequate
locking of the logging actions. For this the tsLock array has been
removed from CegoTableManager and lmLock array has been set up in
CegoBufferPool. Since checkpoint writing occurs in CegoBufferPool
( which is also relevant for loging operations ), the logging method
is now part of CegoBufferPool.
- The logAction method in CegoLogManager has also been improved in
a way, that a log buffer is not allocated for each logging operation
anymore. Instead, a logBuf array has been defined for all tablesets
and the logBuf is reallocated, if the current logging record exceeds
the log buffer.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
29 Mar 2018 11:55:48
2.39.9

|
pi  |
databases/cego: update 2.39.8 -> 2.39.9
- Added fixes for recovery procedure in CegoTableManager. Now the
LSN is allocated at the beginning of critical operation to avoid
double operations in case of a forced checkpoint. For this the
CegoLogManager::nextLSN method has been introduced. Now it is no
more ensured that the log is written with increasing LSN, so some
logical parts of the recovery procedure in CegoRecoveryManager has
been changed.
- In CegoBufferPool, the writeCheckPoint method still returned int
value. This has been changed to unsigned long long
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
18 Mar 2018 10:57:01
2.39.8

|
pi  |
devel/lfcbase: 1.11.6 -> 1.11.7
databases/cego: 2.39.7 -> 2.39.8
lfcbase:
- Fix for memory leak in TreeT and AVLTreeT.
The = operator implementation did not empty the tree before copy.
- Additional fix to this release : Added regfree call to Matcher
destructor. Missing this call seems to cause a small memory leak
cego:
- Fix for memory leak in CegoPredDesc, pMatcher has not been cleaned up
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
10 Mar 2018 11:45:01
2.39.7

|
pi  |
databases/cego: update 2.39.5 -> 2.39.7
- Fix in CegoTableManager::deleteDataTable, pBlock has to be checked
for null value, otherwise crash recovery might crash. ( bug came
with 2.39.0 to check for pBlock->getTriggerValueList )
- Some clob related fixes in CegoQueryHelper::decodeNativeFVL /
decodeFVL relevant for recovery handling
- Fix in CegoRecoveryManager::recoverCurrentTransactionLog for the
INSERT case. For the blob/clob handling, the lobREf values have not
been set up correctly. This might lead to problems for table recovery
with more than one lob row ( e.g. table t1 ( a blob , b clob )
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
06 Mar 2018 18:26:49
2.39.5

|
pi  |
databases/cego: update 2.39.4 -> 2.39.5
- Bug fix in CegoAction::reallocateStringBuf, in the memcpy call,
just the previous stringBufLen has to be copied ( _stringBufLen -
MAXSTRINGLEN ). This bug might lead to seg fault in case of large
parser input ( e.g. clob strings )
- In CegoQuery for insert and insert-by-select case, allocated blob
and clob data ( by CegoQueryHelper::prepareFieldValue ) is cleaned
now if any exception occurs
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
05 Mar 2018 20:34:13
2.39.4

|
pi  |
databases/cego: update 2.39.3 -> 2.39.4
- Small bug fix in CegoDistManager, which came up with version
2.39.0. In method deleteLocalDataTable, the variable delCount was
declared two times, which lead to a result of 0 tuples deleted in
any case
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
03 Mar 2018 09:10:07
2.39.3

|
pi  |
databases/cego: update 2.39.2 -> 2.39.3
- Small improvement in CegoDbThreadPool. For a better db thread
load value calculation, the request queue is no longer locked while
waiting for incoming requests. Instead the QUEUEDELAY parameter has been
increased to a default value of 200 msec to reduce db thread cpu
load while idle. Now the db thread has a good chance to report
idle time to the db thread pool.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
01 Mar 2018 12:29:31
2.39.2

|
pi  |
databases/cego: update 2.39.1 -> 2.39.2
databases/cegobridge: update 1.3.0 -> 1.4.0
cego:
- Fix in CegoTableManager::updateTuple, while setting up expression
list, field list array must be setup BEFORE block ist set, since
field list is needed by block setup ( in case of subqueries for
prepare )
cegobridge:
- Adaptions for cego-2.39
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
28 Feb 2018 18:53:11
2.39.1

|
pi  |
databases/cego: update 2.38.20 -> 2.39.1
- Introduced table locking statements to set an explicit lock on a
table ( e.g. for update synchronisation ). This feature replaces
the "set update sync on/off" command
- Trigger implementation basically completed
- Fix in CegoQueryHelper::encodeFVL, for blob/clob values lists,
the corresponding index variables ( blobidx/clobidx ) have not been
increaed while encoding lob data. This might lead to invalid results
and seg faults in case of multiple lobs values in one insert/update
operation.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
25 Feb 2018 04:49:55
2.38.20_1

|
pi  |
databases/cego: fix distinfo
Reported by: pkg-fallout |
24 Feb 2018 19:09:17
2.38.20

|
pi  |
databases/cego: 2.38.19 -> 2.38.20
- For heavy update operations on tables with btrees using embedding
transactions, duplicate btree errors may occur. This is caused
by not checking corresponding tuple states. To solve this problem,
the following fixes have been done :
o Fix in CegoTableManager::checkBTreeIntegrity : The tuple state for
found entries has to be checked if state = COMMITTED
o Fix in CegoBTreeNode:checkForAffected ( was checkForDeleted before ) :
The tuple state has already checked for state
INSERTED if tid != dataTid
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
13 Feb 2018 20:25:50
2.38.19

|
pi  |
databases/cego: update 2.38.18 -> 2.38.19
- Fix in dbcheck/check065.sql for union sql in view.There must be
set up aliases for attributes in selection now
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
02 Feb 2018 18:04:41
2.38.18

|
pi  |
databases/cego: update 2.38.16 -> 2.38.18
- Fix in CegoTableManager::createForeignKey, for empty tables,
referenced attributes names have not been checked. This might lead
to invalid key objects.
- Fix in CegoSelect::prepare, expression alias in select list are
checked now for union selects. Alias definition in select expression
list should be identical for all select statements in union
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
31 Dec 2017 19:28:21
2.38.16

|
pi  |
databases/cego: update 2.38.14 -> 2.38.16
- Increased NETMNG_QUEUE_DELAY to 1000000 ( 1 ms ) to minimize CPU load
- Introduced QUEUEDELAY ( in usec ) config parameter to adjust queue
delay in database xml file. This allows to throttle down database
response time for incoming connection requests and minimize CPU
load
- Added dbcheck/check072.sql. This implements the calculation of
fibonacci numbers using stored procedures as a demonstration for
massive recursive procedure calls
- Optimization for procedure load in CegoFunction::evalFieldValue
( case USERDEFINED ), procedure is just loaded as a dedicated
instance ( via loadProcedure method ), if pMasterBlock is set. This
avoids ( expensive ) dedicated load, if the procedure is still not
in use by the corresponding thread. So just for recursive procedure
calls, the dedicated load happens.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
20 Dec 2017 19:59:04
2.38.14

|
pi  |
devel/lfcbase: update 1.11.4 -> 1.11.5
databases/cego: update 2.38.12 -> 2.38.14
lfcbase:
- Stability patch for strptime implementation ( MinGW only )
cego:
- Fixed memory lead in CegoDistManager destructor ( _pPA was not deleted )
- Further optimization done in CegoBTreeCursor, introduced methods
traceLow and inRange to treat btree comparison in a more efficient way
- Fix in CegoAttrCond::getIndexCond, like and no like comparisons
must be filtered out for new btree cursor tracing logic
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
14 Dec 2017 16:56:12
2.38.12

|
pi  |
databases/cego: update 2.38.10 -> 2.38.12
- Small optimization in CegoAttrCond::checkIndex, removed primary
flag, since this is done now by attribute ordering. This leads
to full index trace match instead of trace with index support and
so, additional unnecessary predicate evaluation is avoided.
- More rework for btree evaluation in CegoBTreeCursor
- Optimization in CegoBTreeCursor::getNext. Instead of calling
getNext in a recursive way, this is now done in a iterative way.
This might avoid heavy stacking in case of special query constraints
( e..g multi dimensional btrees and range conditions like a > 400
and b betweeen 'AAA' and 'DDD' )
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
10 Dec 2017 20:36:28
2.38.10

|
pi  |
devel/lfcbase: update 1.11.3 -> 1.11.4
databases/cego: update 2.38.9 -> 2.38.10
lfcbase:
- Fixes in TreeT class, changed methods First, Next, isEmpty and
compare operators to const
cego:
- Fix in CegoDistManager, we have to use a dedicated parser for
loadView and loadProc methods. Otherwise compilation may fail in
case of nested objects ( e.g. a view which references another view
object)
- Fix in CegoBTreeCursor, CegoAttrCond and CegoAttrComp, for
conflicting cursor conditions ( e.g. a = 4 and a < 1 ), the cursor
evaluation failed, since just the primary condition was treated.
- For CegoBTreeCursor, the method fullMatch has been introduced,
to make an final evalution in case of multi conditions.
- Also introduced: a ordering for CegoAttrComp set in
CegoAttrCond to treat more constraint conditions at the beginning
( EQUAL before LESS_THAN before NOT_EQUAL and so on )
- Changed CegoAttrCond compSet from SetT to TreeT.
This is required, since we need the ordering in the set.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
09 Dec 2017 10:52:32
2.38.9

|
pi  |
databases/cego: update 2.38.7 -> 2.38.9
- Introduction of new functions ascii ( get ascii character for
numeric value ) , ldiv and lmod ( div and mod operation for long
values )
- Modification in CegoFunction::evalFieldValue. To allow recursive
calls of user defined functions and procedures, dedicated procedure
instances are created for each call. This is done by parsing the
procedure text via CegoAction
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
02 Dec 2017 10:43:31
2.38.7

|
pi  |
devel/lfcbase: update 1.11.2 -> 1.11.3
databases/cego: update 2.38.6 -> 2.38.7
lfcbase:
- Improvements made for dedicated strptime implementation. The
function did not return null in case of unparsable date values.
This code is just used for MinGW compiles since there is no
implementation in the Standard C library available.
cego:
- Fix in CegoXPorter::readTableObject, the defintion for MAXROW BUF
still was defined locally and rowLen was noch checked.
- Optimization in CegoFieldValue::decode, memory was allocated via
malloc, rather _staticBuf should be used for performance reasons.
_isLocalCopy was not set to true
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
30 Nov 2017 20:09:17
2.38.6

|
pi  |
devel/lfcbase: update 1.11.1 -> 1.11.2
databases/cego: update 2.38.5 -> 2.38.6
lfcbase:
- More detailed exception messages for BigDecimal and BigInteger
cego:
- Fix in CegoFunction::getId and CegoSelect::getQueryId : with
enabled query cache, the following select is cached
select nextcount(mycount);
- Since nextcount is a modifying operation, this is not a good idea.
To avoid caching, CegoFunction now throws an Exception if
nextcount / setcount function calls are detected during getQueryId.
For these cases, the query id ignored for caching
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
25 Nov 2017 12:54:49
2.38.5

|
pi  |
databases/cego: update 2.38.3 -> 2.38.5
- Fix in CegoBTreeValue::valueFromSchema, introduced method
getReservedLength to return fixed value length for type fixed and
decimal. Since for decimal and fixed type just the dimension is
stored in CegoField::getLength, we must define a reserved area
for those types. This is done now with constant definition
RESERVED_BTREE_FLOATLEN in CegoDefs.h
- Improved ordersize calculation in CegoOrderSpace:insertTuple. Now
the following formula is used :
int s = sizeof(fv);
if ( fv.getLength() > STATICFIELDBUF )
s += fv.getLength();
orderEntryLen += s;
The catches the base memory usage for the instance but also the
dynamic allocated part
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
22 Nov 2017 18:46:12
2.38.3

|
pi  |
databases/cego: update 2.38.1 -> 2.38.3
- Fix in CegoXMLSpace::setTSSortAreaSize, changed type from int to
unsigned long long, otherwise overflow may occur for large sort
area size configurations
- Performance optimization done in CegoOrderSpace. Instead of storing
the CegoField list for the result tuple in CegoOrderNode, just the
values are stored there. The order cursor now gets the schema with
the constructor and build the CegoField List in the getFirst /
getNext methods. This seems a huge amount of heap space, which is
dynamically allocated during the sorting procedure ( sortareasize
parameter ).
Especially for large ordering result sets this saves significantly
memory and improves performance.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
19 Nov 2017 09:33:10
2.38.1

|
pi  |
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 <lemke@lemke-it.com> |
18 Nov 2017 08:34:07
2.38.0

|
pi  |
databases/cego: update 2.37.3 -> 2.38.0
databases/cegobridge: update 1.2.1 -> 1.3.0
cego:
- 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.
cegobridge:
- 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 <lemke@lemke-it.com> |
15 Nov 2017 12:32:34
2.37.3

|
pi  |
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 <lemke@lemke-it.com> |
10 Nov 2017 19:09:34
2.37.1

|
pi  |
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 <lemke@lemke-it.com> |
08 Nov 2017 10:23:00
2.37.0

|
pi  |
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
lfcbase:
- 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
cego:
- 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 ) |
01 Nov 2017 17:42:35
2.36.4

|
pi  |
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
cego:
- 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
cegobridge:
- Speed up imports by changing the way the parser reads the input
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
01 Nov 2017 06:44:05
2.36.3

|
pi  |
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
reasons.
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
30 Oct 2017 19:36:54
2.36.2

|
pi  |
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 <lemke@lemke-it.com> |
29 Oct 2017 10:42:23
2.36.1

|
pi  |
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 <lemke@lemke-it.com> |
30 Sep 2017 06:17:07
2.36.0

|
pi  |
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 <lemke@lemke-it.com> |
17 Sep 2017 18:23:36
2.35.10

|
pi  |
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 <lemke@lemke-it.com> |
09 Sep 2017 20:38:04
2.35.8

|
pi  |
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 <lemke@lemke-it.com> |
03 Sep 2017 09:44:23
2.35.4

|
pi  |
databases/cego: update 2.35.3 -> 2.35.4
- Added tuple information command tupleinfo to indicate
tuple state information for a given table
( COMMITTED, INSERTED, DELETED, OBSOLETE )
- 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 <lemke@lemke-it.com> |
02 Sep 2017 10:08:30
2.35.3

|
pi  |
devel/lfcxml: update 1.2.4 -> 1.2.5
databases/cego: update 2.35.2 -> 2.35.3
lfcxml:
- Small improvement in XMLSuite::nextChar to check for non-ASCII characters
cego:
- 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 <lemke@lemke-it.com> |
25 Aug 2017 19:50:19
2.35.2

|
pi  |
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 <lemke@lemke-it.com> |
24 Aug 2017 17:20:17
2.35.1

|
pi  |
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 <lemke@lemke-it.com> |
23 Aug 2017 14:32:57
2.35.0

|
pi  |
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
correctly.
- 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 ) |
12 Aug 2017 12:21:23
2.34.0

|
pi  |
devel/lfcbase: update 1.9.7 -> 1.10.0
databases/cego: update 2.33.22 -> 2.34.0
lfcbase:
- Adoptions made in CommandExecuter and Outstream for MINGW builds
- Added Datetime advanced constructor for more efficient datetime construction
cego:
- 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 <lemke@lemke-it.com> |
05 Aug 2017 12:12:36
2.33.22

|
pi  |
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 <lemke@lemke-it.com> |
29 Jul 2017 07:01:49
2.33.21

|
pi  |
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
methods
- 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 <lemke@lemke-it.com> |
22 Jul 2017 08:34:58
2.33.20

|
pi  |
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 <lemke@lemke-it.com> |
16 Jul 2017 13:47:20
2.33.19

|
pi  |
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 <lemke@lemke-it.com> |
14 Jul 2017 06:22:06
2.33.18

|
pi  |
databases/cego: update 2.33.16 -> 2.33.18
- Method cleanup in CegoSelect.cc, 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
getCounterValue.
- 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 <lemke@lemke-it.com> |
29 Jun 2017 05:38:13
2.33.16

|
pi  |
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
caller
- Seg faults have been experienced for delete with double nested
subselect conditions ( see check055 )
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
27 Jun 2017 13:46:53
2.33.14_1

|
sunpoet  |
Update devel/readline to 7.0 patch 3
- Bump PORTREVISION for shlib change
Changes: https://cnswww.cns.cwru.edu/php/chet/readline/CHANGES
https://lists.gnu.org/archive/html/bug-bash/2016-09/msg00107.html
https://lists.gnu.org/archive/html/bug-readline/2017-01/msg00002.html
Differential Revision: https://reviews.freebsd.org/D11172
PR: 219947
Exp-run by: antoine |
03 Jun 2017 18:48:09
2.33.14

|
pi  |
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 <lemke@lemke-it.com> |
27 May 2017 07:39:21
2.33.12

|
pi  |
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 <lemke@lemke-it.com> |
25 May 2017 20:03:54
2.33.11

|
pi  |
databases/cego: update 2.33.9 -> 2.33.11
- Fix in CegoObjectManager::createBTreeObject to avoid some duplicate btree
entries
- 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"
occurs.
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 <lemke@lemke-it.com> |
07 May 2017 11:50:49
2.33.9

|
pi  |
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 <lemke@lemke-it.com> |
22 Apr 2017 15:29:38
2.33.8

|
pi  |
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
condition.
- 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 <lemke@lemke-it.com> |
22 Apr 2017 12:45:43
2.33.6_1

|
miwi  |
- Fix shebangs |
14 Apr 2017 14:30:12
2.33.6

|
pi  |
devel/lfcbase: update 1.9.3 -> 1.9.6
databases/cego: update 2.33.5 -> 2.33.6
lfcbase:
- 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)
cego:
- Small improvements for utility scripts cgmkdb, logManager and backupManager
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
07 Apr 2017 19:56:49
2.33.5

|
pi  |
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 <lemke@lemke-it.com> |
02 Apr 2017 08:01:52
2.33.4

|
pi  |
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 <lemke@lemke-it.com> |
01 Apr 2017 08:18:38
2.33.3

|
pi  |
devel/lfcbase: update 1.9.2 -> 1.9.3
databases/cego: update 2.33.1 -> 2.33.3
lfcbase:
- Small fixes for Monitor and Pager class, adding missing ifdef for
curses option in Pager class, replaced CGNOCURSES with LFCNOCURSES
cego:
- 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 ) |
26 Mar 2017 09:02:55
2.33.1

|
pi  |
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 <lemke@lemke-it.com> |
25 Mar 2017 18:06:25
2.33.0

|
pi  |
devel/lfcbase: update 1.9.1 -> 1.9.2
databases/cego: update 2.32.14 -> 2.33.0
lfcbase:
- Added CommandExecuter::executeStream method to catch stdout for
any forked process
- Added class OutStream to catch stdout from forked programs via popen
cego:
- 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 ) |
11 Mar 2017 19:33:22
2.32.14

|
pi  |
devel/lfcbase: update 1.9.0 -> 1.9.1
databases/cego: update 2.32.11 -> 2.32.14
lfcbase:
- Small fix for Monitor::showFormBox, in case of menu elements,
delete key is disabled
cego:
- 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 ) |
05 Mar 2017 11:08:50
2.32.11

|
pi  |
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
devel/lfcbase:
- 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
databases/cego:
- 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 ) |
29 Jan 2017 09:36:37
2.32.8

|
pi  |
devel/lfcebase: update 1.8.11 -> 1.8.12
databases/cego: update 2.32.7 -> 2.32.8
lfcbase:
- Changed methods for class Sleeper to static. Added Sleeper class
test to test suite
- Added include file limits.h in Chain.cc. For Linux compiles, this
include is required ( definition of INT_MAX and INT_MIN )
cego:
- Small improvements for CegoAdmMon curses based admin console
Submitted by: Bjoern Lemke <lemke@lemke-it.com> |
21 Jan 2017 15:10:16
2.32.7

|
pi  |
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 <lemke@lemke-it.com> |