FWD » Core Development » Database

04/07/2023

02:26 PM Bug #7258: Optimize INDEX-INFORMATION with closed dynamic queries

Well, the listener was added exactly for this reason, to invoke the @execute()@ method later, asynchronously from pre... Ovidiu Maxiniuc

04:12 AM Bug #7258: Optimize INDEX-INFORMATION with closed dynamic queries

Ovidiu Maxiniuc wrote:
> Rather it seems to me that the @getDelegate().notifyQueryOpenListeners(false);@ is not call... Alexandru Lungu

09:58 PM Bug #7258: Optimize INDEX-INFORMATION with closed dynamic queries

Alexandru Lungu wrote:
> Ovidiu, OFC, we can't mark the query as opened to avoid this. Can we at least short-circuit... Ovidiu Maxiniuc

08:39 AM Feature #7194 (WIP): Avoid generating an ORDER-BY clause if not required

Alexandru Lungu

02:10 AM Feature #6995 (Closed): possibly support NO-UNDO temporary tables directly in H2

Eric Faulhaber

04/06/2023

07:37 AM Feature #7194: Avoid generating an ORDER-BY clause if not required

I've added in @PreselectQuery@ a function that checks if the query will retrieve a unique finding. If so, then no @OR... Radu Apetrii

07:34 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

*Committed 7108a/rev.14528*. Removed @isAutoRtrimAndCi@ and replaced it with @isAutoRtrim and isAutoCi@.
I think tha... Dănuț Filimon

03:23 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Ovidiu Maxiniuc wrote:
> Historically speaking (in P2J/FWD terms), the @rtrim@ and @upper@ were handled together bec... Alexandru Lungu

08:45 PM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Alexandru Lungu wrote:
> Ovidiu Maxiniuc wrote:
> > Dănuț Filimon wrote:
> > Note that, for the moment, only Maria... Ovidiu Maxiniuc

07:16 AM Bug #7258: Optimize INDEX-INFORMATION with closed dynamic queries

I profiled the @INDEX-INFORMATION@ implementation in FWD on a POC that runs in ~10.000ms. ~10ms are spent inside @IND... Alexandru Lungu

07:00 AM Bug #7258 (Closed): Optimize INDEX-INFORMATION with closed dynamic queries

Alexandru Lungu

04:36 AM Bug #7185: H2 in-memory lazy hydration

Alexandru Lungu wrote:
> Radu, can you please check-out 7185a and test it against adaptive-scrolling/non-scrolling t... Radu Apetrii

04/05/2023

04:02 PM Feature #6444: dataset improvements

The changes in @expressions.rules@ do not affect the code generated by the conversion. Ovidiu Maxiniuc

04:00 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> Ovidiu Maxiniuc wrote:
> > Review of 6444a/14552.
> >
> > @expressions.rules@: please u... Eugenie Lyzenko

03:45 PM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> Review of 6444a/14552.
>
> @expressions.rules@: please update the gap status for @KW_SYN... Igor Skornyakov

03:29 PM Feature #6444: dataset improvements

Review of 6444a/14552.
@expressions.rules@: please update the gap status for @KW_SYNCHRON@ ("synchronize"), @KW_F_... Ovidiu Maxiniuc

02:11 PM Feature #6444: dataset improvements

Updated history entries.
Committed to 6444a/14552.
Changes to the @rules/gaps/expressions.rules@ are also committed. Igor Skornyakov

02:25 AM Feature #6444: dataset improvements

Branch 6444a was rebased to the trunk rev. 14525.
Pushed up to revision 14551.
Igor Skornyakov

03:46 PM Feature #6453: temp-table features

Merged to the trunk rev. 14526. Igor Skornyakov

01:41 PM Support #6455: XML feature(s) needing testing

Igor,
The revision 14552 is NOT visible in @devsrv01:/opt/secure/code/p2j_repo/p2j/active/6444a@.
Is it possible ... Ovidiu Maxiniuc

08:51 AM Support #6455: XML feature(s) needing testing

Eric Faulhaber wrote:
> As part of your final cleanup of #6444, please update the gap marking in @expressions.rules@... Igor Skornyakov

04:20 AM Support #6455 (Closed): XML feature(s) needing testing

As part of your final cleanup of #6444, please update the gap marking in @expressions.rules@ in branch 6444a to full ... Eric Faulhaber

04:13 AM Support #6455: XML feature(s) needing testing

Eric Faulhaber wrote:
> Thank you, Igor. It does appear that runtime support for READ-XMLSCHEMA was updated from par... Igor Skornyakov

04:08 AM Support #6455: XML feature(s) needing testing

Igor Skornyakov wrote:
> Eric,
> I believe that it was completely implemented in #6444. At least I've tested this f... Igor Skornyakov

04:07 AM Support #6455: XML feature(s) needing testing

Thank you, Igor. It does appear that runtime support for READ-XMLSCHEMA was updated from partial to basic in @rules/g... Eric Faulhaber

03:47 AM Support #6455: XML feature(s) needing testing

Eric Faulhaber wrote:
> Igor, is this issue already covered by the work you have done for #6444? If so, how complete... Igor Skornyakov

03:42 AM Support #6455: XML feature(s) needing testing

Igor, is this issue already covered by the work you have done for #6444? If so, how complete is the support now for t... Eric Faulhaber

11:11 AM Bug #7235 (WIP): Avoid selecting all fields for an CAN-FIND sub-select

Alexandru Lungu

10:45 AM Bug #7185: H2 in-memory lazy hydration

I have troubles testing 7185a. One customer application works flawlessly, while the other in hanging right at the sta... Alexandru Lungu

09:13 AM Bug #7185: H2 in-memory lazy hydration

Rebased 7185a with trunk (rev. 14525). 7185a is now at 14530. Alexandru Lungu

09:01 AM Feature #7066: Implement multi-table indexed query in H2

Tested 7066a against a customer application: most of the tests pass, but I have one that provides an unexpected outpu... Alexandru Lungu

06:27 AM Feature #7066: Implement multi-table indexed query in H2

Rebased 7066a with trunk rev. 14525. 7066a is now at rev. 14526.
Radu, please update 7066a and notify me if somethin... Alexandru Lungu

05:43 AM Feature #7066: Implement multi-table indexed query in H2

*Review for 7066a_h2/rev. 14*
Most of the changes for #7066 are conceptually inside H2. I see that there are a lot... Alexandru Lungu

07:47 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Note that the changes require reconversion of the application (or at least regeneration of DDL - convert.middle and j... Alexandru Lungu

05:00 AM Bug #7108 (Test): Simulate upper/rtrim directly in H2 using case specific columns

Alexandru Lungu wrote:
> Danut, please address this issue and I will move this to test.
Never mind. This is not c... Alexandru Lungu

04:17 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

I tested several applications:
* customer application POC - no regressions
* 2 customer application regression test... Alexandru Lungu

05:47 AM Bug #6458: ensure that OO expressions resolve to query substitution parameters, like handle-based...

I think the issue is that we don't emit as lambda the OO expression. Take this test:... Constantin Asofiei

03:24 AM Bug #6458: ensure that OO expressions resolve to query substitution parameters, like handle-based...

Constantin, Greg informed me that you were concerned about certain OO expressions embedded in WHERE clauses not conve... Eric Faulhaber

01:35 AM Bug #6887: improve performance of dataset/table[-handle] parameters

We should profile and check how #6887-3 test behaves now with FWD first. Constantin Asofiei

12:06 AM Bug #6887: improve performance of dataset/table[-handle] parameters

Constantin Asofiei wrote:
> This is the entire JMX result for the large application:
> [...]
>
> The 3 cases fro... Eric Faulhaber

04/04/2023

10:11 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

*4GL code:*... Alexandru Lungu

09:57 AM Bug #7252 (WIP): Use direct-access to support for-each queries without WHERE and BY clauses

Alexandru Lungu

06:32 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Ovidiu Maxiniuc wrote:
> Dănuț Filimon wrote:
> Note that, for the moment, only MariaDb support this kind of charac... Alexandru Lungu

04:59 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Rebased 7108a with trunk (rev. 14523). 7108a is now at rev. 14527. Alexandru Lungu

06:06 AM Bug #7035 (Review): Extract query parameters from statically converted FQL

*Committed 7035a/rev.14526*. This is a fix for #7035-24.
I found a similar problem on a customer application after ... Dănuț Filimon

04:14 AM Bug #7035: Extract query parameters from statically converted FQL

Constantin Asofiei wrote:
> There is another peculiarity at least with PostgreSQL - @select '1' = 1;@ will show 'tru... Alexandru Lungu

04/03/2023

09:47 AM Bug #7035: Extract query parameters from statically converted FQL

The H2 supports implicit conversion of @1 = '1'@, @'true' = true@ and even @'1' = true@. MariaDb will also return ret... Ovidiu Maxiniuc

05:07 AM Bug #7035 (WIP): Extract query parameters from statically converted FQL

Constantin Asofiei wrote:
> There is another peculiarity at least with PostgreSQL - @select '1' = 1;@ will show 'tru... Alexandru Lungu

07:42 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Ovidiu Maxiniuc wrote:
> ... Indeed, both dialects (actually the character type on SQL side) handle both of these la... Dănuț Filimon

04/01/2023

08:28 AM Bug #7035: Extract query parameters from statically converted FQL

There is another peculiarity at least with PostgreSQL - @select '1' = 1;@ will show 'true'. The same for @select 'tr... Constantin Asofiei

04:57 AM Bug #7035: Extract query parameters from statically converted FQL

The root cause seems to be an FQL like @tt1.f1 <> 0@ where @f1@ is an integer field. In this case, @0@ is extracted ... Constantin Asofiei

08:58 PM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Dănuț Filimon wrote:
> Ovidiu, is there any case where a rtrim is used but should not be removed when using @MariaDb... Ovidiu Maxiniuc

03/31/2023

07:28 PM Bug #6767: Possible name clashes in DMO classes

Eric Faulhaber wrote:
> Vladimir Tsichevski wrote:
>
> > What am I expected to do to make this patch merged to th... Vladimir Tsichevski

03:06 PM Feature #6371: implement SAVE CACHE statement

Merged into trunk as revision 14524. Boris Schegolev

02:18 PM Feature #6371 (Review): implement SAVE CACHE statement

Code review 6371b/14529: the changes look good. Eric Faulhaber

01:53 PM Feature #6371: implement SAVE CACHE statement

I pushed cleanup and headers update for modified files as revision 14529. Also, normalized extent support is replaced... Boris Schegolev

12:08 PM Feature #6371: implement SAVE CACHE statement

I've looked at 6371b and the changes look safe, they are limited to SAVE CACHE package in FWD. Constantin Asofiei

11:25 AM Bug #7035: Extract query parameters from statically converted FQL

7035a still fails, I think is related to some date literal. I need to find the actual FQL and SQL, will get back to ... Constantin Asofiei

07:13 AM Bug #7035: Extract query parameters from statically converted FQL

Committed it as 7035a/rev. 14525. I will also redo some of my regression tests for this. Alexandru Lungu

04:51 AM Bug #7035: Extract query parameters from statically converted FQL

Dănuț Filimon wrote:
> I attached a patch that should solve the issue. When handling strings in @FQLPreprocessor.cre... Constantin Asofiei

04:08 AM Bug #7035: Extract query parameters from statically converted FQL

I attached a patch that should solve the issue. When handling strings in @FQLPreprocessor.createParameterDiff@, they ... Dănuț Filimon

02:03 AM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> Yes, That is correct. The time-stamps remain, but they need to be grouped together at the e... Igor Skornyakov

03/30/2023

07:29 PM Feature #6444: dataset improvements

Yes, That is correct. The time-stamps remain, but they need to be grouped together at the end of history list, under ... Ovidiu Maxiniuc

04:32 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> Ovidiu Maxiniuc wrote:
> > Actually, not what I meant by updating the history entries.
> ... Igor Skornyakov

03:15 PM Feature #6444: dataset improvements

Constantin Asofiei wrote:
> The 'scale' computed in @int colDecs = Math.max(1, column.getDecimals());@ results in '0... Igor Skornyakov

03:04 PM Feature #6444: dataset improvements

The 'scale' computed in @int colDecs = Math.max(1, column.getDecimals());@ results in '0' so colDecs becomes 1, in Ov... Constantin Asofiei

02:28 PM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> Here is the isolated testcase:
> [...]
> And the results are as follows:
> |_. Reference... Igor Skornyakov

02:22 PM Feature #6444: dataset improvements

Constantin Asofiei wrote:
> We need Ovidiu's test first. Also, try the test in #6444-201 with and without DECIMAL... Igor Skornyakov

02:20 PM Feature #6444: dataset improvements

Here is the isolated testcase:... Ovidiu Maxiniuc

01:13 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> Constantin Asofiei wrote:
> > If DECIMALS is not specified, it defaults to 10 in OE. In F... Constantin Asofiei

01:12 PM Feature #6444: dataset improvements

Constantin Asofiei wrote:
> If DECIMALS is not specified, it defaults to 10 in OE. In FWD, there may be a problem a... Igor Skornyakov

01:08 PM Feature #6444: dataset improvements

If DECIMALS is not specified, it defaults to 10 in OE. In FWD, there may be a problem as we assume '0' in @persist.o... Constantin Asofiei

12:54 PM Feature #6444: dataset improvements

Well, in fact I've used the attached test for WRITE-JSON. Igor Skornyakov

12:40 PM Feature #6444: dataset improvements

For example, this test:... Constantin Asofiei

12:39 PM Feature #6444: dataset improvements

Constantin Asofiei wrote:
> Do you have a test which just uses @WRITE-XML@ for a temp-table with some records?
I me... Constantin Asofiei

12:39 PM Feature #6444: dataset improvements

This test uses appserver calls - the data may be affected by the transfer over the appserver. Do you have a test whi... Constantin Asofiei

12:27 PM Feature #6444: dataset improvements

Constantin Asofiei wrote:
> Igor, please specify a testcase I can use for the decimal serialization - where you saw ... Igor Skornyakov

12:23 PM Feature #6444: dataset improvements

Igor, please specify a testcase I can use for the decimal serialization - where you saw that the rounding is necessary. Constantin Asofiei

12:22 PM Feature #6444: dataset improvements

Branch 6444a was rebased to the trunk rev. 14523.
Pushed up to revision 14548. Igor Skornyakov

01:35 AM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> Actually, not what I meant by updating the history entries.
> Your entry must be the last ... Igor Skornyakov

12:15 AM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> Ovidiu Maxiniuc wrote:
> > Please update the H entries first. I will do some tests regardi... Ovidiu Maxiniuc

02:51 PM Feature #6371: implement SAVE CACHE statement

Boris Schegolev wrote:
> I rebased the branch (well, merged trunk into 6371b) without major issues.
>
> > As not... Eric Faulhaber

02:44 PM Feature #6371: implement SAVE CACHE statement

Awesome, I will apply headers update and continue cleanup and testing. Thank you! Boris Schegolev

02:42 PM Feature #6371: implement SAVE CACHE statement

Eric Faulhaber wrote:
> Boris Schegolev wrote:
> > I rebased the branch (well, merged trunk into 6371b) without maj... Eric Faulhaber

01:37 PM Feature #6371: implement SAVE CACHE statement

Boris Schegolev wrote:
> I rebased the branch (well, merged trunk into 6371b) without major issues.
This is not ... Eric Faulhaber

01:17 PM Feature #6371: implement SAVE CACHE statement

I rebased the branch (well, merged trunk into 6371b) without major issues.
> As noted in #6371-100, #6371-101, an... Boris Schegolev

11:23 AM Bug #7035: Extract query parameters from statically converted FQL

There are lots of these:... Constantin Asofiei

11:21 AM Bug #7035: Extract query parameters from statically converted FQL

Alexandru Lungu wrote:
> Rebased 7035a with latest trunk/rev. 14523.
ETF testing fails badly. Constantin Asofiei

09:53 AM Bug #7035: Extract query parameters from statically converted FQL

Rebased 7035a with latest trunk/rev. 14523. Alexandru Lungu

09:34 AM Bug #7035: Extract query parameters from statically converted FQL

Alexandru Lungu wrote:
> Tested it against two large customer applications. Also profiled against a customer POC. Th... Constantin Asofiei

06:37 AM Bug #7035: Extract query parameters from statically converted FQL

Tested it against two large customer applications. Also profiled against a customer POC. There were no regressions.
... Alexandru Lungu

06:31 AM Bug #7035: Extract query parameters from statically converted FQL

Alexandru, what's the state of testing for 7035a? Constantin Asofiei

10:08 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

*Committed 7108a_h2/rev.18*. Fix for cached @CompareMode@ where the same instance is used but a different one is requ... Dănuț Filimon

05:39 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

*Committed 7108a/rev.14519*. Skip adding upper and rtrim in the @SortCriterion.toString@ represensation when necessar... Dănuț Filimon

09:08 AM Feature #7066: Implement multi-table indexed query in H2

Alexandru Lungu wrote:
> * @s.setType(INDEX);@ means that you set the @index_name@ AST type to INDEX. This way, in a... Radu Apetrii

08:27 AM Feature #7066: Implement multi-table indexed query in H2

*Review for 7066a/rev. 14532*
The changes are reasonable considering the need of enforcing USE-INDEX in some scenari... Alexandru Lungu

06:26 AM Feature #7066: Implement multi-table indexed query in H2

I've committed to 7066a, rev. 14532 and 7066a_h2, rev. 14 some changes that target the use of @use index@.
As Alex p... Radu Apetrii

05:36 AM Feature #7194: Avoid generating an ORDER-BY clause if not required

Alexandru Lungu wrote:
> Eric Faulhaber wrote:
> > If you are intending to remove it at the FQL level, please note ... Radu Apetrii

03:05 AM Bug #6767: Possible name clashes in DMO classes

Vladimir Tsichevski wrote:
> What am I expected to do to make this patch merged to the trunk?
Create a task bra... Eric Faulhaber

03/29/2023

05:10 PM Bug #6767: Possible name clashes in DMO classes

Eric Faulhaber wrote:
> Code review 6767-full.diff:
>
> The changes look good.
>
> Just some minor issues with... Vladimir Tsichevski

12:58 PM Bug #6767: Possible name clashes in DMO classes

Code review 6767-full.diff:
The changes look good.
Just some minor issues with the file headers:
* The dates... Eric Faulhaber

04:09 PM Feature #6444: dataset improvements

Ovidiu, please post when you have some test results, so we can figure out where this falls in the merge order. Thanks. Eric Faulhaber

12:23 AM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> Please update the H entries first. I will do some tests regarding the synchronize, fill and... Igor Skornyakov

03:30 PM Feature #6371: implement SAVE CACHE statement

Code review 6371b/14485-14488:
Overall, it seems good functionally; nice work. I do have some considerations and c... Eric Faulhaber

11:40 AM Bug #7185: H2 in-memory lazy hydration

Committed 7185a/rev. 14532 and 7185a_h2/rev. 16: handle cases when result-set is composed out of multiple row structu... Alexandru Lungu

11:09 AM Bug #7185: H2 in-memory lazy hydration

*Done some tests with latest 7185a/rev. 14531 and latest 7185a_h2:*
* @FWDDirectAccess.retrieveResponse@ you creat... Alexandru Lungu

09:02 AM Bug #7185: H2 in-memory lazy hydration

Based on #7185-14 I committed *7185a/rev.14531*. I confirmed that @TempRecord.checkIncomplete@ is redundant and remov... Dănuț Filimon

07:15 AM Bug #7185: H2 in-memory lazy hydration

Eric Faulhaber wrote:
> The idea when I first implemented @BaseRecord@ was to make the @data@ array directly accessi... Alexandru Lungu

06:28 AM Bug #7185: H2 in-memory lazy hydration

Alexandru Lungu wrote:
> *Eric, Constantin, please advice*. If we attempt to implement lazy-hydration in any form ... Eric Faulhaber

06:03 AM Bug #7185: H2 in-memory lazy hydration

*Review for 7185a/rev. 14529 and 14530*
This is close to a conceptually correct solution. However, there are still... Alexandru Lungu

05:19 AM Bug #7185: H2 in-memory lazy hydration

*Committed 7185a/rev.14530*. Fixed a NPE in @TempRecord.getDatum()@ where fallback was assigned but readFields was null. Dănuț Filimon

10:16 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Danut, please mark #7108-31 as high priority for now. Alexandru Lungu

07:47 AM Bug #7235: Avoid selecting all fields for an CAN-FIND sub-select

4GL code:... Alexandru Lungu

07:39 AM Bug #7235 (Closed): Avoid selecting all fields for an CAN-FIND sub-select

Alexandru Lungu

07:17 AM Feature #7194: Avoid generating an ORDER-BY clause if not required

Eric Faulhaber wrote:
> If you are intending to remove it at the FQL level, please note that we do a reverse lookup ... Alexandru Lungu

06:37 AM Feature #7194: Avoid generating an ORDER-BY clause if not required

Is the idea to just remove the ORDER BY at the SQL level (as opposed to the FQL level)?
If you are intending to re... Eric Faulhaber

05:25 AM Feature #7066: Implement multi-table indexed query in H2

Created 7066a from trunk rev. 14519 and rebased with 7026b changes. Also created 7066a_h2 from FWD-H2 trunk rev. 13. Alexandru Lungu

03/28/2023

07:37 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> > *** according to https://docs.progress.com/bundle/openedge-prodatasets-117/page/Using-the... Ovidiu Maxiniuc

07:11 AM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> Review of 6444a/14538:
> * @AbstractQuery.java@, @CompoundComponent.java@, Dialect.java, e... Igor Skornyakov

02:30 AM Feature #6444: dataset improvements

Branch 6444a was rebase to the trunk rev. 14518.
Pushed up to revision 14541. Igor Skornyakov

02:12 AM Feature #6444 (WIP): dataset improvements

Igor Skornyakov

11:34 PM Feature #6444: dataset improvements

Review of 6444a/14538:
* @AbstractQuery.java@, @CompoundComponent.java@, Dialect.java, etc: GCD coding standard: ple... Ovidiu Maxiniuc

07:05 PM Feature #6371: implement SAVE CACHE statement

I added support for comments / meta info for extent fields as revision 6371b/14488. Documentation is also updated - s... Boris Schegolev

10:58 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

h2. Reviews
*Review for 7108a*
* @SortCriterion@ instances are still generated with @upper@ and @rtrim@! Please c... Alexandru Lungu

08:25 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Rebased 7108a from trunk rev. 14515. 7108a is now at rev. 14518. Alexandru Lungu

09:50 AM Bug #7185: H2 in-memory lazy hydration

Based on #7185-10 I committed *7185a/rev.14529* and *7185a_h2/rev.15.*.
* Fixed @TempRecord@.
* Made @BaseRecord.ja... Dănuț Filimon

05:27 AM Bug #7185: H2 in-memory lazy hydration

*Review for 7185a/rev. 14528*
* In @TempRecord@:
** @readFields.set(i);@ is redundant as @readProperty@ already s... Alexandru Lungu

02:57 AM Bug #7185: H2 in-memory lazy hydration

*Committed 7185a_h2/rev.14* and *7185a/rev.14528* as part of the initial implementation for lazy hydration.
I've m... Dănuț Filimon

09:23 AM Feature #7194: Avoid generating an ORDER-BY clause if not required

Radu, please address #7194 once you get a stable solution for #7066. AFAIK, you already have some implementation rega... Alexandru Lungu

07:16 AM Feature #7060 (Review): Consider using wildcard selection to reduce SQL size

Alexandru Lungu

04:27 AM Bug #7138 (WIP): Short circuit fake-update (update with a new value eqaul to the old value) in H2

Alexandru Lungu

03/27/2023

10:29 AM Bug #7220: Record not created when property is set to empty string

I remember that Danut also tested the example with a temporary table. In that case, the record was found because @isA... Alexandru Lungu

03/24/2023

06:56 PM Feature #6371: implement SAVE CACHE statement

I puhsed revision 6371b/14487. It provides support for DTTZ columns, fixes for MariaDB in @SchemaCheck@ and support f... Boris Schegolev

03/23/2023

04:27 AM Feature #7061 (Test): Enable the use of lazy result sets in H2

Alexandru Lungu

04:25 AM Bug #7165 (Test): Close multiplex scope using prepared statement

Alexandru Lungu

10:49 PM Bug #7220: Record not created when property is set to empty string

Interesting finding.
The record is not forced to flush to DB when it was created. The 'touch' marks the field as d... Ovidiu Maxiniuc

03/22/2023

07:18 AM Bug #7220: Record not created when property is set to empty string

Found an issue related to persistent tables where a record is not created when the property is set to an empty string... Dănuț Filimon

07:10 AM Bug #7220 (New): Record not created when property is set to empty string

Dănuț Filimon

06:34 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

When I added rtrimming to H2, I set it so that it will always rtrim when comparing strings. Then I noticed an issue d... Dănuț Filimon

03/20/2023

01:30 PM Bug #7211: Several H2 connections for one single session

-Adding a server log that contains around 100 of such connections. Note that is just during server startup without th... Thanasis Giannakopoulos

09:54 AM Feature #7062: Direct access to H2 internals to solve basic queries

I also committed an optimization for #7062-27 (7062b_h2/rev. 14 and 7026b/rev. 14512), including a mean of lazily com... Alexandru Lungu

03/17/2023

08:48 AM Feature #7062: Direct access to H2 internals to solve basic queries

Created 7062b_h2 for further work on H2.
Committed 7062b_h2/rev. 13 - generating a dummy jdbc statement for each r... Alexandru Lungu

06:30 AM Feature #6444: dataset improvements

Please don't. They will get forgotten. Marian has already confirmed he will handle the merge. Greg Shah

06:15 AM Feature #6444: dataset improvements

Greg Shah wrote:
> Marian/Constantin: Can you recommend a better place for these tests than @6453-6444/@?
>
> Igo... Igor Skornyakov

06:11 AM Feature #6444: dataset improvements

Marian/Constantin: Can you recommend a better place for these tests than @6453-6444/@?
Igor: We don't want to stor... Greg Shah

05:49 AM Feature #6444: dataset improvements

Tests for #6453 and #6444 has been added to @6453-6444@ subfolder of the @xfer.goldencode.com/opt/testcases/@ rev. 13... Igor Skornyakov

04:14 AM Feature #6444: dataset improvements

Marian Edu wrote:
> Igor, I think the easiest way to do that is to simply use a 'pipe through' routine - I think we ... Igor Skornyakov

03:16 AM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> This is for testing TEMP-TABLEs DATA-SETs as arguments in the remote calls.
Igor, I th... Marian Edu

03:12 AM Feature #6444: dataset improvements

Greg Shah wrote:
> Marian: Do you want Igor to commit his tests into the current [[p2j:Testcases]] or do you want so... Marian Edu

03:09 AM Feature #6444: dataset improvements

Greg Shah wrote:
> Marian: Has your team had to do this with the existing tests?
We've followed a similar approac... Marian Edu

05:51 AM Bug #5306: AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Radu Apetrii wrote:
> Alexandru Lungu wrote:
> > Can you do a run on the latest rev. 14507?
>
> Since the tests ... Alexandru Lungu

05:07 AM Bug #5306: AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Alexandru Lungu wrote:
> Can you do a run on the latest rev. 14507?
Since the tests were already set up, I ran th... Radu Apetrii

03/16/2023

01:08 PM Feature #6444: dataset improvements

Greg Shah wrote:
> We may want this to be configurable.
>
> Why does it generate output on the server side? That... Igor Skornyakov

12:55 PM Feature #6444: dataset improvements

We may want this to be configurable.
Why does it generate output on the server side? That doesn't sound expected. Greg Shah

12:53 PM Feature #6444: dataset improvements

Please note also that some tests generate files not only in the client home but also in the app. server home. This ma... Igor Skornyakov

12:46 PM Feature #6444: dataset improvements

Greg Shah wrote:
> I agree. It is good to be able to look deeply at any issue. I just want the comparison/detectio... Igor Skornyakov

12:40 PM Feature #6444: dataset improvements

I agree. It is good to be able to look deeply at any issue. I just want the comparison/detection of a problem to be... Greg Shah

12:25 PM Feature #6444: dataset improvements

Please note that my approach for testing is based on visual comparision of multiple output files generated by the tes... Igor Skornyakov

12:08 PM Feature #6444: dataset improvements

Marian: Do you want Igor to commit his tests into the current [[p2j:Testcases]] or do you want some other process to ... Greg Shah

12:06 PM Feature #6444: dataset improvements

Greg Shah wrote:
> Are all of your testcases integrated into the dataset tests in [[p2j:Testcases]]? If not, they s... Igor Skornyakov

12:02 PM Feature #6444: dataset improvements

Are all of your testcases integrated into the dataset tests in [[p2j:Testcases]]? If not, they should be.
Marian'... Greg Shah

10:31 AM Feature #6444 (Review): dataset improvements

Radu Apetrii wrote:
> Igor, I've attached a patch that should solve the problem.
>
> There was a parameter in @Ad... Igor Skornyakov

10:06 AM Feature #6444: dataset improvements

Radu Apetrii wrote:
> Igor, I've attached a patch that should solve the problem.
>
> There was a parameter in @Ad... Igor Skornyakov

09:54 AM Feature #6444: dataset improvements

Igor, I've attached a patch that should solve the problem.
There was a parameter in @AdaptiveQuery.executeScroll@ ... Radu Apetrii

05:41 AM Feature #6444: dataset improvements

Radu Apetrii wrote:
> In @AdaptiveQuery.executeQuery@, due to the introduction of @lazyMode@, all the @ProgressiveRe... Radu Apetrii

05:12 AM Feature #6444: dataset improvements

Eric Faulhaber wrote:
> Radu, have you been able to recreate the problem with branch #6444a?
Yes, I have.
In @Ad... Radu Apetrii

02:14 AM Feature #6444: dataset improvements

Eric Faulhaber wrote:
> Rather than just commenting out the lazy mode code in @AdaptiveQuery@, as in #6444-147, I st... Igor Skornyakov

11:48 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> Apart from READ-JSON support and #6444-149 all is done and 6444a is ready for the code re... Eric Faulhaber

11:53 AM Bug #6887: improve performance of dataset/table[-handle] parameters

This is the entire JMX result for the large application:... Constantin Asofiei

02:59 AM Bug #6887: improve performance of dataset/table[-handle] parameters

Boris Schegolev wrote:
> I found a few points where we spend most CPU time:
>
> 1. Reflexive invocation @java.lan... Eric Faulhaber

02:31 AM Bug #6887: improve performance of dataset/table[-handle] parameters

Constantin Asofiei wrote:
> In a large application, there is this JMX reported times (count/millis/nanos):
> ... Eric Faulhaber

11:50 AM Feature #7062: Direct access to H2 internals to solve basic queries

Go with option 2 - on @getStatement()@ call, lazily create the @java.sql.Statement@ instance which has all the entire... Constantin Asofiei

11:31 AM Feature #7062: Direct access to H2 internals to solve basic queries

Response to #7026-97
Constantin Asofiei wrote:
> Alexandru, I'm not sure where to post this. The changes for @Di... Alexandru Lungu

11:16 AM Bug #7211: Several H2 connections for one single session

This is an issue as there are several messages like the following in the server log:... Alexandru Lungu

11:04 AM Bug #7211 (WIP): Several H2 connections for one single session

Alexandru Lungu

10:58 AM Bug #5306: AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Radu, I think you have both 7026b (at least rev. 14505) and the @adaptive_scrolling@ tests (scrolling and non-scrolli... Alexandru Lungu

10:28 AM Feature #7060 (WIP): Consider using wildcard selection to reduce SQL size

I committed 7026b/rev. 14506 for wildcard selection only for P2JH2 dialect which already supports @INVISIBLE@ keyword... Alexandru Lungu

09:34 AM Bug #7185: H2 in-memory lazy hydration

> override checkIncomplete or create checkFetched, to automatically fetch the data at the specified index from the st... Alexandru Lungu

08:38 AM Bug #7174: Resolve simple CAN-FIND statements faster

Alexandru Lungu wrote:
> I think your <10% rates are error thresholds, considering that the first two optimizations ... Dănuț Filimon

07:23 AM Bug #7035 (Review): Extract query parameters from statically converted FQL

Committed 7035a/rev.14507. I applied the patch from #7035-11 which refactors @ParameterIndices@ into @ParameterDiff@ ... Dănuț Filimon

05:07 AM Bug #7035: Extract query parameters from statically converted FQL

I profiled #7035 fix again and I noticed a slight performance improvement this time. I think the optimization is havi... Alexandru Lungu

06:17 AM Bug #7167: Associating records from opened buffers to new sessions is slow

After a bit of investigation, the database sessions @com.goldencode.p2j.persist.orm.Session@ are closed quite eagerly... Alexandru Lungu

05:52 AM Bug #7165: Close multiplex scope using prepared statement

Alexandru Lungu wrote:
> * In @TemporaryBuffer.java@, add a proper default capacity for @additionalArgs@ and @ooArgs... Radu Apetrii

03/15/2023

01:18 PM Bug #6887: improve performance of dataset/table[-handle] parameters

I found a few points where we spend most CPU time:
# Reflexive invocation @java.lang.reflect.Method.invoke()@ - th... Boris Schegolev

12:45 PM Feature #6444: dataset improvements

Fixed the the NESTED/FOREIGN-KEY-HIDDEN support for WRITE-JSON.
6444a/14525.
The current status of the NESTED/FORE... Igor Skornyakov

11:13 AM Feature #6830 (Test): find and fix all SQL SELECT statements with inlined literal arguments, and ...

This reached trunk with 6129b. It can be closed.
#7165 was opened in the meantime targeting a "sub-issue" from here. Alexandru Lungu

11:10 AM Feature #6995 (Test): possibly support NO-UNDO temporary tables directly in H2

This reached trunk with 7026a. It can be closed. Alexandru Lungu

07:00 AM Bug #5306 (Review): AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Committed fix for repetitive fetching in 7026b/rev. 14505. I also attached the changes here.
The fix is the same a... Alexandru Lungu

06:38 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

I noticed a problem related to unique index/primary keys where the value that needs to be inserted is rtrimmed, but a... Dănuț Filimon

05:26 AM Feature #7061: Enable the use of lazy result sets in H2

Alexandru Lungu wrote:
> Radu, please commit #7061-28 patch to 7026b if there are no obvious problems in your tests.... Radu Apetrii

05:05 AM Feature #7061: Enable the use of lazy result sets in H2

Radu, please commit #7061-28 patch to 7026b if there are no obvious problems in your tests. I am looking forward to s... Alexandru Lungu

05:25 AM Bug #7174 (Review): Resolve simple CAN-FIND statements faster

> There is an improvement when using ANY instead of ONE for persistent tables when a findByUniqueIndex is detected. T... Alexandru Lungu

05:19 AM Bug #7165: Close multiplex scope using prepared statement

*Review of 7026b/rev. 14501*
* In @TemporaryBuffer.java@, add a proper default capacity for @additionalArgs@ and @... Alexandru Lungu

03/14/2023

02:11 PM Feature #6444: dataset improvements

Added FOREIGN-KEY-HIDDEN support for WRITE-XML,(READ|WRITE)-XMLSCHEMA.
Committed to 6444a/14524
The remaining thi... Igor Skornyakov

04:59 AM Feature #6444: dataset improvements

Rebased 6444a to the trunk/14503.
Pushed up to revision 14523.
Igor Skornyakov

04:51 AM Feature #6444: dataset improvements

Fixed @READ-XML(SCHEMA)?@ support for DATA-SETs with NESTED DATA-RELATIONs and multiple namespaces.
It works correct... Igor Skornyakov

12:30 PM Bug #7174: Resolve simple CAN-FIND statements faster

This semantic is why we have the @has{Any|One}@ nomenclature in @FindQuery@.
* @CAN-FIND({FIRST|LAST} ...)@ is con... Eric Faulhaber

09:35 AM Bug #7174: Resolve simple CAN-FIND statements faster

These are the expected results, where ONE is @CAN-FIND(tt)@, ANY is @CAN-FIND(FIRST tt)@.
|_. Number of records |_... Alexandru Lungu

09:23 AM Bug #7174: Resolve simple CAN-FIND statements faster

In OE, will a CAN-FIND ONE result return true if there is more than one match? In other words, is CAN-FIND ONE meant... Greg Shah

05:29 AM Bug #7174: Resolve simple CAN-FIND statements faster

I created tests that use simple queries, those tests consist of executing CAN-FIND for each record in a temporary/per... Dănuț Filimon

10:50 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

Ovidiu Maxiniuc wrote:
> Alexandru Lungu wrote:
> > Right now, I am still dragged back by @String.hashCode@:
> > [... Alexandru Lungu

10:32 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

Alexandru Lungu wrote:
> Right now, I am still dragged back by @String.hashCode@:
> [...]
Why is that? It seems li... Ovidiu Maxiniuc

09:42 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

Ovidiu Maxiniuc wrote:
> Apparently, the hash short-circuit is not used. The @length@ of the strings are compared, b... Alexandru Lungu

08:46 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

H2 database engine is built in Java. My first reaction to your hash suggestion was that it unneeded since Java has th... Ovidiu Maxiniuc

05:10 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

... Alexandru Lungu

10:02 AM Feature #7194: Avoid generating an ORDER-BY clause if not required

This task targets the following scenario:... Alexandru Lungu

09:49 AM Feature #7194 (Closed): Avoid generating an ORDER-BY clause if not required

Alexandru Lungu

08:03 AM Feature #7062: Direct access to H2 internals to solve basic queries

Moved the @isFindByRowid@ short-circuit from #7062-30 to @RAQ.execute@. This is because @isSimpleQuery@ was always re... Alexandru Lungu

07:33 AM Bug #7185: H2 in-memory lazy hydration

Danut, please focus on implementing a demo for point 5 - we should have a fast mock to test its performance. Therefor... Alexandru Lungu

07:15 AM Bug #7185 (WIP): H2 in-memory lazy hydration

Alexandru Lungu

04:47 AM Bug #7165: Close multiplex scope using prepared statement

Alexandru Lungu wrote:
> Radu, please move 7061a, rev. 14487 to 7026b.
> I will review, test and profile it once th... Radu Apetrii

04:03 AM Bug #7165 (Review): Close multiplex scope using prepared statement

Radu, please move 7061a, rev. 14487 to 7026b.
I will review, test and profile it once there. Alexandru Lungu

03/13/2023

06:47 PM Bug #6887 (WIP): improve performance of dataset/table[-handle] parameters

I did more testing on provided code. The INPUT-OUTPUT DATASET-HANDLE is slightly slower in FWD, but it's definitely n... Boris Schegolev

03:44 PM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> The main difference between @ds.xsd@ and the deserialied @hds.xsd@ is that the namespace, t... Igor Skornyakov

03:21 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> I've noticed a strange thing. Consider the attached test @nested-test.p@.
> It defines a D... Ovidiu Maxiniuc

09:55 AM Feature #6444: dataset improvements

Radu Apetrii wrote:
> Igor Skornyakov wrote:
> > The problem is with 'lazyMode'. After applying the attached path t... Igor Skornyakov

09:32 AM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> The problem is with 'lazyMode'. After applying the attached path the regression has gone.
... Radu Apetrii

05:28 AM Feature #6444: dataset improvements

Fixed minor issues with @WRITE-XML(SCHEMA)?@ for tables.
Committed to 6444a/14519. Igor Skornyakov

03:59 AM Feature #6444: dataset improvements

Eric Faulhaber wrote:
> Please post the test case, explain the regression to Radu, and let him fix it.
I'm workin... Radu Apetrii

03:09 AM Feature #6444: dataset improvements

Sorry, I've attached a wrong file. Igor Skornyakov

02:51 AM Feature #6444: dataset improvements

Eric Faulhaber wrote:
> Igor Skornyakov wrote:
> > Igor Skornyakov wrote:
> > > After rebasing I see a regression ... Igor Skornyakov

02:14 AM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> Igor Skornyakov wrote:
> > After rebasing I see a regression in the FILL test for temporar... Eric Faulhaber

10:32 AM Bug #5306 (WIP): AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Alexandru Lungu

07:37 AM Bug #7185: H2 in-memory lazy hydration

There is already some effort into lazy hydration as a general topic:
* supporting FIELDS/EXCEPT clause, so we can fe... Alexandru Lungu

03/12/2023

12:40 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> After rebasing I see a regression in the FILL test for temporary source tables and recursiv... Igor Skornyakov

10:28 AM Feature #6444: dataset improvements

After rebasing I see a regression in the FILL test for temporary source tables and recursive DATA-RELATION. Igor Skornyakov

10:13 AM Feature #6444: dataset improvements

Rebased 6444a to the trunk/14500.
Pushed up to revision 14517. Igor Skornyakov

09:26 AM Feature #6444: dataset improvements

Fixed WRITE-XML(SCHEMA) for multiple namespaces and NESTED relations.
Committed to 6444a/14508. Igor Skornyakov