| Änderungsprotokolle |
|---|
Im folgenden sind die letzten Änderungen der verschiedenen Softwarepakete aufgeführt.
Letze 10 30 100 1000 10000 Einträge
| Kategorie | Datum | Version | Eintrag |
|---|---|---|---|
| cego | 18.08.2025 | 2.52.29 | Version released |
| cego | 17.08.2025 | 2.52.29 | In CegoDbThread::serveRequest, added further tableset states ( BACKUP, CHECKPOINT ) where sessions are accepted |
| cego | 17.08.2025 | 2.52.29 | Renamed new option forcestart to lockexpire. Since the argument expects an expire value, this seems to be a better naming. Added lockexpire option to bsd rc script |
| cego | 14.08.2025 | 2.52.28 | Version released |
| cego | 14.08.2025 | 2.52.28 | Added command line option forcestart with integer parameter seconds exceeded. If set, this option will check for the configured daemon lockfile and if the timestamp of the lockfile is older than now - seconds exceeded, the lock file is removed and the database is started. Since in the meantime, the database crash recovery seems to be pretty stable, this option makes sense. |
| cego | 13.08.2025 | 2.52.28 | Improved input handling in CegoClient. For interactive mode, trailing LF, CR and multiple semicolons are cut now. |
| cego | 11.08.2025 | 2.52.27 | Version released |
| cego | 10.08.2025 | 2.52.27 | Some code cleanup done in CegoSelect::nextTuple for code isolation regarding start and finish caching ( methods startCaching and finishCaching have been introduced ) Another performance patch was made regarding CegoSelect::reset method. Freeing table cursors is no more needed, so doRelease parameter was removed from the method. It is expected, that nested views and subqueries in expressions which are traced multiple times should run pretty faster. |
| cego | 08.08.2025 | 2.52.26 | Version released |
| cego | 08.08.2025 | 2.52.26 | Version released |
| cego | 08.08.2025 | 2.52.26 | For the admin command "threadinfo db", lastAction was added to the threadlist to indicate the current processed query. Once, this was indicated by "threadinfo db <thrid>", but was lost with introduction of query history |
| cego | 08.08.2025 | 2.52.26 | Added format improvements for CegoAction::getPlanString to indent subqueries |
| cego | 08.08.2025 | 2.52.26 | Added fix in CegoPredicate::eval, the cleanUp method call was removed, since this seems to be not needed and throttles performance in case of nested select statements |
| 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 |