Activity

From 06/23/2025 to 07/22/2025

07/22/2025

01:36 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap: Eric,
Yesterday I've updated the branch 10094a according to suggestions in the review from #note-26. It was also r... Ovidiu Maxiniuc
12:34 PM Feature #6457: finish COPY-LOB support: Eduard Soltan wrote:
> I will look into it. I observed how transaction is handled in @buffer-copy@ or other similar ... Constantin Asofiei
12:33 PM Feature #6457: finish COPY-LOB support: Constantin Asofiei wrote:
> Eduard Soltan wrote:
> > Committed on 6457a, rev. 16066.
> >
> > - Emit @Transaction... Eduard Soltan
12:14 PM Feature #6457: finish COPY-LOB support: Eduard Soltan wrote:
> Committed on 6457a, rev. 16066.
>
> - Emit @Transaction.FULL@ parameter when target of cop... Constantin Asofiei
12:12 PM Feature #6457: finish COPY-LOB support: Committed on 6457a, rev. 16066.
- Emit @Transaction.FULL@ parameter when target of copy-lob operation is a persist... Eduard Soltan
11:28 AM Feature #10310: move tenant database from one multitenant cluster to another: Just to be sure I understand the goal of this new FWD tool: the idea is to balance the load of FWD servers by migrati... Ovidiu Maxiniuc
10:43 AM Bug #6923: inner transaction block reverts too much: I have reviewed the changes in 6923a/r16049. I think the code will work. Thank you for adding comments with the chang... Ovidiu Maxiniuc
07:36 AM Feature #10325: Optimize AdaptiveQuery for single-result scenarios: The scope of this task is to optimize the @AdaptiveQuery@ into @RandomAccessQuery@ when we know that the where clause... Andrei Plugaru
03:17 AM Feature #10325 (Review): Optimize AdaptiveQuery for single-result scenarios: Andrei Plugaru
04:20 AM Support #6709: track nested FIND inside a related FOR loop: Dănuț Filimon wrote:
> I see the ChUI project used @datanames.xml@ which also changes how the converted project sees... Dănuț Filimon

07/21/2025

01:03 PM Feature #6457: finish COPY-LOB support: First major problem found, it is common for around 100 tests.... Eduard Soltan
12:38 PM Feature #6457: finish COPY-LOB support: Greg Shah wrote:
> From the wiki:
>
> > All files from @tests/copy_lob/support/data@ should be moved to @deploy/c... Eduard Soltan
10:55 AM Feature #6457: finish COPY-LOB support: From the wiki:
> All files from @tests/copy_lob/support/data@ should be moved to @deploy/client/tests/copy_lob/sup... Greg Shah
10:29 AM Feature #6457: finish COPY-LOB support: After solving all configuration issues, I was left only with assertion errors which should be investigated.... Eduard Soltan
09:05 AM Feature #6457: finish COPY-LOB support: As you work through issues in these tests, please update [[p2j:LOB Tests]] with details of the test status and how to... Greg Shah
08:26 AM Feature #6457: finish COPY-LOB support: After creating the following path in @deploy/client/tests/copy_lob/support/data@, I get the following results:
<pr... Eduard Soltan
08:07 AM Feature #6457: finish COPY-LOB support: Got the following after running @testcases/tests/copy_lob/@... Eduard Soltan
07:36 AM Feature #6457: finish COPY-LOB support: Greg Shah wrote:
> The BOM handling has a testcase already written. See @testcases/copy_lob/tests/bom.p@.
Greg/S... Eduard Soltan
06:25 AM Feature #6457: finish COPY-LOB support: > Stanislav: please summarize any work done for this task
I didn't produce any testcases and used the existing one... Stanislav Lomany
06:00 AM Feature #6457: finish COPY-LOB support: Stanislav: please summarize any work done for this task
Eduard: please look into the xfer testcase, run them in FW... Constantin Asofiei
10:47 AM Bug #6923: inner transaction block reverts too much: Committed xfer/testcases rev. 1792 with my unit tests for this. "safe" suites are ones that are cut-out in terms of p... Alexandru Lungu
10:43 AM Bug #6923 (Review): inner transaction block reverts too much: I committed 6923a/16047 and 6923a/16048 with:
* Fixed re-reserving of the PK after rollbacking flushed NEW records (... Alexandru Lungu
09:47 AM Support #6709: track nested FIND inside a related FOR loop: I see the ChUI project used @datanames.xml@ which also changes how the converted project sees the bufname and filenam... Dănuț Filimon
08:57 AM Support #6709: track nested FIND inside a related FOR loop: I'll have to work on the conversion changes a bit more, the bufname is not the right one to use in this case. I've fo... Dănuț Filimon
07:34 AM Support #6709: track nested FIND inside a related FOR loop: I implemented the conversion changes necessary, this works by emitting a DataModelObject array before the Object arra... Dănuț Filimon
06:55 AM Feature #9456 (WIP): implement SQL Server dialect and helpers: Ovidiu Maxiniuc
06:48 AM Feature #9456: implement SQL Server dialect and helpers: I have created 9456b from trunk 16062 for subsequent changes. Ovidiu Maxiniuc
06:46 AM Feature #9456: implement SQL Server dialect and helpers: Branch 9456a was merged into trunk as 16062 then it was archived. Ovidiu Maxiniuc
05:47 AM Feature #9456: implement SQL Server dialect and helpers: I peeked at r16089. There are some updates which do not seem logical (although they will work with the default CI col... Ovidiu Maxiniuc
04:57 AM Feature #9456 (Merge Pending): implement SQL Server dialect and helpers: Ovidiu, please merge 9456a after 10114b. Constantin Asofiei
04:54 AM Feature #9456: implement SQL Server dialect and helpers: Committed on 9456a, rev. 16089. Added some udfs functions overloads, and small functions fix ups. Only @sqlserver/udf... Eduard Soltan
04:06 AM Feature #9456: implement SQL Server dialect and helpers: Eduard, please double-check your pending UDF changes for SqlServer and after that commit them to 9456a. We will merg... Constantin Asofiei

07/18/2025

05:18 PM Feature #10310: move tenant database from one multitenant cluster to another: In a multitenant environment, there is a requirement to "move" a tenant database instance from one database cluster t... Eric Faulhaber
04:52 PM Feature #10310 (New): move tenant database from one multitenant cluster to another: Eric Faulhaber
04:50 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap: Code review 10094a/16060-16062:
Looks good overall.
The only objection I have is that the dialect-specific erro... Eric Faulhaber
10:07 AM Bug #6923: inner transaction block reverts too much: What I continued investigating:
* I made the H2 changes to "reclaimPrimaryKey" if the DMO was NEW in the outer sub-t... Alexandru Lungu
06:54 AM Support #6709: track nested FIND inside a related FOR loop: > If conversion changes are acceptable, this is what I'd like to do.
Yes, go ahead. Greg Shah
06:50 AM Support #6709: track nested FIND inside a related FOR loop: Greg Shah wrote:
> Dănuț Filimon wrote:
> > [...]
> >
> > I can't come up with any idea on how to let the FindQu... Dănuț Filimon
06:47 AM Support #6709: track nested FIND inside a related FOR loop: Dănuț Filimon wrote:
> [...]
>
> I can't come up with any idea on how to let the FindQuery that @tt2@ is a refere... Greg Shah
03:51 AM Support #6709: track nested FIND inside a related FOR loop: ... Dănuț Filimon
05:02 AM Bug #9078: emit FindQuery as (reused) variables: I did a ChUI conversion and the project built with no issues, I noticed both the array and variable FindQuery types b... Dănuț Filimon
03:13 AM Feature #9456 (Internal Test): implement SQL Server dialect and helpers: Ovidiu, please consider 9456a frozen for testing. Constantin Asofiei
08:16 PM Feature #9456: implement SQL Server dialect and helpers: I added missing javadoc and reverted blank changes.
The support for boolean data type should be working correctly no... Ovidiu Maxiniuc

07/17/2025

05:03 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap: I used branch 10094a to test the import process on a large ST database and performed a smoke-test on it. No problems ... Ovidiu Maxiniuc
11:06 AM Bug #10307: FFcache keys don't match for the values inlined vs passed as args: While working on #8279, found a scenario where the a record wasn't retrieved from the FF cache, even though it should... Andrei Plugaru
11:02 AM Bug #10307 (New): FFcache keys don't match for the values inlined vs passed as args: Andrei Plugaru
11:01 AM Bug #10302: checkUniqueFind in FQLPreprocessor doesn't work properly: While working on #8279, I tried to understand how many @AdaptiveQuery@ s have the where clause matching an unique ind... Andrei Plugaru
07:37 AM Bug #10302 (New): checkUniqueFind in FQLPreprocessor doesn't work properly: Andrei Plugaru
07:57 AM Bug #9683: CompoundQuery is doing extra hydration attempts: I assume we will finish this task first, but I am highlighting that we *really need to finish* the general solution t... Greg Shah
02:17 AM Bug #9683: CompoundQuery is doing extra hydration attempts: Greg Shah wrote:
> We need to finish the work in #6720.
Before finishing up #9683 or instead of #9683? Artur Școlnic
06:59 AM Support #6709: track nested FIND inside a related FOR loop: I committed *6709a/16052*. Added FOR_LOOP_WHILE and DO_TO_WHILE reports, fixed database joins report. (refs: #6709)
... Dănuț Filimon
05:24 AM Support #6709: track nested FIND inside a related FOR loop: Added a fix to *6709a/16051*, only reports are affected. I also got the report results for the ChUI application.
!ch... Dănuț Filimon
03:20 AM Support #6709: track nested FIND inside a related FOR loop: One solution would be to consider all FindQuery nested when its buffers can be found in the @openBuffers@ and we are ... Dănuț Filimon
03:12 AM Support #6709: track nested FIND inside a related FOR loop: Greg Shah wrote:
> If we are implementing a runtime mode for this detection, we would expect to use the @Transaction... Dănuț Filimon
03:15 AM Feature #7504 (Test): Export data tool from FWD into .d files: *7504c* was merged into @trunk / rev 16053@. Lorian Sandu
03:06 AM Feature #7504 (Merge Pending): Export data tool from FWD into .d files: 7504c can be merged now. Constantin Asofiei
03:03 AM Feature #7504: Export data tool from FWD into .d files: Aside from exporting some data, I believe there's nothing else that needs testing, as the changes only affect @Export... Lorian Sandu

07/16/2025

12:43 PM Feature #4369: implement stateless FWD server clustering: We already run in Docker quite nicely. The issue is that there is quite a bit of 4GL compatibility (like database lo... Greg Shah
10:50 AM Feature #4369: implement stateless FWD server clustering: I am a little late to the party, but glancing over this task, I think Docker fits quite well for Stateless FWD Cluste... Artur Școlnic
12:25 PM Bug #9683: CompoundQuery is doing extra hydration attempts: We need to finish the work in #6720. Greg Shah
10:14 AM Bug #9683 (Review): CompoundQuery is doing extra hydration attempts: Artur Școlnic
06:48 AM Bug #9683: CompoundQuery is doing extra hydration attempts: Rebased 9683a on trunk rev 16047. Addressed review points in rev 16053. Artur Școlnic
12:24 PM Support #6709: track nested FIND inside a related FOR loop: We don't want this to be driven by conversion, but rather we would want to detect things purely based on runtime proc... Greg Shah
12:23 PM Support #6709: track nested FIND inside a related FOR loop: If we are implementing a runtime mode for this detection, we would expect to use the @TransactionManager@ to get deta... Greg Shah
06:31 AM Support #6709: track nested FIND inside a related FOR loop: Dănuț Filimon wrote:
> I'm looking into the runtime changes and how the blocks are converted at the moment, just to ... Dănuț Filimon
06:03 AM Support #6709: track nested FIND inside a related FOR loop: Ovidiu/Alexandru, please review 6709a for the report changes. Dănuț Filimon
05:20 AM Support #6709 (Review): track nested FIND inside a related FOR loop: I'm looking into the runtime changes and how the blocks are converted at the moment, just to understand what I can us... Dănuț Filimon
04:10 AM Support #6709: track nested FIND inside a related FOR loop: I rebased *6709a* to latest *trunk/16046* and committed *16050*. Added nested find block type reports. Dănuț Filimon
07:44 AM Bug #6923: inner transaction block reverts too much: I committed 6923a/16047 containing more or less the change in #6923-7. However, I refined it to better consider sub-t... Alexandru Lungu
06:19 AM Feature #9456: implement SQL Server dialect and helpers: No. @bzr@ added it without my knowledge. I never use @add@ during rebase. I think it was confused because the file wa... Ovidiu Maxiniuc
06:08 AM Feature #9456: implement SQL Server dialect and helpers: Ovidiu, is @src/com/goldencode/p2j/persist/dialect/P2JSQLServer2008Dialect.java.THIS.THIS@ supposed to exist? Constantin Asofiei
05:50 AM Feature #9456: implement SQL Server dialect and helpers: Branch 9456a was rebase to trunk r16048. Current revision is 16078. Ovidiu Maxiniuc
04:41 AM Feature #7504: Export data tool from FWD into .d files: Ovidiu Maxiniuc wrote:
> I took a look at 7504c / 16047.
>
> I think the code is handle the expanded extents corr... Lorian Sandu
04:14 AM Feature #7020 (Test): always use "expanded" extent fields: Branch 7020f was merged into trunk as rev. 16048 and archived. Stefanel Pezamosca
03:46 AM Feature #7020 (Merge Pending): always use "expanded" extent fields: Please merge 7020f now. Constantin Asofiei
03:46 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: I have ported the changes to @7156e@ as rev. 15764. Andrei Plugaru
03:17 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: 10111a changes should also be ported to *7156e*. Dănuț Filimon
03:15 AM Bug #10111 (Test): All statements are logged to a single text file for P2JQueryLogger and SQLStat...: I have merged to trunk as rev. 16047. Andrei Plugaru
02:39 AM Bug #10111 (Merge Pending): All statements are logged to a single text file for P2JQueryLogger an...: 10111a can be merged now. Constantin Asofiei

07/15/2025

06:02 PM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: I think so.
*Constantin* can you queue this branch for merging? Ovidiu Maxiniuc
06:50 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: I have rebased @10111a@ to the latest trunk.
*Ovidiu*, please let me know when can it be merged. Andrei Plugaru
06:18 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: OK. If there's just a single warning and the tests showed no regressions then I do not see a reason to delay the merg... Ovidiu Maxiniuc
03:13 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: Ovidiu Maxiniuc wrote:
> but if the node already exists, what will happen when FWD will try to read the node?
If ... Andrei Plugaru
03:06 PM Feature #7504: Export data tool from FWD into .d files: Lorian, please double-check datetime-tz scalar and extent fields. Constantin Asofiei
02:52 PM Feature #7504: Export data tool from FWD into .d files: I took a look at 7504c / 16047.
I think the code is handle the expanded extents correctly. However, I ask you agre... Ovidiu Maxiniuc
08:41 AM Feature #7504: Export data tool from FWD into .d files: I tested again the export tool and with the new @expanded_extents@ in place, there is a thing that i had to change in... Lorian Sandu
07:14 AM Feature #7504: Export data tool from FWD into .d files: The changes are good. I modified the title and contents to remove the reference to "Progress". These are now just r... Greg Shah
06:55 AM Feature #7504: Export data tool from FWD into .d files: > I will also update the [[p2j:Data_Migration#Data-Export|Data_Migration]] with details about the new export tool.
... Lorian Sandu
03:42 AM Feature #7504 (Test): Export data tool from FWD into .d files: *7504b* was merged into @trunk / rev 16046@
I will also update the [[p2j:Data_Migration#Data-Export|Data_Migration... Lorian Sandu
01:48 PM Feature #9456: implement SQL Server dialect and helpers: Thank you for noticing this issue.
The @SQLServerHelper@ class has more issues than this. It creates a list of DDL... Ovidiu Maxiniuc
11:12 AM Feature #9456: implement SQL Server dialect and helpers: Ovidiu, looking at the udfs tests I found a couple of problems:
1) When creating the udfs aliases, we get with ref... Eduard Soltan
12:27 PM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: At a first quick look, the code seems OK. I will do a more thoroughly review soon. Ovidiu Maxiniuc
10:23 AM Bug #10171 (Review): Word Index/CONTAINS support for MS SQL Server.: Ovidiu,
There was another issue in the trigger function generation for word index tables over expanded extent fiel... Stefanel Pezamosca
11:34 AM Feature #7020 (Internal Test): always use "expanded" extent fields: I have reviewed 7020f/r16040. I think the code is good.
In particular, I see a lot of changes in @rename_word_tables... Ovidiu Maxiniuc
07:40 AM Feature #7020: always use "expanded" extent fields: Ovidiu, please review the .sql and the FqlToSql changes Constantin Asofiei
04:36 AM Feature #7020: always use "expanded" extent fields: Added the dmoMeta NULL check in 7020f revision 16040.
7020f is ready for a final review. Stefanel Pezamosca
04:13 AM Feature #7020: always use "expanded" extent fields: I managed to reproduce.... Stefanel Pezamosca
03:45 AM Feature #7020: always use "expanded" extent fields: Constantin Asofiei wrote:
> Stefanel, the code in p2o.xml needs to be in an outer @while true@ loop, which exits whe... Stefanel Pezamosca
02:08 AM Feature #7020: always use "expanded" extent fields: Stefanel, the code in p2o.xml needs to be in an outer @while true@ loop, which exits when no longer @isCollision@ by ... Constantin Asofiei
09:23 AM Bug #9317 (Closed): FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause match...: This can be closed. Alexandru Lungu
08:09 AM Bug #10288: Encrypted connetion to SQL Server: Constantin Asofiei wrote:
> Is there any configuration specific on the setup of SQLServer ?
I just setup the SQL ... Eduard Soltan
08:05 AM Bug #10288: Encrypted connetion to SQL Server: Is there any configuration specific on the setup of SQLServer ? Constantin Asofiei
05:54 AM Support #6709: track nested FIND inside a related FOR loop: I've managed to get a report for nested FINDs in FOR EACH statements, the report works in the following way:
# there... Dănuț Filimon
04:04 AM Support #6709: track nested FIND inside a related FOR loop: Alexandru Lungu wrote:
> Is this ready for review? Or are you actively working on #6709-47?
I'm working on #6709-... Dănuț Filimon
04:02 AM Support #6709: track nested FIND inside a related FOR loop: Is this ready for review? Or are you actively working on #6709-47? Alexandru Lungu

07/14/2025

05:10 PM Feature #7504: Export data tool from FWD into .d files: Actually, please merge after 10286a. Greg Shah
02:35 PM Feature #7504 (Merge Pending): Export data tool from FWD into .d files: 7504b can be merged to trunk now. Greg Shah
02:16 PM Feature #7504: Export data tool from FWD into .d files: Yes, branch 7504b can be queued for merging into trunk. Ovidiu Maxiniuc
03:35 PM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: I understand that your test have a good coverage of the affected code.
Related to node type change. If the node is... Ovidiu Maxiniuc
02:48 PM Feature #9455: port native user defined functions to SQL Server: Ovidiu Maxiniuc wrote:
> I think the cause for this exception is the absence from @build.properties@ of the definiti... Eduard Soltan
02:25 PM Feature #9455: port native user defined functions to SQL Server: I think the cause for this exception is the absence from @build.properties@ of the definition for @db.import_threads@... Ovidiu Maxiniuc
01:09 PM Bug #10288: Encrypted connetion to SQL Server: Constantin Asofiei wrote:
> Lets make this decision only after we find what's needed to make the secure connection... Eduard Soltan
10:01 AM Bug #10288: Encrypted connetion to SQL Server: Eduard Soltan wrote:
> In a development environment should we use a certificate or skip the the certificate validati... Constantin Asofiei
09:12 AM Bug #10288: Encrypted connetion to SQL Server: In a development environment should we use a certificate or skip the the certificate validation? Eduard Soltan
05:12 AM Bug #10288: Encrypted connetion to SQL Server: SQL Server is running on a virtual machine. I want to connect to the server instance from my local environment (Ubunt... Eduard Soltan
04:42 AM Bug #10288 (New): Encrypted connetion to SQL Server: Eduard Soltan
07:47 AM Feature #7020 (Review): always use "expanded" extent fields: Committed to 7020f:
* revision 16037: Improved the logic of rename_word_tables_postgresql.sql - renaming the main wo... Stefanel Pezamosca
07:45 AM Feature #7020 (WIP): always use "expanded" extent fields: Created branch 7020f from trunk revision 16036.
Stefanel Pezamosca
05:16 AM Feature #7020: always use "expanded" extent fields: Constantin Asofiei wrote:
> 7020e was merged to trunk rev 16036 - it contained a fix related to loading extent datet... Stefanel Pezamosca
07:19 AM Bug #9078: emit FindQuery as (reused) variables: DO blocks are quite tricky, those blocks do not have an instvarid and in some cases I can get out of the expected blo... Dănuț Filimon
06:54 AM Bug #6923: inner transaction block reverts too much: I am encountering the same problem described here when dealing with #8388. The reason is exactly that the DMO is roll... Alexandru Lungu
04:16 AM Bug #10285: Static compound query returns no result: I have found out that the issue is only reproducible when using the MariaDB driver. I have tracked the difference to ... Andrei Plugaru
04:12 AM Bug #10285: Static compound query returns no result: While investigating #8279, regarding some CQ instances, I found an example that doesn't seem to work properly in FWD:... Andrei Plugaru
04:11 AM Bug #10285 (Test): Static compound query returns no result: Andrei Plugaru

07/13/2025

05:42 AM Feature #7020: always use "expanded" extent fields: There is also this NPE in ETF:... Constantin Asofiei
04:43 AM Feature #7020: always use "expanded" extent fields: 7020e was merged to trunk rev 16036 - it contained a fix related to loading extent datetime-tz fields (the offset in ... Constantin Asofiei

07/11/2025

09:31 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap: Constantin Asofiei wrote:
> Why the @if (restInBucket++ == 0)@? Just to get the first result?
Sorry for the C/C++ ... Ovidiu Maxiniuc
09:17 AM Feature #10094 (Internal Test): RECIDs from different tenants of same logical database should not...: I've also tested an import and it worked. Constantin Asofiei
09:17 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap: @TenantIdContext.prepareNextBracket@ - there is a @while (rs.next())@ which suggets that there may be more than one ... Constantin Asofiei
08:58 AM Support #6709: track nested FIND inside a related FOR loop: To do:
* add a report where nested find queries are displayed based on the type of block, but only if the block refe... Dănuț Filimon
07:40 AM Support #6709: track nested FIND inside a related FOR loop: Committed *6709a/16034*. Included UNIQUE finds in the report, I missed those previously. Dănuț Filimon
06:54 AM Support #6709: track nested FIND inside a related FOR loop: Dănuț Filimon wrote:
> * Nested FIND: 13 first, 6 next, 5 last, 5 current, 3 where (this is confusing a bit because ... Dănuț Filimon
06:35 AM Bug #9078 (Review): emit FindQuery as (reused) variables: Fixed #9078-113 in *9078b/16039*. We did not emit the find query as a variable when we had a block in the queue, but ... Dănuț Filimon
05:21 AM Bug #9078 (WIP): emit FindQuery as (reused) variables: Found the issue from #9078-113 again, but I got a reliable reproduction this time. It seems that when I use the array... Dănuț Filimon
06:23 AM Feature #9456: implement SQL Server dialect and helpers: This is in trunk.
* Dialect has this:... Constantin Asofiei
06:14 AM Feature #9456: implement SQL Server dialect and helpers: Constantin Asofiei wrote:
> Ovidiu, first results on conversion: @nulls last@ is added on indexes for H2 dialect (th... Ovidiu Maxiniuc

07/10/2025

06:09 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap: Constantin Asofiei wrote:
> Ovidiu, are there any changes required in existing scripts (non-tenant and multi-tenant)... Ovidiu Maxiniuc
05:40 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap: Ovidiu, are there any changes required in existing scripts (non-tenant and multi-tenant) for data import? Constantin Asofiei
03:51 PM Feature #9456: implement SQL Server dialect and helpers: This is not intentional. I wonder why I did not notice it. It is a regression. Thank you for reporting it. I'm fixing... Ovidiu Maxiniuc
03:48 PM Feature #9456: implement SQL Server dialect and helpers: Ovidiu, first results on conversion: @nulls last@ is added on indexes for H2 dialect (this includes the meta schema a... Constantin Asofiei
11:58 AM Feature #9456 (Review): implement SQL Server dialect and helpers: Ovidiu Maxiniuc
11:58 AM Feature #9456: implement SQL Server dialect and helpers: Branch 9456a was rebased to trunk/16032. Pushed up to revision 16060.
It is ready for review.
Note: I have some... Ovidiu Maxiniuc
05:41 AM Feature #9456: implement SQL Server dialect and helpers: Ovidiu, can 9456a be moved to review?
About the data/dump/ database folder missing: if you haven't already fixed i... Constantin Asofiei
09:57 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: I have run a test suite of a large customer application and also tested different options for the logging tools and d... Andrei Plugaru
09:24 AM Support #6709: track nested FIND inside a related FOR loop: I ran the reports for hotel and got:
* Nested FIND: 13 first, 6 next, 5 last, 5 current, 3 where (this is confusing ... Dănuț Filimon
08:02 AM Support #6709: track nested FIND inside a related FOR loop: Committed *6709a/16032*. Extended the functionality of the nested_find annotation and added more detailed reports:
... Dănuț Filimon
05:48 AM Support #6709: track nested FIND inside a related FOR loop: > Alex, I took a look at the last example from #6709-38 and only the FOR EACH find has the nested_find annotation. Ar... Alexandru Lungu

07/09/2025

12:17 PM Feature #9455: port native user defined functions to SQL Server: Tried to import the import the testcases database in sql server and got the following error.... Eduard Soltan
10:34 AM Bug #10276: Joinable interface should be made public: While investigating #8279, I found an important functional issue regarding @Joinable@ interface. I was getting this e... Andrei Plugaru
08:51 AM Bug #10276 (New): Joinable interface should be made public: Andrei Plugaru
08:49 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: Thanks, Ovidiu for the review.
Regarding testing, I am thinking of running a test suite of a large customer applic... Andrei Plugaru
08:00 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap: *Eric/Constantin: Please review this ASAP so we can move this task ahead.* Greg Shah
08:00 AM Support #6709: track nested FIND inside a related FOR loop: ... Dănuț Filimon
07:18 AM Feature #7504: Export data tool from FWD into .d files: Ovidiu: Please get this into the merge queue if it is ready to go. Greg Shah
05:36 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: I fixed the above warnings by creating the @word@ field in the generated @wordTable@ with the parent field @maxWidth@... Stefanel Pezamosca
04:33 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: > Maybe a possible solution is to have a mix of private FFCs and common FFC. The latter will keep only pristine data ... Alexandru Lungu
03:49 AM Bug #6767: Possible name clashes in DMO classes: Vladimir Tsichevski wrote:
>
> So I am not the person to blame :-).
OK, you get only a partial blame :-).
I ... Hynek Cihlar
03:37 AM Bug #10083 (Test): Infinite loop when changing walking index fields: Constantin Asofiei

07/08/2025

07:43 PM Feature #10270: implement some temp-tables using the persistent database instance when they are j...: I think this might be useful, but the heuristic could be difficult to implement because of dynamic queries. What I me... Ovidiu Maxiniuc
09:35 AM Feature #10270: implement some temp-tables using the persistent database instance when they are j...: > The idea here is that we could analyze usage of each temp-table and implement heuristcs that mark specific temp-tab... Alexandru Lungu
08:28 AM Feature #10270: implement some temp-tables using the persistent database instance when they are j...: The idea here is that we could analyze usage of each temp-table and implement heuristcs that mark specific temp-table... Greg Shah
08:23 AM Feature #10270 (New): implement some temp-tables using the persistent database instance when they...: Greg Shah
07:31 PM Bug #10111 (Internal Test): All statements are logged to a single text file for P2JQueryLogger an...: I think the changes in 15984 are OK. Can we move to 100% done? Ovidiu Maxiniuc
04:24 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: I remembered something worth noting. In my current implementation, I have changed the type of the @enabled@ node for ... Andrei Plugaru
03:51 AM Bug #10111 (Review): All statements are logged to a single text file for P2JQueryLogger and SQLSt...: I have committed @10111a/15984@ with the missing files and addressed the rest of the review. Ovidiu, please take a lo... Andrei Plugaru
06:44 PM Feature #9456: implement SQL Server dialect and helpers: As discussed during technical meet from Monday I tried executing the import from within the guest OS. That required m... Ovidiu Maxiniuc
01:05 PM Feature #9456: implement SQL Server dialect and helpers: 9456a seems stable now after the fixes for word tables.
The customer's 'small' database imports without any issue.... Ovidiu Maxiniuc
12:31 PM Feature #9456: implement SQL Server dialect and helpers: Ovidiu/Stefanel/Eduard: please lets get 9456a stabilized and ready for review tomorrow (this will include all the UDF... Constantin Asofiei
06:34 PM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: Alexandru Lungu wrote:
> Of course, I am looking further for *Ovidiu*'s input on this matter.
I had a look over 102... Ovidiu Maxiniuc
04:39 PM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: I have just noticed a warning when the word indexes are created:... Ovidiu Maxiniuc
08:24 AM Bug #10171 (WIP): Word Index/CONTAINS support for MS SQL Server.: Stefanel Pezamosca wrote:
> Hmm, another case of "IntelliJ knows better".
It tries to help based on your configurat... Ovidiu Maxiniuc
06:54 AM Bug #10171 (Review): Word Index/CONTAINS support for MS SQL Server.: I fixed the above issues in revision 9456a revision 16053. Stefanel Pezamosca
04:47 AM Bug #10171 (WIP): Word Index/CONTAINS support for MS SQL Server.: Stefanel Pezamosca
04:47 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: Ovidiu Maxiniuc wrote:
> I did not do a thorough review, only a few observations:
> * please stick to JDK8 for the ... Stefanel Pezamosca
02:56 PM Bug #6767: Possible name clashes in DMO classes: Hynek Cihlar wrote:
> The private data getter and setter was added by Vladimir in the context of #5144. I don't reca... Vladimir Tsichevski
01:42 PM Bug #6767: Possible name clashes in DMO classes: The private data getter and setter was added by Vladimir in the context of #5144. I don't recall @PRIVATE-DATA@ neede... Hynek Cihlar
09:47 AM Support #6709: track nested FIND inside a related FOR loop: Alex, I took a look at the last example from #6709-38 and only the FOR EACH find has the nested_find annotation. Are ... Dănuț Filimon
09:05 AM Support #6709: track nested FIND inside a related FOR loop: I'll mention a few ideas from the latest discussions so that I do not lose track of them:
* Tracking nested finds in... Dănuț Filimon
07:59 AM Support #6709: track nested FIND inside a related FOR loop: There are some bugs in the report so that more nested FINDs are logged than needed. I think the flag is set incorrect... Alexandru Lungu
09:43 AM Bug #10198: analyze FIND statements which use only a small number of fields: Just FYI: I also thought of this a while ago, but there was an issue with caching. The more variance we have in the F... Alexandru Lungu
09:43 AM Feature #9455: port native user defined functions to SQL Server: Ovidiu Maxiniuc wrote:
> I do not know (most likely not yet) whether 9457c was also rebased. Therefore they are most... Constantin Asofiei
09:41 AM Feature #9455: port native user defined functions to SQL Server: Ovidiu Maxiniuc wrote:
>
> I do not know (most likely not yet) whether 9457c was also rebased. Therefore they are ... Eduard Soltan
09:35 AM Feature #9455: port native user defined functions to SQL Server: Branch 9456a was rebased after 7020a was merged in. The denormalisation of extent fields was replaced with expanded c... Ovidiu Maxiniuc
09:27 AM Feature #9455: port native user defined functions to SQL Server: Eduard Soltan wrote:
> I think there is a issue with some @_meta@ dmos.
>
> The following field in @_meta.MetaDb@... Stefanel Pezamosca
09:26 AM Feature #9455: port native user defined functions to SQL Server: I think there is a issue with some @_meta@ dmos.
The following field in @_meta.MetaDb@ dmo:... Eduard Soltan
07:55 AM Bug #9078 (Review): emit FindQuery as (reused) variables: I added 9078b to my ETF conversion queue, it will take a while to get through it. Dănuț Filimon
07:54 AM Bug #9078: emit FindQuery as (reused) variables: Dănuț Filimon wrote:
> I've managed to fix the issue, I've also noticed that CAN-FINDs were ignored and AdaptiveFind... Dănuț Filimon
07:23 AM Bug #9078: emit FindQuery as (reused) variables: I've managed to fix the issue, I've also noticed that CAN-FINDs were ignored and AdaptiveFinds were also counted. I'l... Dănuț Filimon
06:24 AM Bug #9078 (WIP): emit FindQuery as (reused) variables: I've found an issue while converting ETF:... Dănuț Filimon

07/07/2025

04:07 PM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: I did not do a thorough review, only a few observations:
* please stick to JDK8 for the moment. @List<E> of(E... ele... Ovidiu Maxiniuc
02:50 PM Feature #9455: port native user defined functions to SQL Server: See my note #9991-52. The import of the smaller database was (pretty much) successful.
There are some issues with t... Ovidiu Maxiniuc
02:32 PM Feature #9455: port native user defined functions to SQL Server: Manage to set up Hotel Gui with connection to a SQL Server instance running on a virtual machine. Did a smoke test wi... Eduard Soltan
10:26 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: Ovidiu Maxiniuc wrote:
> +Review of 10111a/r15983+
>
> First, why in revno: 15983 the files: @src/com/goldencode/... Andrei Plugaru
10:12 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: +Review of 10111a/r15983+
First, why in revno: 15983 the files: @src/com/goldencode/p2j/persist/BaseLoggingConfigu... Ovidiu Maxiniuc
04:59 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: I think this branch is ready for a review.
Main changes:
* @10111a/15982@: Moved the common logic from @P2JLoggingD... Andrei Plugaru
09:22 AM Feature #7020: always use "expanded" extent fields: Roger Borrello wrote:
> Stefanel Pezamosca wrote:
> > Is there anything else to do before merging 7020d to trunk?
... Stefanel Pezamosca
09:21 AM Feature #7020: always use "expanded" extent fields: Stefanel Pezamosca wrote:
> Is there anything else to do before merging 7020d to trunk?
Yes... I know. Too late.
... Roger Borrello
09:16 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: > FWD is not leaking anything except FINDs that were done on other sessions as well. It sounds quite bad to me. Overa... Greg Shah
08:44 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: Of course, I am looking further for *Ovidiu's* input on this matter. Alexandru Lungu
08:40 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: *Greg*, I decided in today's stand-up to put #10222 on hold. The implementation of fast-find cache is complete and so... Alexandru Lungu
06:04 AM Support #10222 (WIP): Is cross-session dirty share available through Fast Find Cache even if disa...: Review for #10222:
* I don't understand @session.getCached(dmo.getClass(), cacheResult.getRecordID()).equals(dmo))@.... Alexandru Lungu
08:36 AM Bug #6767: Possible name clashes in DMO classes: Constantin Asofiei wrote:
> Argh, this is OCX.
It was, but it is not in FWD.
>
> Hynek: can you point Vladimir t... Vladimir Tsichevski
01:44 AM Bug #6767: Possible name clashes in DMO classes: Argh, this is OCX.
Hynek: can you point Vladimir to an example how @TreeFace@ emits @get/setPrivateData@ via OCX? Constantin Asofiei
07:17 AM Bug #9078: emit FindQuery as (reused) variables: Rebased *9078b* to latest *trunk/16028*, the branch is now at revision *16037*. Dănuț Filimon
02:39 AM Bug #9078: emit FindQuery as (reused) variables: Constantin Asofiei wrote:
> Danut, does @AdaptiveFind@ still emit properly? This is the @FIND FIRST. REPEAT: FIND N... Dănuț Filimon
02:25 AM Bug #9078: emit FindQuery as (reused) variables: Danut, does @AdaptiveFind@ still emit properly? This is the @FIND FIRST. REPEAT: FIND NEXT. END.@ pattern, if I'm no... Constantin Asofiei
02:19 AM Feature #7504: Export data tool from FWD into .d files: The runtime regression testing for @7504b@ finished successfully. Lorian Sandu

07/04/2025

11:45 AM Bug #9078: emit FindQuery as (reused) variables: The 9078b/16012 seems OK. Ovidiu Maxiniuc
09:36 AM Feature #7020 (Test): always use "expanded" extent fields: Branch 7020d was merged to trunk rev 16026 and archived. Stefanel Pezamosca
08:41 AM Feature #7020 (Merge Pending): always use "expanded" extent fields: I don't think so. Please go ahead and merge.
Make sure to have in the note at #8828 what is needed to run for tha... Constantin Asofiei
08:37 AM Feature #7020: always use "expanded" extent fields: Is there anything else to do before merging 7020d to trunk? Stefanel Pezamosca
08:04 AM Feature #7020: always use "expanded" extent fields: Ovidiu Maxiniuc wrote:
> Rename the file so that we know the dialect. We will eventually group them by dialects if t... Stefanel Pezamosca
07:45 AM Feature #7020: always use "expanded" extent fields: Rename the file so that we know the dialect. We will eventually group them by dialects if the number of files in the ... Ovidiu Maxiniuc
07:23 AM Feature #7020: always use "expanded" extent fields: Ovidiu Maxiniuc wrote:
> I have reviewed revisions 16043..16046 (LE) of 7020d. I see nothing wrong with the code.
>... Stefanel Pezamosca
07:16 AM Feature #7020: always use "expanded" extent fields: I have reviewed revisions 16043..16046 (LE) of 7020d. I see nothing wrong with the code.
The new file @migrate_wor... Ovidiu Maxiniuc
04:24 AM Feature #7020: always use "expanded" extent fields: Committed to 7020d revision 16046 a change to build.xml to include @tools/scripts/*.sql@ into @p2j.jar@. Stefanel Pezamosca
01:57 AM Feature #7020: always use "expanded" extent fields: Branch *7020d* was rebased to *trunk revsion 16023*, now at revision *16045*.
In revision 16044, I added the @migr... Stefanel Pezamosca
05:33 AM Feature #9455: port native user defined functions to SQL Server: Added 3 more SQL test files to @testcases/udfs/t-sql@.
Committed on 9456a, rev. 16042 - 16043, fix ups of @tostrin... Eduard Soltan
01:37 AM Feature #9455: port native user defined functions to SQL Server: Committed functions fixups on 9456a, rev. 16040. Eduard Soltan
04:09 AM Bug #10195 (Test): Reset of query buffer in a nested function: 10195a was merged to trunk 16024 and archived. Eduard Soltan
03:39 AM Bug #10195 (Merge Pending): Reset of query buffer in a nested function: Constantin Asofiei
04:02 AM Bug #10171 (Review): Word Index/CONTAINS support for MS SQL Server.: I have committed my changes for word tables support in MS SQL Server in *9456a revision 16041*.
At the moment only ... Stefanel Pezamosca

07/03/2025

01:59 PM Bug #10195: Reset of query buffer in a nested function: Constantin Asofiei wrote:
> I'll run ETF today.
ETF passed. Constantin Asofiei
10:34 AM Bug #10195: Reset of query buffer in a nested function: I'll run ETF today. Constantin Asofiei
10:31 AM Bug #10195: Reset of query buffer in a nested function: Testing performed the 10195 branch:
- smoke tests of a GUI application ☑️
- smoke and unit tests of a large GUI a... Eduard Soltan
11:49 AM Bug #6767: Possible name clashes in DMO classes: Vladimir Tsichevski wrote:
> Constantin Asofiei wrote:
> > Vladimir, please look into TreeFace.java and TreeWidgetB... Vladimir Tsichevski
11:16 AM Bug #6767: Possible name clashes in DMO classes: Constantin Asofiei wrote:
> Vladimir, please look into TreeFace.java and TreeWidgetBase.java - these define i.e. @ge... Vladimir Tsichevski
10:48 AM Bug #10083 (Internal Test): Infinite loop when changing walking index fields: 10083a was merged to trunk rev 16023 and archived. Eduard Soltan
10:34 AM Bug #10083 (Merge Pending): Infinite loop when changing walking index fields: Please merge now. Constantin Asofiei
10:30 AM Bug #10083: Infinite loop when changing walking index fields: Constantin Asofiei wrote:
> ETF testing passed.
>
> Is there anything else to test?
Stefanel tested another cu... Eduard Soltan
04:14 AM Bug #10083: Infinite loop when changing walking index fields: ETF testing passed.
Is there anything else to test? Constantin Asofiei
10:35 AM Feature #9455: port native user defined functions to SQL Server: Adopted the sql tests for T-SQL and posted on @testcases/udfs/t-sql@. Eduard Soltan
08:10 AM Feature #7020: always use "expanded" extent fields: I have committed @migrate_word_table_names.sql@ to @7020d/tools/scripts@ and added copyright and history entries, etc. Stefanel Pezamosca
07:57 AM Bug #9078 (Review): emit FindQuery as (reused) variables: Committed *9078b/16012*. In case of a DO block that is also a loop, ensure that a block/inner block with "instvarid" ... Dănuț Filimon
06:17 AM Bug #9078 (WIP): emit FindQuery as (reused) variables: There's a scenario when using a DO block as a loop and there is no "instvarid" to attach the array, this causes the c... Dănuț Filimon
07:52 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: Stefanel Pezamosca wrote:
> Word tables should theoretically work now. All I need to do is to test them on a real te... Eduard Soltan
07:15 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: Word tables should theoretically work now. All I need to do is to test them on a real testcase. Before that, I want a... Stefanel Pezamosca
07:14 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...: I have committed in @10111a/15980@ the main refactor for having the common logic from @P2JQueryStatisticsConfiguratio... Andrei Plugaru

07/02/2025

10:49 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: I have the function to generate the necessary triggers for word index table updates. I attached a generated DDL to se... Stefanel Pezamosca
05:46 AM Feature #9455: port native user defined functions to SQL Server: Eduard Soltan wrote:
> Question, can the tests from @testcases/udfs@ be adopted to SQL Server and properly tested?
... Greg Shah
03:11 AM Bug #6767: Possible name clashes in DMO classes: Vladimir, please look into TreeFace.java and TreeWidgetBase.java - these define i.e. @get/setPrivateData@, while the ... Constantin Asofiei
02:32 AM Bug #10083: Infinite loop when changing walking index fields: Constantin Asofiei wrote:
> I'll run ETF with this. Eduard, what's the state of the #10083-17 tests?
Passed with... Eduard Soltan
02:31 AM Bug #10083: Infinite loop when changing walking index fields: I'll run ETF with this. Eduard, what's the state of the #10083-17 tests? Constantin Asofiei

07/01/2025

07:42 PM Feature #9455: port native user defined functions to SQL Server: Yes, I think so. That's a good idea. Although, at a quick look they are not very extensive, but it's better than noth... Ovidiu Maxiniuc
04:09 AM Feature #9455: port native user defined functions to SQL Server: Question, can the tests from @testcases/udfs@ be adopted to SQL Server and properly tested? Eduard Soltan
01:43 AM Feature #9455: port native user defined functions to SQL Server: Ovidiu Maxiniuc wrote:
> Eduard,
>
> Do you have any pending changes to 9456a as part of this task?
For now n... Eduard Soltan
03:41 PM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: Yes, please. Use 9456a. Ovidiu Maxiniuc
05:04 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: I have an untested prototype for @P2JSQLServer2012Dialect.generateWordTablesDDLImpl@ method. I guess I should work ov... Stefanel Pezamosca
08:13 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: Artur Școlnic wrote:
> I used the temp table for simplicity, the behavior of the @find@ should be similar. I am just... Greg Shah
06:27 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: I used the temp table for simplicity, the behavior of the @find@ should be similar. I am just trying to understand wh... Artur Școlnic
06:18 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: PS: FWD is trying to do its best to cover such "no cost" with the FF cache. Alexandru Lungu
06:17 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: > Is this accurate?
> find tt1 where tt1.f1 = 1. //no op? record already in buffer
Not really. We can't tell if... Alexandru Lungu
04:08 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: ... Artur Școlnic
02:56 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: I made the change, the code is in 10222a/16013. Artur Școlnic

06/30/2025

10:12 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.: Yes, there are a few changes in the UDFs for word tables. To check their existence the right type is @IF@ not @FN@ an... Ovidiu Maxiniuc
03:56 AM Bug #10171 (WIP): Word Index/CONTAINS support for MS SQL Server.: What I have so far.
* An improved @dbo.words@ function:... Stefanel Pezamosca
10:08 AM Bug #6767: Possible name clashes in DMO classes: 6767c rebased to the current trunk, rev now is 16018. Vladimir Tsichevski
08:29 AM Bug #6767: Possible name clashes in DMO classes: Tested the branch with our big customer application, and no issues were identified. We can also validate using our Ch... Vladimir Tsichevski
09:59 AM Feature #9455: port native user defined functions to SQL Server: Eduard,
Do you have any pending changes to 9456a as part of this task?
The reason to ask is that I have some o... Ovidiu Maxiniuc
09:54 AM Bug #9078: emit FindQuery as (reused) variables: I looked at the fix in 16011. The changes are correct. Ovidiu Maxiniuc
02:26 AM Bug #9078: emit FindQuery as (reused) variables: Dănuț Filimon wrote:
> Artur found a regression while converting a customer application, currently investigating.
I... Dănuț Filimon
02:18 AM Bug #9078: emit FindQuery as (reused) variables: Artur found a regression while converting a customer application, currently investigating. Dănuț Filimon
09:12 AM Feature #7020: always use "expanded" extent fields: *7020d* was rebased to *trunk revision 16013*. Last revision is 16033. Stefanel Pezamosca
02:00 AM Feature #7020: always use "expanded" extent fields: All regression testing has passed. The previous found regression for ChUI tests has been fixed.
I'd say *7020d* is... Stefanel Pezamosca
07:59 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: Artur Școlnic wrote:
> I agree, in a hypothetical scenario where someone changes a record and immediately attempts t... Greg Shah
07:47 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: I agree, in a hypothetical scenario where someone changes a record and immediately attempts to find it more than once... Artur Școlnic
07:43 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: Yes, this is what happens in trunk and is a valid scenario. Removing this will be functionally OK, but we will see a ... Alexandru Lungu
07:42 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: So to be clear, in the same session, If a record is modified, but not yet committed, it should be cached and be found... Artur Școlnic
07:39 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: Artur Școlnic wrote:
> It is my understanding that this is correct behavior, if the data is changed (and uncommitted... Alexandru Lungu
07:37 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: Alexandru Lungu wrote:
> I one session runs a FIND multiple times, then it won't benefit from the cache considering ... Artur Școlnic
07:34 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: After writing #10222-1 I reckon that such change can introduce some performance penalty for same-session case. I one ... Alexandru Lungu
07:21 AM Support #10222 (Review): Is cross-session dirty share available through Fast Find Cache even if d...: I added a new dmo state @COMMITED@, it indicates that a record contains committed data, dafault value is true. The fa... Artur Școlnic
04:31 AM Support #10222 (WIP): Is cross-session dirty share available through Fast Find Cache even if disa...: Artur Școlnic
04:03 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: There are two changes we should consider implementing to prevent transaction isolation violations in Fast Find Cache:... Artur Școlnic
03:39 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?: The Fast Find Cache is a cache that targets FIND queries. It is cross-session and per-database. If a session does a F... Alexandru Lungu
03:28 AM Support #10222 (WIP): Is cross-session dirty share available through Fast Find Cache even if disa...: Alexandru Lungu
06:53 AM Support #10226: Consider creating one single dirty-share database per session to support intra-se...: Similar to #10222, I think that @DefaultDirtyShareManager@ is still able to leak records in between sessions. I am no... Alexandru Lungu
06:49 AM Support #10226 (New): Consider creating one single dirty-share database per session to support in...: Alexandru Lungu

06/27/2025

12:43 PM Bug #10181 (Test): Date shifted one day earlier when importing data: Branch 10181a was merged into trunk on behalf of Lorian (ls) as rev. 16010 and archived. Ovidiu Maxiniuc
09:24 AM Bug #10181: Date shifted one day earlier when importing data: Update on the regression testing:
* harness ✅
* large app with fwd tests -- unittests ✅
* large GUI app unittest... Lorian Sandu
09:44 AM Bug #10195 (Internal Test): Reset of query buffer in a nested function: I am OK with the changes in 10195a. Alexandru Lungu
08:05 AM Bug #10195 (Review): Reset of query buffer in a nested function: Eduard Soltan
05:16 AM Bug #10195: Reset of query buffer in a nested function: Committed on 10195a, rev. 15997.
Changed iterateReleaseOverrideScope into a stack of scopes. A new level is added... Eduard Soltan
03:55 AM Bug #10195: Reset of query buffer in a nested function: Alexandru Lungu wrote:

> This is a problem, right?
Of course this is a problem, I am currently giving a try to... Eduard Soltan
03:25 AM Bug #10195: Reset of query buffer in a nested function: Eduard Soltan wrote:
> Alexandru Lungu wrote:
> > > It is not affected since the RecordBuffer will not be included ... Alexandru Lungu
03:24 AM Bug #10195: Reset of query buffer in a nested function: Alexandru Lungu wrote:
> > It is not affected since the RecordBuffer will not be included in the of the nested for-e... Eduard Soltan
09:33 AM Feature #7020: always use "expanded" extent fields: Stefanel Pezamosca wrote:
> There may be a regression showing in the ChUI tests. I need to double check.
I might ... Stefanel Pezamosca
03:26 AM Feature #7020: always use "expanded" extent fields: #10215 is the task handling this. Alexandru Lungu
09:23 AM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...: I did a small investigation into this issue, my main conclusions are:
1. Unix sockets cannot be used to communicat... Artur Școlnic
09:01 AM Bug #9078: emit FindQuery as (reused) variables: I committed *9078b/16010* to address #9078-101 and #9078-102. Dănuț Filimon
07:29 AM Bug #9078: emit FindQuery as (reused) variables: I think @downPath(this, prog.kw_find, prog.record_phrase)@ will cover all @FIND@ statements. For example, a @FIND FIR... Ovidiu Maxiniuc
04:16 AM Bug #9078: emit FindQuery as (reused) variables: Ovidiu Maxiniuc wrote:
> I looked at 9078b / r16008.
>
> The code looks pretty much solid. But it's difficult to ... Dănuț Filimon
08:42 AM Feature #9456: implement SQL Server dialect and helpers: As reported previously, I encountered some issues while fixing the FWD support for logical/boolean expressions in MSS... Ovidiu Maxiniuc
02:51 AM Feature #9455: port native user defined functions to SQL Server: Changed udfs names and comments formats in *rev. 16007*. I confused the formats with @mariadb@ udfs, and it is a bit ... Eduard Soltan

06/26/2025

07:10 PM Feature #9455: port native user defined functions to SQL Server: Sorry, I did these changes unintentionally. I do not have an explanation for them 😕. Ovidiu Maxiniuc
07:02 PM Feature #9455: port native user defined functions to SQL Server: Eduard,
I looked a bit over the UDFs you wrote. There is a bit of work still to be done. Please see my 5 notes blo... Ovidiu Maxiniuc
08:11 AM Feature #9455: port native user defined functions to SQL Server: Eduard Soltan wrote:
> Committed on 9456a, rev. *16006*.
Thank you, I am grabbing the changes right now.
> Add m... Ovidiu Maxiniuc
05:07 AM Feature #9455: port native user defined functions to SQL Server: Committed on 9456a, rev. *16006*.
Add most of the remaining udfs. There still some edge cases to handle, especiall... Eduard Soltan
04:35 PM Bug #9078: emit FindQuery as (reused) variables: I looked at 9078b / r16008.
The code looks pretty much solid. But it's difficult to spot all possible issues only ... Ovidiu Maxiniuc
07:25 AM Bug #9078: emit FindQuery as (reused) variables: Rebased *9078b* to latest *trunk/16003*, the branch is now at revision *16008*. Dănuț Filimon
06:57 AM Bug #9078 (Review): emit FindQuery as (reused) variables: Committed *9078b/15974*, Added rules to count the number of FindQuery instances in a top level block, but also added ... Dănuț Filimon
02:45 PM Bug #6767: Possible name clashes in DMO classes: Constantin Asofiei wrote:
> The conversion with 6767c gives me this:
> [...]
>
> The compile error is on @getPri... Vladimir Tsichevski
02:06 PM Bug #6767: Possible name clashes in DMO classes: The conversion with 6767c gives me this:... Constantin Asofiei
01:43 PM Bug #6767: Possible name clashes in DMO classes: Constantin Asofiei wrote:
> Vladimir Tsichevski wrote:
> > I updated @methodText@ from @getNextSibling@ to @nextSib... Vladimir Tsichevski
12:35 PM Bug #6767: Possible name clashes in DMO classes: Vladimir Tsichevski wrote:
> I updated @methodText@ from @getNextSibling@ to @nextSibling@. However, this change did... Constantin Asofiei
01:22 PM Feature #7020: always use "expanded" extent fields: Stefanel Pezamosca wrote:
> Roger Borrello wrote:
> > An I apologize if this isn't related to expanded extents at a... Roger Borrello
01:09 PM Feature #7020: always use "expanded" extent fields: Roger Borrello wrote:
> An I apologize if this isn't related to expanded extents at all. I can post to #7143, if nec... Stefanel Pezamosca
01:00 PM Feature #7020: always use "expanded" extent fields: And I apologize if this isn't related to expanded extents at all. I can post to #7143, if necessary. Roger Borrello
12:58 PM Feature #7020: always use "expanded" extent fields: I am not sure if this is related, but I the *ReportDriver* gives a NPE error getting the @"extent"@ annotation.
{{co... Roger Borrello
09:29 AM Feature #7020: always use "expanded" extent fields: Stefanel Pezamosca wrote:
> Roger Borrello wrote:
> > Stefanel Pezamosca wrote:
> > > Radu tested @7020d@ with @<p... Roger Borrello
10:18 AM Bug #10195: Reset of query buffer in a nested function: > It is not affected since the RecordBuffer will not be included in the of the nested for-each block or any other ite... Alexandru Lungu
10:01 AM Bug #10195: Reset of query buffer in a nested function: Alexandru Lungu wrote:
> I am OK with the changes in 10195a.
>
> The point here is that the buffer can have its s... Eduard Soltan
08:57 AM Bug #10049: UDF configuration regression in Persistence.java: Ovidiu Maxiniuc wrote:
> No intention. Sorry. Reverted back to old values.
Thank you! Roger Borrello
08:56 AM Bug #10083: Infinite loop when changing walking index fields: Rebased to latests trunk, and performed the following tests:
- smoke tests of a GUI application ☑️
- smoke and un... Eduard Soltan
08:06 AM Feature #10169: result-set streaming (and asynchronous programming?): I want this to also be documented in case the discussion about using one connection in a multithreaded environment ar... Artur Școlnic
07:29 AM Feature #10169: result-set streaming (and asynchronous programming?): I want to document on the task what exactly could the async 'for each' achieve and when it is especially beneficial.
... Artur Școlnic

06/25/2025

05:30 PM Feature #9455 (WIP): port native user defined functions to SQL Server: Yes, of course! Ovidiu Maxiniuc
08:27 AM Feature #9455: port native user defined functions to SQL Server: Ovidiu, should I commit my udfs implementation on 9456a? Eduard Soltan
05:28 PM Bug #10049: UDF configuration regression in Persistence.java: No intention. Sorry. Reverted back to old values. Ovidiu Maxiniuc
05:03 PM Bug #10049: UDF configuration regression in Persistence.java: I am a little concerned with how Hotel GUI has changed. I have been enabling the capability to modify the password fo... Roger Borrello
10:37 AM Feature #10169: result-set streaming (and asynchronous programming?): > To answer Alexandru's questions, the JDBC driver does not allow for concurrent result set traversal within a single... Alexandru Lungu
10:28 AM Feature #10169: result-set streaming (and asynchronous programming?): To answer Alexandru's questions, the JDBC driver does not allow for concurrent result set traversal within a single ... Artur Școlnic
09:23 AM Feature #10169: result-set streaming (and asynchronous programming?): I really don't want to purge some historical philosophy from FWD (JDBC + connection pooling + one connection per thre... Alexandru Lungu
05:33 AM Feature #10169: result-set streaming (and asynchronous programming?): I also think we can determine if the queries in the for each alter the iterated table, if not, enable async, but crea... Artur Școlnic
05:26 AM Feature #10169: result-set streaming (and asynchronous programming?): I think I have hit a wall with the current approach. When you're using the same JDBC Connection and have an open Resu... Artur Școlnic
09:05 AM Bug #9078: emit FindQuery as (reused) variables: Dănuț Filimon wrote:
> I managed to get a working version for #9078-95 and started working on a version where it use... Dănuț Filimon
08:18 AM Bug #9078: emit FindQuery as (reused) variables: I managed to get a working version for #9078-95 and started working on a version where it uses an array in case too m... Dănuț Filimon
04:56 AM Bug #9078: emit FindQuery as (reused) variables: Current rule-set:... Dănuț Filimon
04:53 AM Bug #9078: emit FindQuery as (reused) variables: Constantin mentioned that I could count the number of FindQueries for each top level block and emit the array only wh... Dănuț Filimon
03:10 AM Bug #10195 (Internal Test): Reset of query buffer in a nested function: I am OK with the changes in 10195a.
The point here is that the buffer can have its scope opened several times. Usi... Alexandru Lungu
02:05 AM Feature #7020: always use "expanded" extent fields: There may be a regression showing in the ChUI tests. I need to double check. Stefanel Pezamosca

06/24/2025

05:38 PM Bug #10198: analyze FIND statements which use only a small number of fields: > * at runtime, a mode (when activated) will allow tracking and reporting buffer's field usage (how many fields are r... Ovidiu Maxiniuc
05:21 PM Bug #10198: analyze FIND statements which use only a small number of fields: #4400 is a mechanism to identify every query back to its original definition in source code. We could do a similar t... Greg Shah
03:45 PM Bug #10198: analyze FIND statements which use only a small number of fields: In a customer application, there are patterns where FIND is used to get a record, and from that record only its recid... Constantin Asofiei
03:35 PM Bug #10198 (New): analyze FIND statements which use only a small number of fields: Constantin Asofiei
05:11 PM Feature #10199: implement a temp-table size limit such that usage above that limit is backed by d...: Unlimited temp-table usage causes an OOME for the server. OE "spills" to disk when temp-table usage is too large. W... Greg Shah
05:05 PM Feature #10199 (New): implement a temp-table size limit such that usage above that limit is backe...: Greg Shah
04:43 PM Feature #9456: implement SQL Server dialect and helpers: Created a table with SQL Server specific issues in "Limitations and Workarounds":https://proj.goldencode.com/projects... Ovidiu Maxiniuc
04:38 PM Feature #9455: port native user defined functions to SQL Server: As noted in the Monday technical meet, revision 16004 of 9456 contains full support for recognising and parsing custo... Ovidiu Maxiniuc
03:33 PM Support #6709: track nested FIND inside a related FOR loop: This needs to be brought back into focus. What we need is a mode (when activated) which will track FIND queries, at ... Constantin Asofiei
12:33 PM Feature #7020: always use "expanded" extent fields: Roger Borrello wrote:
> Stefanel Pezamosca wrote:
> > Radu tested @7020d@ with @<parameter name="expand-extents" va... Stefanel Pezamosca
12:08 PM Feature #7020: always use "expanded" extent fields: Stefanel Pezamosca wrote:
> Radu tested @7020d@ with @<parameter name="expand-extents" value="false" />@ in @p2j.cfg... Roger Borrello
10:02 AM Bug #10195: Reset of query buffer in a nested function: Eduard, it will take me a bit more time to review, so I may not make it by EOD. I need to get some tests ongoing on O... Alexandru Lungu
04:05 AM Bug #10195 (Review): Reset of query buffer in a nested function: Eduard Soltan
04:04 AM Bug #10195 (WIP): Reset of query buffer in a nested function: Eduard Soltan
04:04 AM Bug #10195: Reset of query buffer in a nested function: Committed on 10195a, rev. 15996. Eduard Soltan
03:34 AM Bug #10195: Reset of query buffer in a nested function: I think this tests is a bit more accurate.... Eduard Soltan
07:26 AM Feature #10169: result-set streaming (and asynchronous programming?): Ok, I revised the code, indeed I am creating one thread each time a @for each@ is called and leaking threads, but jus... Artur Școlnic
07:16 AM Feature #10169: result-set streaming (and asynchronous programming?): > Well, it may be a bit more complex to implement but a solution would be to use a pool of worker threads. Consider t... Alexandru Lungu
07:05 AM Feature #10169: result-set streaming (and asynchronous programming?): Ovidiu Maxiniuc wrote:
> But when FWD decided the code from a client requires a background execution, the context is... Artur Școlnic
06:56 AM Feature #10169: result-set streaming (and asynchronous programming?): Well, it may be a bit more complex to implement but a solution would be to use a pool of worker threads. Consider the... Ovidiu Maxiniuc
05:42 AM Feature #10169: result-set streaming (and asynchronous programming?): My goal is to delegate as much work as possible to the secondary thread, ideally the whole @query.next@, this include... Artur Școlnic
03:36 AM Feature #10169: result-set streaming (and asynchronous programming?): I see. I wonder if you can't simply pass the result-set to the main thread and use it from there rather than using it... Alexandru Lungu
03:22 AM Feature #10169: result-set streaming (and asynchronous programming?): !async_for_each.png!
Each line is a result set access for a given thread, but the connection is shared, so the acc... Artur Școlnic
03:03 AM Feature #10169: result-set streaming (and asynchronous programming?): > I meant the access to any result set by a thread should not overlap with the access of another result set
I don'... Alexandru Lungu
03:00 AM Feature #10169: result-set streaming (and asynchronous programming?): Artur Școlnic wrote:
> we will need to synchronize the access to the result sets so that there is no overlap.
I ... Artur Școlnic
02:56 AM Feature #10169: result-set streaming (and asynchronous programming?): > we will need to synchronize the access to the result sets so that there is no overlap.
I don't quite understand ... Alexandru Lungu
02:31 AM Feature #10169: result-set streaming (and asynchronous programming?): After a quick investigation, I found out that most JDBC drivers support multiple opened result sets on a single conne... Artur Școlnic
06:18 AM Feature #7504: Export data tool from FWD into .d files: I think that should be enough. If the extracted data was identical to original .d files in the cases where these were... Ovidiu Maxiniuc
05:46 AM Feature #7504: Export data tool from FWD into .d files: An update on the testing :
* multitenant app : exported the data from a multitenant db ✅
* large GUI app : expor... Lorian Sandu

06/23/2025

02:02 PM Bug #10195: Reset of query buffer in a nested function: Found a problem in unit tests of a customer application.... Eduard Soltan
01:54 PM Bug #10195 (Test): Reset of query buffer in a nested function: Eduard Soltan
10:33 AM Feature #10169: result-set streaming (and asynchronous programming?): > I am not sure how we could end up retrieving more records than indented. We still have the progressive results, the... Alexandru Lungu
10:12 AM Feature #10169: result-set streaming (and asynchronous programming?): We might want some kind of "read ahead" limit to avoid doing too much on the secondary thread. Greg Shah
10:11 AM Feature #10169: result-set streaming (and asynchronous programming?): Alexandru Lungu wrote:
> But with an implementation of async fetching, you may end up gathering record 100.000th and... Artur Școlnic
09:59 AM Feature #10169: result-set streaming (and asynchronous programming?): Using different connections is a big NO from my POV. If you have X nested FOR EACH, then you may end up with a sessio... Alexandru Lungu
08:40 AM Feature #10169: result-set streaming (and asynchronous programming?): At the meeting, Alexandru raised a valid concern regarding the async execution for the foreach query. In my initial i... Artur Școlnic
09:15 AM Bug #9078: emit FindQuery as (reused) variables: I've made some progress, but I will have to refactor all of the changes for the FindQuery. If I am using an array to ... Dănuț Filimon
03:11 AM Bug #9078: emit FindQuery as (reused) variables: Ovidiu Maxiniuc wrote:
> I was thinking about @fqueryArray[0] = new FindQuery();@ initialization. To have a more com... Dănuț Filimon
09:07 AM Feature #9305: Replace begins with interval based conditional: From #10165:
For temp-table (H2 database), @LIKE 'prefix%'@ does not use an index at the moment. I suspect it is bec... Stefanel Pezamosca
07:28 AM Feature #7504: Export data tool from FWD into .d files: Ovidiu Maxiniuc wrote:
> I am OK with the changes.
> Please update the @%Done@.
>
> Just out of my curiosity, wh... Lorian Sandu
07:23 AM Feature #7504: Export data tool from FWD into .d files: I am OK with the changes.
Please update the @%Done@.
Just out of my curiosity, why the need to check for @null@ @... Ovidiu Maxiniuc
03:11 AM Feature #7504: Export data tool from FWD into .d files: Ovidiu Maxiniuc wrote:
> I cannot update to those revisions. The latest I see on branch 7504b is 15914. Maybe you fo... Lorian Sandu

« Previous

Also available in: Atom

Project

General

Profile

FWD » Core Development » Database

Activity

Activity

07/22/2025

07/21/2025

07/18/2025

07/17/2025

07/16/2025

07/15/2025

07/14/2025

07/13/2025

07/11/2025

07/10/2025

07/09/2025

07/08/2025

07/07/2025

07/04/2025

07/03/2025

07/02/2025

07/01/2025

06/30/2025

06/27/2025

06/26/2025

06/25/2025

06/24/2025

06/23/2025