FWD » Core Development » Database

02/21/2023

08:26 PM Feature #7020 (Review): always use "expanded" extent fields

I attempted to rebase 7020a to trunk, but that proved to be a very time consuming task, practically duplicating Const... Ovidiu Maxiniuc

02/20/2023

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

Alexandru Lungu wrote:
> I am facing a hot-spot in my profiling that may actual affect #7108 effort as well. It is r... Ovidiu Maxiniuc

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

Dănuț Filimon wrote:
> The tests from #7108-8 were done *without any patch applied*. I retested with the patch appli... Ovidiu Maxiniuc

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

Ovidiu, I recall that you had done some work with locale at some point. Please let me know if you can help me on this... Alexandru Lungu

02:28 PM Bug #7113: Problem with nested CAN-FIND conversion

The only remaining issue is that generated SQL statement contains extra closing brackets @)@ at the end of the WHERE ... Igor Skornyakov

11:20 AM Bug #7113: Problem with nested CAN-FIND conversion

Committed fix for the nested CAN-FIND to 7113a/14485. Igor Skornyakov

10:55 AM Bug #7113: Problem with nested CAN-FIND conversion

Created task branch 7113a. Igor Skornyakov

09:48 AM Bug #7113: Problem with nested CAN-FIND conversion

Igor Skornyakov wrote:
> Igor Skornyakov wrote:
> > Fixed nested CAN-FIND conversion (see attached .diff).
> > Ple... Igor Skornyakov

08:52 AM Bug #7113: Problem with nested CAN-FIND conversion

Igor Skornyakov wrote:
> Fixed nested CAN-FIND conversion (see attached .diff).
> Please review.
> Thank you.
>
... Igor Skornyakov

08:40 AM Bug #7113: Problem with nested CAN-FIND conversion

Fixed nested CAN-FIND conversion (see attached .diff).
Please review.
Thank you.
Working on runtime issue (#7113... Igor Skornyakov

08:56 AM Bug #7132: Eliminate for-each loops and lambda in FWD-H2 code

Alexandru Lungu wrote:
> Second, there is an overhead with using lambdas, especially the ones which reference local ... Radu Apetrii

04:10 AM Bug #7132: Eliminate for-each loops and lambda in FWD-H2 code

There is an overhead in using foreach loops: @for (Object obj : objs)@. This is because an iterator object is generat... Alexandru Lungu

03:47 AM Bug #7132 (WIP): Eliminate for-each loops and lambda in FWD-H2 code

Alexandru Lungu

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

Radu:
* I've created 7061a branched from trunk to commit your changes to.
* Please notify me once you address the r... Alexandru Lungu

02/17/2023

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

Alexandru Lungu wrote:
> As the patch and H2 modifications are mostly complete, in the sense that I have no obvious ... Alexandru Lungu

02/16/2023

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

The methods/attributes implemented by #6444 are not related to parameters. They perform the same regardless the datas... Ovidiu Maxiniuc

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

I didn't make any changes for this task. Not sure if there are any relevant changes coming from #6444. Boris Schegolev

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

Has any of this implementation been touched by the recent waves of performance work in 3821c and 6129c, or are we ess... Eric Faulhaber

03:26 PM Bug #6812: fix FastFindCache to use a shared instance per persistent database

Boris, please look at the @FastFindCache@ implementation and ask any questions you may have as it pertains to this task. Eric Faulhaber

03:19 PM Bug #6919: fix ErrorManager.displayError in TempTableBuilder

Is there anything left to do on this task, or can we close it? Eric Faulhaber

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

Eric Faulhaber wrote:
> One clarification to this point. It is not so much the fact that the new lazy mode should be... Alexandru Lungu

09:11 AM Support #7058: get the FWD fork of the H2 code base under version control

*UPDATE*: regression testing passed; merged 7062a_h2 to FWD-H2 trunk including support for direct access to internal ... Alexandru Lungu

06:18 AM Support #7058: get the FWD fork of the H2 code base under version control

Eric Faulhaber wrote:
> Alexandru, if there is any change to the build process, beyond just checking out the trunk F... Alexandru Lungu

09:07 AM Feature #7062 (Review): Direct access to H2 internals to solve basic queries

Merged 7062a_h2 into trunk after adding support for some extra data-types from FWD (object as resourceId and decimal ... Alexandru Lungu

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

The tests from #7108-8 were done *without any patch applied*. I retested with the patch applied and there is no diffe... Dănuț Filimon

02/15/2023

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

Alexandru Lungu wrote:
> Do you mean the case where the field is case-insensitive and the field is case-sensitive, b... Ovidiu Maxiniuc

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

I found several mismatched between FWD and 4GL. All of the tests are done in the following manner:... Dănuț Filimon

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

Danut, please make a complete set of independent *4GL tests* for each of these cases - or *search the testcases proje... Alexandru Lungu

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

Ovidiu Maxiniuc wrote:
> The problem is I do not think forcing the character substitutions to be case-sensitive is t... Alexandru Lungu

01:54 PM Feature #7061: Enable the use of lazy result sets in H2

Radu Apetrii wrote:

> I modified the patch from the last post a bit, because the change with the removal of @Prog... Eric Faulhaber

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

Update: I've committed a fix to 7061a_h2, rev. 12. *I no longer have issues when testing a large customer application... Radu Apetrii

12:58 PM Support #7058: get the FWD fork of the H2 code base under version control

Alexandru Lungu wrote:
> Once we have the pending branches merged into the FWD-H2 trunk, we will have a new build ... Eric Faulhaber

06:08 AM Support #7058: get the FWD fork of the H2 code base under version control

For H2, Eric will push this when it is ready. Greg Shah

03:56 AM Support #7058: get the FWD fork of the H2 code base under version control

*UPDATE*: regression testing passed; merged 6829a_h2 to FWD-H2 trunk including performance improvements regarding les... Alexandru Lungu

12:01 PM Feature #7037: remove dirty share manager

Guys, I want to commit the dirty sharing changes, but I want to know what dirty share state should be for the existin... Stanislav Lomany

10:52 AM Feature #6444: dataset improvements

Branch 6444a was rebased to the trunk rev. 14484.
Pushed up to revision 14493. Igor Skornyakov

09:13 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Error handler support for MariaDB committed to 6628a/14485
See also #6628-175.
Please review.
Thank you. Igor Skornyakov

08:24 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Created task branch 6628a from the trunk rev.14484 Igor Skornyakov

06:53 AM Feature #7062: Direct access to H2 internals to solve basic queries

Alexandru Lungu wrote:
> I am planning to make some final changes to 7062a (javadoc and small performance changes), ... Alexandru Lungu

03:59 AM Bug #6829 (Review): H2 forces re-parse of all prepared statements when metadata is changed

Merged 6829a_h2 to FWD-H2 trunk including performance improvements regarding less recompiling of prepared statements ... Alexandru Lungu

03:35 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed

There are no problems with rev.11. I checked @psCache@ hit/miss with rev.6 and rev.11 and didn't get very different r... Dănuț Filimon

03:58 AM Bug #7120 (Test): NO-UNDO dynamic temp-table does not set the NO-UNDO at the .schema

Changes look good. Thanks. Constantin Asofiei

02/14/2023

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

Review of @ffCache-20230214.patch@.
Nice detective work. Indeed, there seems to be a key collision which causes th... Ovidiu Maxiniuc

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

I've done some changes to how strings are compared in H2. I included a @rtrim@ parameter that, if set to true (by def... Dănuț Filimon

04:08 PM Bug #7120 (WIP): NO-UNDO dynamic temp-table does not set the NO-UNDO at the .schema

Good analysis!
Actually, the value of the @undo@ table attribute is not copied from the source table. It is by defau... Ovidiu Maxiniuc

07:00 AM Bug #7120: NO-UNDO dynamic temp-table does not set the NO-UNDO at the .schema

This test:... Constantin Asofiei

06:58 AM Bug #7120 (Test): NO-UNDO dynamic temp-table does not set the NO-UNDO at the .schema

Constantin Asofiei

12:28 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov wrote:
> Finished with error Handler support for MariaDB.
> Because of #7113 it was tested with a s... Igor Skornyakov

08:12 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed

Dănuț Filimon wrote:
> Committed 6829a_h2/rev.7. Stopped forced re-parsing for prepared statements.
>
> Each SELE... Alexandru Lungu

07:10 AM Support #7058: get the FWD fork of the H2 code base under version control

Will pre-built FWD-H2 revisions jars be uploaded into GCD repository ?
Tomasz Domin

07:00 AM Support #7058: get the FWD fork of the H2 code base under version control

*UPDATE*: regression testing passed; merged 6928a_h2 to FWD-H2 trunk including performance improvements for UPDATE st... Alexandru Lungu

07:01 AM Feature #6928 (Test): H2 UPDATE performance improvement

Merged 6928a_h2 to FWD-H2 trunk including performance improvements for UPDATE statement, with in-memory and PageStore... Alexandru Lungu

06:52 AM Feature #6928: H2 UPDATE performance improvement

Thanks, the change is OK. It can be merged to trunk. Constantin Asofiei

06:26 AM Feature #6928: H2 UPDATE performance improvement

Constantin Asofiei wrote:
> Was the branch bound? I don't see rev 11 for 6928a_h2.
What a quick response! My bzr ... Alexandru Lungu

06:23 AM Feature #6928: H2 UPDATE performance improvement

Alexandru Lungu wrote:
> Tested 6928a_h2/rev. 10 and found a regression: the old-row stored by @deltaChangeCollector... Constantin Asofiei

06:20 AM Feature #6928: H2 UPDATE performance improvement

Tested 6928a_h2/rev. 10 and found a regression: the old-row stored by @deltaChangeCollector@ inside the H2 update sta... Alexandru Lungu

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

I've added the option to execute queries in a lazy manner. Alongside this change, @AdaptiveQuery@ now uses only @Scro... Radu Apetrii

01:22 AM Bug #7113: Problem with nested CAN-FIND conversion

Ovidiu Maxiniuc wrote:
> The nested CAN-FIND is an old issue. There were some fixes in time (see #3040, #3465, #3771... Igor Skornyakov

09:22 PM Feature #7037: remove dirty share manager

Review of @7037b.diff@.
A clean implementation. Nice job. The patch should work as described in note #7037-35.
Pl... Ovidiu Maxiniuc

02/13/2023

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

Attaching a working version of sequences support in @SchemaCheck@ and @SchemaValidator@ for review. Boris Schegolev

05:20 PM Bug #7113: Problem with nested CAN-FIND conversion

The nested CAN-FIND is an old issue. There were some fixes in time (see #3040, #3465, #3771, and others) and the issu... Ovidiu Maxiniuc

09:13 AM Bug #7113 (WIP): Problem with nested CAN-FIND conversion

Igor Skornyakov

05:19 AM Bug #7113: Problem with nested CAN-FIND conversion

Thank you for checking, you can continue with your normal tasks. Constantin Asofiei

05:03 AM Bug #7113: Problem with nested CAN-FIND conversion

Igor Skornyakov wrote:
> Constantin Asofiei wrote:
> > One more thing: is this a regression in 6129c compared to tr... Igor Skornyakov

05:02 AM Bug #7113: Problem with nested CAN-FIND conversion

Constantin Asofiei wrote:
> One more thing: is this a regression in 6129c compared to trunk?
No, I get the same e... Igor Skornyakov

04:54 AM Bug #7113: Problem with nested CAN-FIND conversion

One more thing: is this a regression in 6129c compared to trunk? Constantin Asofiei

04:52 AM Bug #7113: Problem with nested CAN-FIND conversion

Constantin Asofiei wrote:
> So instead of @?@ it should be @Order.OrderNum@ and @OrderLine.ItemNum@, respectively? I... Igor Skornyakov

04:25 AM Bug #7113: Problem with nested CAN-FIND conversion

Igor Skornyakov wrote:
> Constantin Asofiei wrote:
> > What's the problem with the query? What would be the correct... Constantin Asofiei

04:23 AM Bug #7113: Problem with nested CAN-FIND conversion

Constantin Asofiei wrote:
> What's the problem with the query? What would be the correct variant? If you change the ... Igor Skornyakov

04:16 AM Bug #7113: Problem with nested CAN-FIND conversion

What's the problem with the query? What would be the correct variant? If you change the FQL manually to the correct v... Constantin Asofiei

03:02 AM Bug #7113: Problem with nested CAN-FIND conversion

The problem is at the program conversion (not only runtime).
The query from the previous noye is converted to... Igor Skornyakov

09:14 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Greg Shah wrote:
> > Because of #7113 it was tested with a simple test only
>
> Go ahead and fix this now.
OK... Igor Skornyakov

08:48 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

> Because of #7113 it was tested with a simple test only
Go ahead and fix this now. Greg Shah

02/12/2023

11:03 AM Feature #6628 (Review): port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov

11:03 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Finished with error Handler support for MariaDB.
Because of #7113 it was tested with a simple test only
Please rev... Igor Skornyakov

07:45 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov wrote:
> I've encoutered a weird problem with MariaDB that makes the error handling based on @initEr... Igor Skornyakov

07:01 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

I've encoutered a weird problem with MariaDB that makes the error handling based on @initError@/@checkError@ impossib... Igor Skornyakov

04:25 AM Bug #7113: Problem with nested CAN-FIND conversion

Consider the following statement:... Igor Skornyakov

04:18 AM Bug #7113 (Review): Problem with nested CAN-FIND conversion

Igor Skornyakov

02/11/2023

10:59 AM Feature #6928: H2 UPDATE performance improvement

Rebased 6928a_h2 rev 8 from fwd-h2.trunk rev 8 - new rev 10. Constantin Asofiei

09:38 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

I tried using the call stack you provided but it seems different from 6129c/14808. The code at @FqlToSqlConverter.jav... Ovidiu Maxiniuc

02/10/2023

10:56 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

I've experienced problem with CAN-FIND (6129c/14808).
When creating the query from the attached test I get the follo... Igor Skornyakov

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

I committed 7062a_h2/rev. 9 the changes to H2 to allow direct access.
There is a patch here on the changes required ... Alexandru Lungu

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

I've redone the tests with direct access:
* Computed columns are now marked as invisible in H2.
* Before returning ... Alexandru Lungu

05:08 AM Feature #7037: remove dirty share manager

Ovidiu: Please review. Greg Shah

02/09/2023

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

Please test how the right-padding spaces are handled. An important element in the expressions above is the @rtrim@ fu... Ovidiu Maxiniuc

10:49 AM Bug #7108 (WIP): Simulate upper/rtrim directly in H2 using case specific columns

Consider supporting case specific operators directly in H2 for character fields. For case-insensitive character field... Alexandru Lungu

10:42 AM Bug #7108 (Closed): Simulate upper/rtrim directly in H2 using case specific columns

Alexandru Lungu

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

Rebased from trunk and merged 6995a_h2 to FWD-H2 trunk: includes the addition of a NO-UNDO keyword being natively sup... Alexandru Lungu

10:53 AM Support #7058: get the FWD fork of the H2 code base under version control

*UPDATE*: regression testing passed; merged 6995a_h2 to FWD-H2 trunk including the addition of a NO-UNDO keyword bein... Alexandru Lungu

10:42 AM Feature #7062: Direct access to H2 internals to solve basic queries

Alexandru Lungu wrote:
> > In the absence of a SQL option to SELECT * EXCEPT __ifield1, __sfield2 FROM... I think we... Alexandru Lungu

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

Alexandru Lungu wrote:
> I get a NPE in com.goldencode.p2j.persist.ParameterDiff.getSubstParameters(ParameterDiff.ja... Dănuț Filimon

02/08/2023

10:56 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed

Eric Faulhaber wrote:
> Has anyone who has looked inside H2 gotten a sense of how that cache interacts with our prep... Alexandru Lungu

10:09 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed

Dănuț Filimon wrote:
> Committed 6829a_h2/rev.7. Stopped forced re-parsing for prepared statements.
>
> Each SELE... Alexandru Lungu

09:46 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

Alexandru Lungu wrote:
> Radu, please redo the FWD patch considering my first comment in #6995-16 regarding @getCrea... Radu Apetrii

03:41 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

Code review @6995-6129b.patch@ and @fwd-h2-6995.patch@:
Nice work, Radu!
I agree with Alexandru's comments in #... Eric Faulhaber

08:48 AM Support #7058: get the FWD fork of the H2 code base under version control

Alexandru Lungu wrote:
> I am planning to merge 7046_h2 to the FWD-H2 trunk after handling #7085-3 (test suite segre... Alexandru Lungu

04:00 AM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it

Ovidiu Maxiniuc wrote:
> Unless this can be configured somewhere else. Or if there is another data type for this?
... Eric Faulhaber

02/07/2023

06:44 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed

Committed 6829a_h2/rev.7. Stopped forced re-parsing for prepared statements.
Each SELECT/DELETE/UPDATE/INSERT quer... Dănuț Filimon

06:34 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

Radu, please redo the FWD patch considering my first comment in #6995-16 regarding @getCreateTemporaryTablePostfix@ o... Alexandru Lungu

06:33 AM Support #7058: get the FWD fork of the H2 code base under version control

I am planning to merge 7046_h2 to the FWD-H2 trunk after handling #7085-3 (test suite segregation). There are still s... Alexandru Lungu

02/06/2023

06:45 PM Feature #7037: remove dirty share manager

Please review the diff (for the trunk 14478) which adds the following directory configuration parameters:
# In addit... Stanislav Lomany

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

Boris Schegolev wrote:
> Currently, my best option is adding SQLs to retrieve sequence information into individual... Eric Faulhaber

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

I am working on support for sequences in @SchemaCheck@ for use in validations and I wanted to have a confirmation tha... Boris Schegolev

04:43 AM Feature #7062: Direct access to H2 internals to solve basic queries

> Actually the prefixes for the computed columns in H2 dialect are __i and __s (for i gnore casing and case- s ensiti... Alexandru Lungu

02/04/2023

07:32 PM Feature #7062: Direct access to H2 internals to solve basic queries

Eric Faulhaber wrote:
> Ultimately, we create the SQL forms of the column names. So, we can use whatever we want as ... Ovidiu Maxiniuc

02/03/2023

06:53 PM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it

Thank you. I tried it now and it worked. I was able to create a table and execute a quick select statement over a cou... Ovidiu Maxiniuc

06:17 PM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it

I'm pretty sure @citext@ existed as an extension before PostgreSQL 11. I thought it was one of the core data types af... Eric Faulhaber

05:25 PM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it

The changes are necessary only if/when we decide to switch from case-sensitive character data types to case-insensiti... Ovidiu Maxiniuc

10:51 AM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it

It seems like note 11 is suggesting some changes to encode the logic in the dialects and fix the DDL generation. Greg Shah

10:49 AM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it

It sounds like this task can be closed, then, correct? Eric Faulhaber

05:17 PM Feature #7062: Direct access to H2 internals to solve basic queries

Ultimately, we create the SQL forms of the column names. So, we can use whatever we want as an identifier, if we find... Eric Faulhaber

04:20 PM Feature #7062: Direct access to H2 internals to solve basic queries

Actually the prefixes for the computed columns in H2 dialect are @__i@ and @__s@ (for *i* gnore casing and case- *s* ... Ovidiu Maxiniuc

10:34 AM Feature #7062: Direct access to H2 internals to solve basic queries

I extended my solution to cover all unique indexes. Most of the processing is done in @FQLPreprocessor@ to identify w... Alexandru Lungu

10:50 AM Feature #6348: implement support for MariaDB

Ovidiu Maxiniuc wrote:
> Committed revision 14396 / 6129b.
The change looks good. Can we close this task? Eric Faulhaber

02/02/2023

03:47 PM Feature #7062: Direct access to H2 internals to solve basic queries

Greg Shah wrote:
> You're saying that in the 4GL these have separate @recid@ values when a temp-table is passed as a... Ovidiu Maxiniuc

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

Alexandru Lungu wrote:
> I may have misinterpreted FWD's behavior. I have seen multiple fields like "some_field" a... Eric Faulhaber

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

Greg Shah wrote:
> > I only consider tables without computed-columns (date-time, extent or case-insensitive char fie... Alexandru Lungu

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

> I only consider tables without computed-columns (date-time, extent or case-insensitive char fields)
In regard to... Greg Shah

05:51 AM Feature #7062: Direct access to H2 internals to solve basic queries

> Please also consider #6720; I don't yet know if lazy hydration should be applied to H2 embedded databases. I have t... Alexandru Lungu

03:26 PM Feature #7037: remove dirty share manager

Stanislav Lomany wrote:
> FYI I've found @uast/shared-dirty-records/p*.p@ and @uast/shared-dirty-records/leaking*.p@... Tomasz Domin

03:24 PM Feature #7037: remove dirty share manager

FYI I've found @uast/shared-dirty-records/p*.p@ and @uast/shared-dirty-records/leaking*.p@ testcases which "demonstra... Stanislav Lomany

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

Boris Schegolev wrote:
> Branch 6129b is frozen for now, so, let's take a look at what we know was not implemented b... Eric Faulhaber

08:27 AM Feature #6371: implement SAVE CACHE statement

> EXTENT support (currently, expanded mode only...
I think we only need expanded mode support. The old "denormali... Greg Shah

06:40 AM Bug #7088: Lazily initialize activeBundle inside RandomAccessQuery

I've done a slim test with ~40,000 find queries. ~13.000 of them used @ffCache@. The total time spent on activation w... Alexandru Lungu

02/01/2023

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

Branch 6129b is frozen for now, so, let's take a look at what we know was not implemented by now:
* more validatio... Boris Schegolev

04:28 PM Feature #6348: implement support for MariaDB

The update I was talking in #6348-54 was committed the next day in revision 14308 (see @MariaDbSequenceHandler.java@)... Ovidiu Maxiniuc

01:29 PM Feature #7062: Direct access to H2 internals to solve basic queries

> A copy in a separate logical or physical temp-table should have a distinct primary key (recid) value. This is the i... Greg Shah

01:26 PM Feature #7062: Direct access to H2 internals to solve basic queries

Eric Faulhaber wrote:
> Alexandru, one other thing to consider, which I suppose you've already noticed: we don't act... Eric Faulhaber

01:25 PM Feature #7062: Direct access to H2 internals to solve basic queries

Greg Shah wrote:
> > I empirically discovered that (recid) is always the primary key of our temp-tables in H2; multi... Eric Faulhaber

01:15 PM Feature #7062: Direct access to H2 internals to solve basic queries

Alexandru, one other thing to consider, which I suppose you've already noticed: we don't actually create unique indic... Eric Faulhaber

01:09 PM Feature #7062: Direct access to H2 internals to solve basic queries

> I empirically discovered that (recid) is always the primary key of our temp-tables in H2; multiplex is irrelevant. ... Greg Shah

12:54 PM Feature #7062: Direct access to H2 internals to solve basic queries

Alexandru Lungu wrote:
> I've finished implementing a simple mean of H2 direct access for @RAQ@ with simple @recid@ ... Eric Faulhaber

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

I've finished implementing a simple mean of H2 direct access for @RAQ@ with simple @recid@ look-up. The results are f... Alexandru Lungu

01:00 PM Bug #7088: Lazily initialize activeBundle inside RandomAccessQuery

This makes sense. Although the cost currently is mitigated to some degree by caching in @FQLHelper@, there is still w... Eric Faulhaber

04:23 AM Bug #7088: Lazily initialize activeBundle inside RandomAccessQuery

There is relevant activity when building an @activeBundle@ in general, mostly related to FQL composition (@createBund... Alexandru Lungu

04:09 AM Bug #7088 (New): Lazily initialize activeBundle inside RandomAccessQuery

Alexandru Lungu

10:11 AM Feature #6444: dataset improvements

Rebased task branch 6444a to the trunk rev.14483.
Suspended working on this task while the trunk and 6129b are frozen. Igor Skornyakov

09:49 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

Eric Faulhaber wrote:
> I have not yet reviewed the changes in detail, but my opinion is that removing all SQL redo ... Alexandru Lungu

09:40 AM Support #7058: get the FWD fork of the H2 code base under version control

Greg Shah wrote:
> See if you can just do some limited edits to Source Code Management to explain branching for FWD ... Alexandru Lungu

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

*Review for patch #7035-9*
There is consistent work going on with this extraction and I am pleased with this new @Pa... Alexandru Lungu

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

Eric Faulhaber wrote:
> Please add a test with such an extent field reference, and make sure it still works, both in... Dănuț Filimon

01/31/2023

05:11 PM Feature #6348: implement support for MariaDB

Ovidiu, are all the sequence features working now? Based on #6348-54 and the entries leading up to it, it seemed this... Eric Faulhaber

04:12 PM Feature #6348: implement support for MariaDB

Committed revision 14396 / 6129b. Ovidiu Maxiniuc

01:35 AM Feature #6348: implement support for MariaDB

Ovidiu Maxiniuc wrote:
> ... there are a few methods which still use @UnimplementedFeature@ to report missing featur... Eric Faulhaber

03:59 PM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it

The current implementation injects the upper/rtrim into FQLs of the queries at conversion time because it assumes at ... Ovidiu Maxiniuc

01:59 AM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it

What is left to do on the MariaDB side for:
* lenient mode?
* strict mode? Eric Faulhaber

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

I pushed revision 6129b/14395 with comment cleaning procedure and some JavaDoc that was missing. Boris Schegolev

02:13 AM Feature #6371: implement SAVE CACHE statement

Boris, please continue implementing the remaining items in #6371-119.
I've also noticed in the code that the colum... Eric Faulhaber

11:25 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

I have not yet reviewed the changes in detail, but my opinion is that removing all SQL redo code from FWD is OK as lo... Eric Faulhaber

08:59 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

> I am not necessarily sensitive with huge chunks of code being removed (less is faster), but should we keep some of ... Greg Shah

08:36 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

Eric, I added you as a watcher now. Alexandru Lungu

08:27 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

I tested 6995a_h2 with your FWD patch against a large customer application and there was no regression.
The performa... Alexandru Lungu

05:06 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

I committed to 6995a_h2, rev.7 the changes that you asked for.
Also, when running @build.sh test@, the errors were ... Radu Apetrii

03:49 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

Radu, based on our new FWD-H2 branching system #7058, I've created 6995a_h2 to hold your patch from #6995-13. However... Alexandru Lungu

09:08 AM Support #7058: get the FWD fork of the H2 code base under version control

See if you can just do some limited edits to Source Code Management to explain branching for FWD vs H2. Greg Shah

05:09 AM Support #7058: get the FWD fork of the H2 code base under version control

Greg, I've done only one documentation change to "Patching and Building Customized 3rd Party Libraries":/projects/p2j... Alexandru Lungu

08:25 AM Feature #7037: remove dirty share manager

Greg Shah wrote:
> > Cross-session use for the small set of tables (currently, only one I know of) which needs it.
... Tomasz Domin

05:38 AM Feature #7037: remove dirty share manager

> Cross-session use for the small set of tables (currently, only one I know of) which needs it.
Tomasz may have fo... Greg Shah

01:56 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > I think that error handling can be finished in 2-3 days.
>... Igor Skornyakov

01:32 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov wrote:
> I think that error handling can be finished in 2-3 days.
Please finish this when you ... Eric Faulhaber

01/30/2023

05:43 PM Feature #7037: remove dirty share manager

AFAICT, your assessment of how @DirtyShareSupport@ works currently is correct.
It seems we need to support the fol... Eric Faulhaber

03:03 PM Feature #7037: remove dirty share manager

In @DirtyShareSupport@ we effectively have @forceDirtyShare@ always enabled, and, correct me if I'm wrong, no convert... Stanislav Lomany

01:01 PM Feature #7037: remove dirty share manager

Stas, I'm sorry I did not remember this existing implementation. How does this overlap/conflict/differ with your rece... Eric Faulhaber

12:58 PM Feature #7037: remove dirty share manager

Stanislav Lomany wrote:
> As far as I understand, the following should happen when dirty sharing is disabled in the ... Eric Faulhaber

11:10 AM Feature #7037: remove dirty share manager

One more thing: what cases that should be tested to make sure then remain working after cross-session dirty sharing h... Stanislav Lomany

09:52 AM Feature #7061 (WIP): Enable the use of lazy result sets in H2

Alexandru Lungu

09:42 AM Feature #6371: implement SAVE CACHE statement

The documentation for this task is in [[p2j:Non-Standard Save Cache Implementation]]. Greg Shah

09:11 AM Support #7058: get the FWD fork of the H2 code base under version control

I'm glad the existing scripts worked. Greg Shah

08:33 AM Support #7058 (WIP): get the FWD fork of the H2 code base under version control

Added version control for our H2 fork:
* redesigned @code/p2j_repo/fwd-h2@ to honor the @active/dead/merged/trunk@ p... Alexandru Lungu

06:52 AM Support #7058: get the FWD fork of the H2 code base under version control

Greg Shah wrote:
> > Should we use the same branch naming convention (task number + ascending letters) as we use in ... Alexandru Lungu

07:03 AM Bug #6829 (WIP): H2 forces re-parse of all prepared statements when metadata is changed

Danut, please strictly refer to #6829-1 for the moment: consider the H2 performance of reparsing prepared statements ... Alexandru Lungu

03:17 AM Feature #6444: dataset improvements

Marian Edu wrote:
> Igor Skornyakov wrote:
> > Marian,
> > The description of the @SYNCHRONIZE@ method semantics i... Igor Skornyakov

03:12 AM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> Marian,
> The description of the @SYNCHRONIZE@ method semantics in the OE documentation lo... Marian Edu

01/28/2023

03:54 AM Feature #6444: dataset improvements

Marian,
The description of the @SYNCHRONIZE@ method semantics in the OE documentation looks not very clear for me.
... Igor Skornyakov

03:35 AM Feature #6444: dataset improvements

> > And generally, please place the @{@ on a new line (FWD coding standard). I forgot to add this in my previous revi... Igor Skornyakov

02:56 AM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> I looked in the log of FWD repository and, indeed it shows I added some implementation for ... Igor Skornyakov

08:22 PM Feature #6444: dataset improvements

I looked in the log of FWD repository and, indeed it shows I added some implementation for @synchronize@ method (and ... Ovidiu Maxiniuc

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

Rev 6129b/14392 fixes issues with setting initial values in the DMO interface. It also pulls in a newer MariaDB JDBC ... Eric Faulhaber

01/27/2023

12:08 PM Feature #6444: dataset improvements

Retrofitted Ovidio's changes for the @DynamicQueryHelper@ from 6129b to 6444a.
This resolves #6444-115. Reworked @Bu... Igor Skornyakov

09:57 AM Feature #6444: dataset improvements

Indeed, #6444-115 does not manifest itself in 6129b.
However, there are a lot of differences between this branch and... Igor Skornyakov

07:30 AM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> I did a quick review of your commits up to 14485/6444a since 14480:
> AbstractQuery, Compo... Igor Skornyakov

02:24 AM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > I've encountered a strange problem. Consider the following prog... Igor Skornyakov

10:44 AM Feature #6371: implement SAVE CACHE statement

I added same filtering for columns and indexes, it should save some CPU time. Also, MariaDB returns @boolean@ as @bit... Boris Schegolev

10:17 AM Feature #6371: implement SAVE CACHE statement

Filtering is resolved - see revision 6129b/14389. It also removes the TODO I had there. Boris Schegolev

07:21 AM Feature #6371: implement SAVE CACHE statement

Boris Schegolev wrote:
> I pushed 2 commits into 6129b - 14385 and 14386. Now our save-cache test programs operate o... Eric Faulhaber

09:16 AM Feature #7064: Analyze the performance impact of the implicit meta schema in H2

> org.h2.engine.Database.meta only stores information from non-temporary sessions, which we do not use
Although we... Greg Shah

08:34 AM Feature #7064 (WIP): Analyze the performance impact of the implicit meta schema in H2

Alexandru Lungu wrote:
> * H2 generates an implicit @INFORMATION_SCHEMA@ schema on database creation. This schema co... Radu Apetrii

07:58 AM Feature #7062 (WIP): Direct access to H2 internals to solve basic queries

I've done some consistent implementation for the @FIND tt WHERE recid(tt) = 2@ use-case. However, I am facing some li... Alexandru Lungu

10:58 PM Feature #6348: implement support for MariaDB

Indeed, there were several updates to the dialects. But there are some unfinished features:
* what I know for sure i... Ovidiu Maxiniuc

01/26/2023

06:20 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> I've encountered a strange problem. Consider the following program:
> [...]
> It works fi... Ovidiu Maxiniuc

01:45 PM Feature #6444: dataset improvements

Finished support for the @SYNCHRONIZE@ method, albeit not in a very efficient way (see #6444-115, #6444-116).
Comm... Igor Skornyakov

11:53 AM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> What is the right way to retrieve the value of the primary key from the @BufferImpl@ instan... Igor Skornyakov

10:02 AM Feature #6444: dataset improvements

What is the right way to retrieve the value of the primary key from the @BufferImpl@ instance.
Thank you. Igor Skornyakov

07:23 AM Feature #6444: dataset improvements

The @HQLPrepocessor.getFindByRowid@ method looks strange
# It checks only the first parameter. In my test the @rowid... Igor Skornyakov

05:40 AM Feature #6444: dataset improvements

I've found a workarount for #6444-115, but at the cost of more complicated (and expensive) query:... Igor Skornyakov

04:35 AM Feature #6444: dataset improvements

I've encountered a strange problem.
Consider the following program:... Igor Skornyakov

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

I pushed 2 commits into 6129b - 14385 and 14386. Now our save-cache test programs operate on PostgreSQL and MariaDB e... Boris Schegolev

06:28 AM Feature #6371: implement SAVE CACHE statement

I've manually ported the SAVE CACHE feature from trunk rev 14483 to 6129b and committed that as 6129b/14383. I have d... Eric Faulhaber

03:53 AM Feature #6371: implement SAVE CACHE statement

Boris, we were discussing the @datetime-tz@ implementation yesterday, but there is still a TODO in the code for the I... Eric Faulhaber

03:48 AM Feature #6371: implement SAVE CACHE statement

I committed 6371a/14458, which:
* implements thread safety to prevent concurrent schema checking and DMO generatio... Eric Faulhaber

02:09 PM Feature #7037: remove dirty share manager

As far as I understand, the following should happen when dirty sharing is disabled in the directory:
# Dirty databa... Stanislav Lomany

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

Dănuț Filimon wrote:
> What is the purpose of @inlineSubstitutionParameter@? The modifications I made for extracting... Alexandru Lungu

08:21 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

I've included in H2 a flag for temporary tables that shows whether or not a table is defined with @no-undo@. The main... Radu Apetrii

04:12 AM Feature #7076: make CAN-FIND avoid hydration

I found Ovidiu's comment in #5453-2 relevant for this task. Alexandru Lungu

01/25/2023

05:17 PM Feature #7076: make CAN-FIND avoid hydration

Let's go for the quick win. Greg Shah

04:43 PM Feature #7076: make CAN-FIND avoid hydration

It does, if we implement it as a sub-select (i.e., when it is a nested CAN-FIND in another query's WHERE clause).
... Eric Faulhaber

02:59 PM Feature #7076: make CAN-FIND avoid hydration

I assume we already do this, but just in case, does CAN-FIND avoid hydration? Greg Shah

02:58 PM Feature #7076 (Closed): make CAN-FIND avoid hydration

Greg Shah

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

Implemented validation "except for the implicit primary key index, the primary key may only appear at the end of a no... Boris Schegolev

02:28 PM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries

> > For example, the @lvalue@ rule will be doing constant lookups of a wide range of possible matches while the actua... Greg Shah

02:10 PM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries

In regard to writing things to disk for persistence between server runs, we could write the generated DMOs (bytecode)... Greg Shah

01:47 PM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries

Greg Shah wrote:
> I suspect there is still some significant improvement that can be made to the performance. The c... Ovidiu Maxiniuc

01:37 PM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries

Greg Shah wrote:
> I have another idea, which I think should be a "game changer". Let's write out the generated cla... Ovidiu Maxiniuc

10:25 AM Feature #6928: H2 UPDATE performance improvement

I added a patch that fixes the problem that I found earlier (and another one that I found while testing). Long story ... Radu Apetrii

05:36 AM Feature #6928: H2 UPDATE performance improvement

Radu, please debug this and fix it. Constantin Asofiei

05:34 AM Feature #6928: H2 UPDATE performance improvement

While working on another task, I stumbled upon an issue. With fwd-h2 rev.7 it worked fine, *but in rev.8 there seems ... Radu Apetrii

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

Eric Faulhaber wrote:
> Alexandru Lungu wrote:
>
> > Adopting this idea means replacing @ProgressiveResults@ with... Alexandru Lungu

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

Alexandru Lungu wrote:
> Adopting this idea means replacing @ProgressiveResults@ with @ScrollingResults@ backed by... Eric Faulhaber

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

Dănuț Filimon wrote:
> Are there any cases where @NUM_LITERAL, DEC_LITERAL, STRING@ should not be substituted?
... Eric Faulhaber

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

I wrote an implementation for that makes use of the @FQLPreprocessor.mainWalk@ method to parse the where clause AST a... Dănuț Filimon

05:38 AM Feature #7063: Support FIRST/LAST join directly in H2

Eric Faulhaber wrote:
> When converting FIND/FIRST LAST, whether as a joined query component (i.e., @RandomAccessQue... Alexandru Lungu

01/24/2023

05:32 PM Feature #7063: Support FIRST/LAST join directly in H2

Alexandru Lungu wrote:
> An alternative to this technique would be to introduce a @FIRST JOIN@ or @LAST JOIN@ into... Eric Faulhaber

11:10 AM Feature #6444: dataset improvements

Eric Faulhaber wrote:
> Igor, have you ported the changes needed from 6129b into 6444a? Where do you feel we now sta... Igor Skornyakov

10:53 AM Feature #6444: dataset improvements

Igor, have you ported the changes needed from 6129b into 6444a? Where do you feel we now stand on % Done for this iss... Eric Faulhaber

10:49 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> Igor, is this task finished, other than implementing your idea for error handling? How much ... Igor Skornyakov

10:44 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor, is this task finished, other than implementing your idea for error handling? How much effort do you think it is... Eric Faulhaber

10:40 AM Feature #6348: implement support for MariaDB

Ovidiu, as of 3821c/14182, we have this issue marked as 60% done. Many changes have been made since then, including l... Eric Faulhaber

06:17 AM Feature #7064: Analyze the performance impact of the implicit meta schema in H2

Alexandru Lungu wrote:
> Now that I am reading #7064-1 again, it needs some rephrasing indeed.
> I am mostly referr... Igor Skornyakov

05:48 AM Feature #7064: Analyze the performance impact of the implicit meta schema in H2

Igor Skornyakov wrote:
> Sorry, I do not understand what you mean. As far as I remember the META database contains i... Alexandru Lungu

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

You can simply check @prg.h2.result.SortOrder.sort@. This holds the @ORDER BY@ clause and is triggered only when H2 n... Alexandru Lungu

02:31 AM Feature #7066: Implement multi-table indexed query in H2

Alexandru, what H2 methods are responsible for this re-sorting of the rows? I want to check in the profiler. Constantin Asofiei

05:16 AM Feature #7062: Direct access to H2 internals to solve basic queries

Greg Shah wrote:
> This is really interesting. For temp-tables (and using H2 for a permanent database), it is conce... Alexandru Lungu

07:42 PM Feature #7020: always use "expanded" extent fields

Thank you Constantin for the link to wiki. I was able to identify the cause of the NPE. When retrieving meta informat... Ovidiu Maxiniuc

01/23/2023

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

I pushed a fix for the issue with removing columns. Also fixed another minor thing. See revision 14456. Boris Schegolev

04:50 PM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed

Alexandru Lungu wrote:
> Constantin Asofiei wrote:
> > Alexandru, I've uncommited 6129b rev 14378. The changes in t... Eric Faulhaber

04:38 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed

I created #7060 to target exactly the issue of wildcard usage, as a performance/memory management standalone improvem... Alexandru Lungu

04:14 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed

Eric Faulhaber wrote:
> Alexandru Lungu wrote:
>
> > Committed 6129b/rev. 14378. This includes no alias columns f... Alexandru Lungu

03:17 PM Support #7058: get the FWD fork of the H2 code base under version control

> Should we use the same branch naming convention (task number + ascending letters) as we use in FWD? It probably mak... Greg Shah

03:11 PM Feature #7064: Analyze the performance impact of the implicit meta schema in H2

Sorry, I do not understand what you mean. As far as I remember the META database contains information about permanent... Igor Skornyakov

07:22 AM Feature #7064: Analyze the performance impact of the implicit meta schema in H2

There is a so called @INFORMATION_SCHEMA@ in H2 which is implicitly built: once for a shared temp-database and multip... Alexandru Lungu

07:02 AM Feature #7064 (Rejected): Analyze the performance impact of the implicit meta schema in H2

Alexandru Lungu

02:52 PM Feature #7062: Direct access to H2 internals to solve basic queries

This is really interesting. For temp-tables (and using H2 for a permanent database), it is conceptually close to the... Greg Shah

06:23 AM Feature #7062: Direct access to H2 internals to solve basic queries

I've done slim experiments with the H2 internals to understand how easy/fast is to interface directly with H2. I have... Alexandru Lungu

05:38 AM Feature #7062 (Closed): Direct access to H2 internals to solve basic queries

Alexandru Lungu

12:33 PM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries

I have another idea, which I think should be a "game changer". Let's write out the generated classes (and any critic... Greg Shah

12:28 PM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries

I suspect there is still some significant improvement that can be made to the performance. The core parsing might be... Greg Shah

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

As far as I could investigate H2, it seems like multi-table queries are severely lacking indexed traversal of joined ... Alexandru Lungu

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

Alexandru Lungu

06:47 AM Feature #7063: Support FIRST/LAST join directly in H2

I recall spending some time in #6196 to identify a clean and short way to encode the 4GL FIRST/LAST semantics using S... Alexandru Lungu

06:24 AM Feature #7063 (New): Support FIRST/LAST join directly in H2

Alexandru Lungu

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

*Prerequisites*
FWD converts most of the index-sorted single-table @FOR@ queries into @AdaptiveQuery@. With the effo... Alexandru Lungu

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

Alexandru Lungu

04:50 AM Feature #7060: Consider using wildcard selection to reduce SQL size

Please note that this change may require extensive testing and changes in some non-obvious places.
For example in m... Igor Skornyakov

04:35 AM Feature #7060: Consider using wildcard selection to reduce SQL size

There is initial work in #6829 on introducing wildcard selection (using @*@ symbol). This can reduce the size of an S... Alexandru Lungu

04:17 AM Feature #7060 (Closed): Consider using wildcard selection to reduce SQL size

Alexandru Lungu

02:53 AM Feature #6816: improve PreselectQuery.assembleHQL

Alexandru Lungu wrote:
> Looks good, no concerns.
Done. Committed to 6129b, rev. 14379. Radu Apetrii