non port: databases/cego/pkg-plist |
Number of commits found: 28 |
Sunday, 4 Jul 2021
|
07:48 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.
5aa5b64 |
Thursday, 4 Jul 2019
|
19:13 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;
desc alias a1;
drop if exists alias a1;
create table t1 ( a int, b string(30));
create alias a1 on t1 ( a as ax, b as bx );
insert into a1 ( ax, bx ) values ( 1, 'XXX');
insert into a1 ( ax, bx ) values ( 2, 'YYY');
insert into a1 ( ax, bx ) values ( 3, 'ZZZ');
select ax from a1;
- More work on table alias handling. Now works with more sophisticated
select queries ( e.g. select ax from a1 aa where aa.ax = 1; ) For
this, some fixes had to be done in CegoContentObject, since the the
table alias attribute ( _tabAlias ) was not setup in constructor
and other methods
- Added alias and trigger xml export and import feature ( trigger
xport was still not implemented ) Fix in CegoDbThread::loadObjects
for trigger reload, instead of triggerList.Next(), triggerList.First()
was called, which result in an infinite loop in case of existing
trigger objects
- Added trigger and alias object handling to CegoXPorter binary
export and import
Submitted by: Bjoern Lemke <lemke@lemke-it.com>
|
Sunday, 21 Apr 2019
|
13:31 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
|
Wednesday, 28 Feb 2018
|
18:53 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>
|
Saturday, 25 Mar 2017
|
18:06 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
also might lead to wrong cursor results
- Introduced archive manager, which can be triggered, to perform
an online backup. For now, online backups have to be triggered
externally.
The achive manager should make backup / restore handling more convenient
- Update to version 2.33.0 since the backup feature changes the product
specification.
- Integration of newly introduced lfcbase OutStream class to catch output
from backup manager. This allows to indicate a more detailed
output from backup manager on the admin console.
Submitted by: Bjoern Lemke <lemke@lemke-it.com>
|
Saturday, 6 Feb 2016
|
15:59 pi
devel/lfcbase: 1.7.0 -> 1.7.2
databases/cego: 2.28.3 -> 2.29.1
databases/cegobridge: 1.1.1 -> 1.1.2
Please note: Updating cego databases needs an export/import
cycle for 2.28 -> 2.29
lfcbase:
- Fix in Datetime.cc, added include config.h, otherwiese the local
implementation of strptime ist used. This should just be done, if
the system API does not provide this call ( e.g. MINGW ) .
- Memory leak fixed in File::readLine
cego:
- Started with clob datatype implementation
- Fix in CegoSelect constructor, _cacheEnabled var was not initialized
in the decoding constructor, which might lead to core dumps in case
of recovery of complex with enabled querycache Fix in CegoAdminThread
constructor, disableAuth method for TableManger called, otherwise
tableset recovery might fail with auth error
- Required network protocol expansions done for clob handling
(putclob, getclob, delclob)
- More work on clob handling. A fix was done for update operations
on clob values in CegoTableManager::updateTuple method. Before
updating the tuple, all clob references must be cloned, otherwise
in case of untouched clobs, references are invalid. This approach
is brute force, better would be, to stay on the untouched clob
references. But in terms of transaction and recovery handling,
this is not trivial
- Very long strings are handled now in CegoAction and CegoClient
to also parse large clob values
- Modification in cgclt for raw mode, Now just plain data is listed,
with the command line option --raw=X, a separator token can be setup
as a column separator
cegobridge:
- fix build problem
Submitted by: Bjoern Lemke <lemke@lemke-it.com>
|
Saturday, 7 Nov 2015
|
09:28 pi
databases/cego: 2.26.7 -> 2.26.9
- Version passed concurrent load test with 10 million concurrent
operations ( random insert, update and delete on one table with 2
processes )
- Fix in CegoFileHandler::allocatePage, In case of page exceed with
appendMode = true, a second try is done with appendMode = false
- Small fix in CegoObjectManager::reorgObject, ref page id information
for append mode is set to new last page id
- Small fix in CegoSelect::filterRefs, allow expressions with constant
values ( getAttrRefList= 0 ) in aggregation
- Locking improvements for delete and update operations.
All delete operations are done now via transactions ( introduced
CegoTableManager::deleteDataTableAtomic ). This allows to use a
shared lock as the table lock for using the table
(CegoDistManager::deleteLocalDataTable and
CegoDistManager::updateLocalDataTable )
As a result, a table can be accessed in parallel during a ( long
running ) delete operation on the table( e.g. delete from table).
E.g. select count(*) from table will not block anymore, rather
indicates the remaining number of tuples in the table.
This modification is still under investigation and must verfied
( also in combination with btree/index objects on the table )
- Fix in CegoBTreeManager::deleteBTree, the relevance value was not
calculated correctly
Fix in CegoQuery, cache invalidation is done before query operations.
Otherwise, if the query is aborted, an exception is thrown and
the cache is not cleaned
- Small modifications on cgblow load simulation client
- Changed locking for delete an update operations to exclusive due
to concurrency prpblems with btree operations
- Added page locking to AVLIndexManager and AVLIndexCursor
- Improvements for locking done. Since locking is done on page level,
Insert and delete operations can be done now in parallel . For this
locking had to be introduced in CegoBtreeManager::insertBTree and
CegoBTreeManager::deleteBTree
Further performance path for grouping queries in CegoGroupSpace.
Since the current grouping key is stored now in the class variable
_groupSchema, some expensive list copy operations could be avoided.
This improves performance for about 4%.
Submitted by: Bjoern Lemke <lemke@lemke-it.com>
|
Friday, 11 Sep 2015
|
06:19 pi
databases/cego: 2.24.4 -> 2.25.0
- Added throw statement for stored procedures. This allows to throw
exceptions on application level
Submitted by: Bjoern Lemke <lemke@lemke-it.com>
|
Saturday, 29 Aug 2015
|
08:37 pi
databases/cego: 2.23.12 -> 2.24.3
- Implemented query cache
http://www.lemke-it.com/litexec?request=pubcegodoc&user=&lang=en§ion=cgdoc_cgadm.html#cgadm_querycache
- SQL keywords can now be used case-insensitive, with proper CSMODE
http://www.lemke-it.com/litexec?request=pubcegodoc&user=&lang=en§ion=cgdoc_database_running.html#compatattr
Submitted by: Bjoern Lemke <lemke@lemke-it.com>
|
Friday, 15 May 2015
|
20:48 pi
databases/cego: 2.23.0 -> 2.23.1
Added some missing include files to be installed
Submitted by: Bjorn Lemke <lemke@lemke-it.com>
|
Thursday, 14 May 2015
|
06:01 pi
databases/cego: 2.22.0 -> 2.23.0
- Introduced CegoDatabaseFormater.
Since the API has changed (proagation of database formatting methods),
this is 2.23.0
Submitted by: Bjorn Lemke <lemke@lemke-it.com>
|
Sunday, 15 Feb 2015
|
16:52 pi
databases/cego: 2.20.19 -> 2.20.20
- Added fork+setsid system calls to daemon mode
- rc.d script is now part of the distribution
Submitted by: lemke@lemke-it.com (author)
|
Monday, 20 Oct 2014
|
10:41 bapt
Cleanup plist
|
Saturday, 14 Jun 2014
|
20:14 pi
databases/cego: 2.20.9 -> 2.20.10, USES libtool, strip libs
Submitted by: lemke@lemke-it.com
|
Tuesday, 22 Oct 2013
|
04:55 danilo
- Update from 2.19.6 to 2.19.7 [1]
- Add stage support [1]
- Convert LIB_DEPENDS to new syntax
PR: ports/183128
Submitted by: Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer) [1]
|
Thursday, 23 May 2013
|
09:31 zeising
Move devel/lfc to devel/lfcbase, to avoid conflicts with other software using
liblfc as name. [1]
Update devel/lfcbase to 1.5.4: [1]
Several shared lib issues were addressed
The license was changed from GPLv2 to GPLv3.
Update devel/lfcxml to 1.1.3 and chase the move of devel/lfc [2]
Update devel/dragon to 1.3.10 and chase the move of devel/lfc [3]
Update databases/cego to 2.18.6 and chase the move of devel/lfc [4]
Several shared lib issues were addressed.
The license was changed from GPLv2 to GPLv3.
Update databases/my2cego to 1.1.3 and chase the move of devel/lfc [5]
Updated the autoconf setup
Changed License from GPLv2 to GPLv3
PR: ports/178745 [1]
ports/178746 [2]
ports/178747 [3]
ports/178752 [4]
ports/178754 [5]
Submitted by: Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer) [1-5]
|
Monday, 2 Jul 2012
|
06:48 culot
- Update to 2.13.2 [1]
- Fix plist
PR: ports/169589 [1]
Submitted by: Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
|
Monday, 14 May 2012
|
19:20 culot
- Update to 2.13.0
Changes: http://www.lemke-it.com/cego_blog.html
PR: ports/167838
Submitted by: Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
|
Wednesday, 20 Jul 2011
|
12:57 culot
- Update to 2.10.10 [1]
- Add missing entries to pkg-plist (cgbackup, cgmkdb and cgrecover)
PR: ports/159054 [1]
Submitted by: Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
|
Sunday, 1 May 2011
|
22:42 pav
- Fix typo
Reported by: pointyhat
Pointy hat to: bapt (for committing without testing)
|
Tuesday, 26 Apr 2011
|
13:01 bapt
fix plist
Reported by: pointyhat (pav and erwin)
|
Sunday, 24 Apr 2011
|
09:54 bapt
- update to 2.8.3
- use of USERS/GROUPS macros
- add rc script
PR: ports/155405
Submitted by: Kurt Jaeger <fbsd-ports _at_ opsec.eu> (maintainer)
|
Friday, 1 Oct 2010
|
23:15 makc
Update to 2.6.14
PR: ports/150677
Submitted by: Kurt Jaeger (maintainer)
|
Wednesday, 18 Aug 2010
|
22:41 lwhsu
- Update to 2.6.8
PR: ports/149779
Submitted by: Kurt Jaeger <fbsd-ports AT opsec.eu> (maintainer)
|
Saturday, 24 Jul 2010
|
16:27 sahil
- Update to 2.6.4 [1]
- Remove redundant DISTNAME assignment
- Remove license files from pkg-plist
PR: ports/148518 [1]
Submitted by: Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
|
Monday, 5 Jul 2010
|
13:31 sylvio
- Update to 2.6.3
PR: ports/148298
Submitted by: Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
Feature safe: yes
|
Sunday, 4 Jul 2010
|
14:40 sylvio
- Update to 2.6.2
PR: ports/148298
Submitted by: Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
Feature safe: yes
|
Thursday, 1 Jul 2010
|
05:49 miwi
Cego is a Relational Database Management System (RDBMS). Cego
supports transactional SQL query requests in a multithreaded
architecture. For high availablility requirements, Cego supports a
database shadowing feature. Several compute nodes can be defined in
a Cego database configuration, where each node is able to manage a
number of so called table sets. For each tableset, a backup node
can be defined, which runs is recover mode for the corresponding
tableset. If required, the tableset can be switched to the backup
node and this node gets the active node for the tableset.
Many more details are available at:
WWW: http://www.lemke-it.com/
PR: ports/147822
Submitted by: Kurt Jaeger <fbsd-ports at opsec.eu>
Feature safe: yes
|
Number of commits found: 28 |