FWD » Core Development » Database

09/26/2022

08:05 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Nice catch!
The fix from #6628-153 should be enough. When HQL/FQL are parsed, the LPARENS of the functions are drop... Ovidiu Maxiniuc

09/24/2022

05:30 AM Feature #6582: implement multi-table AdaptiveQuery

|_\13. Iterate all records with NEXT |
|_\2. Test |_\2. 4GL temporary ... Alexandru Lungu

09/23/2022

02:24 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

That if end of the switch is... Igor Skornyakov

02:07 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> You need the data type of an argument to a UDF, where the argument itself is a UDF, correct?... Igor Skornyakov

01:47 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

You need the data type of an argument to a UDF, where the argument itself is a UDF, correct?
Two questions:
* L... Eric Faulhaber

01:24 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> Wouldn't
>
> [...]
>
> be more reliable?
@case FUNCTION@ already exists. Igor Skornyakov

01:03 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Wouldn't... Eric Faulhaber

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

Igor Skornyakov wrote:
> I've temporary restored rev. 13138 changes to @where_clause_pre_prep.rules@ to run compatib... Igor Skornyakov

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

I've temporary restored rev. 13138 changes to @where_clause_pre_prep.rules@ to run compatibility tests with nullable ... Igor Skornyakov

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

I implemented class unloading through delegates as was suggested in TODO in @AsmClassLoader@.
The code is in 6371a... Boris Schegolev

09:48 AM Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id

I made a set of tests for multiplex and no-multiplex using indexes.
The tests have the following specifications:
... Dănuț Filimon

09/22/2022

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

Eric Faulhaber wrote:
> the @ClassLoader@ itself had to be garbage collected
That is correct. We can re-instantia... Boris Schegolev

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

Boris Schegolev wrote:
> Class unloading is done (unless I missed something). Unloading the class from JVM itself is... Eric Faulhaber

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

Class unloading is done (unless I missed something). Unloading the class from JVM itself is only done by the Garbage ... Boris Schegolev

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

Here is the list of matching by name methods:... Vladimir Tsichevski

10:16 AM Bug #6767: Possible name clashes in DMO classes

Eric Faulhaber wrote:
> To clarify the task, we need to work through all superinterfaces of the @persist.Buffer@ int... Vladimir Tsichevski

10:11 AM Feature #6582: implement multi-table AdaptiveQuery

I've done the same tests for persistent tables and updated #6582-30.
For persistent tables, multi-table @AdaptiveQue... Alexandru Lungu

09/21/2022

02:01 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Fixed trimming UDFs string arguments for MariaDB.
Committed to 6191a/14412.
All compatibility tests except ones h... Igor Skornyakov

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

Greg Shah wrote:
> Isn't this just a consequence of the (currently) broken compatibility of using varchar as a datat... Igor Skornyakov

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

Isn't this just a consequence of the (currently) broken compatibility of using varchar as a datatype for MariaDB? Greg Shah

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

I've experienced the #4551-310 again (the compatibility test for @lengthof@ fails because of the argument trimming).... Igor Skornyakov

12:11 PM Feature #6457: finish COPY-LOB support

Stanislav Lomany wrote:
> Do you have any idea what and how 4GL produces?
Try launching the 4GL using @-cpinternal ... Ovidiu Maxiniuc

01:45 AM Feature #6457: finish COPY-LOB support

Stanislav, looking at the @14844588@ value, in hex is e282ac. See this: https://community.progress.com/s/article/P18... Constantin Asofiei

11:10 AM Feature #6582: implement multi-table AdaptiveQuery

I've prepared a consistent set of tests, but it seems only some are actually finished in a reasonable time.
|_\2. ... Alexandru Lungu

04:25 AM Feature #6582: implement multi-table AdaptiveQuery

I am close to an end with #6582-27. Only some use cases are left to clear off. Note that I updated #6582-27 to reflec... Alexandru Lungu

09/20/2022

07:24 PM Feature #6457 (WIP): finish COPY-LOB support

Guys, I don't quite understand how 4GL produces output. Consider the following UTF-16 output example:... Stanislav Lomany

04:21 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Greg Shah wrote:
> It would be best to avoid such code in our testcases. If you really need something platform spec... Igor Skornyakov

03:56 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

It would be best to avoid such code in our testcases. If you really need something platform specific, then have a ve... Greg Shah

03:30 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ovidiu Maxiniuc wrote:
> Set the OS of the sources in @cfg/p2j.cfg.xml@:
> [...]or[...]
Thank you, Ovidiu.
It h... Igor Skornyakov

03:25 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Set the OS of the sources in @cfg/p2j.cfg.xml@:... Ovidiu Maxiniuc

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

Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > A string literal @'a1b123*\{}()1'@ is converted to @new charact... Igor Skornyakov

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

Igor Skornyakov wrote:
> A string literal @'a1b123*\{}()1'@ is converted to @new character("a1b123*{}()1")@. What I'... Ovidiu Maxiniuc

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

The compatibility test for @matches@ fails for a strange reason.
A string literal @'a1b123*\{}()1'@ is converted to ... Igor Skornyakov

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

I got rid of TODOs in the code and followed some of suggestions above (naming). The new code now only has a TODO for ... Boris Schegolev

11:29 AM Feature #6582: implement multi-table AdaptiveQuery

What can you see in terms of the impact of this refactoring on performance so far, if anything? Eric Faulhaber

09/19/2022

06:43 PM Bug #6767: Possible name clashes in DMO classes

To clarify the task, we need to work through all superinterfaces of the @persist.Buffer@ interface, along with all th... Eric Faulhaber

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

In DMO classes, getter and setter names are created automatically by conversion, based on the field names which are a... Vladimir Tsichevski

08:12 AM Bug #6767 (Review): Possible name clashes in DMO classes

Vladimir Tsichevski

03:15 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Fixed injection of session attributes' values into UDF calls for MariaDB.
Committed to 6129a/14407. Igor Skornyakov

03:09 PM Bug #6703: loading schema table DMO interface with no defined fields

Ovidiu Maxiniuc wrote:
> Constantin, I reviewed it and your fix in 6129a/14273 seems logical.
>
> I also added tw... Eric Faulhaber

09/18/2022

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

More about collation.
At this moment @import.db@ creates MariaDB database with @DEFAULT CHARACTER SET utf8mb4 DEFAUL... Igor Skornyakov

09/17/2022

09:04 AM Bug #6766 (WIP): before-table options not inherited from the after-table (like NO-UNDO, SHARED, etc)

At least the NO-UNDO options needs to be inherited by the before-table, if is set at the after-table.
The other of... Constantin Asofiei

09:02 AM Bug #6766 (WIP): before-table options not inherited from the after-table (like NO-UNDO, SHARED, etc)

Constantin Asofiei

05:22 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > Adding @indexof(text, text, boolean)@ and @lookup(text, text, b... Igor Skornyakov

09:40 PM Feature #6348: implement support for MariaDB

I have committed r14399/6129a. It contains improved compatibility for sorting NULL high for MariaDb.
Note that, Mari... Ovidiu Maxiniuc

09/16/2022

05:30 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov wrote:
> Adding @indexof(text, text, boolean)@ and @lookup(text, text, boolean)@ to @Functions@ fixe... Ovidiu Maxiniuc

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

Igor Skornyakov wrote:
> It looks that we have problems with conversion of case-sensitive fields for MariaDB. We nee... Igor Skornyakov

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

It looks that we have problems with conversion of case-sensitive fields for MariaDB. We need to specify case-sensitiv... Igor Skornyakov

05:15 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov wrote:
> Igor Skornyakov wrote:
> > There is a problem with creation of @SQLWarning@ with MariaDB. ... Igor Skornyakov

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

Igor Skornyakov wrote:
> There is a problem with creation of @SQLWarning@ with MariaDB. Unlike PostgreSQL @RAISE NOT... Igor Skornyakov

09:48 AM Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id

Alexandru Lungu wrote:
> Please consider several "abstract" testcases (eventually with etime) which can show clear t... Dănuț Filimon

08:36 AM Feature #6418: represent extent fields as arrays

The above is my opinion. Eric makes the final decision here. Greg Shah

08:36 AM Feature #6418: represent extent fields as arrays

Some things to note:
* Customers hate normalized mode. We should simplify the runtime and get rid of it since the... Greg Shah

05:16 AM Feature #6418: represent extent fields as arrays

A few updates:
* I've tested the correctness of results regarding denormalized extent fields. Out of 108 tests that ... Radu Apetrii

05:12 AM Feature #6695 (WIP): Multi-table preselect query may underperform due to repetitive fetching

Alexandru Lungu

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

Boris Schegolev wrote:
> In the latest version (6371a/14102) I removed dependency on @DynamicTablesHelper@ completel... Eric Faulhaber

09/15/2022

05:21 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

I see two problems which I've already seen with native PostgreSQL UDFs:
# We have to use @eq@, @ne@, @le@, ... UDFs... Igor Skornyakov

05:23 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov wrote:
> what is *not* registered are @indexOf@ and @lookup@ for signatures @[TEXT, TEXT, BOOLEAN]@ ... Igor Skornyakov

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

I consistently see the following log entries at the end of my UDFs' compatibility test:... Igor Skornyakov

04:21 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ovidiu Maxiniuc wrote:
> I do not understand. There is nothing particular to those functions. I did a quick test and... Igor Skornyakov

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

Igor Skornyakov wrote:
> I will take a closer look tomorrow.
Using a debugger with a breakpoint in the @FqlToSq... Igor Skornyakov

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

If (better said 'when') we will be able to cache the DMO generated classes we will surely have a boost for the startu... Ovidiu Maxiniuc

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

In the latest version (6371a/14102) I removed dependency on @DynamicTablesHelper@ completely. The code compiles, but ... Boris Schegolev

01:24 PM Bug #6699 (WIP): TemporaryBuffer$Multiplexer memory leak in global block

There is still a leak in the @TransactionManager$WorkArea.globalBlock.finalizables@. Constantin Asofiei

07:54 AM Feature #6763 (Rejected): implement configurable sizes (in the directory) for FastFindCache and O...

Greg Shah

09/14/2022

03:33 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ovidiu Maxiniuc wrote:
> I do not understand. There is nothing particular to those functions. I did a quick test and... Igor Skornyakov

03:29 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

I do not understand. There is nothing particular to those functions. I did a quick test and the functions are correct... Ovidiu Maxiniuc

02:35 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

In the converted queries there are no 'signature suffix' for @indexOf@ and @lookup@.
Ovidiu, I undestand that the ... Igor Skornyakov

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

There is a problem with creation of @SQLWarning@ with MariaDB. Unlike PostgreSQL @RAISE NOTICE@, @SIGNAL SQLSTATE '01... Igor Skornyakov

11:29 AM Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id

Please consider several "abstract" testcases (eventually with @etime@) which can show clear time differences in diffe... Alexandru Lungu

11:12 AM Feature #6582: implement multi-table AdaptiveQuery

I committed 6582a/rev. 14164 including all the latest changes done to increase stability of the multi-table @Adaptive... Alexandru Lungu

09/13/2022

07:27 PM Feature #6457: finish COPY-LOB support

> The BOM handling has a testcase already written. See @testcases/copy_lob/tests/bom.p@.
OK, the first issue I me... Stanislav Lomany

07:04 AM Feature #6457: finish COPY-LOB support

The BOM handling has a testcase already written. See @testcases/copy_lob/tests/bom.p@. Greg Shah

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

Ovidiu Maxiniuc wrote:
> Eric Faulhaber wrote:
> > What I am not sure about is from where we gather the legacy info... Eric Faulhaber

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

Eric Faulhaber wrote:
> What I am not sure about is from where we gather the legacy information (i.e., the informati... Ovidiu Maxiniuc

01:38 AM Feature #6371: implement SAVE CACHE statement

Boris Schegolev wrote:
> I updated @DatabaseManager@ to handle registration of the new interface.
I didn't really... Eric Faulhaber

01:16 PM Feature #6582: implement multi-table AdaptiveQuery

The non-scrolling query examples that were working on 3821c are now working properly on 6582a as well. Note that I mo... Alexandru Lungu

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

Eric Faulhaber wrote:
> Any issues coming out of testing? Any headway on the error handling solution? Thanks.
Not... Igor Skornyakov

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

Any issues coming out of testing? Any headway on the error handling solution? Thanks. Eric Faulhaber

10:16 AM Feature #6453 (WIP): temp-table features

Eric Faulhaber

09/12/2022

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

I updated @DatabaseManager@ to handle registration of the new interface. I am still working on removal of the last ca... Boris Schegolev

12:27 PM Support #6679: H2 general performance tuning

Is the H2 storage engine API implemented in a clean manner or is the storage engine implemented as pieces of code spr... Greg Shah

08:39 AM Support #6679: H2 general performance tuning

> I wonder if there is any case in which a physical 4GL user can have multiple transactions to one single temporary t... Greg Shah

08:35 AM Support #6679: H2 general performance tuning

Greg Shah wrote:
> Clearly, we cannot move ahead with the new version of H2. At least we cannot without something th... Alexandru Lungu

05:44 AM Support #6679: H2 general performance tuning

Clearly, we cannot move ahead with the new version of H2. At least we cannot without something that changes the perf... Greg Shah

05:24 AM Support #6679: H2 general performance tuning

Eric Faulhaber wrote:
> I don't know how the tests were performed for the bottom table, which actually is the more ... Dănuț Filimon

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

I've found the following tool which can be useful - https://www.linuxbabe.com/ubuntu/mysql-mariadb-database-performan... Igor Skornyakov

06:11 AM Feature #6348: implement support for MariaDB

Igor Skornyakov wrote:
> It looks that we need to use @timestamp(3)@/@datetime(3)@ instead of @timestamp@/@datetime@... Ovidiu Maxiniuc

05:07 AM Feature #6453: temp-table features

6129a Greg Shah

04:53 AM Feature #6453: temp-table features

Ovidiu,
Which branch should I use for this task?
Thank you. Igor Skornyakov

09/09/2022

12:13 PM Bug #6744: rollback when there are catch/finally blocks opening their own transactions

I'm seeing an abend with a customer app where a savepoint is no longer valid (when trying to rollback-/commit-). I'v... Constantin Asofiei

12:08 PM Bug #6744 (New): rollback when there are catch/finally blocks opening their own transactions

Constantin Asofiei

12:08 PM Feature #6453: temp-table features

Ovidiu Maxiniuc wrote:
> Igor, I think @PRIMARY@ has already been implemented in branch 6129a. I think that is your ... Igor Skornyakov

12:06 PM Feature #6453: temp-table features

Igor, I think @PRIMARY@ has already been implemented in branch 6129a. I think that is your target. Anyway that branch... Ovidiu Maxiniuc

12:30 AM Feature #6453: temp-table features

Igor, please see #6453-3 and ask Ovidiu any questions you have. Eric Faulhaber

12:05 PM Bug #6699 (Review): TemporaryBuffer$Multiplexer memory leak in global block

The fix for this is in #6641-34, 6129a rev 14388. Constantin Asofiei

10:19 AM Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block

Eric Faulhaber wrote:
> Constantin Asofiei wrote:
> > I think I have a better fix for this leak; in @TemporaryBuffe... Constantin Asofiei

10:19 AM Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block

Constantin Asofiei wrote:
> I think I have a better fix for this leak; in @TemporaryBuffer.initialize@ do this:
> [... Eric Faulhaber

05:49 AM Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block

I think I have a better fix for this leak; in @TemporaryBuffer.initialize@ do this:... Constantin Asofiei

10:17 AM Feature #6582: implement multi-table AdaptiveQuery

I started using the tests from @uast/adaptive_scrolling@ to test the changes for multi-table @AdaptiveQuery@. Almost ... Alexandru Lungu

06:05 AM Feature #6418: represent extent fields as arrays

Small update on this topic: I ran the tests from the previous post, but with a small change regarding the tables. Ins... Radu Apetrii

04:51 AM Feature #6348: implement support for MariaDB

It looks that we need to use @timestamp(3)@/@datetime(3)@ instead of @timestamp@/@datetime@ in the tables' DDL for Ma... Igor Skornyakov

01:43 AM Bug #6741: Word index support for MariaDB.

Implement word index support for MariaDB using word tables Igor Skornyakov

01:41 AM Bug #6741 (New): Word index support for MariaDB.

Igor Skornyakov

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

Eric Faulhaber wrote:
> Is there any value in implementing a @CONTAINS@ UDF? As I recall, we can't fully support the... Igor Skornyakov

12:46 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov wrote:
> Finished port of PostgreSQL UDFs (except ones related to error handling and word tables) to... Eric Faulhaber

12:23 AM Feature #6507: cross-database joins

Greg Shah wrote:
> Is there a reason to implement this for a specific database backend?
Yes. Some databases (e.g.... Eric Faulhaber

11:01 PM Support #6679: H2 general performance tuning

Dănuț Filimon wrote:
> Alexandru Lungu wrote:
> > retest the Hotel GUI examples from #6679-21. Check if we have reg... Eric Faulhaber

09/08/2022

07:24 PM Bug #6703 (WIP): loading schema table DMO interface with no defined fields

Constantin, I reviewed it and your fix in 6129a/14273 seems logical.
I also added two changes in 6129a/14387:
* @... Ovidiu Maxiniuc

09/07/2022

04:16 PM Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id

Eric Faulhaber wrote:
> I thought this naming convention was just for the DMO interfaces. When did we start using th... Ovidiu Maxiniuc

03:52 PM Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id

Ovidiu Maxiniuc wrote:
> We are already forced to use a naming schema for temp-tables as @<converted-original-name... Eric Faulhaber

01:52 PM Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id

The investigation should take into account that, beside the expected direct SQL internal benefits, should also includ... Ovidiu Maxiniuc

02:58 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Finished port of PostgreSQL UDFs (except ones related to error handling and word tables) to MariaDB.
Committed to 61... Igor Skornyakov

09:43 AM Feature #6418: represent extent fields as arrays

I've done some more testing, this time regarding the SQLs for three different approaches of storing an extent field a... Radu Apetrii

09:25 AM Support #6679: H2 general performance tuning

Alexandru Lungu wrote:
> retest the Hotel GUI examples from #6679-21. Check if we have regressions with prepared sta... Dănuț Filimon

02:09 AM Support #6679: H2 general performance tuning

Eric Faulhaber wrote:
> Is this something which is fixed with the patched v214?
No, this is related to the FWD ... Dănuț Filimon

09/06/2022

02:34 PM Support #6679: H2 general performance tuning

I'm trying to use H2 v214 to see if it still shows a memory leak I see when running a converted application with v200... Eric Faulhaber

10:15 AM Support #6679: H2 general performance tuning

Some things to note for your testing:
* We do not use persistent tables with H2 for customer applications. All use... Eric Faulhaber

09:56 AM Support #6679: H2 general performance tuning

Alexandru Lungu wrote:
> retest 2.1.210 (and eventually 2.1.212 and 2.1.214) with one-by-one strategy. Check if we s... Dănuț Filimon

11:26 AM Feature #6582: implement multi-table AdaptiveQuery

Alexandru Lungu wrote:
in my mind, the "dynamic mode" is still initially represented by the CompundQuery b... Alexandru Lungu

11:24 AM Feature #6695: Multi-table preselect query may underperform due to repetitive fetching

- removed the comment -
It was meant to be posted in #6582 Alexandru Lungu

09/05/2022

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

It is not ideal to use @DynamicTablesHelper@ (in its current form) to create persistent table DMO interfaces/classes.... Eric Faulhaber

03:47 PM Support #6679: H2 general performance tuning

Alexandru Lungu wrote:
> [...]
Thank you for the explanation.
> I will update Performance_Testing_the_H2_Datab... Eric Faulhaber

12:12 PM Support #6679: H2 general performance tuning

The tests from our current Performance_Testing_the_H2_Database are decent for 1.4.200, but are no quite accurate for ... Alexandru Lungu

10:31 AM Support #6679: H2 general performance tuning

Dănuț Filimon wrote:
> Eric Faulhaber wrote:
> > Dănuț Filimon wrote:
> > > Committed fwd-h2/rev.9. I applied a fe... Eric Faulhaber

09:46 AM Support #6679: H2 general performance tuning

Eric Faulhaber wrote:
> Dănuț Filimon wrote:
> > Committed fwd-h2/rev.9. I applied a few changes from versions 2.1.... Dănuț Filimon

02:22 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ported the following UDF: ... Igor Skornyakov

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

I was thinking about error handling support ('guarded' UDFs) for MariaDB.
It looks that it can be implemented using ... Igor Skornyakov

04:28 AM Feature #6418: represent extent fields as arrays

> The question I would like to ask is: Is there any reason why normalized is preferred over denormalized, since the l... Greg Shah

02:58 AM Feature #6418: represent extent fields as arrays

I have tested these two methods of representing extent fields (normalized and denormalized) over a series of tests an... Radu Apetrii

01:57 AM Feature #2137: runtime support for FIELDS/EXCEPT record phrase options

I was in a session the other day which was offered at the PUG Challenge 2022. This was presented by Gus, who designe... Greg Shah

09/02/2022

02:14 PM Feature #6720: lazy hydration

If we are to lazily hydrate records, any column data which was not loaded in the initial hydration pass will have to ... Eric Faulhaber

01:03 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ported the following UDFs: ... Igor Skornyakov

04:06 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ported the following UDFs: ... Igor Skornyakov

10:26 AM Support #6679: H2 general performance tuning

Dănuț Filimon wrote:
> Eric Faulhaber wrote:
> > Have you discovered any cases where H2 v2.1.210patched was slower ... Eric Faulhaber

09:46 AM Support #6679: H2 general performance tuning

Eric Faulhaber wrote:
> Have you discovered any cases where H2 v2.1.210patched was slower than v1.4.200patched (Page... Dănuț Filimon

09:07 AM Feature #6418 (WIP): represent extent fields as arrays

Alexandru Lungu

09:06 AM Support #6713 (WIP): check if it is faster to use separate temp-table instances instead of multip...

Alexandru Lungu

02:47 AM Feature #6729: improve database and temp-table toString to write all records without relying on w...

This is in my opinion a very important problem that needs to be fixed asap. Enabling the DataSet.fullDebugString allo... Stefan Brands

09/01/2022

03:59 PM Support #6679: H2 general performance tuning

Thank you for all the research and testing. In all the work so far...
* Have you discovered any cases where H2 v2.... Eric Faulhaber

08/31/2022

02:50 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ported the following UDFs: ... Igor Skornyakov

09:33 AM Feature #6729: improve database and temp-table toString to write all records without relying on w...

We need to allow the dataset or temp-table 'toString' representation (like in a debugger) to show all records in all ... Constantin Asofiei

09:30 AM Feature #6729 (New): improve database and temp-table toString to write all records without relyin...

Constantin Asofiei

08/30/2022

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

I pushed the latest version (see revision 6371a/14100). I tried to use existing DynamicTablesHelper implementation in... Boris Schegolev

02:01 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Constantin Asofiei wrote:
> Import always requires @ant deploy.prepare@, as it needs the application's jar. Did you... Roger Borrello

01:49 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Import always requires @ant deploy.prepare@, as it needs the application's jar. Did you have this in our @deploy/lib... Constantin Asofiei

01:48 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

The issue was that I had been trying to link p2j to the @convert@ deployment and *not* run @ant deploy.prepare@, whic... Roger Borrello

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

Eric Faulhaber wrote:
> Igor Skornyakov wrote:
> > Igor Skornyakov wrote:
> > > This revision should be OK. Let m... Igor Skornyakov

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

Igor Skornyakov wrote:
> Igor Skornyakov wrote:
> > This revision should be OK. Let me test the imports with my ve... Eric Faulhaber

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

Igor Skornyakov wrote:
> This revision should be OK. Let me test the imports with my version of MariaDB.
Eric. W... Igor Skornyakov

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

Eric Faulhaber wrote:
> I was using 3821c/14206. The latest revision is 14207, but I do not see a newer version of @... Igor Skornyakov

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

Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > Igor, is MariaDB 10.8 the minimum version on which the UDFs are ... Eric Faulhaber

04:21 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> Igor, is MariaDB 10.8 the minimum version on which the UDFs are supported? I've been trying ... Igor Skornyakov

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

Igor, is MariaDB 10.8 the minimum version on which the UDFs are supported? I've been trying to get Hotel GUI going wi... Eric Faulhaber

07:16 AM Support #6679: H2 general performance tuning

Eric Faulhaber wrote:
> The statements under test ultimately were the same for 200patched and 210patched, correct?
... Dănuț Filimon

06:12 AM Support #6679: H2 general performance tuning

Committed fwd-h2/rev.7 containing version 2.1.210 without any patches from version 1.4.200.
Committed fwd-h2/rev.8... Dănuț Filimon

08/29/2022

12:56 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Greg Shah wrote:
> > Could that be where the issue is? Should the jar include these in the cvt directory?
>
> Yes... Roger Borrello

09:48 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

> Could that be where the issue is? Should the jar include these in the cvt directory?
Yes and probably yes. You ... Greg Shah

09:41 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Using a conversion with 3821c_14194, my @ant import@ for a customer application is receiving this in the import log:
... Roger Borrello

07:21 AM Feature #6720: lazy hydration

In query processing, it is my understanding that a substantial percentage of time is spent in hydration of returned r... Greg Shah

06:39 AM Feature #6720 (WIP): lazy hydration

Greg Shah

07:03 AM Feature #6721: calculate field lists at conversion time where possible

There are use cases of buffers in which it is not possible to statically calculate the exact fields used at runtime (... Greg Shah

06:54 AM Feature #6721 (New): calculate field lists at conversion time where possible

Greg Shah

06:21 AM Support #6679: H2 general performance tuning

After running some tests regarding the performances of 4GL, SQL and P2J, I have generated a table that is meant to de... Radu Apetrii

05:40 AM Feature #6695: Multi-table preselect query may underperform due to repetitive fetching

I added 3821c/rev. 14206 including a new MBean for query profiling: @QueryProfiler@. It stores a map from an SQL prep... Alexandru Lungu

04:53 AM Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block

Constantin Asofiei wrote:
> Actually, the previous patch is incorrect. I think this code in @TemporaryBuffer.define... Eric Faulhaber

08/28/2022

04:30 AM Feature #6695: Multi-table preselect query may underperform due to repetitive fetching

Greg Shah wrote:
> Actually, it looks like the documentation already exists in [[p2j:Profiling#JMX-MBean-Instrumenta... Igor Skornyakov

08/27/2022

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

Added @rindexof_<suffix>@, @rtrimws_<suffix>@, and @lc_t@ UDFs corresponding to @R-INDEX@, @RIGHT-TRIM@ and @LC@ 4GL ... Igor Skornyakov

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

Implemented @substitute_tf@ UDF (see #6628-102).
Committed to 3821c/14202. Igor Skornyakov

05:19 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov wrote:
> I think that we can implement a @substitute@ for MariaDB as a two-argument UDF with JSON ... Igor Skornyakov

05:15 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

> I think that we can implement a @substitute@ for MariaDB as a two-argument UDF with JSON array as a second argument... Igor Skornyakov

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

Eric Faulhaber wrote:
> @substitute@ could be used as a UDF, but it is not in this initial application. Again, this ... Igor Skornyakov