FWD » Core Development » Database

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

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