Activity

From 06/12/2025 to 07/11/2025

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

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

« Previous

Also available in: Atom

Project

General

Profile

FWD » Core Development » Database

Activity

Activity

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

06/21/2025

06/20/2025

06/19/2025

06/18/2025

06/17/2025

06/16/2025

06/13/2025

06/12/2025