Project

General

Profile

Activity

From 06/10/2025 to 07/09/2025

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

06/21/2025

06:45 PM Feature #7504: Export data tool from FWD into .d files
I cannot update to those revisions. The latest I see on branch 7504b is 15914. Maybe you forgot to bind / push? Ovidiu Maxiniuc
07:54 AM Feature #7504: Export data tool from FWD into .d files
After exporting data from different customer databases, i've rebase to latest trunk and made two commits to @7504b@ :... Lorian Sandu

06/20/2025

04:28 PM Bug #9078: emit FindQuery as (reused) variables
I was thinking about @fqueryArray[0] = new FindQuery();@ initialization. To have a more compact code, we could emit i... Ovidiu Maxiniuc
07:39 AM Bug #9078: emit FindQuery as (reused) variables
> will the template above do to generate FindQuery[] fqueryArray = new FindQuery[5]; or is there a way to make it sim... Greg Shah
05:45 AM Bug #9078: emit FindQuery as (reused) variables
The solution would be to move @fqueryArray[0] = new FindQuery();@ in the @body()@, emit the FindQuery normally withou... Dănuț Filimon
05:37 AM Bug #9078: emit FindQuery as (reused) variables
The following test:... Dănuț Filimon
10:46 AM Feature #10169: result-set streaming (and asynchronous programming?)
The java test cases show that the benefit of running the query in a separate thread is similar with running the busin... Artur Școlnic
08:02 AM Feature #10169: result-set streaming (and asynchronous programming?)
Well, this changes things. If the for each body cannot be executed in a new thread, I will go the other way and try t... Artur Școlnic
07:57 AM Feature #10169: result-set streaming (and asynchronous programming?)
I don't think we should look at pushing 4GL logic into other threads. Our core design will not allow this without a ... Greg Shah
07:46 AM Feature #10169: result-set streaming (and asynchronous programming?)
Artur Școlnic wrote:
> I attached the source for this test.
Artur Școlnic
07:44 AM Feature #10169: result-set streaming (and asynchronous programming?)
Artur Școlnic wrote:
> I started working on introducing async in @forEachWorker@, currently there are issues with ou...
Artur Școlnic
07:35 AM Feature #10169: result-set streaming (and asynchronous programming?)

On another note, I found a way to introduce artificial latency on a network adapter.
The delay is per tcp packet, ...
Artur Școlnic
07:32 AM Feature #10169: result-set streaming (and asynchronous programming?)
I believe another way to utilize the result set streaming and async programming is streaming results in a for each wh... Artur Școlnic
06:38 AM Feature #9455: port native user defined functions to SQL Server
At the time I wrote @CREATE FUNCTION dbo.modulo_ii (@p1 INT, @p2 INT) RETURNS BIGINT AS@ I was not able to test it. A... Ovidiu Maxiniuc
05:44 AM Feature #9455: port native user defined functions to SQL Server
Constantin Asofiei wrote:
> What if you call a PROCEDURE from a FUNCTION?
This could be done. And error is raised.
Eduard Soltan
05:21 AM Feature #9455: port native user defined functions to SQL Server
What if you call a PROCEDURE from a FUNCTION? Constantin Asofiei
05:21 AM Feature #9455: port native user defined functions to SQL Server
I see that in T-SQL, statements like @RAISERROR('Dates before October 15, 1582 are not yet supported', 16, 1);@. coul... Eduard Soltan
03:52 AM Bug #10181: Date shifted one day earlier when importing data
Thanks, Ovidiu.
What testing should be performed for this change?
Lorian Sandu

06/19/2025

10:24 AM Bug #10181 (Internal Test): Date shifted one day earlier when importing data
I am OK with the change because the UTC will leave the data unaffected by the TZ.
However, I think all occurrences...
Ovidiu Maxiniuc
08:30 AM Bug #10181 (Review): Date shifted one day earlier when importing data
Lorian Sandu
08:30 AM Bug #10181 (WIP): Date shifted one day earlier when importing data
Lorian Sandu
08:26 AM Bug #10181: Date shifted one day earlier when importing data
In #7504-31 :
> I also encountered a potential bug during *import*:
> * I imported a .d file containing the value...
Lorian Sandu
08:05 AM Bug #10181 (Test): Date shifted one day earlier when importing data
Lorian Sandu
08:25 AM Feature #7504: Export data tool from FWD into .d files
When testing the export tool and importing/exporting the db from a large gui app i encountered again this type of err... Lorian Sandu
07:33 AM Bug #9078: emit FindQuery as (reused) variables
The following template worked:... Dănuț Filimon
07:20 AM Bug #9078: emit FindQuery as (reused) variables
I've adjusted the template in the following way:... Dănuț Filimon
07:06 AM Bug #9078: emit FindQuery as (reused) variables
I found the @named_array@ template in @java_templates.tpl@ and managed to generate something like:... Dănuț Filimon
06:07 AM Feature #10169: result-set streaming (and asynchronous programming?)
I think this implies tracking and storing the time of execution for queries and iterative blocks that have queries (a... Artur Școlnic
05:44 AM Feature #10169: result-set streaming (and asynchronous programming?)
One approach for implementation would be to measure conditions at runtime and shift into this streaming/async mode wh... Greg Shah
04:59 AM Feature #10169 (WIP): result-set streaming (and asynchronous programming?)
Below you can find the result of testing async execution for db queries combined with result set streaming.
To simul...
Artur Școlnic

06/18/2025

04:14 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
Eric Faulhaber wrote:
> @ImportWorker$TenantIdContext.prepareNextBracket@: Why is it safe to fall back to using the ...
Ovidiu Maxiniuc
02:22 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
One other thing I noticed in my last review, though it already existed in the code before your recent changes. In @Im... Eric Faulhaber
02:14 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
Code review 10094a/15985-15988:
@ImportWorker$TenantIdContext.prepareNextBracket@: Why is it safe to fall back to ...
Eric Faulhaber
07:56 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.
Another version without using the @dbo.Delimiters@ table:
{{Collapse(See sql ...)...
Stefanel Pezamosca
05:10 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.
This task is for implementing support for word indexing and CONTAINS statements in Microsoft SQL Server.
As part of ...
Stefanel Pezamosca
04:14 AM Bug #10171 (Test): Word Index/CONTAINS support for MS SQL Server.
Stefanel Pezamosca
07:06 AM Feature #9456: implement SQL Server dialect and helpers
> * I hit another MSSQL implementation restriction, one we were not aware of in the iteration of several years ago: t... Greg Shah
06:56 AM Feature #9456: implement SQL Server dialect and helpers
Related to my note #9456-8: with my current changes in 9456a, I encountered in @hotel_runtime@ a query where predicat... Ovidiu Maxiniuc
08:12 PM Feature #9456: implement SQL Server dialect and helpers
The @ORDER BY@ issue was partially resolved. In case of @UNIQUE@ finds, the HQL bundle was expressly setting the sort... Ovidiu Maxiniuc
11:32 PM Feature #7020: always use "expanded" extent fields
Eric Faulhaber wrote:
> Stefanel, did we ever get these ChUI test results? Is there any other testing needed?
Unf...
Stefanel Pezamosca

06/17/2025

04:01 PM Feature #7020: always use "expanded" extent fields
Stefanel Pezamosca wrote:
> Radu tested @7020d@ with @<parameter name="expand-extents" value="false" />@ in @p2j.cfg...
Eric Faulhaber
12:25 PM Feature #10169: result-set streaming (and asynchronous programming?)
This seems quite promising, I especially like the idea of adding threading in to keep the data transfer happening in ... Greg Shah
12:23 PM Feature #10169: result-set streaming (and asynchronous programming?)
From Artur in #9802-210:
As already discussed, one of the main reasons for the differences in performance we see i...
Greg Shah
12:20 PM Feature #10169 (WIP): result-set streaming (and asynchronous programming?)
Greg Shah
08:00 AM Feature #9456: implement SQL Server dialect and helpers
One more thing, related to paging. We knew that MSSQL does not have a @LIMIT@ / @OFFSET@ syntax for query pagination,... Ovidiu Maxiniuc
05:22 AM Bug #10080: Temp-table records are leaking in can-find statements
Sure. Eduard Soltan
05:21 AM Bug #10080: Temp-table records are leaking in can-find statements
Eduard, 8308f wasn't backed out from 7156c/e. Please commit the necessary changes from 10080a to 7156c and 7156e. Dănuț Filimon
05:18 AM Bug #10080 (Test): Temp-table records are leaking in can-find statements
10080a was merged to trunk rev 15986 and archived. Eduard Soltan
04:38 AM Bug #10080 (Merge Pending): Temp-table records are leaking in can-find statements
Go ahead and merge now. Constantin Asofiei
04:32 AM Bug #10080: Temp-table records are leaking in can-find statements
Eduard Soltan wrote:
> Still haven't got an response from harness/web/report of an application testing.
Testing...
Lorian Sandu
03:49 AM Bug #10080: Temp-table records are leaking in can-find statements

- unit tests and smoke tests of a large gui application ✅
- chui regression tests ✅
- smoke tests of a gui appl...
Eduard Soltan
03:45 AM Bug #10080: Temp-table records are leaking in can-find statements
Can this be queued for merge? Constantin Asofiei

06/16/2025

04:58 AM Feature #9456: implement SQL Server dialect and helpers
A 'new' old issue: the MSSQL and lack of support for boolean literals. That is the reason the @Dialect.supportsBoolea... Ovidiu Maxiniuc
02:40 AM Bug #10080: Temp-table records are leaking in can-find statements
Yes, they are passing and received the news from Danut that ETF has passed. Eduard Soltan
02:39 AM Bug #10080: Temp-table records are leaking in can-find statements
Eduard Soltan wrote:
> Tested performed:
>
> - unit tests of a large gui application ✅
> - chui regression tests...
Stefanel Pezamosca

06/13/2025

05:56 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
I upgraded the project of the single customer to be MT-enabled. Committed to r89.
Here are the changes in @build.pro...
Ovidiu Maxiniuc
04:13 PM Bug #6767: Possible name clashes in DMO classes
I’m struggling to get the conversion to work as intended. For example, I’d like the @NEXT-SIBLING@ attribute converte... Vladimir Tsichevski
02:20 PM Bug #6767: Possible name clashes in DMO classes
Vladimir Tsichevski wrote:
> We should distinguish these cases within the conversion rules, perhaps using conditiona...
Constantin Asofiei
02:13 PM Bug #6767: Possible name clashes in DMO classes
Constantin Asofiei wrote:
> Vladimir Tsichevski wrote:
> > We need to update the conversion rules, as the correct m...
Vladimir Tsichevski
01:40 PM Bug #6767: Possible name clashes in DMO classes
Vladimir Tsichevski wrote:
> We need to update the conversion rules, as the correct method names are now @privateDat...
Constantin Asofiei
09:52 AM Bug #6767: Possible name clashes in DMO classes
Vladimir Tsichevski wrote:
> Constantin Asofiei wrote:
>
> > Looks like you don't need to revert.
> Good, now I ...
Vladimir Tsichevski

06/12/2025

12:11 PM Bug #6767: Possible name clashes in DMO classes
Constantin Asofiei wrote:
> Looks like you don't need to revert.
Good, now I am running a customer big applicatio...
Vladimir Tsichevski
12:02 PM Bug #6767: Possible name clashes in DMO classes
Vladimir Tsichevski wrote:
> Constantin Asofiei wrote:
> > Review of 6767c rev 15980.
> > * @AbstractTempTable@
>...
Constantin Asofiei
07:24 AM Bug #6767: Possible name clashes in DMO classes
Constantin Asofiei wrote:
> Review of 6767c rev 15980.
> * @AbstractTempTable@
> ** line 2938 - please add back @d...
Vladimir Tsichevski
05:05 AM Bug #6767: Possible name clashes in DMO classes
Review of 6767c rev 15980.
* @AbstractTempTable@
** line 2938 - please add back @defBuffer.bufferManager@ instead o...
Constantin Asofiei
10:22 AM Bug #9078: emit FindQuery as (reused) variables
Danut, just keep in mind that a Map has a higher overhead than a plain array. That is why I am suggesting creating an... Alexandru Lungu
02:24 AM Bug #9078: emit FindQuery as (reused) variables
Alexandru Lungu wrote:
> Dănuț Filimon wrote:
> > I did not take into account that there might be a limitation to t...
Dănuț Filimon

06/11/2025

05:28 PM Bug #6767: Possible name clashes in DMO classes
Eric Faulhaber wrote:
> Vladimir, this is a large set of changes. What testing do you propose?
I think, convert...
Vladimir Tsichevski
05:22 PM Bug #6767 (Review): Possible name clashes in DMO classes
Committed as 6767c rev. 15980. Please, review. Vladimir Tsichevski
12:13 PM Bug #6767: Possible name clashes in DMO classes
For @HandleChain@ and its ancestors I found 8 matching methods:... Vladimir Tsichevski
11:43 AM Bug #6767: Possible name clashes in DMO classes
Eric, Constantin,
I need you to confirm this:
*DMO setters* do not use *Java built-in types*. For example, we can...
Vladimir Tsichevski
04:28 PM Feature #10142: allow UDFs to live in the public schema instead a UDF-specific schema
A customer using PostgreSQL in the cloud requested that the native SQL UDFs representing Progress built-in functions ... Eric Faulhaber
04:16 PM Feature #10142 (New): allow UDFs to live in the public schema instead a UDF-specific schema
Eric Faulhaber
10:39 AM Bug #9078: emit FindQuery as (reused) variables
Dănuț Filimon wrote:
> I did not take into account that there might be a limitation to the number of local variables...
Alexandru Lungu
09:14 AM Bug #9078: emit FindQuery as (reused) variables
I did not take into account that there might be a limitation to the number of local variables that can be defined in ... Dănuț Filimon
08:36 AM Bug #9078: emit FindQuery as (reused) variables
I discussed with Artur and took time to take a look at all find queries from the problematic class. I took each one a... Dănuț Filimon
07:59 AM Feature #7504 (Internal Test): Export data tool from FWD into .d files
Lorian Sandu
07:50 AM Feature #7020: always use "expanded" extent fields
Constantin Asofiei wrote:
> Is @expand-extents=true@ now the default and we need to configure projects which can't u...
Stefanel Pezamosca
07:47 AM Feature #7020: always use "expanded" extent fields
Is @expand-extents=true@ now the default and we need to configure projects which can't use this mode explicitly in p2... Constantin Asofiei
07:17 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
I made sure the tables are not skipped if the @.d@ files are empty. Replacing all @System.out@ with proper logging.
...
Ovidiu Maxiniuc
08:07 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
Greg Shah wrote:
> We will need to have tested that as well to confirm that it resolves everything safely.
As a fir...
Ovidiu Maxiniuc

06/10/2025

03:07 PM Bug #6767: Possible name clashes in DMO classes
> And this refactor can be done automatically (with CTRL+SHIFT+G) in Eclipse, although each one needs to be done 'by ... Constantin Asofiei
02:14 PM Bug #6767 (WIP): Possible name clashes in DMO classes
Vladimir Tsichevski
02:13 PM Bug #6767: Possible name clashes in DMO classes
Constantin Asofiei wrote:
> Vladimir, did you use some script to 'sed' the changes?
No. I used Java reflection to c...
Vladimir Tsichevski
01:17 PM Bug #6767: Possible name clashes in DMO classes
Vladimir, did you use some script to 'sed' the changes? As Eric mentioned, there are lots of unintended changes. The... Constantin Asofiei
12:59 PM Bug #6767: Possible name clashes in DMO classes
Code review 6767b/15628-15629 (apologies for the long delay):
Overall, the changes look good, though I think we ar...
Eric Faulhaber
09:08 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
The ideal test 10094a would be to have a logical database with the shared db at least two tenant dbs. The customer di... Ovidiu Maxiniuc
08:50 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
> Please let me know if I got your question right.
Yes, mostly.
If the schema can be incorrect from prior runs ...
Greg Shah
08:24 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
What 10094a adds is that the empty tables from the (re-)imported database are guaranteed to be indexed.
Do you thi...
Ovidiu Maxiniuc
05:53 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
I'm trying to determine if we need to write a migration script to cleanup existing MT installations so that they matc... Greg Shah
09:02 AM Bug #10111 (WIP): All statements are logged to a single text file for P2JQueryLogger and SQLState...
Addressed the 1st and 2nd point in @10111a/15979@.
For the 3rd, I am thinking of creating a super class for those 2 ...
Andrei Plugaru
07:57 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...
+Review of 10111a/15978.+
The changes are logical. The reason is explained in 1st note above. Good catch!
The c...
Ovidiu Maxiniuc
06:34 AM Bug #10111 (Review): All statements are logged to a single text file for P2JQueryLogger and SQLSt...
Committed @10111a/15978@. The changes are quite simple: just removing the static keyword for @fileLogger@ in @SQLStat... Andrei Plugaru
06:33 AM Bug #10111 (WIP): All statements are logged to a single text file for P2JQueryLogger and SQLState...
Andrei Plugaru
06:02 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...
While using @SQLStatementLogger@ for multiple databases, I discovered that all the statements are logged to a single ... Andrei Plugaru
04:58 AM Bug #10111 (Test): All statements are logged to a single text file for P2JQueryLogger and SQLStat...
Andrei Plugaru
06:39 AM Bug #9078: emit FindQuery as (reused) variables
Artur ran a conversion for a customer application and found a conversion issue. I plan to work with Artur to identify... Dănuț Filimon
05:55 AM Bug #9994 (Rejected): Err: Cannot run GET methods on query until it is opened.
Greg Shah
01:56 AM Bug #9994: Err: Cannot run GET methods on query until it is opened.
This can be closed/rejected. Stefanel Pezamosca
03:14 AM Feature #9440 (Test): get-codepage() function should work with CLOB fields
Branch 9440a was merged to trunk rev 15975 and archived. Teodor Gorghe
02:49 AM Feature #9440 (Merge Pending): get-codepage() function should work with CLOB fields
Please rebase and merge 9440a now. Constantin Asofiei
12:18 AM Bug #10080: Temp-table records are leaking in can-find statements
Updated @query/canfindmultiplex@ testcases. Eduard Soltan
 

Also available in: Atom