Project

General

Profile

Activity

From 08/13/2025 to 09/11/2025

09/11/2025

08:11 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Artur, can you pick up 10480a fox performance testing (only runtime)? Alexandru Lungu

09/10/2025

08:46 AM Bug #10542 (Internal Test): Write trigger called when multiple buffers reference the same record
Alexandru Lungu
08:39 AM Bug #10542: Write trigger called when multiple buffers reference the same record
Alexandru Lungu wrote:
> I am OK with the changes.
>
> * @setLocked@ should always be set to false. It is basica...
Eduard Soltan
08:21 AM Bug #10542: Write trigger called when multiple buffers reference the same record
I am OK with the changes.
* @setLocked@ should always be set to false. It is basically related to the fact that t...
Alexandru Lungu
07:56 AM Bug #10542 (Review): Write trigger called when multiple buffers reference the same record
Eduard Soltan
07:56 AM Bug #10542 (WIP): Write trigger called when multiple buffers reference the same record
Committed on 10542a, rev. 16160. Eduard Soltan
07:14 AM Bug #10542: Write trigger called when multiple buffers reference the same record
> Then we have to really fire the trigger only on explicit releases. The implicit query initialisation will fire it o... Alexandru Lungu
06:43 AM Bug #10542: Write trigger called when multiple buffers reference the same record
Very well.
Then we have to really fire the trigger only on explicit releases. The implicit query initialisation will...
Ovidiu Maxiniuc
06:38 AM Bug #10542: Write trigger called when multiple buffers reference the same record
Ovidiu Maxiniuc wrote:
> Please test this assumption to confirm or infirm my assumption.
I have the following tes...
Eduard Soltan
06:29 AM Bug #10542: Write trigger called when multiple buffers reference the same record
Does it matter? In both cases, the modified record is still loaded in a buffer. The trigger will have the chance to f... Ovidiu Maxiniuc
06:26 AM Bug #10542: Write trigger called when multiple buffers reference the same record
Ovidiu Maxiniuc wrote:
> <notextile>@</notextile>Alex: @prepareBuffer()@ calls @buffer.flush()@. The @flush()@ (@val...
Eduard Soltan
06:22 AM Bug #10542: Write trigger called when multiple buffers reference the same record
<notextile>@</notextile>Alex: @prepareBuffer()@ calls @buffer.flush()@. The @flush()@ (@validateMaybeFlush()@ actuall... Ovidiu Maxiniuc
05:19 AM Bug #10542: Write trigger called when multiple buffers reference the same record
I am inclined to say that @prepareBuffer@ should have taken @isMultiplyReferenced@ into consideration. Alexandru Lungu
05:08 AM Bug #10542: Write trigger called when multiple buffers reference the same record
Alexandru Lungu wrote:
>
> Just a heads-up: in FWD, the newly created records are *flushed* to the database if all...
Eduard Soltan
04:35 AM Bug #10542: Write trigger called when multiple buffers reference the same record
> Just a heads-up: in FWD, the newly created records are flushed to the database if all indexes are validated (check ... Alexandru Lungu
04:31 AM Bug #10542: Write trigger called when multiple buffers reference the same record
> Then in the main buffer I try to load the second record from book4 table. As you can observe the WRITE is not trigg... Alexandru Lungu
04:17 AM Bug #10542: Write trigger called when multiple buffers reference the same record
I have found the following test case. Please note that I defined on @book4@ table a WRTIE TRIGGER that just message *... Eduard Soltan
03:58 AM Bug #10542 (Test): Write trigger called when multiple buffers reference the same record
Eduard Soltan
03:41 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
> Moreover, the results can have a boolean variable which dictates in what mode we are currently in. convertBracket()... Alexandru Lungu
01:49 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
If the concern is on the bracket calculation, maybe when commiting a transaction we can convert the current bracket t... Razvan-Nicolae Chichirau

09/09/2025

06:13 PM Feature #10491: Tool to standardize PG cluster creation
Roger Borrello wrote:
> I added functionality so that the cluster can be controlled properly with *systemctl*.
>
...
Roger Borrello
06:12 PM Feature #10491 (Review): Tool to standardize PG cluster creation
Usage of @fwd_create_pg_cluster.sh@:... Roger Borrello
12:54 PM Feature #10491: Tool to standardize PG cluster creation
Roger Borrello wrote:
> I added functionality so that the cluster can be controlled properly with *systemctl*.
>
...
Roger Borrello
10:25 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
> If as in your example, the requested row is 1.000.000 and we iterate with brackets of 100 in size, it will take som... Alexandru Lungu
08:27 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
> For 1e9 - 1, if the forcedMaxExponent is 2, then the right bracket is around (1e9 - 100) and offset is 99 (size is... Razvan-Nicolae Chichirau
07:22 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
Review of 9383a:
* @bracket == forcedMaxExponent + 1@ I don't think this is a hard constraint. I think @bracket > ...
Alexandru Lungu
04:25 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
Also commited rev. 16141 to remove some unnecessary history entries. Razvan-Nicolae Chichirau
04:14 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
Alex: Please review *9383a/rev. 16138-16140*. Razvan-Nicolae Chichirau
07:28 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Huh, this will be tough. Having it in trunk will affect at least one production customer. We will have a meeting tomo... Alexandru Lungu
07:26 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Alexandru Lungu wrote:
> Will this change be compatible with current database, right? But it will simply be slower.
...
Eduard Soltan
07:24 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Got it. Then I think 10380a integration in trunk will be highly dependent upon customer's schedule to update the data... Alexandru Lungu
06:54 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Alexandru Lungu wrote:
> Did this happen only with run-time testing? The fix only include DDL changes ... were the...
Eduard Soltan
06:53 AM Bug #10480 (Internal Test): Wrong sort criteria in FOR LAST when index has desc component
I am OK with the changes.
> Testing of all customer applications has passed with 10480a.
Did this happen only w...
Alexandru Lungu
05:51 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Testing of all customer applications has passed with 10480a. Eduard Soltan
07:25 AM Bug #9016: Improve performance in FQLPreprocessor by using astCache
All regression tests passed, *9016a* can be merged. Dănuț Filimon
07:08 AM Feature #6720: lazy hydration
Alexandru Lungu wrote:
> > Well, I don't think lazy hydration really avoids creating BDT objects. Lazy hydration jus...
Alexandru Lungu
07:04 AM Feature #6720: lazy hydration
> Well, I don't think lazy hydration really avoids creating BDT objects. Lazy hydration just populates the data array... Alexandru Lungu
03:04 AM Feature #6720: lazy hydration
Greg Shah wrote:
> In these tests you aren't measuring the cost of creating the BDT values. That tends to be expens...
Andrei Plugaru
04:43 AM Bug #10385 (Internal Test): Incorrect reset of the cursor cache in Reposition
* Check javadoc: @If position = -1, this means that a operation was triggered by REPOSITION-BY-ID statement.@ this sh... Alexandru Lungu

09/08/2025

07:29 PM Feature #10491: Tool to standardize PG cluster creation
I added functionality so that the cluster can be controlled properly with *systemctl*.
*TBD:* In order to control...
Roger Borrello
10:57 AM Feature #6720: lazy hydration
In these tests you aren't measuring the cost of creating the BDT values. That tends to be expensive. Greg Shah
10:44 AM Feature #6720: lazy hydration
Based on the previous note, it seemed that hydrating a record from H2 would be slower than a persistent one. So, I we... Andrei Plugaru
04:54 AM Feature #6720: lazy hydration
I have analysed some performance snapshot of 2 large customer applications that use different DBMS and discovered som... Andrei Plugaru
08:15 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Alexandru Lungu wrote:
> Review of 10385a:
>
> * Mind that @cursor.@ is viable is cursor is not null (i.e. the qu...
Eduard Soltan
06:59 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Review of 10385a:
* Mind that @cursor.@ is viable is cursor is not null (i.e. the query is scrolling). If the quer...
Alexandru Lungu
02:04 AM Bug #10526 (Review): Progressive results don't get invalidated when buffer-copy is performed
Committed on 10526a, rev. 16148. Eduard Soltan
01:47 AM Bug #10526 (WIP): Progressive results don't get invalidated when buffer-copy is performed
I have the following test case:... Eduard Soltan
01:37 AM Bug #10526 (Closed): Progressive results don't get invalidated when buffer-copy is performed
Eduard Soltan

09/05/2025

11:21 AM Feature #9542: finish ORIGIN-HANDLE ProDataSet attribute
The implementations for these two APIs have 2 years now and they are unchanged ever since. I think we should consider... Ovidiu Maxiniuc
09:34 AM Feature #6720: lazy hydration
Update on the current status:
* I have added the implicit hydration of fields from unique indexes proposed by Alex i...
Andrei Plugaru
06:53 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Alexandru Lungu wrote:
> Hmm, you are right. But this should still hold for Locator, right? So @trimToTableCount@ sh...
Eduard Soltan
06:26 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
> Doesn't DBUtils.trimToTableCount method trim the ids array only when the array size is bigger then query.getTableCo... Alexandru Lungu
06:03 AM Feature #9543: implement missing BUFFER attributes
Eric Faulhaber wrote:
> Is there anything left to do on this task, or can we close it?
@CAN-READ@ runtime support...
Eduard Soltan
05:44 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Added @tests/table/index/TestSuite.cls@ unit tests.
From my observation, I noticed that @recid desc@ is used only ...
Eduard Soltan

09/04/2025

02:47 PM Feature #9543: implement missing BUFFER attributes
Is there anything left to do on this task, or can we close it? Eric Faulhaber
02:41 PM Feature #9542: finish ORIGIN-HANDLE ProDataSet attribute
Ovidiu, the gap markings for @prog.kw_first_bu@ and @prog.kw_first_qr@ both have the comment "not heavily tested". Do... Eric Faulhaber
09:06 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Alexandru Lungu wrote:
> Review of 10385a:
>
Committed changes to handle review issues on rev. 16094.
> * In...
Eduard Soltan
08:20 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Review of 10385a:
* Please make the Locator immutable as it will be easier to keep track of its data without being...
Alexandru Lungu
03:05 AM Bug #10385 (Review): Incorrect reset of the cursor cache in Reposition
I tried removing the following code in @CompoundQuery.retrieveImpl@:... Eduard Soltan
08:48 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
> Also, since messing up with the size of the session cache is not possible, what if we would detect this one-by-one ... Alexandru Lungu
08:21 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
> So, technically, it is right to cache records after commit only if it fits in this 1024 limit. Otherwise, with high... Razvan-Nicolae Chichirau
07:50 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
> I was wondering, if we save so many records on a transaction commit, couldn't we pick it up from results (as we do ... Alexandru Lungu
07:34 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
> What are the sizes of brackets to be cached when COMMIT occurs? I am wondering if we reach brackets of size 1.000 (... Razvan-Nicolae Chichirau
05:01 AM Support #6709: track nested FIND inside a related FOR loop
Rebased *6709a* to latest *trunk/16145*, the branch is now at revision *16152*. Dănuț Filimon
02:55 AM Bug #7793: incremental conversion with deleted table from .df
The following should be tested:
# Conversion test, the .df should contain an additional table from the start.
# Inc...
Dănuț Filimon
09:26 PM Feature #10491: Tool to standardize PG cluster creation
Revision 85 of the container project contains updates in preparation for PowerShell support. I broke a portion of the... Roger Borrello

09/03/2025

10:28 AM Bug #7793 (Internal Test): incremental conversion with deleted table from .df
Code Review Task Branch 6083a Revisions 16130 and 16131
The changes are good.
Greg Shah
07:09 AM Bug #7793: incremental conversion with deleted table from .df
Fixed a bug where the md5 field was initialized to null instead of filename: *6083a/16131*. Dănuț Filimon
05:51 AM Bug #7793: incremental conversion with deleted table from .df
I committed *6083a/16130* to address the #7793-28 review. Dănuț Filimon
08:13 AM Bug #10390: FIND FIRST buffer field change does not propagate into the next FIRST FIRST statements.
Because @persistence.load@ (@Session.getImpl@) returns the cached version of the @dmo@. The cached version of the @dm... Teodor Gorghe
06:56 AM Bug #10390: FIND FIRST buffer field change does not propagate into the next FIRST FIRST statements.
> In this form, that third FQL statement seems valid to me and is normal to return a record from database, since the ... Alexandru Lungu
07:45 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
PS, the code is:
> dmo.updateState(null, TRACKED, false);
So after committing, the DMOs are *no longer tracked*, ...
Alexandru Lungu
07:42 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
> By catching all the rows from the current bracket + what the called sub-procedure catches, the next record from the... Alexandru Lungu
03:35 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
Increasing the lenient threshold does not solve #10172. Although all record properties are now cached, the problem st... Razvan-Nicolae Chichirau
04:24 AM Feature #10436: Detect Sequential Data Access and Prefetch Records from the Database
> Can it be used to cache records in advance?
This is exactly the point. But @AdaptiveFind@ is used when there is ...
Alexandru Lungu
02:26 AM Feature #10436: Detect Sequential Data Access and Prefetch Records from the Database
Alexandru Lungu wrote:
> Do you refer to patterns like the one in #10436-3 where you have a nested find?
Yes.
> @A...
Artur Școlnic
02:34 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
*Question*, when a call to @Cursor.getResult@ is made with the cursor positioned between the rows (lets say at @posit... Eduard Soltan

09/02/2025

03:55 PM Bug #7793: incremental conversion with deleted table from .df
Code Review Task Branch 6083a Revisions 16127 and 16128
Overall, it looks good.
1. In @getPathToConversionFolde...
Greg Shah
08:21 AM Bug #7793: incremental conversion with deleted table from .df
Made a fix in *6083a/16129* for the issue mentioned in #7793-26, the DMO will also be deleted from the registry. Dănuț Filimon
08:06 AM Bug #7793: incremental conversion with deleted table from .df
There is an issue where the table should also be deleted from the registry.xml file. At a closer inspection I've foun... Dănuț Filimon
07:25 AM Bug #7793 (Review): incremental conversion with deleted table from .df
I committed *6083a/16128*. Added the changes mentioned in #7793-24.
Greg/Constantin, please review.
Dănuț Filimon
06:34 AM Bug #7793: incremental conversion with deleted table from .df
I finally got something, the implementation works like this:
* In @ConversionData.java@, the @table_signature@ will ...
Dănuț Filimon
03:34 PM Feature #10491: Tool to standardize PG cluster creation
Greg Shah wrote:
> > From this, I gather that *md5* was the preferred authorization method at the time of writing. A...
Ovidiu Maxiniuc
08:33 AM Feature #10491: Tool to standardize PG cluster creation
> It's difficult to tell how any other projects create their clusters, since it isn't part of any current scripting. ... Greg Shah
09:11 AM Bug #10390: FIND FIRST buffer field change does not propagate into the next FIRST FIRST statements.
I have checked the bundle and the results when @FIND FIRST@ is used.
When @activeBundleKey@ is first, the old record...
Teodor Gorghe
03:29 AM Bug #10390: FIND FIRST buffer field change does not propagate into the next FIRST FIRST statements.
The full schema for @adaptivept9@ (taken from testcases project) is:... Teodor Gorghe
03:24 AM Bug #10390 (WIP): FIND FIRST buffer field change does not propagate into the next FIRST FIRST sta...
> on processDirtyResults, the useDirtyDMO is already set to true and there are no changes required.
Right; this is...
Alexandru Lungu
02:41 AM Bug #10390 (Review): FIND FIRST buffer field change does not propagate into the next FIRST FIRST ...
Committed revision *16103* on task branch *10390a*:
- Addressed code review #10390-17.
Teodor Gorghe
02:28 AM Bug #10390: FIND FIRST buffer field change does not propagate into the next FIRST FIRST statements.
Response to code review #10390-17:
* the @if (hasEnteredIteration)@ conditional from @RAQ.executeImpl@ was moved bec...
Teodor Gorghe
04:23 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Review of 10480a:
* I am OK with the technical approach.
* However, there are several places where @SortCriterion...
Alexandru Lungu
03:12 AM Bug #10480 (Review): Wrong sort criteria in FOR LAST when index has desc component
Eduard Soltan
03:12 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
I have encountered this case in a regression tests, only there @find prev tt1 use-index desc_idx no-lock no-error@ qu... Eduard Soltan

09/01/2025

04:25 PM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Alexandru Lungu wrote:
> Ovidiu, do you have a feedback for this? I am concerned that we might miss something.
I ...
Ovidiu Maxiniuc
08:54 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
There is a regression in Chui regression tests project. In the current implementation, @recid asc@ is added to the @s... Eduard Soltan
02:43 PM Bug #7793: incremental conversion with deleted table from .df
Greg Shah wrote:
> The idea here is about cases where an output artifact is deleted but the source artifact exists. ...
Constantin Asofiei
08:45 AM Bug #7793: incremental conversion with deleted table from .df
> > * Reconvert any source artifact whose output artifact has been deleted.
> I don't really understand the idea her...
Greg Shah
06:05 AM Bug #7793: incremental conversion with deleted table from .df
Greg Shah wrote:
> If possible, try not to make the changes for #7180 more difficult.
>
> It also seems like a po...
Constantin Asofiei
05:52 AM Bug #7793: incremental conversion with deleted table from .df
For #6738, I looked into the code and found @JavaPatternWorker$WorkArea.pfiles@, this helps us to track the persisted... Dănuț Filimon
11:51 AM Feature #10491: Tool to standardize PG cluster creation
Greg Shah wrote:
> I thought we had automated the cluster initialization. The fact that we haven't is a problem for...
Roger Borrello
10:17 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Experimented a bit with the query a scrolling query.... Eduard Soltan
10:00 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
The issue in #10172 is not that the record is not inside the cache, but rather that its data was not selected. In gen... Alexandru Lungu
08:42 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
With 9383a I get around 30k calls for the scenario from #10172 comparative with 34-35k calls with trunk. The reason f... Razvan-Nicolae Chichirau
06:08 AM Feature #6457: finish COPY-LOB support
Constantin Asofiei wrote:
> * @longchar.write@ - what if the existing longchar instance already has the codepage s...
Eduard Soltan
06:00 AM Feature #6457: finish COPY-LOB support
Review of 6457a rev 16071:
* @block_properties.rules@ has the XML prolog removed.
* @LobCopy@ - no history entry
*...
Constantin Asofiei

08/29/2025

12:16 PM Feature #10491: Tool to standardize PG cluster creation
I am not suggesting that we expand use of @build_db.xml@. The opposite, I want everything in there to be using tools... Greg Shah
11:49 AM Feature #10491: Tool to standardize PG cluster creation
Greg,
The @build_db.xml@ might not be the best place for configuring the cluster. This is a one-time operation (only...
Ovidiu Maxiniuc
09:10 AM Bug #7793: incremental conversion with deleted table from .df
It is fine to store at any point in the process, late or early, it should not matter. Greg Shah
09:08 AM Bug #7793: incremental conversion with deleted table from .df
We'd have to make a difference between code and schema artifacts, JavaPatternWorker.createJavaFile() is used for both... Dănuț Filimon
08:59 AM Bug #7793: incremental conversion with deleted table from .df
If possible, try not to make the changes for #7180 more difficult.
It also seems like a potentially good idea to s...
Greg Shah
08:42 AM Bug #7793: incremental conversion with deleted table from .df
From the looks of it, I will need to load hotel.p2o which can give me access to the "path" annotation (com/goldencode... Dănuț Filimon
07:20 AM Bug #7793: incremental conversion with deleted table from .df
Alexandru told me that import.sh is able to determine the DMO, I'll investigate and check if this can be of help. Dănuț Filimon
06:59 AM Bug #7793: incremental conversion with deleted table from .df
The dmo file name is build in java_dmo.xml and I can't build the file name of a dmo that doesn't exist. The only opti... Dănuț Filimon
06:09 AM Bug #7793: incremental conversion with deleted table from .df
I tried to look into @DatabaseManager.getDatabaseDMOs()@ and @DatabaseManager.getDatabaseTables()@, but the issue wit... Dănuț Filimon
09:01 AM Bug #10483: memory leak in BufferManager.openBuffers
> The protection ensures only for this specific case.
I understand. But should we expand this to be unconditional...
Greg Shah
08:46 AM Bug #10483: memory leak in BufferManager.openBuffers
Greg Shah wrote:
> Code Review Task Branch 10483a Revision 16137 and 16138
>
> For @RB.openScope()@, what are 4GL...
Constantin Asofiei
08:41 AM Bug #10483: memory leak in BufferManager.openBuffers
Code Review Task Branch 10483a Revision 16137 and 16138
For @RB.openScope()@, what are 4GL code examples that caus...
Greg Shah
06:01 AM Bug #10455 (Review): Persistent table CAN-FIND FIRST issue
Teodor Gorghe
06:00 AM Bug #10455: Persistent table CAN-FIND FIRST issue
Committed revision *16127* on task branch *10455a*:
- Avoid calling validation multiple times in the nested function...
Teodor Gorghe
03:55 AM Bug #10455 (WIP): Persistent table CAN-FIND FIRST issue
Review of 10455a:
* I am very OK with the logic being moved to @BlockManager.functionBlock@.
* I am still not con...
Alexandru Lungu
03:33 AM Bug #10455: Persistent table CAN-FIND FIRST issue
Committed revision *16126* on task branch *10455a*:
* Moved validation from @BufferManager@ into @BlockManager.funct...
Teodor Gorghe
02:44 AM Bug #10455: Persistent table CAN-FIND FIRST issue
The property block case works just fine, but the problem is that when there is no buffer usage into the the called fu... Teodor Gorghe
05:27 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Alexandru Lungu wrote:

> Ah, I see. @CompoundQuery@ does a NEXT and forces its AQ to load that second row, but AQ...
Eduard Soltan
05:24 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
> Suppose I have in cursor [1432, 1432], cursor is set on the second element. After the execution of loadByValues and... Alexandru Lungu
04:10 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Alexandru Lungu wrote:
> Exactly. If the first component (EACH) has a cursor with ids [1, 2, 3], then @loadByValue...
Eduard Soltan
03:35 AM Bug #10385 (WIP): Incorrect reset of the cursor cache in Reposition
> repositionByID is performed only in certain cases, added additional reposition parameter to loadByValues and load m... Alexandru Lungu
01:58 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Committed on 10385a, rev. 16091.
@repositionByID@ is performed only in certain cases, added additional @reposition...
Eduard Soltan
12:42 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Alexandru Lungu wrote:
> * I don't think the changes are right (or maybe I am misinterpreting something). The @repoC...
Eduard Soltan
04:55 AM Bug #10390 (WIP): FIND FIRST buffer field change does not propagate into the next FIRST FIRST sta...
I am not sure the changes in 10390a are right because:
* moving the @if (hasEnteredIteration)@ after means that we...
Alexandru Lungu

08/28/2025

02:57 PM Feature #10491: Tool to standardize PG cluster creation
This must be able to fully replace the cluster initialization in @build_db.xml@. In other words, we will eliminate t... Greg Shah
02:53 PM Feature #10491: Tool to standardize PG cluster creation
> Should I leave it like that, or allow each current line to have the specified authorization method, instead of the ... Greg Shah
12:18 PM Feature #10491: Tool to standardize PG cluster creation
Added watchers. Roger Borrello
12:17 PM Feature #10491: Tool to standardize PG cluster creation
With respect to @postgresql.conf@, our current Docker implementation makes the below changes, which essentially uncom... Roger Borrello
10:35 AM Feature #10491 (WIP): Tool to standardize PG cluster creation
Right now the attached is within the @container@ project, but needs to be moved to a FWD branch in the @./tools/scrip... Roger Borrello
10:32 AM Feature #10491: Tool to standardize PG cluster creation
We need a tool to standardize the method by which a PostgreSQL cluster is created. It needs to be able to function bo... Roger Borrello
09:05 AM Feature #10491 (Review): Tool to standardize PG cluster creation
Roger Borrello
10:32 AM Bug #10483 (Review): memory leak in BufferManager.openBuffers
Actually, the memory leak was from a case where a buffer from a super-class is opened (in the pseudo-execute method f... Constantin Asofiei
09:15 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
Committed #9383-17 to *9383a/16139*. Made transactionCommitting() default. Dănuț Filimon
09:09 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
You can do this:... Dănuț Filimon
09:04 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
Danut, @transactionCommiting@ is not implemented as a no-op in all @Results@ classes after the rebase:... Razvan-Nicolae Chichirau
08:49 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used
Rebased *9383a* to latest *trunk/16136*, the branch is now at revision *16138*. Dănuț Filimon
09:07 AM Bug #10455: Persistent table CAN-FIND FIRST issue
The changes are reverted to the state that was before @BATCH@ mode.
The synchronization does not happen when the val...
Teodor Gorghe
06:53 AM Bug #10455: Persistent table CAN-FIND FIRST issue
Review of 10455a:
* I would like to defer the review of exception handling to Constantin. To me it looks OK, but I a...
Alexandru Lungu
06:39 AM Bug #10455 (Review): Persistent table CAN-FIND FIRST issue
Committed revision *16125* on task branch *10455a*:
- Added validation when a function is called in batch assignment...
Teodor Gorghe
03:33 AM Bug #10455: Persistent table CAN-FIND FIRST issue
Thanks for code review!
I have started working on this task branch, but I think that adding the validation into th...
Teodor Gorghe
07:22 AM Bug #7793: incremental conversion with deleted table from .df
I like the approach. You can put the changes into 6083a. Greg Shah
06:54 AM Bug #7793: incremental conversion with deleted table from .df
6083a does give me a way to determine the deleted tables, the only problem is getting the *.java and *.java.jast file... Dănuț Filimon
05:45 AM Bug #7793: incremental conversion with deleted table from .df
I tested hotel using two persistent tables (pt1 and pt2), after removing the pt2 table I am still left with those two... Dănuț Filimon
03:22 AM Bug #7793 (WIP): incremental conversion with deleted table from .df
I'll pick this up since I worked on #6083. Dănuț Filimon
06:42 AM Feature #6720: lazy hydration
> The root cause is the fallback to Loader which causes in retrieving a newer state of the record than we would have ... Alexandru Lungu
06:27 AM Feature #6720: lazy hydration
I have good news and bad news:))
I have tested the fwd tests and unit tests of another large customer application ...
Andrei Plugaru
06:28 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Alexandru Lungu wrote:
> > Assignee set to Alexandru Lungu
>
> Constantin, shall I pick this up or was it a mista...
Constantin Asofiei
06:27 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
> Assignee set to Alexandru Lungu
Constantin, shall I pick this up or was it a mistake changing the Assignee?
Alexandru Lungu
06:26 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Eduard,
> 3) qh:get-first() find the record with recid 1432 and updated index field. In Cursor.results is added anot...
Alexandru Lungu
03:18 AM Bug #10385: Incorrect reset of the cursor cache in Reposition
Alex, please review this. To me the change makes sense. Constantin Asofiei
06:13 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
> do you remember why in SortCriterion.parse, when adding recid to the sort criteria an asc/desc is gotten from the l... Alexandru Lungu
06:12 AM Bug #10480 (Internal Test): Wrong sort criteria in FOR LAST when index has desc component
Is the following a reasonable example to prove the issue (both temporary and persistent tables)?... Alexandru Lungu
02:38 AM Bug #10480 (Review): Wrong sort criteria in FOR LAST when index has desc component
Eduard Soltan
02:37 AM Bug #10480 (WIP): Wrong sort criteria in FOR LAST when index has desc component
Committed on 10480a, revision 16133.
Excluded descending order from recid component from DDL and FQL generation.
Eduard Soltan
03:40 AM Bug #10398 (Test): Incorrect base data type used in buffer dereference
10398a was merged to trunk and archived. Eduard Soltan
03:22 AM Bug #10398 (Merge Pending): Incorrect base data type used in buffer dereference
Please merge to trunk now. Constantin Asofiei
03:19 AM Bug #10390: FIND FIRST buffer field change does not propagate into the next FIRST FIRST statements.
Alex, please review this. Constantin Asofiei

08/27/2025

11:28 AM Bug #10483: memory leak in BufferManager.openBuffers
In @BufferManager.bufferInitialized@, the @buffer.activeScopeDepth@ is 0-based; this code:... Constantin Asofiei
11:14 AM Bug #10483 (WIP): memory leak in BufferManager.openBuffers
Constantin Asofiei
09:12 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
> Do you remember why in SortCriterion.parse, when adding recid to the sort criteria an asc/desc is gotten from the l... Alexandru Lungu
08:56 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Unfortunately I didn't find any testcases related to this. Eduard Soltan
08:52 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
The only places where I could find @(pKeyAscend ? "asc" : "desc")@ mentioned is #7414-14 and #1666-15.
Ovidiu wrot...
Eduard Soltan
07:41 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
> Sorry Tomasz, I saw that you made the last change in this area, but the part of the code of interest is pretty old ... Alexandru Lungu
07:35 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Eduard Soltan wrote:
> Tomasz,
>
> Do you remember why in @SortCriterion.parse@, when adding @recid@ to the sort ...
Eduard Soltan
07:18 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
Tomasz,
Do you remember why in @SortCriterion.parse@, when adding @recid@ to the sort criteria an @asc/desc@ is go...
Eduard Soltan
05:52 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component
... Eduard Soltan
05:46 AM Bug #10480 (Test): Wrong sort criteria in FOR LAST when index has desc component
Eduard Soltan
08:44 AM Bug #10455 (WIP): Persistent table CAN-FIND FIRST issue
I made some experiments my own and reached the same conclusion as yours. Using function invocations inside the ASSIGN... Alexandru Lungu
08:26 AM Feature #6720: lazy hydration
While investigating the FWD tests of a large customer applications, I came across some problems and fixed them. @6720... Andrei Plugaru
04:45 AM Bug #10479: Deleted record is added to session cache in ProgressiveResults.getResults
When a new bracket is processed in @ProgressiveResults.getResults@, this code is executed:... Andrei Plugaru
04:30 AM Bug #10479 (New): Deleted record is added to session cache in ProgressiveResults.getResults
Andrei Plugaru

08/25/2025

01:45 PM Bug #10470 (WIP): Wrong order of records fetching when index modification
... Eduard Soltan
01:39 PM Bug #10470 (Rejected): Wrong order of records fetching when index modification
Eduard Soltan
10:33 AM Support #10420: Refactoring DMO interface layers
Good additions, Alex! Greg Shah
08:08 AM Support #10420: Refactoring DMO interface layers
I like #10420-3! I would like to extend upon the Issues section with a question:
* are there limits on Java file/cla...
Alexandru Lungu
08:28 AM Bug #9016 (Internal Test): Improve performance in FQLPreprocessor by using astCache
I am ok with 9016a. Please proceed with testing. Alexandru Lungu
06:52 AM Bug #9493: Inline word index CTE for trivial clauses
Alexandru Lungu wrote:
> Stefanel, please describe here the optimization in #10431-12 here. We may want to implement...
Stefanel Pezamosca
06:38 AM Bug #9493: Inline word index CTE for trivial clauses
Stefanel, please describe here the optimization in #10431-12 here. We may want to implement such optimization directl... Alexandru Lungu
06:45 AM Feature #10436: Detect Sequential Data Access and Prefetch Records from the Database
> Detect Sequential Data Access and Prefetch Records from the Database
Arthur, can you provide a 4GL code that wou...
Alexandru Lungu
01:47 AM Bug #10455: Persistent table CAN-FIND FIRST issue
ChUI regression testing passed with the current changes. Teodor Gorghe

08/22/2025

02:03 PM Feature #6720: lazy hydration
I have continued with addressing the functional issues I have found in the large GUI application. These were also mai... Andrei Plugaru
06:55 AM Bug #10390: FIND FIRST buffer field change does not propagate into the next FIRST FIRST statements.
Alexandru Lungu wrote:
> Ah, I see. The DMO is updated and validated. It is inserted in the @RecordNursery@ for futu...
Teodor Gorghe

08/21/2025

07:34 AM Support #10420: Refactoring DMO interface layers
The app-by-app conversion process customizes DMO naming by delegating all of the *TRPL processing* to a dedicated Jav... Octavian Adrian Gavril
06:17 AM Bug #10390 (Review): FIND FIRST buffer field change does not propagate into the next FIRST FIRST ...
Teodor Gorghe
06:17 AM Bug #10390 (WIP): FIND FIRST buffer field change does not propagate into the next FIRST FIRST sta...
Committed revision *16102* on task branch *10390a*:
- Allow FIND UNIQUE to retrieve dmo from dirty database when dmo...
Teodor Gorghe
03:13 AM Bug #10455 (Review): Persistent table CAN-FIND FIRST issue
Committed revision *16124* on task branch *10455a*:
- Commit changes to @DirtyShareContext@ on open block scope when...
Teodor Gorghe
03:12 AM Bug #10455 (WIP): Persistent table CAN-FIND FIRST issue
Created task branch *10455a*. Teodor Gorghe
02:23 AM Bug #10455: Persistent table CAN-FIND FIRST issue
I have continued the research for this problem, and I have noticed the following:
* On @DirtyShareContext.getDirtyIn...
Teodor Gorghe

08/20/2025

10:05 AM Bug #10455: Persistent table CAN-FIND FIRST issue
I have investigated more about this issue.
The original code that was here, actually worked, it was just the dirty i...
Teodor Gorghe
05:36 AM Bug #10455: Persistent table CAN-FIND FIRST issue
The following test fails on FWD:... Teodor Gorghe
05:32 AM Bug #10455 (Closed): Persistent table CAN-FIND FIRST issue
Teodor Gorghe

08/19/2025

09:29 AM Feature #10436: Detect Sequential Data Access and Prefetch Records from the Database
In RandomAccessQuery:
1. Detect sequential increment of a subset of substitution value for the fql.
* Add a smal...
Artur Școlnic
09:14 AM Support #6709: track nested FIND inside a related FOR loop
Rebased *6709a* to latest *trunk/16122*, the branch is now at revision *16129*. Dănuț Filimon
09:02 AM Bug #9016: Improve performance in FQLPreprocessor by using astCache
Alexandru, let me know if you have any plans to review 9016a or add it directly to the work from #10362. Dănuț Filimon
09:00 AM Bug #9078: emit FindQuery as (reused) variables
Rebased *9078b* to latest *trunk/16122*, the branch is now at revision *16134*. Dănuț Filimon
03:58 AM Bug #10398 (Internal Test): Incorrect base data type used in buffer dereference
Looks good, thanks. Constantin Asofiei
03:52 AM Bug #10398: Incorrect base data type used in buffer dereference
Committed revision 16112 on task branch 10398a:
- ABS builtin function should not raise error condition when bdt is ...
Teodor Gorghe
03:47 AM Bug #10398: Incorrect base data type used in buffer dereference
Please check if the @bdt.isUnknown()@, also - I assume no ERROR condition is raised in this case, and it just returns... Constantin Asofiei
03:46 AM Bug #10398: Incorrect base data type used in buffer dereference
Committed revision *16111* on task branch *10398a*:
- @ABS@ builtin function should raise error condition when the d...
Teodor Gorghe
03:12 AM Bug #10398: Incorrect base data type used in buffer dereference
Please work on this as Eduard is out. I'd like to have this and #10406 in trunk so we can run another conversion. Constantin Asofiei
03:07 AM Bug #10398: Incorrect base data type used in buffer dereference
Then a character field has a valid number representation, this still does throw the same error.
On this and on the p...
Teodor Gorghe
03:01 AM Bug #10398: Incorrect base data type used in buffer dereference
The incompatible data type error is thrown (223) when the input parameter is not an NumberType, with an Error conditi... Teodor Gorghe
02:46 AM Bug #10398: Incorrect base data type used in buffer dereference
The change looks good. The only unknown is what happens if @h::f1@ is i.e. a character - is there an ERROR condition... Constantin Asofiei
02:45 AM Bug #10351 (Test): ProDataSet READ-XML issue when temp-table node is the same as dataset node
Branch 10351a was merged to trunk rev 16121 and archived. Teodor Gorghe
02:22 AM Bug #10351 (Merge Pending): ProDataSet READ-XML issue when temp-table node is the same as dataset...
10351a can be merged after 10360a Constantin Asofiei
01:52 AM Bug #10351: ProDataSet READ-XML issue when temp-table node is the same as dataset node
Yes, now is ready to be merged. Teodor Gorghe
02:33 AM Bug #10360 (Test): FOR loop WHERE condition evaluation issue
Branch *10360a* was merged to trunk rev *16120* and archived. Teodor Gorghe
02:22 AM Bug #10360 (Merge Pending): FOR loop WHERE condition evaluation issue
10360a can be merged now. Constantin Asofiei

08/18/2025

07:58 AM Support #10420: Refactoring DMO interface layers
This would certainly solve the concern I had in #9976 and much more. It seems to me that the performance of this pro... Greg Shah
10:36 PM Support #10420: Refactoring DMO interface layers
I am going to propose you a radical change in the way we interact with the buffers. This is a new paradigm, maybe clo... Ovidiu Maxiniuc
06:13 AM Feature #10436: Detect Sequential Data Access and Prefetch Records from the Database
Prefetching records into cache can significantly improve performance, especially when access patterns are predictable... Artur Școlnic
06:11 AM Feature #10436 (WIP): Detect Sequential Data Access and Prefetch Records from the Database
Artur Școlnic

08/14/2025

07:01 AM Feature #6720: lazy hydration
> Yes, but this was actually the case even before #9701. The return value of the @equalData@ method is used to update... Greg Shah
04:11 AM Feature #6720: lazy hydration
Thanks Alex for the comprehensive overview. I will think about the refactoring of @FIND CURRENT@ and maybe others ins... Andrei Plugaru
03:46 AM Feature #6720: lazy hydration
> I'm not OK with limiting this implementation to only FOR EACH. Large percentages of application queries would be mi... Alexandru Lungu
03:31 AM Feature #6720: lazy hydration
Greg Shah wrote:
> Are you saying that we force hydration of all fields any time @BaseRecord.equalData@ is called? ...
Andrei Plugaru
05:37 AM Bug #9016: Improve performance in FQLPreprocessor by using astCache
Rebased *9016a* to latest *trunk/16114*, the branch is now at revision *16115*. Dănuț Filimon
04:29 AM Feature #9455 (Internal Test): port native user defined functions to SQL Server
Tests performed with udfs are:
- @testcases/udfs/t-sql@ these are refactored tests in T-SQL language from @testca...
Eduard Soltan

08/13/2025

12:36 PM Feature #6720: lazy hydration
> @16110@ and @16112@: Apart from unimportant rebase issues, I have changed the implementation of @BaseRecord.equalD... Greg Shah
12:07 PM Feature #6720: lazy hydration
> The original implementation of #6720 was to cover as many scenarios as possible, but the @OPEN QUERY@ and @FIND FIR... Greg Shah
08:22 AM Feature #6720: lazy hydration
I have got back to working on this task. I have started with the rebase of the @6720b@ branch. I have rebased to trun... Andrei Plugaru
09:31 AM Support #10420: Refactoring DMO interface layers
Ovidiu suggested to use @default@ to delegate from the @get@ / @set@ to the super-interface cryptic methods (@get1@, ... Alexandru Lungu
09:26 AM Support #10420: Refactoring DMO interface layers
This task is used to discuss how we should avoid non-deterministic naming of DMOs in multithreaded conversion. The in... Octavian Adrian Gavril
08:38 AM Support #10420 (New): Refactoring DMO interface layers
Octavian Adrian Gavril
 

Also available in: Atom