FWD » Core Development » Database

12/13/2024

12:01 PM Bug #6767 (WIP): Possible name clashes in DMO classes

A year passed since the issue was fixed, the old results cannot be used anymore, the work should be redone. Vladimir Tsichevski

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

Lorian Sandu wrote:
> @9397a@ has only runtime changes?
Yes, no reconversion needed. Ioana-Cristina Prioteasa

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

@9397a@ has only runtime changes? Lorian Sandu

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

Testing plan for *9397a rev. 15585-15589*:
* *Ioana[icp]*: large customer application unit tests - *done*
* *Andrei... Ioana-Cristina Prioteasa

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

Committed to *9397a rev. 15589* a couple of quick fixes: removed unused import and corrected the use of @getPropretyN... Ioana-Cristina Prioteasa

12/12/2024

09:46 AM Bug #9030: FIND statements should use an internal buffer cursor

Committed 9030b/rev. 15614: minor fixes
* reintroduced off-end on RAQ to properly support invalidated AdaptiveQuery ... Alexandru Lungu

07:55 AM Bug #9030: FIND statements should use an internal buffer cursor

Committed 9030b/rev 15612 and 9030b/rev. 15613:
* Finished the implementation at the level of fixing the unit tests ... Alexandru Lungu

08:43 AM Bug #9465: Emit the right errors when binding datasets

There are some edge cases for binding datasets that throw errors in 4GL, however FWD doesn't handle at all these case... Andrei Plugaru

03:50 AM Bug #9465 (WIP): Emit the right errors when binding datasets

Andrei Plugaru

07:40 AM Bug #9267: Index Selection in case of a multiple index matches.

Alexandru Lungu wrote:
> I don't think this is correct. If I am defining the @indexes@ in a different order @idx1@ f... Ovidiu Maxiniuc

06:41 AM Bug #9267: Index Selection in case of a multiple index matches.

Alexandru Lungu wrote:
> I don't think this is correct. If I am defining the @indexes@ in a different order @idx1@ ... Eduard Soltan

06:10 AM Bug #9267: Index Selection in case of a multiple index matches.

> I think it makes sense: the first find next had a f2 = 5, therefore idx2(f2) was the logical choice. The simpler fi... Alexandru Lungu

05:30 AM Bug #9267: Index Selection in case of a multiple index matches.

I think it makes sense: the first @find next@ had a @f2 = 5@, therefore @idx2(f2)@ was the logical choice. The simple... Ovidiu Maxiniuc

05:13 AM Bug #9267: Index Selection in case of a multiple index matches.

I think it related to the way how index is selected in temp-tables, when the tie between 2 indices that satisfy all c... Eduard Soltan

05:03 AM Bug #9267: Index Selection in case of a multiple index matches.

I found another case of incorrect index selection. As Eduard and Radu already engaged in this topic through #9267, I ... Alexandru Lungu

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

Harness and reports passed.
Alexandru, please review. Dănuț Filimon

07:27 PM Feature #9456 (WIP): implement SQL Server dialect and helpers

Eric Faulhaber

07:26 PM Feature #9455 (Internal Test): port native user defined functions to SQL Server

Eric Faulhaber

12/11/2024

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

Created *9383a* from *trunk/15611* and committed *9383a/15612*. @cacheResults()@ call from the notified TRANSACTION_C... Dănuț Filimon

12/10/2024

12:47 PM Feature #9443: add runtime support for DSLOG-MANAGER

At a minimum, @DB-CONTEXT@ needs to be supported.
In all likelihood, instrumentation for logging levels and entry-... Greg Shah

12:45 PM Feature #9443 (New): add runtime support for DSLOG-MANAGER

Greg Shah

12:00 PM Bug #9397 (Internal Test): Fix COPY-TEMP-TABLE issues

I have reviewed 9397a rev. 15588.
All issues I identified are done. Please also remove the unnecessary imports fro... Ovidiu Maxiniuc

05:11 AM Bug #9397: Fix COPY-TEMP-TABLE issues

Addressed the code review in *9397a rev. 15588*:
* Corrected the @if@ statement, which was indeed missing a set of p... Ioana-Cristina Prioteasa

10:35 AM Feature #9440: get-codepage() function should work with CLOB fields

The current implementation of @GET-CODEPAGE()@ (implemented in #3753) works with @LONGCHAR@ but not with @CLOB@ field... Greg Shah

10:31 AM Feature #9440 (Closed): get-codepage() function should work with CLOB fields

Greg Shah

10:24 AM Bug #9030 (WIP): FIND statements should use an internal buffer cursor

Implemented 9030b/rev 15611
* Includes an alpha version of @FindSupport@ that managed the algorithm presented abov... Alexandru Lungu

09:09 AM Bug #9030: FIND statements should use an internal buffer cursor

Extra findings:
* doing a FIND NEXT on another index *doesn't seem to reset the cursor*... Alexandru Lungu

05:53 AM Bug #9030: FIND statements should use an internal buffer cursor

Extra findings:
* If the buffer is sent as parameter, it keeps it state in regard to FIND NEXT.
* If the table is s... Alexandru Lungu

04:42 AM Bug #9030: FIND statements should use an internal buffer cursor

> Alexandru, I've created task branch 9030a from trunk rev 15372. This is the first attempt to solve the buffer's int... Alexandru Lungu

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

Alexandru Lungu wrote:
> > I will try to find a test case from a customer application scenario and an analysis of ho... Dănuț Filimon

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

> I will try to find a test case from a customer application scenario and an analysis of how often cacheResults and s... Alexandru Lungu

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

Alexandru Lungu wrote:
>If the results are progressive, then an optimization would be to only cache the current dele... Dănuț Filimon

12/09/2024

04:05 PM Bug #9397: Fix COPY-TEMP-TABLE issues

*Review of 9397a, r15587:*
I see the issues from my previous review have been addressed.
But, as Alex mentioned... Ovidiu Maxiniuc

10:00 AM Bug #9397: Fix COPY-TEMP-TABLE issues

*Review of 9397a*:
* Changes look good in terms of error handling.
* for type checking:... Alexandru Lungu

08:25 AM Bug #9426 (Rejected): Failed to UPDATE when flushing an INVALID dmo

Greg Shah

08:10 AM Bug #9426: Failed to UPDATE when flushing an INVALID dmo

After setting up an instance with the proper version and testing the test mentioned in #9416, the issue can't be repr... Dănuț Filimon

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

Dănuț Filimon

12/06/2024

09:21 AM Bug #9426: Failed to UPDATE when flushing an INVALID dmo

The stack trace:... Dănuț Filimon

09:11 AM Bug #9426 (Rejected): Failed to UPDATE when flushing an INVALID dmo

Dănuț Filimon

08:42 AM Bug #9318: Make record nursery visible on removeRecords

Latest implementation was committed to *9318a/15588* Dănuț Filimon

08:01 AM Bug #9318 (Review): Make record nursery visible on removeRecords

@Buffer.delete()@ is used for temporary tables because there is no order by clause generated at conversion, but a @re... Dănuț Filimon

05:35 AM Bug #9397: Fix COPY-TEMP-TABLE issues

Ioana, please design a 4GL Unit Tests suite according to [[p2j:4GL_Unit_Testing]]. Include the cases you found in the... Alexandru Lungu

05:32 AM Bug #9397 (Review): Fix COPY-TEMP-TABLE issues

Committed on *9397a rev. 15587*:
* removed logic to rollback when a validation error occurs.
* Moved the 12304 erro... Ioana-Cristina Prioteasa

12/05/2024

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

The result is a bit strange, before the fix. I understand that @a: 1, c: 0, d: 0@ is the row correctly copied, but th... Ovidiu Maxiniuc

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

I am currently testing different parameter combinations for @COPY-TEMP-TABLE@ and have identified another inconsisten... Ioana-Cristina Prioteasa

06:50 AM Bug #9318: Make record nursery visible on removeRecords

My point for #9318-10 is that we do not need a deleteAll(deleteIndex), we only need to make the distinction between d... Dănuț Filimon

06:30 AM Bug #9318: Make record nursery visible on removeRecords

Currently:
* EMPTY TEMP-TABLE should honor all indices;
* FOR EACH tt1. DELETE tt1. END. should honor the primary i... Dănuț Filimon

04:42 AM Bug #7496 (Test): finish support for query:forward-only attribute

Branch 7496c was merged into trunk as rev. 15596 and archived. Dănuț Filimon

04:33 AM Bug #7496 (Merge Pending): finish support for query:forward-only attribute

Please merge 7496c to trunk now. Alexandru Lungu

12/04/2024

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

Addressed code review in *9397a rev. 15586*.
Ovidiu Maxiniuc wrote:
> * @TemporaryBuffer.java@:
> ** line 4481... Ioana-Cristina Prioteasa

12/03/2024

01:08 PM Bug #9397 (WIP): Fix COPY-TEMP-TABLE issues

+Review of *9397a rev. 15584/5*.+
In spite of the long list below, the update is actually good. These are hidden a... Ovidiu Maxiniuc

09:31 AM Bug #9397 (Review): Fix COPY-TEMP-TABLE issues

Committed on *9397a rev. 15585*.
Added 5368 and 12304 errors, added type check for throwing 11885 error, fixed how @... Ioana-Cristina Prioteasa

09:30 AM Bug #9397 (WIP): Fix COPY-TEMP-TABLE issues

Ioana-Cristina Prioteasa

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

Ioana-Cristina Prioteasa wrote:
> 1. Are there other places where assigning int and in64 does not match progress beh... Ovidiu Maxiniuc

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

The type check for emitting the *11885* error has been implemented and we now we also ensure the @srcBuf@ is not empt... Ioana-Cristina Prioteasa

09:56 AM Bug #9034 (Test): FindQuery unique fails in a self join context

9034a was merged to trunk as rev 15593. Artur Școlnic

09:42 AM Bug #9034 (Merge Pending): FindQuery unique fails in a self join context

Please merge 9034a *after 9263a* to trunk. Alexandru Lungu

08:08 AM Bug #7496: finish support for query:forward-only attribute

ChUI regression tests passed. l.e. updated #7496-102
*7496c* can be merged. Dănuț Filimon

05:33 AM Bug #6744: rollback when there are catch/finally blocks opening their own transactions

On the first look, it seems related. Artur Școlnic

05:30 AM Bug #6744: rollback when there are catch/finally blocks opening their own transactions

Artur, is this task related to your recent work on FINALLY blocks and transaction scoping? Alexandru Lungu

12/02/2024

04:03 AM Bug #9318: Make record nursery visible on removeRecords

Alexandru Lungu wrote:
> I meant making the existing @deleteAll()@ call the @deleteAll(deleteIndex)@ with @null@ and... Dănuț Filimon

03:54 AM Bug #9318: Make record nursery visible on removeRecords

> I am wondering how should this look in the converted code?
Well, the converted code is now @tt.deleteAll()@ and ... Alexandru Lungu

03:50 AM Bug #9318: Make record nursery visible on removeRecords

Created *9318a* from *trunk/15586* and committed an initial implementation on *9318a/15587*. Allows to make a distinc... Dănuț Filimon

03:48 AM Bug #7496: finish support for query:forward-only attribute

Alexandru Lungu wrote:
> Danut, what is the status of 7496c? What testing is left?
*7496c* has be queued for ChUI r... Dănuț Filimon

03:46 AM Bug #7496: finish support for query:forward-only attribute

Danut, what is the status of 7496c? What testing is left? Alexandru Lungu

11/29/2024

11:19 AM Bug #9399: Record cannot be found by ROWID in non-default buffer

No, 4GL doesn't behave in this way. Stanislav Lomany

02:10 AM Bug #9399: Record cannot be found by ROWID in non-default buffer

Please run the test in OpenEdge with the same .df schema as you originally used in FWD - if OpenEdge behaves the same... Constantin Asofiei

10:15 AM Feature #9057 (Test): enable intermixed access to default tenant (shared) data and tenant-specifi...

The branch 9057a was rebased and then merged into trunk. Before that I did a quick smoke-test to be sure there is no ... Ovidiu Maxiniuc

08:24 AM Feature #9057 (Merge Pending): enable intermixed access to default tenant (shared) data and tenan...

Please merge 9057a to trunk, rebasing if necessary. Eric Faulhaber

05:54 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

> Where does this testing stand?
The regression testing passed.
Alexandru Lungu

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

I have committed a small clean revision and rebased the branch to 15584.
I pushed up to revision 15609. If the last ... Ovidiu Maxiniuc

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

I tested on the above testcase more combinations of data types.
These are the results:
|_.TtFirst – SRC|_.TtSecon... Ioana-Cristina Prioteasa

11/28/2024

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

Alexandru Lungu wrote:
> Ovidiu, compilation worked (no more errors); I am moving on with run-time testing.
Where... Eric Faulhaber

10:20 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Ovidiu, compilation worked (no more errors); I am moving on with run-time testing. Alexandru Lungu

09:04 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

I added those 3 methods reported in note 50. Committed revision 15601.
Note that all methods which were added havi... Ovidiu Maxiniuc

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

Alex, if you have time before Ovidiu gets in, please add back the missing APIs upon which the ChUI application is dep... Eric Faulhaber

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

I think the compiling is quite incremental. Even I get past #9057-42, new issues are present:
* @persistence.execu... Alexandru Lungu

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

Committed revision 15600 of 9057a. It contains the changes noted in above discussion (review). Ovidiu Maxiniuc

01:31 PM Bug #9399: Record cannot be found by ROWID in non-default buffer

OK, I resolved the issue for myself. It is a weird FWD conversion issue. In my @.df@ file I had a permanent table cal... Stanislav Lomany

10:01 AM Bug #9399: Record cannot be found by ROWID in non-default buffer

Testcase attached. 4GL displays "1", FWD throws "xtt record not on file".
Checked on trunk rev 15583. Checked that i... Stanislav Lomany

09:50 AM Bug #9399 (New): Record cannot be found by ROWID in non-default buffer

Stanislav Lomany

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

h3. Summary of the Issue
Two key issues have been identified with the @COPY-TEMP-TABLE@ function:
*1. When Shou... Ioana-Cristina Prioteasa

06:41 AM Bug #9397 (Closed): Fix COPY-TEMP-TABLE issues

Ioana-Cristina Prioteasa

11/27/2024

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

Eric Faulhaber wrote:
> * I reviewed the changes, but it is hard to review for possible missing changes, such as pla... Ovidiu Maxiniuc

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

Code review 9057a/15578-15598:
Big update! In part, this is because I have re-reviewed the older revisions I revie... Eric Faulhaber

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

Never done, in the new format. I will try to. Ovidiu Maxiniuc

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

Ovidiu Maxiniuc wrote:
> I've just done that. Committed revision 15599.
>
> I wanted to test them but for some st... Eric Faulhaber

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

I've just done that. Committed revision 15599.
I wanted to test them but for some strange causes, the project fail... Ovidiu Maxiniuc

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

Alexandru Lungu wrote:
> I was successful in converting and compiling some part of the direct Java code. However, I ... Eric Faulhaber

10:01 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

I was successful in converting and compiling some part of the direct Java code. However, I got to a point where there... Alexandru Lungu

08:38 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Status update:
* I addressed the issues reported by Constantin in note #9057-38 and Alexandru in #9057-39. Committe... Ovidiu Maxiniuc

06:08 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Testing ETF, in the conversion the only change is a new line which no longer exists between the var def and the @forE... Constantin Asofiei

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

Ovidiu, I am sorry, but I missed:... Alexandru Lungu

02:58 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Ovidiu, please remove this debug line:
> src/com/goldencode/p2j/persist/orm/SessionFactory.java:381: ... Constantin Asofiei

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

Added TRPL documentation on MT processing.
Committed revision 15597. Ovidiu Maxiniuc

09:33 AM Bug #9365 (Test): The active buffer is no longer set for getters, so _getClob is not working

Artur Școlnic

09:30 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

9365a is merged to trunk as rev 15579. Artur Școlnic

09:21 AM Bug #9365 (Merge Pending): The active buffer is no longer set for getters, so _getClob is not wor...

I am OK with the changes in 9365a. Please merge to trunk now. Alexandru Lungu

08:44 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

I committed rev 15578 and tested it, the testing went ok. Artur Școlnic

07:30 AM Bug #9365 (Internal Test): The active buffer is no longer set for getters, so _getClob is not wor...

Review of 15577:
* I think there is a confusion. I was looking into a branch older than rev. 15573 in which the ac... Alexandru Lungu

06:21 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

Made the discussed changes, committed rev 15577 and added @TestCLOBGetter.cls@ to the testcases project. Artur Școlnic

05:39 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

I think we need more consistency with the moment when the active buffer is set and @activeBufferSet@ flag is used. So... Alexandru Lungu

05:34 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

Alexandru Lungu wrote:
> Can you describe what are the possible cases in which this addition in required?
This is ... Artur Școlnic

05:15 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

> If you mean if (bmd.batchDepth != BatchModeData.NOT_ACTIVE && !bmd.dirtyBatchBuffers.containsKey(buffer)), then yes... Alexandru Lungu

04:57 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

Alexandru Lungu wrote:
> Review of 9365a:
> * is @BufferManager@ change still needed?
If you mean @if (bmd.batchDe... Artur Școlnic

04:35 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

Review of 9365a:
* I am OK with the set/restore mechanism.
* is @BufferManager@ change still needed?
* you also ha... Alexandru Lungu

04:06 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

The largest app unit test regression testing passed. I could think of a single scenario where the issue discussed in ... Artur Școlnic

07:34 AM Feature #6441: compatible collation for UTF-8 databases

From #9378-8 :
This looks like is just how @en_US.UTF-8@ collation works, and is not a postgresql problem, but a c... Constantin Asofiei

05:34 AM Bug #7496: finish support for query:forward-only attribute

Rebased *7496c* to latest *trunk/15578* and the branch is now at revision *7496c/15579*. Dănuț Filimon

05:24 AM Bug #7496: finish support for query:forward-only attribute

Test plan:
* large customer application harness and run some reports. (Harness passed, tested 4 reports and those al... Dănuț Filimon

03:29 AM Bug #7496: finish support for query:forward-only attribute

Committed *xfer testcases/1655*:
* adaptive scrolling tests in @fwd_tests/persist/queries/@
* forward-only tests ... Dănuț Filimon

11/26/2024

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

Done. I did a quick smoke test to check at least it compiles correctly.
I am going on with tests as described in #90... Ovidiu Maxiniuc

11:30 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Alexandru,
Thank you for reporting this.
I encountered similar issue when I did some tests with the large applicat... Ovidiu Maxiniuc

10:00 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Ovidiu, I started looking into 9057a, but I failed running @ant deploy@ on the ChUi regression tests because it uses ... Alexandru Lungu

09:35 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Ovidiu, should I test 9057a? There is also a 9057b, that is why I am asking. Alexandru Lungu

09:27 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Eric Faulhaber wrote:
> Ovidiu, don't you need to rebase the branch?
I've just done the rebase. The current revisio... Ovidiu Maxiniuc

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

I attempted to patch 7156c with the changes from 9057a, but did not succeed, the patch is over 10k lines, 7156c and t... Artur Școlnic

11:45 PM Feature #9057 (Review): enable intermixed access to default tenant (shared) data and tenant-speci...

Ovidiu, don't you need to rebase the branch? Eric Faulhaber

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

I think I have finished the multi-tenant specific implementation. The latest commit is 15586 in branch 9057a.
Since ... Ovidiu Maxiniuc

09:46 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

Artur, please also design a small 4GL Unit Test suite with this edge case and add it to your existing suite. Also tes... Alexandru Lungu

09:45 AM Bug #9365 (Review): The active buffer is no longer set for getters, so _getClob is not working

I made the necessary changes and committed 15576, meanwhile I started a large app unit test module for testing. Artur Școlnic

08:53 AM Bug #9365 (WIP): The active buffer is no longer set for getters, so _getClob is not working

Alexandru Lungu

07:32 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

I wanted to be consistent with the way the restore is happening for all buffers, but I guess this is not imperative f... Artur Școlnic

07:28 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

> but if is is used in a batch assign, then it's state can't be restored in the invoke of the getter, it has to be at... Alexandru Lungu

06:25 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

@getterActiveBuffers@ has a similar functionality to @dirtyBathBuffers@ In a simple assign case, we can just check if... Artur Școlnic

05:37 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

*My understanding of the problem and proposed solution*: The problem is that CLOB field getters don't have an active ... Alexandru Lungu

09:45 AM Bug #9194 (WIP): FWD selects the wrong index when using CONTAINS?

I've committed to 9194a rev. 15578 a really small change:
* I re-enabled the selection of word-indexes.
Next, we ... Radu Apetrii

07:27 AM Bug #7496: finish support for query:forward-only attribute

Alexandru Lungu wrote:
> adaptive_scrolling should clearly go into fwd_tests (maybe persist/queries folder?).
I was... Dănuț Filimon

07:25 AM Bug #7496: finish support for query:forward-only attribute

adaptive_scrolling should clearly go into fwd_tests (maybe persist/queries folder?).
forward_only depends ... the ... Alexandru Lungu

06:04 AM Bug #7496: finish support for query:forward-only attribute

Alexandru Lungu wrote:
> Also please extend xfer 4GL unit test suite with your examples.
Should I commit the adap... Dănuț Filimon

05:11 AM Bug #7496 (Internal Test): finish support for query:forward-only attribute

*Review of 7496c/15558*
* The changes aim to notify the @AdaptiveQuery@ when the delegate of the @ProgressiveResul... Alexandru Lungu

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

An observation as part of #7496 (especially #7496-92), the @ProgressiveResults@ are not cached if it uses a @SimpleRe... Alexandru Lungu

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

Alexandru Lungu

11/25/2024

10:22 AM Bug #9194: FWD selects the wrong index when using CONTAINS?

Radu Apetrii wrote:
> I think I'll run the same test with Hotel next.
Well, nothing changed in Hotel with word-inde... Radu Apetrii

09:04 AM Bug #9194: FWD selects the wrong index when using CONTAINS?

Eric, if you want to take a look at the files, you can check both @.diff@ files, they aren't that large. Keep in mind... Radu Apetrii

06:51 AM Bug #9194: FWD selects the wrong index when using CONTAINS?

Soo, I can finally make an update. I will attach a couple of files:
* A @start.p@ which contains 7 query examples wr... Radu Apetrii

08:52 AM Bug #9318: Make record nursery visible on removeRecords

From #8959-19:
> The only limitation is that deleteIndex should come from the converted code and requires conversion... Dănuț Filimon

07:42 AM Bug #9318 (WIP): Make record nursery visible on removeRecords

Dănuț Filimon

07:38 AM Bug #9318: Make record nursery visible on removeRecords

9275a was merged recently to trunk. The same changes reached 7156c at some point. Danut, please take over this as par... Alexandru Lungu

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

PS: Mind that @FqlPreprocessor.preprocess@ does the whole work. It iterates the AST *multiple times*, so there are se... Alexandru Lungu

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

Ioana, please focus on detecting how @dropAlias@ and @replacementAlias@ are relevant and why we need to computed them... Alexandru Lungu

07:43 AM Bug #7641: Lower the number of Map.get() calls in the persistence layer

Alexandru Lungu wrote:
> I think we already invested to much effort on too little results for #7641. I will reject t... Stefanel Pezamosca

07:39 AM Bug #7641 (Rejected): Lower the number of Map.get() calls in the persistence layer

I think we already invested to much effort on too little results for #7641. I will reject this task. Stefanel, please... Alexandru Lungu

06:25 AM Bug #9365 (Review): The active buffer is no longer set for getters, so _getClob is not working

@isBatchAssignMode@ looks in the current scope, so in the case from note 1, @tt2@ won't be added to the dirty batch b... Artur Școlnic

06:23 AM Bug #9365 (WIP): The active buffer is no longer set for getters, so _getClob is not working

Artur Școlnic

11/23/2024

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

Yesterday I implemented the runtime support for the @setMultiTenantAlternative()@ to be method injected in case of po... Ovidiu Maxiniuc

11/22/2024

05:29 AM Bug #9365: The active buffer is no longer set for getters, so _getClob is not working

After the following change:... Alexandru Lungu

03:55 AM Bug #9365 (Test): The active buffer is no longer set for getters, so _getClob is not working

Alexandru Lungu

03:09 AM Bug #7496: finish support for query:forward-only attribute

I've tested 7496c/15558 using the unit tests of a large customer and did not find any regressions. Dănuț Filimon

11/21/2024

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

Greg Shah wrote:
> > a new set of FindQuery APIs which would accept both tuple of (fql, client-where, args). I think... Ovidiu Maxiniuc

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

Carson Mader wrote:
> Will the runtime still support running in single-tenant and multi-tenant mode without the need... Greg Shah

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

Will the runtime still support running in single-tenant and multi-tenant mode without the need for a conversion when ... Carson Mader

06:44 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

> a new set of FindQuery APIs which would accept both tuple of (fql, client-where, args). I think we can keep the cur... Greg Shah

06:09 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Yes, I did think of something like that, but since it involved changes in generated code, I kept it a plan B.
Ther... Ovidiu Maxiniuc

04:34 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

Are you expecting conversion to be specific to MT in this case? It would be the first thing that was hard coded in t... Greg Shah

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

Update on my latest effort to get done the last known multiple-tenant issue described above.
The compound queries ... Ovidiu Maxiniuc

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

Branch 9251b was merged into trunk as rev. 15572 and archived. Stefanel Pezamosca

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

You can merge to trunk now. Greg Shah

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

9251b should have been merged to trunk. It's just a null check. Stefanel Pezamosca

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

What are the next steps with 9251b? Greg Shah

05:03 AM Bug #7496 (Review): finish support for query:forward-only attribute

*Committed 7496c/15558*. When the delegate of ProgressiveResults closes, the AdaptiveQuery.resultsCached should be se... Dănuț Filimon

04:11 AM Bug #7496: finish support for query:forward-only attribute

Dănuț Filimon wrote:
> I am now thinking on how to _notify_ the AdaptiveQuery that it's results (ProgressiveResults)... Dănuț Filimon

07:11 PM Feature #9302: new reports for abbreviated field names and abbreviated table names

Eugenie Lyzenko wrote:
> Does it require reconversion?
No. Roger Borrello

07:05 PM Feature #9302: new reports for abbreviated field names and abbreviated table names

Roger,
Does it require reconversion? Eugenie Lyzenko

11/20/2024

06:56 PM Feature #9302 (Closed): new reports for abbreviated field names and abbreviated table names

Greg Shah

06:45 PM Feature #9302: new reports for abbreviated field names and abbreviated table names

*Merge notification for task branch 9302a*
Branch 9302a was merged to trunk as revision 15571 and archived.
* A... Roger Borrello

06:32 PM Feature #9302 (Merge Pending): new reports for abbreviated field names and abbreviated table names

You can merge to trunk now. Greg Shah

06:14 PM Feature #9302: new reports for abbreviated field names and abbreviated table names

There isn't anything left to do with this task. I've rebased the branch to 15577. Roger Borrello

06:09 PM Feature #9302: new reports for abbreviated field names and abbreviated table names

That's fine. We'll just document the Custom Reports:
|_. Field |_. Value |
| Report Type | ... Roger Borrello

05:53 PM Feature #9302: new reports for abbreviated field names and abbreviated table names

The multiple buckets version is the useful case for actually interacting with the report online.
If we need this k... Greg Shah

05:47 PM Feature #9302: new reports for abbreviated field names and abbreviated table names

Greg Shah wrote:
> Instead of setting @dumpType@, you set @dumpExpr@.
That works great... this is a very useful r... Roger Borrello

05:02 PM Feature #9302: new reports for abbreviated field names and abbreviated table names

> Is there a way to set the match expression in the profile.rpt?
Instead of setting @dumpType@, you set @dumpExpr@... Greg Shah

04:44 PM Feature #9302: new reports for abbreviated field names and abbreviated table names

I have a good report that aggregates all the details so an export contains all the matches:... Roger Borrello

09:31 AM Bug #7496: finish support for query:forward-only attribute

Dănuț Filimon wrote:
> The strangest part now, I'd expect a rollback / the transaction to be committed (the TRANSACT... Dănuț Filimon

05:00 AM Bug #7496: finish support for query:forward-only attribute

I've tracked the issue and found the following:
* In @ProgressiveResults.moveTo()@, the @position@ is @236@, it scro... Dănuț Filimon

11/19/2024

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

The need for a subselect is currently determined in two places:
# @QueryComponent.getWhere()@:... Ioana-Cristina Prioteasa

11/18/2024

05:02 PM Feature #7020: always use "expanded" extent fields

Greg Shah wrote:
> Ovidiu: What is the list of remaining work/testing to finish this task?
I have committed revis... Ovidiu Maxiniuc

08:13 AM Feature #7020: always use "expanded" extent fields

Ovidiu Maxiniuc wrote:
> As far as I can remember, 7020c is the latest revision. I did not removed (archived) 7020b ... Stefanel Pezamosca

08:08 AM Feature #7020: always use "expanded" extent fields

Stefanel Pezamosca wrote:
> I have locally rebased 7020b branch to trunk revision 15561. @./gradlew all@ works, but ... Ovidiu Maxiniuc

07:41 AM Feature #7020: always use "expanded" extent fields

I have locally rebased 7020b branch to trunk revision 15561. @./gradlew all@ works, but functionality remains to be t... Stefanel Pezamosca

08:44 AM Feature #9057: enable intermixed access to default tenant (shared) data and tenant-specific data

I have committed a new revision of 9057a (r15574, was rebased to trunk 15560).
It contains clarifications for all ... Ovidiu Maxiniuc

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

This is right! However, the optimization shouldn't be only on OUTER-JOIN; it can be used for non-outer join queries. ... Alexandru Lungu

07:22 AM Bug #9317 (WIP): FIRST/LAST clauses can avoid generating sub-selects if the WHERE clause matches ...

h3. Testcase
The schema consists of two persistent tables, @table1@ and @table2@, with the following characteristi... Ioana-Cristina Prioteasa

03:38 AM Bug #9267: Index Selection in case of a multiple index matches.

Updated [[p2j:Chapter_27_Sorting_Query_Results#section-18]], with new index selection rule (4.1). Eduard Soltan

03:20 AM Bug #9034: FindQuery unique fails in a self join context

9034a_h2 was merged to FWD-H2 trunk as rev 54. Artur Școlnic

03:11 AM Bug #9034: FindQuery unique fails in a self join context

Please go ahead and merge 9034a_h2 to FWD-H2 trunk. Alexandru Lungu

02:10 AM Bug #9034: FindQuery unique fails in a self join context

I am ready to merge 9034a_h2. Artur Școlnic

03:18 AM Bug #9347: Refactor the breakTie method fro temp-tables.

This task is a follow up for #9267-44.
The way to break the tie between multiples indices choices should be refacto... Eduard Soltan

03:12 AM Bug #9347 (New): Refactor the breakTie method fro temp-tables.

Eduard Soltan

11/16/2024

05:27 PM Feature #9302: new reports for abbreviated field names and abbreviated table names

Greg Shah wrote:
> > So the report now looks like this, although I'm pressed for time, and haven't been able to tes... Roger Borrello