Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
Commit | Credits | Log message |
2.48.45 17 Mar 2024 12:39:33 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.44 -> 2.48.45
- Added patches for return on update handling to treat value handling
in return list. The order in the return list must be stricter,
otherwise field evaluation via FLA caching in CegoFactor fails.
- returnList has been localized ( new method CegoQueryHelper::localizeFL )
to ensure correct values after update cursor ist closed. |
2.48.44 16 Mar 2024 12:30:50 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.43 -> 2.48.44
- CegoXPorter: improve exception handling for invalid export file names |
2.48.43 08 Mar 2024 18:58:35 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: 2.48.42 -> 2.48.43
- Added patch in CegoSelect::evalSchema to treat null values for union all,
added patch in CegoFunction::clone to treat counterId value |
2.48.42 15 Feb 2024 18:53:01 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.41 -> 2.48.42
- In CegoDistCursor::nextTuple, added query aborted check.
This is needed to abort long running inner and outer join selects |
2.48.41 13 Feb 2024 08:59:49 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.40 -> 2.48.41
- Patch added in CegoProcedure::cleanup to set pMasterBlock to zero.
In some cases, the setup master block lead to usage leaks for user
function calls. See check110.sql as a sample to cause this problem. |
2.48.40_1 07 Feb 2024 08:29:31 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: fix distinfo
Author: Björn Lemke <lemke@lemke-it.com> |
2.48.40 05 Feb 2024 10:09:53 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.38 -> 2.48.40
- Patch added in CegoAdminThread::srvParameterInfo to list current
QUEUEDELAY value and configured scandal formats ( SCANDATETIMEFORMAT )
- Small patch on CegoDistManager::startTableSet,
improvement for exception message added
Author: Bjoern Lemke <lemke@lemke-it.com> |
2.48.38 18 Jan 2024 19:02:19 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.37 -> 2.48.38
- Patch added in CegoQueryHelper::evalBetween
The comparison ( f2 <= f1 && f1 <= f3 ) has changed to
( f1 >= f2 && f1 <= f3 )
This forces a type cast to f1 datatype in case mismatched datatypes.
This might be useful for queries like
select a from v1 where a between '30.11.2023' and '31.12.2023';
where a cast should be done to date time value ( instead of string )
Author: Björn Lemke <lemke@lemke-it.com> |
2.48.37 21 Dec 2023 15:43:15 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.36 -> 2.48.37
- Patch added in CegoQueryHelper::encodeFL and CegoQueryHelper::decodeFL.
The dim field value was still not treated.
This might lead to wrong fixed values for update operations during
crash recovery operation
Author: Björn Lemke <lemke@lemke-it.com> |
2.48.36 13 Dec 2023 07:59:25 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.34 -> 2.48.36
- Renaming date function dateformat to scandate to reflect its
scanning function. Please note, that cegojdbc uses this
function in CegoPreparedStatement class.
- Fix in CegoXPorter for view import.
For view creation, the field entries in schema must be setup
with a unique id ( analog to view creation via sql command )
Author: Björn Lemke <lemke@lemke-it.com> |
2.48.34 16 Nov 2023 20:25:44 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.32 -> 2.48.34
- Add patch in CegoFactor::setFieldListArray, _flaCached again is
set to false since the field list in the the array may change
( e.g. for outer join queries used in views )
- In CegoDistCursor::getTuple, the tuple retrievel has been changed
for view objects. Complicated reasons... |
2.48.32 14 Nov 2023 14:32:09 |
Kurt Jaeger (pi) Author: Björn Lemke |
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> |
2.48.29 08 Aug 2023 09:06:00 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.28 -> 2.48.29
- Fix added in CegoAggregation::decode, c flag was
not decoded correctly ( wrong order in memcpy function ) |
2.48.28 30 Jul 2023 18:06:09 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.27 -> 2.48.28
- Fix added in CegoProcQueryStmt::execute,
after execution of the query, the cleanUp method must be called
to avoid leaks regarding stored proc object use
( this corresponds to the new optimized stored proc handling ) |
2.48.27 17 Jul 2023 10:18:36 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.25 -> 2.48.27
- Patch addd for tableset stop procedure.
With the new optimized stored procedure handling ( CegoFunction module ),
the object cleanup must be done BEFORE the tableset is finally stopped.
Otherwise an uncaught exception occurs ( tableset not online )
which results in database crash after tableset shutdown.
Several modules have been modified for this
- In CegoFunction constructors, added _pProc = 0 initialization
for decoding and fromElement constructors. This avoids a set fault,
in case of database recovery, when a predicate expression
with user function is dedoded from log file
Author: Björn Lemke <lemke@lemke-it.com> |
2.48.25 14 May 2023 10:12:13 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.48.23 -> 2.48.25
- Performance improved for stored procedures.
In CegoFunction, the procedure handle is now stored after first
stored procedure call ( instead of freeing the handle and requesting
it again with the next call )
So for subsequent function calls, the handle is already available,
which improves stored procedure execution time significantly.
As a consequene, code has been added for cleanUp the handle at
the end of the query ( object is also in use during the whole
query with CegoDatabaseManager::useObject and must be unused by cleanup )
- Patch added in CegoFunction to avoid useObject leaks |
2.48.23 28 Apr 2023 19:24:12 |
Kurt Jaeger (pi) Author: Björn Lemke |
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 ) ) |
2.48.19 07 Mar 2023 10:58:14 |
Kurt Jaeger (pi) Author: Björn Lemke |
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. |
2.48.15 26 Jan 2023 19:07:17 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: 2.48.14 -> 2.48.15
- Fixes added in CegoAction and CegoSelect to treat cego parser
with tablemanager pointer = 0.
This is needed for cegobridge to parse procedures and generated
other db specific code |
2.48.14 24 Jan 2023 10:49:11 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: 2.48.10 -> 2.48.14
- Fix added in CegoObjectManager::alterObject, after freeing old page entry,
page should be unfixed with marked as dirty. In the main loop,
unfix has been changed to dirty = false
- Added function dateformat which can be feeded with two expressions
to return a datetime value from a given format and value string (
analog to date(x,y) which expects constant input values )
- Added more date functions to the datefunc package. Now there are
the following date functions available
int second(datetime d)
int minute(datetime d)
int hour(datetime d)
int day(datetime d)
int month(datetime d) (Only the first 15 lines of the commit message are shown above ) |
2.48.10 03 Jan 2023 12:31:35 |
Kurt Jaeger (pi) Author: Björn Lemke |
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 (Only the first 15 lines of the commit message are shown above ) |
2.48.2 18 Nov 2022 19:23:16 |
Kurt Jaeger (pi) Author: Björn Lemke |
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() (Only the first 15 lines of the commit message are shown above ) |
2.47.31 23 Sep 2022 14:42:38 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: 2.47.30 -> 2.47.31
Fix added in CegoTableManager::alterDataTable, the altering table
object has to be retrieved completely via getObject to setup
data page id and last data page id. With the new introduced
object manager method alterObject, these values
are not copied during the alter procedure. |
2.47.30 23 Sep 2022 08:53:41 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: 2.47.29 -> 2.47.30
Fix in CegoObjectManager for alterTableObject.
If a new system page has to be allocated, this page was not linked.
This might lead to loss table objects for corresponding altering
queries. Furthermore, the ObjectManager has been cleaned up and
reduced in code size in such a way that generic create and alter
methods are now provided for all objects
( createObject and alterObject using encoding method inherited from
CegoDecodableObject ). This results in less code, since the create/alter
operations are just implemented once. |
2.47.29 22 Sep 2022 12:56:32 |
Kurt Jaeger (pi) Author: Björn Lemke |
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 |
07 Sep 2022 21:58:51 |
Stefan Eßer (se) |
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) |
2.47.27 07 Sep 2022 21:10:59 |
Stefan Eßer (se) |
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.
(Only the first 15 lines of the commit message are shown above ) |
2.47.27 16 Aug 2022 14:23:22 |
Kurt Jaeger (pi) Author: Björn Lemke |
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 |
2.47.26 10 Jul 2022 08:30:14 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.47.25 -> 2.47.26
- In CegoFieldValue, completed appropriate rounding via cast for
decimal types to integer types |
2.47.25 09 Jul 2022 14:22:06 |
Kurt Jaeger (pi) Author: Björn Lemke |
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 |
2.47.24 13 Jun 2022 09:25:23 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.47.22 -> 2.47.24
- Replaced Chain("") with Chain() for several. This was motivated by
an observed bug for check constraint xml import, where a comparision
between Chain() and Chain("") returned false
- Fix in CegoFunction::evalFieldValue for case REPLACE. If replace
string is null, then empty string is replaced instead of "null"
string.
Author: Björn Lemke <lemke@lemke-it.com> |
2.47.22 20 Feb 2022 13:03:57 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: upgrade 2.47.16 -> 2.47.22
- Fix in CegoFunction::clone, also if _exprList is empty, the function
must treated and cloned completely including table manager reference.
Otherwise, for user defined function with no arguments which are used
in views will throw an exception
- Change in CegoJDBCInfo for table list retrievel. This JDBC meta
information command is not split to tab and vie for dedicated
retrievel of table and view objects
- More work has been done regarding clean shutdown of the
database / tableset stop while busy db sessions still exist.
For this, CegoDistCursr desctructor method has been stabilized,
so no exception is thrown. Otherwise, double memory freeing of
cursor resources might occur which results in a crash
- In CegoTableManager::stopTableset, relocated the setTableSetRunState (Only the first 15 lines of the commit message are shown above ) |
2.47.16 16 Jan 2022 20:56:39 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.47.14 -> 2.47.16
- Fix in CegoAttrComp for equal, lt and gt operators.
The compMode ATTR was not treated correctly in a way, that the
attrDesc part was not evaluated. This might lead to missing attr
cond entries for sophisticated queries.
A verify check ( verify008 ) has been added to check this case
Author: Björn Lemke <lemke@lemke-it.com> |
2.47.14 05 Jan 2022 15:43:26 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.47.13 -> 2.47.14
- In CegoDistManager::startTableset the method setCurrentLSN
has to be called before registerObjects since this method
might also trigger checkpoints |
2.47.13 04 Jan 2022 19:33:23 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.47.11 -> 2.47.13
- Fix in CegoDistManager::renameLocalObject, before renaming the object,
it has to be checked, if the new object name is already in use
- Fix in CegoXPorter::readIndexObject, index schema expects tablename
instead of indexname.
As a result binary and plain imports with index objects have failed. |
2.47.11 23 Dec 2021 15:47:08 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: 2.47.7 -> 2.47.11
- Fix in CegoDistManager::startTableSet, the current lsn has
to be setup before performing the cleanup option. cleanup uses
bufferFix which might result in a checkpoint. For this the current
lsn has to be setup
- In CegoQuery, added execSchema which is copied for each execution
call from _schema ( to have a virgin schema definition ). The
execSchema then is enriched in the appropriate way. For the insert
query, an addExprList variable was decleare to store the addition
needed expression to complete the insert value list ( instead of
adding it to _exprListArray ). After performing the query, the
allocated and inserted expression have to be deleted. This
implementation seems to be more useful for procedure based queries,
where the intiantiated CegoQuery object is executed multiple times
- In CegoDistManager, reload message for views, procedure and trigger
is avoided now ( since this occurs for each db thread during startup )
- In CegoAttrComp::setup(ListT** pJoinBuf, int offset) the _isSetup
flag was not set to true for the posSetup case. This might lead to
invalid error message. See https://www.lemke-it.com/litexec?request=pubnews
for details
- Fix in CegoGroupSpace::getValueForAgg, The return value
( of type CegoFieldValue ) must be converted to a local copy,
since the reference to the bufferpool might be invalidated |
2.47.7 10 Oct 2021 19:16:41 |
Kurt Jaeger (pi) Author: Björn Lemke |
databases/cego: update 2.47.6 -> 2.47.7
- Added format correction in CegoField::castTo for case VARCHAR to
FIXED. In case of string values without leading zeros ( e.g. .345),
leading zero is concated.
Author: Björn Lemke <lemke@lemke-it.com> |
2.47.6 04 Jul 2021 07:48:24 |
Kurt Jaeger (pi) Author: Björn Lemke |
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. |
2.47.3 06 Jun 2021 11:47:45 |
Kurt Jaeger (pi) Author: Bjoern Lemke |
databases/cego: update 2.47.2 -> 2.47.3
- New generated parsers ( Cego.def and CegoAdm.def ) with dragon 1.5.5 |
2.47.2 24 May 2021 07:24:30 |
Kurt Jaeger (pi) Author: Bjoern Lemke |
databases/cegobridge: update 1.6.0 -> 1.6.1
Also update databases/cego: update 2.47.1 -> 2.47.2
cego:
- Fix in CegoQueryHelper::checkIndexForPredicate, wrong tabSetId
was used for getObjectListByTable, must be table specific
cegobridge:
- In method void MySQLAction::storeVarcharType, dimension value was
doubled, since MySQL calculates visible length for varchars and
cego length in bytes. So for multibyte character encodings, length
might exceed ... |
2.47.1 23 May 2021 21:24:19 |
Kurt Jaeger (pi) Author: Bjoern Lemke |
databases/cego: update 2.47.0 -> 2.47.1
- Rework of new hash array based query cache.
The new introduced methods HashT::FirstInRange and HashT::NextInRange
are used to find an appropriate hash array slot to replace entries
in an occupied array.
- Added cego command line mode setpwd to setup user password
for offline database |
2.47.0 07 Apr 2021 08:09:01 |
Mathieu Arnold (mat) |
One more small cleanup, forgotten yesterday.
Reported by: lwhsu |
2.47.0 06 Apr 2021 14:31:07 |
Mathieu Arnold (mat) |
Remove # $FreeBSD$ from Makefiles. |
2.47.0 21 Feb 2021 19:14:37 |
pi |
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: Bjorn Lemke <lemke@lemke-it.com> |
2.46.8 01 Feb 2021 15:37:31 |
pi |
databases/cego: update 2.46.7 -> 2.46.8
- Removed log entry in CegoDatabaseManager::checkTableSetRunState
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
2.46.7 29 Jan 2021 19:37:30 |
pi |
databases/cego: update 2.46.6 -> 2.46.7
- Added fix in CegoTableManager::createBTree
For btree value extraction, we also have to use
valueFromSchema(tableSchema, btreeSchema)
Otherwise, in case if inverted index attributes, the values are
not extraced correctly
Example:
create table t1 ( a int, b string(10));
insert into t1 values ( 1, 'alpha');
create btree b1 on t1(b,a); -- inverted, value for a would be
not setup correctly
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
2.46.6 24 Jan 2021 10:01:31 |
pi |
databases/cego: 2.46.5 -> 2.46.6
- Fix in CegoObjectManager / CegoDatabaseManager added.
The checkTableSetRunState method has been moved to CegoDatabaseManager.
This ensures a single point of check definition.
In the previous version, tableset RECOVERY mode was not treated for
useObject, unuseObject and objectExists method calls which might lead to
crash recovery abort.
Submitted by: Bjorn Lemke <lemke@lemke-it.com> |
2.46.5 05 Dec 2020 20:24:59 |
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> |
2.46.0 28 Nov 2020 19:28:22 |
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 ) |
2.45.35 18 Nov 2020 17:01:47 |
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> |
2.45.34 17 Nov 2020 20:22:20 |
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> |
2.45.32 16 Nov 2020 21:15:56 |
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> |
2.45.31 14 Nov 2020 15:46:09 |
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> |
2.45.28 25 Oct 2020 20:53:43 |
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> |
2.45.25 18 Sep 2020 08:01:38 |
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> |
2.45.23 17 Sep 2020 07:25:44 |
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> |
2.45.19 25 Aug 2020 09:16:17 |
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> |
2.45.18 14 Aug 2020 07:20:38 |
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> |
2.45.16 05 Jun 2020 18:05:04 |
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 ) |
2.45.9 01 Dec 2019 20:16:59 |
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> |
2.45.8 24 Nov 2019 17:29:30 |
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> |
2.45.6 18 Aug 2019 17:22:45 |
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> |
2.45.5 14 Jul 2019 07:48:02 |
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> |
2.45.1 07 Jul 2019 08:53:28 |
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> |
2.45.0 04 Jul 2019 19:13:00 |
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 ) |
2.44.14 19 Jun 2019 11:57:36 |
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> |
2.44.13 14 May 2019 05:23:19 |
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 ) |
2.44.12 11 May 2019 07:44:38 |
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> |
2.44.11 10 May 2019 09:19:07 |
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> |
2.44.10 04 May 2019 15:34:35 |
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> |
2.44.9 02 May 2019 12:50:47 |
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> |
2.44.8 28 Apr 2019 08:35:47 |
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> |
2.44.7 26 Apr 2019 07:35:55 |
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> |
2.44.6 23 Apr 2019 11:56:47 |
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> |
2.44.5 22 Apr 2019 14:11:46 |
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> |
2.44.4 22 Apr 2019 12:16:56 |
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> |
2.44.3 22 Apr 2019 06:57:54 |
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> |
2.44.1 21 Apr 2019 13:31:25 |
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 |
2.39.16_1 09 Apr 2019 14:04:50 |
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 |
2.39.16 24 Apr 2018 05:22:57 |
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> |
2.39.15 11 Apr 2018 11:24:41 |
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> |
2.39.14 09 Apr 2018 17:56:15 |
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> |
2.39.13 07 Apr 2018 17:22:23 |
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> |
2.39.12 05 Apr 2018 17:10:43 |
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> |
2.39.11 01 Apr 2018 14:00:47 |
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> |
2.39.9 29 Mar 2018 11:55:48 |
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> |
2.39.8 18 Mar 2018 10:57:01 |
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> |
2.39.7 10 Mar 2018 11:45:01 |
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> |
2.39.5 06 Mar 2018 18:26:49 |
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> |
2.39.4 05 Mar 2018 20:34:13 |
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> |
2.39.3 03 Mar 2018 09:10:07 |
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> |
2.39.2 01 Mar 2018 12:29:31 |
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> |
2.39.1 28 Feb 2018 18:53:11 |
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> |
2.38.20_1 25 Feb 2018 04:49:55 |
pi |
databases/cego: fix distinfo
Reported by: pkg-fallout |
2.38.20 24 Feb 2018 19:09:17 |
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> |
2.38.19 13 Feb 2018 20:25:50 |
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> |
2.38.18 02 Feb 2018 18:04:41 |
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> |
2.38.16 31 Dec 2017 19:28:21 |
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> |
2.38.14 20 Dec 2017 19:59:04 |
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> |
2.38.12 14 Dec 2017 16:56: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> |