FWD » Core Development » Database

01/13/2025

09:57 AM Bug #9317: FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches a uniq...

The problem was caused by another function detecting the need for the subselect which I had initially overlooked and ... Ioana-Cristina Prioteasa

01/09/2025

09:51 AM Bug #9317: FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches a uniq...

Successfully integrated @propertyMatches@ into the subselect decision logic and the above testcase generates the simp... Ioana-Cristina Prioteasa

08:24 AM Bug #9251 (Internal Test): cache the translated FQL in FQLPreprocessor.translate

Considering that 9251c is fixing the regression mentioned and I also retested #9251-3 with similar results, I guess t... Stefanel Pezamosca

01/08/2025

03:26 PM Bug #9036 (Closed): Multi-tenancy: refactor the database in Persistence context-wise

The customer confirmed that this is resolved. Greg Shah

12:32 PM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

I have resumed work on the sequence issues. I have created a couple of testcases and I am now putting them to test in... Ovidiu Maxiniuc

04:27 AM Bug #9251: cache the translated FQL in FQLPreprocessor.translate

I tested the patch from #9251-20, and tested a few modules in the unit tests in a large customer application and did ... Eduard Soltan

03:39 AM Bug #9251: cache the translated FQL in FQLPreprocessor.translate

Constantin Asofiei wrote:
> Please add javadoc for the new params for the ctors in @SortCacheKey@ and @TranslateCach... Stefanel Pezamosca

03:24 AM Bug #9251: cache the translated FQL in FQLPreprocessor.translate

Please add javadoc for the new params for the ctors in @SortCacheKey@ and @TranslateCacheKey@. OTherwise 9251c/15631... Constantin Asofiei

03:14 AM Bug #9251 (Review): cache the translated FQL in FQLPreprocessor.translate

I have created task branch 9251c from trunk revision 15630.
The patch is committed in revision 15631. Please review. Stefanel Pezamosca

03:07 AM Bug #9251 (WIP): cache the translated FQL in FQLPreprocessor.translate

As pointed out by Eduard [es], there seems to be a regression related with the addition of this cache:
> We cache th... Stefanel Pezamosca

12/23/2024

12:40 PM Bug #6767 (Review): Possible name clashes in DMO classes

The new renamed method list:
# @logical Buffer.isMultiTenant()@
# @void Buffer.setMultiTenant(logical)@
# @void ... Vladimir Tsichevski

12/21/2024

07:59 PM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Indeed, we are not handling the sequences the right way. At this moment, all of them are processed within the default... Ovidiu Maxiniuc

12/20/2024

08:56 AM Bug #9397: Fix COPY-TEMP-TABLE issues

9397a is also merged to 7156c as rev.15524. Ioana-Cristina Prioteasa

08:15 AM Bug #9397 (Test): Fix COPY-TEMP-TABLE issues

9397a is merged to trunk as rev. 15627. Ioana-Cristina Prioteasa

07:25 AM Bug #9397 (Merge Pending): Fix COPY-TEMP-TABLE issues

Please merge 9397a to trunk now. Adjust the %Done accordingly. Alexandru Lungu

08:24 AM Bug #7403: Copy-temp-table with replace-mode should replace already inserted records

#7403 is *fixed* by 9397a - FWD behavior aligns with progress with *trunk rev.15627*. Ioana-Cristina Prioteasa

07:27 AM Bug #7403 (WIP): Copy-temp-table with replace-mode should replace already inserted records

Ioana, please reassess #7403 after merging 9397a: is #7403-1 fixed by 9397a? if not, please analyze the status of thi... Alexandru Lungu

07:28 AM Bug #7364: Build a full test-suite for fast copy-temp-table

This task was posted way before the xfer testcases were a thing. Please check if the tests in xfer are comprehensive. Alexandru Lungu

06:33 AM Bug #9493: Inline word index CTE for trivial clauses

This task is deferred from #9370-13 and most of the description and investigation was already delivered there.
TL;... Alexandru Lungu

06:26 AM Bug #9493 (New): Inline word index CTE for trivial clauses

Alexandru Lungu

05:22 AM Bug #9317: FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches a uniq...

Successfully refactored the logic to detect the need for a subselect in @FQLPreprocessor@.
When the preprocessor i... Ioana-Cristina Prioteasa

05:02 AM Bug #9078: emit FindQuery as (reused) variables

Committed *9078b/15623*. Fix an infinite loop by making arguments part of the condition for reinitialization, some ar... Dănuț Filimon

12/19/2024

09:46 AM Bug #9078: emit FindQuery as (reused) variables

Example of the problem:... Dănuț Filimon

08:53 AM Bug #9078: emit FindQuery as (reused) variables

Dănuț Filimon wrote:
> Solution:
> * Reinitialize the query when the arguments do not match.
I found that even i... Dănuț Filimon

06:04 AM Bug #9078: emit FindQuery as (reused) variables

The following FindQuery extracted from ETF (slightly modified table/field names):... Dănuț Filimon

06:04 AM Bug #9397: Fix COPY-TEMP-TABLE issues

Completed performance testing, is seems unaffected as it is 1% better than the baseline.
Testing plan is complete, ... Ioana-Cristina Prioteasa

05:11 AM Bug #9133 (Review): Array subscript is out of range stops the evaluation of other expressions in ...

Alexandru Lungu wrote:
> I put some thinking into this again, but (again) I can't see a clear implementation for thi... Lorian Sandu

03:52 AM Bug #9133: Array subscript is out of range stops the evaluation of other expressions in the where...

I put some thinking into this again, but (again) I can't see a clear implementation for this. Can we have a log SEVER... Alexandru Lungu

02:26 AM Bug #9383 (WIP): Cache only the current delegate on transaction commit if a ProgressiveResults is...

Alexandru Lungu wrote:
> I think there is a flaw in 9383a:
> * in case of a @ProgressiveQuery@, only the current br... Dănuț Filimon

12/18/2024

03:40 PM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Ovidiu, looking back over #9057-48, when we were discussing the use of the @META_CTX@ constant w.r.t. sequence handle... Eric Faulhaber

10:32 AM Bug #9465: Emit the right errors when binding datasets

I further investigate the exception presented in #9465-9. Up until now, in the constructor for @DataSetParameter@ we ... Andrei Plugaru

07:45 AM Bug #9465: Emit the right errors when binding datasets

While running the dataset unit tests, I came across this exception in @server.log@ I would also want to investigate:
... Andrei Plugaru

07:22 AM Bug #9465: Emit the right errors when binding datasets

Committed @9265a/15620@. Main changes:
# Implemented what I described in #9465-5
# Validate the case when the BIND ... Andrei Plugaru

09:03 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

I think there is a flaw in 9383a:
* in case of a @ProgressiveQuery@, only the current bracket will be cached in a @S... Alexandru Lungu

07:20 AM Bug #9078: emit FindQuery as (reused) variables

Committed *9078b/15622*. This branch contains the changes from 9078a, with the database_access.rules adjusted to comp... Dănuț Filimon

02:48 AM Bug #9078: emit FindQuery as (reused) variables

I will have to rework almost all the changes from database_access.rules because the constructor is no longer generati... Dănuț Filimon

12:56 AM Bug #9078: emit FindQuery as (reused) variables

I created *9078b* from *trunk/15621*, after making a patch of 9078a on top of that branch I found conversion issues u... Dănuț Filimon

04:07 AM Bug #9397: Fix COPY-TEMP-TABLE issues

Smoketests of another large GUI application passed ✅ Andrei Iacob

12/17/2024

10:04 AM Bug #9465: Emit the right errors when binding datasets

Here are the testcases I used to test #9465-5. Andrei Plugaru

10:02 AM Bug #9465 (WIP): Emit the right errors when binding datasets

Andrei Plugaru

10:02 AM Bug #9465: Emit the right errors when binding datasets

I am currently looking into the situation when both the datasets on the caller and called side are reference-only. St... Andrei Plugaru

04:56 AM Bug #9465: Emit the right errors when binding datasets

Error @13012@ should now be emitted in the right situation with the appropriate message. The logic for emitting this ... Andrei Plugaru

09:20 AM Bug #9397: Fix COPY-TEMP-TABLE issues

Large customer gui application unit-tests passed ✅ Lorian Sandu

08:01 AM Bug #9397: Fix COPY-TEMP-TABLE issues

Added one more test to the @TestCopyTempTable@ 4GL unit tests suite and committed to the testcases project in total 6... Ioana-Cristina Prioteasa

02:57 AM Bug #9397: Fix COPY-TEMP-TABLE issues

ETF also passed ✅ Lorian Sandu

02:45 AM Bug #9397: Fix COPY-TEMP-TABLE issues

Chui regression tests passed ✅ Andrei Iacob

04:02 AM Bug #9078: emit FindQuery as (reused) variables

I've converted ETF with 9078a but all tests fail due to @Cannot create temp table field for "BATCHACTION"@. I've also... Dănuț Filimon

12/16/2024

02:22 PM Feature #9477: implement missing QUERY handle methods/attributes

* methods
** FIRST-OF(<level>) (none/none)
** LAST-OF(<level>) (none/none)
** REPOSITION-BACKWARDS() (full/basic)
... Eric Faulhaber

02:16 PM Feature #9477 (New): implement missing QUERY handle methods/attributes

Eric Faulhaber

07:33 AM Bug #9465: Emit the right errors when binding datasets

Committed 15 tests to @tests.dataset.parameter.inout.TestHandleDatasetBind@. Currently 4 of them fail all regarding t... Andrei Plugaru

06:44 AM Bug #9465: Emit the right errors when binding datasets

I have found a useful comment in @DataSet.isCompatibleWith@ which clarifies why my initial attempt to throw the error... Andrei Plugaru

05:44 AM Bug #9318: Make record nursery visible on removeRecords

Rebased *9318a* to latest *trunk/15616*, the branch is now at revision *15618*. Dănuț Filimon

05:38 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Rebased *9383a* to latest *trunk/15616*, the branch is now at revision *15617*. Dănuț Filimon

04:30 AM Bug #9397: Fix COPY-TEMP-TABLE issues

Lorian Sandu wrote:
> Ioana, can you rebase the branch to latest trunk, please?
*9397a* is rebased and it is now at... Ioana-Cristina Prioteasa

03:28 AM Bug #9397: Fix COPY-TEMP-TABLE issues

Ioana, can you rebase the branch to latest trunk, please? Lorian Sandu