FWD » Core Development » Database

01/20/2025

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

I went ahead and started testing the changes, on a big customer application I tested regression tests and the results... Ioana-Cristina Prioteasa

05:45 AM Bug #9383 (Review): Cache only the current delegate on transaction commit if a ProgressiveResults...

After working with a test case and having a look at the existent problems, I came to the conclusion that I should rev... Dănuț Filimon

01/17/2025

04:16 PM Feature #9559: no-op implementations for obsolete record phrase and query options

Likewise, the QUERY-TUNING option for queries must be ignored, since query planning is left to the RDBMS implementation. Eric Faulhaber

04:07 PM Feature #9559: no-op implementations for obsolete record phrase and query options

The TABLE-SCAN record phrase option will be a no-op, since the database's query planner will decide whether or not to... Eric Faulhaber

04:06 PM Feature #9559 (New): no-op implementations for obsolete record phrase and query options

Eric Faulhaber

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

Rebased *9383a* to latest *trunk/15651*, the branch is now at revision *15652*.
I managed to create examples after... Dănuț Filimon

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

Committed on *9317a rev.15629* the changes needed based on the code review.
For the @PreselectQuery@ change, Alex is... Ioana-Cristina Prioteasa

01/16/2025

04:37 PM Feature #9549: implement missing metadata features

Some of these may be implemented to a greater degree than marked. If so, the gap marking needs to be fixed.
* @_fi... Eric Faulhaber

04:33 PM Feature #9549 (New): implement missing metadata features

Eric Faulhaber

04:16 PM Feature #9546: investigate and implement field options, if missing

Options:
* LOB-AREA
* LOB-BYTES
* LOB-SIZE
* CLOB-CODEPAGE
* CLOB-COLLATION
* CLOB-TYPE Eric Faulhaber

04:15 PM Feature #9546 (New): investigate and implement field options, if missing

Eric Faulhaber

03:54 PM Feature #9545: confirm/add table parameter support

@TABLE@ Parameters:
* @BY-REFERENCE@ (full/partial)
* @BY-VALUE@ (full/partial)
* @BIND@ (full/partial)
@KW_B... Eric Faulhaber

03:51 PM Feature #9545 (Review): confirm/add table parameter support

Eric Faulhaber

03:47 PM Feature #9544: implement missing SESSION handle attributes

Attributes:
* @FIRST-BUFFER@
* @FIRST-QUERY@ Eric Faulhaber

03:46 PM Feature #9544 (Test): implement missing SESSION handle attributes

Eric Faulhaber

03:45 PM Feature #9543: implement missing BUFFER attributes

Attributes:
* @AUTO-SYNCHRONIZE@ (none/none)
* @CAN-READ@ (none/none) Eric Faulhaber

03:44 PM Feature #9543 (Test): implement missing BUFFER attributes

Eric Faulhaber

03:42 PM Feature #9542: finish ORIGIN-HANDLE ProDataSet attribute

Missing attributes:
* <table_handle>:ORIGIN-HANDLE (none/none) Eric Faulhaber

03:41 PM Feature #9542 (Test): finish ORIGIN-HANDLE ProDataSet attribute

Eric Faulhaber

01/15/2025

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

Overall, I would want to refactor a bit the javadoc/parameter and method names to reflect the join with a FIRST/LAST ... Alexandru Lungu

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

Alexandru Lungu wrote:
> I think this should be assessed now. Most of the PK/FK are groups of more than 1 field in #... Ioana-Cristina Prioteasa

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

Fixed the problem from #9078-75 in *9078b/15625*. The rules rely on the "extbufid" annotation to emit the @setMultiTe... Dănuț Filimon

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

While working on a few tests, I found another conversion regression when using multi-tenancy where a find query that ... Dănuț Filimon

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

Committed *9078b/15624*. Fixed conversion compatibility with multi-tenancy, ETF conversion passed (matches previous c... Dănuț Filimon

01/14/2025

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

> The method checks for unique constraints containing only one field and matches it with the property.
I think th... Alexandru Lungu

10:00 AM Bug #9317 (Review): FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause match...

Committed on 9317a.
*Alex/Eric*, please review *9317a rev. 15624 - 15627*.
Local performance tests were inconclus... Ioana-Cristina Prioteasa

06:32 AM Bug #9251 (Test): cache the translated FQL in FQLPreprocessor.translate

Branch 9251c was merged to trunk as rev. 15636 and archived. Stefanel Pezamosca

06:21 AM Bug #9251 (Merge Pending): cache the translated FQL in FQLPreprocessor.translate

This can be merged to trunk now. Constantin Asofiei

06:18 AM Bug #9251: cache the translated FQL in FQLPreprocessor.translate

Constantin Asofiei wrote:
> Stefanel Pezamosca wrote:
> > Considering that 9251c is fixing the regression mentioned... Stefanel Pezamosca

05:54 AM Bug #9251: cache the translated FQL in FQLPreprocessor.translate

Stefanel Pezamosca wrote:
> Considering that 9251c is fixing the regression mentioned and I also retested #9251-3 wi... Constantin Asofiei

03:58 AM Bug #9078: emit FindQuery as (reused) variables

Managed to setup the dataset project to use multi-tenancy and convert a few examples. The conversion is regressing wi... Dănuț Filimon

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