× News Cego SysMT Croom Web Statistics Impressum
SysMT Logo
Change Log

In the following, change log entries for the managed software packages are shown

Last 10 30 100 1000 10000 entries

Category Date Version Log
cego 01.08.2025 2.52.25 Version released
cego 01.08.2025 2.52.25 Fix added in CegoAttrCond::asConjunctionList, for the _isAnd == false case, the attr name also must be mapped to alias name from expression list to satisfy views, where attribute names are mapped
cego 31.07.2025 2.52.24 Version released
cego 31.07.2025 2.52.24 Added fix for combined conditions with in-expr predicate ( in-expr and comparison, e.g invnr like '%4711%' and status in ( 'EDIT', 'REVIEW' )
For these kind of conditions, CegoQueryHelper::checkAttrCond must priorize one of the predicates. For this, new method CegoAttrCond::hasIndexCandidate has been introduced
cego 27.07.2025 2.52.23 Version released
cego 26.07.2025 2.52.23 The optimization expansion basically works. Several code modules around CegoAttrCond have been adapted to support this expansion. Execution plans for several test cases look good and test suite runs without any errors.
cego 25.07.2025 2.52.23 Started with further join optimization for in-exprlist-Conditions. This idea is, to expand CegoAttrCond with a isAnd-Flag. If flag ist not set, the contains CegoAttrComp set which are treated as a or-list. CegoTableCursor then uses this or-list ( instead of a and-list ) and traces for each attribute comparison via btree cursor
This optimization will just work for in-expr conditions ( e.g. a in ( 'alpha', 'beta', 'gamma') ) but NOT for any other or-Condition
cego 24.07.2025 2.52.22 Version released
cego 24.07.2025 2.52.22 Fixed a memory leak in both CegoDistCursor::distSetup methods. _pJoinPred must be freed before allocate it via CegoPredicate::getReduced method
cego 24.07.2025 2.52.22 To join plan added information for master predicate ( eval on level 0 )
For master predicate mapping, added case cond case
cego 23.07.2025 2.52.22 More work on check123.sql to render random invoices which is useful to perform queries on larger filled tables
cego 23.07.2025 2.52.21 Version released
cego 22.07.2025 2.52.21 Several patches have been addd to handle join master predicate in the most optimal way. To show several condition cases, check123.sql has been introduced to demonstrate the join optimization for different join cases
cego 21.07.2025 2.52.21 For the new introduced master predicate handling, there was still missing some case handling. To map consequently a view condition to the unerlying join, a more sophisticed mapping is needed. For this, further mapping methods have been introduced in CegoExpr, CegoTerm, CegoFactor, CegoFunction and CegoCondition
E.g. for the following query on the view companyview
plan select cpid from companyview cv where lower(cv.cpname) like '%%' or debnr = 3;
The master condition now is mapped as can be seen in the execution plan
... Joining table company (cp) with full table scan with master condition (cp.debnr) = 3 or lower((cp.cpname)) like '%%' ...
Still just a subset of any possible master condition is actually mapped inside the view join. If no mapping is possible, the condition must be evaluated outside with a possibly lower performance
cego 20.07.2025 2.52.20 Version released
cego 20.07.2025 2.52.20 Added verify010 db check with a small invoice er model. This is used for advanced query verification with multilevel nested views and other dynamic stuff which is also relevant to proof valid results from query cache
cego 19.07.2025 2.52.20 Added fix in CegoAction for the following query:
select invid from invoice where status = ( select 'OPEN' );
In CegoAction::noFromOption, for _coListStack has to be pushed empty coList
cego 19.07.2025 2.52.20 For the new introduced query optimization, several code extensions have been added. In CegoPredicate, new methods map, getReduced, mapExpr and reduceExpr have been added to convert the "master" predicate to an appropriate form, which can be handled by CegoDistCursor. Also for for CegoDistCursor, the distSetup methods have been expanded to propagate the master predicate
cego 18.07.2025 2.52.20 Performance optimization added in CegoSelect and CegoDistCursor for or-condition handling
If an or-condition is recognized, the predicate is propagateed to the corresponding join level cursor and the evaluation is handled by the cursor.
This might avoid large table cursor result sets for the embedding join and might improve overall performance of the query
cego 16.07.2025 2.52.19 Version released
lfcbase 16.07.2025 1.22.1 Version released
lfcbase 15.07.2025 1.22.1 More patches on Replacer class to handle more match and replace cases. The match token has been changed to $ char to treat database integration.
cego 14.07.2025 2.52.19 Started with integration of lfcbase Replace class. For this, new function regmatch was added
lfcbase 13.07.2025 1.22.0 Version released
lfcbase 13.07.2025 1.22.0 More work on Replacer class with heafy rework of orgiginal regex_replace.c code. The original code did not treat many cases, e.g. replace string without prefix, multiple replace references and so on.
lfcbase 12.07.2025 1.22.0 Added further fixes for BigDecimal, scale handling still not correct for some cases
lfcbase 11.07.2025 1.22.0 Added class Replacer to support string replacement based on regular expressions ( like unix sed )
lfcbase 11.07.2025 1.21.9 Version released
lfcbase 11.07.2025 1.21.9 Fix added to BigDecimal class for internal constructor to normalize zero values to "0" and in scaleTo method to treat zero values correctly
cego 10.07.2025 2.52.18 Version released