Activity
From 01/02/2025 to 01/31/2025
01/31/2025
- 10:03 AM Feature #7020: always use "expanded" extent fields
- Stefanel Pezamosca wrote:
> So, an update on 7020c, I was testing a customer application and encountered a regressio... - 07:09 AM Feature #7020 (WIP): always use "expanded" extent fields
- So, an update on 7020c, I was testing a customer application and encountered a regression that seems to be related wi...
- 07:08 AM Feature #7020: always use "expanded" extent fields
- Roger Borrello wrote:
> Unfortunately, I ran out of space on my conversion attempt (see #7183-106). I will retry. Di... - 04:25 AM Bug #9317: FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches a uniq...
- h2. ..
Alexandru Lungu wrote:
> > So here the emitted sql differs and without the changes the where clause coming... - 04:20 AM Feature #6720: lazy hydration
- Andrei, please attempt to rebase *6720b* to latest trunk and continue the effort here. We can talk before picking up ...
- 03:56 AM Bug #9318: Make record nursery visible on removeRecords
- Alexandru Lungu wrote:
> Review of 9318a:
> * Please avoid overloading @removeRecords@ and enforce all callers to d... - 01:19 AM Bug #9318: Make record nursery visible on removeRecords
- Rebased *9318a* to latest *trunk/15676*, the branch is now at revision *15679*.
Currently working on addressing th...
01/30/2025
- 05:41 PM Feature #7020: always use "expanded" extent fields
- Roger Borrello wrote:
> Roger Borrello wrote:
> > Stefanel Pezamosca wrote:
> > > *Roger* (or someone who can), co... - 10:59 AM Feature #7020: always use "expanded" extent fields
- Roger Borrello wrote:
> Stefanel Pezamosca wrote:
> > *Roger* (or someone who can), could you help by testing *9537... - 10:13 AM Feature #7020: always use "expanded" extent fields
- I have rebased 7020c to trunk revision 15674.
I have committed a few fixes and code cleanup after the rebase and 70... - 10:31 AM Bug #9595: Records accessed from dynamic buffers remain LOCKed until the user context is destroyed
- +Eric
- 10:27 AM Bug #9595: Records accessed from dynamic buffers remain LOCKed until the user context is destroyed
- I am facing some issues related to (un-)locking of records from (dynamic) buffers. Consider the following 2 procedure...
- 10:19 AM Bug #9595 (WIP): Records accessed from dynamic buffers remain LOCKed until the user context is de...
- 09:59 AM Bug #9317 (Internal Test): FIRST/LAST clauses can avoid generating sub-selects if the WHERE claus...
- > So here the emitted sql differs and without the changes the where clause coming from the OF clause is not included....
- 07:56 AM Bug #9317: FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches a uniq...
- For the case @baseWhere == null@ the subselect is not to be generated. This was overlooked. And now it becomes clear ...
- 06:10 AM Bug #9317: FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches a uniq...
- h2. --...
- 09:47 AM Bug #9318 (WIP): Make record nursery visible on removeRecords
- Review of 9318a:
* Please avoid overloading @removeRecords@ and enforce all callers to decide what kind of delete th... - 02:03 AM Bug #9318: Make record nursery visible on removeRecords
- Alexandru Lungu wrote:
> 9318a is at rev. 15618 (which doesn't include your latest changes).
Sorry about that, th... - 09:43 AM Bug #9590: Double LOAD for each record in FWD
- Using an AdaptiveQuery, the problem is this:...
- 09:14 AM Bug #9590: Double LOAD for each record in FWD
- Octavian Adrian Gavril wrote:
> Yes, the test case is complete. I got the result using *9509a/15650* which has some ... - 08:59 AM Bug #9590: Double LOAD for each record in FWD
- Yes, the test case is complete. I got the result using *9509a/15650* which has some changes for @CompoundQuery@. The ...
- 08:55 AM Bug #9590: Double LOAD for each record in FWD
- I followed up the first run of the test with another one and the @file.txt@ now contains:...
- 08:50 AM Bug #9590: Double LOAD for each record in FWD
- Tested with *trunk/15674*, the output of @file.txt@ was:...
- 08:34 AM Bug #9590 (WIP): Double LOAD for each record in FWD
01/29/2025
- 11:16 AM Bug #9317: FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches a uniq...
- Review of 9317a:
* @if (joinRef != null && !joinRef.equals(ref))@ this makes the query matching a bit more relaxed... - 11:02 AM Bug #9318: Make record nursery visible on removeRecords
- 9318a is at rev. 15618 (which doesn't include your latest changes).
- 09:22 AM Feature #7020: always use "expanded" extent fields
- Stefanel Pezamosca wrote:
> *Roger* (or someone who can), could you help by testing *9537a* with @denorm_extents==tr... - 08:20 AM Feature #7020: always use "expanded" extent fields
- Stefanel Pezamosca wrote:
> Hynek Cihlar wrote:
> > Code review 7020c. The UI changes look OK to me.
> >
> > Th... - 08:13 AM Feature #7020: always use "expanded" extent fields
- Hynek Cihlar wrote:
> Code review 7020c. The UI changes look OK to me.
>
> There are some files that are missing... - 08:02 AM Feature #7020: always use "expanded" extent fields
- Code review 7020c. The UI changes look OK to me.
There are some files that are missing file history entries. - 07:34 AM Feature #7020 (Review): always use "expanded" extent fields
- > There is one more issue I'm trying to fix related with expanded_extents=true. The fields that are empty strings are...
- 07:19 AM Feature #7020: always use "expanded" extent fields
- > *Greg/Roger*: I want to ask: Do you think we should bring the UI fixes for @denorm-extents=true@ in another branch ...
- 03:59 AM Feature #7020: always use "expanded" extent fields
- There is one more issue I'm trying to fix related with @expanded_extents=true@. The fields that are empty strings are...
- 04:07 AM Bug #9590: Double LOAD for each record in FWD
- This testcase is generating the following output:...
- 04:03 AM Bug #9590 (WIP): Double LOAD for each record in FWD
01/28/2025
- 09:04 AM Feature #7020: always use "expanded" extent fields
- I managed to fix some of the errors mentioned in #7020-62. There are more places in code that uses @PropertyMeta.getE...
- 08:40 AM Feature #7020: always use "expanded" extent fields
- +Hynek to review the UI changes.
- 08:32 AM Feature #7020 (WIP): always use "expanded" extent fields
- I realised that until now I tested with @denorm-extents=true@ configuration and not @expand-extents=true@.
I added @... - 05:30 AM Feature #7020 (Review): always use "expanded" extent fields
- Ovidiu Maxiniuc wrote:
> * this is a very simple expression (only the @id_ext@ column), but the extent index can be ... - 02:27 AM Feature #7020: always use "expanded" extent fields
- I have committed to 7020c revision 15669:
* Fixed inconsistency in frame widget handling when using denorm-extents.
... - 07:14 AM Bug #9317: FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches a uniq...
- I build the following testcase:...
- 05:11 AM Bug #9317: FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches a uniq...
- I think 4GL shows a compile error, right? In that case, FWD shouldn't be fixed as it presumes correct 4GL input.
Fo...
01/27/2025
- 09:20 AM Feature #7020: always use "expanded" extent fields
- I found a solution for the compilation issue:...
- 07:01 AM Feature #7020: always use "expanded" extent fields
- Stefanel Pezamosca wrote:
> *Ovidiu*, I have the following testcases:
> [...] Converted to:
> [...] And the sql: ... - 04:14 AM Feature #7020: always use "expanded" extent fields
- *Ovidiu*, I have the following testcases:...
- 07:47 AM Bug #9317: FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches a uniq...
- Trying to create a test using the OF keyword, I stumbled upon another bug that might need fixing.
With the schema de... - 03:00 AM Bug #9318 (Review): Make record nursery visible on removeRecords
- Addressed the review from #9318-15 in *9318a/15589*. I removed @implicitBulkDelete@ and @deleteIndex@ members and cre...
01/24/2025
- 11:24 AM Support #4060: investigate converting extent fields to array columns
- I think this is dialect dependent. If all supported dialects had a fast native support for this, then the mapping wou...
- 07:26 AM Support #4060: investigate converting extent fields to array columns
- I believe our testing showed that array columns are faster than using "normalized" (secondary) array tables. We are ...
- 11:05 AM Feature #9577: persist the artifacts from dynamic query parsing/conversion (including the JAST) a...
- Indeed, this will have a great impact for queries executed early, during server startup. We can pre-train the server ...
- 07:39 AM Feature #9577: persist the artifacts from dynamic query parsing/conversion (including the JAST) a...
- Parsing dynamic queries is time consuming, which is why we cache them. As Ovidiu aptly notes in #9538-18, most of th...
- 07:29 AM Feature #9577 (New): persist the artifacts from dynamic query parsing/conversion (including the J...
- 07:45 AM Feature #6710: persist dynamic temp-tables across server restarts
- Didn't we implement this in #8233? Do we have full documentation for this? Is it linked into our documentation in a...
- 07:27 AM Support #4058: consider denormalizing tables as the default approach
- Can we do this with #7020?
01/23/2025
- 06:56 AM Feature #7020: always use "expanded" extent fields
- I have rebased 7020c to trunk revision 15658 and it's now at revision 15668. I need to make sure that I didn't break ...
- 05:04 AM Feature #7020: always use "expanded" extent fields
- Firstly, I will try rebasing 7020c. If this fails, I will make a new 7020d branch and take the changes manually.
01/22/2025
- 04:13 AM Bug #9133: Array subscript is out of range stops the evaluation of other expressions in the where...
- Serban, can you test the scenario from #9189-1 with @9133b@ , please?
I expect to see some @SEVERE@ logs of this f... - 04:04 AM Bug #9133: Array subscript is out of range stops the evaluation of other expressions in the where...
- Rebased the branch to latest trunk and committed to @9133b / rev 15656@ :...
01/21/2025
- 05:08 PM Feature #7020 (WIP): always use "expanded" extent fields
- 10:01 AM Bug #9133 (Internal Test): Array subscript is out of range stops the evaluation of other expressi...
- I am OK with the changes in 9133b. Only thing is that the arguments should be aligned to @String.format@ first argume...
- 09:52 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/LAS...
- 09:01 AM Bug #9318 (WIP): Make record nursery visible on removeRecords
- I am OK with the "backbone" of 9318a.
* However, I am not enjoying the @implicitBulkDelete@ and @deleteIndex@ class...
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...
- 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...
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.
- 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...
- 04:06 PM Feature #9559 (New): no-op implementations for obsolete record phrase and query options
- 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... - 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...
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... - 04:33 PM Feature #9549 (New): implement missing metadata features
- 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 - 04:15 PM Feature #9546 (New): investigate and implement field options, if missing
- 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... - 03:51 PM Feature #9545 (Review): confirm/add table parameter support
- 03:47 PM Feature #9544: implement missing SESSION handle attributes
- Attributes:
* @FIRST-BUFFER@
* @FIRST-QUERY@ - 03:46 PM Feature #9544 (Test): implement missing SESSION handle attributes
- 03:45 PM Feature #9543: implement missing BUFFER attributes
- Attributes:
* @AUTO-SYNCHRONIZE@ (none/none)
* @CAN-READ@ (none/none) - 03:44 PM Feature #9543 (Test): implement missing BUFFER attributes
- 03:42 PM Feature #9542: finish ORIGIN-HANDLE ProDataSet attribute
- Missing attributes:
* <table_handle>:ORIGIN-HANDLE (none/none) - 03:41 PM Feature #9542 (Test): finish ORIGIN-HANDLE ProDataSet attribute
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 ...
- 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 #... - 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...
- 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 ...
- 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...
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... - 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... - 06:32 AM Bug #9251 (Test): cache the translated FQL in FQLPreprocessor.translate
- Branch 9251c was merged to trunk as rev. 15636 and archived.
- 06:21 AM Bug #9251 (Merge Pending): cache the translated FQL in FQLPreprocessor.translate
- This can be merged to trunk now.
- 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... - 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... - 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...
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 ...
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...
- 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...
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.
- 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...
- 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 ...
- 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... - 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...
- 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. - 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...
Also available in: Atom