Project

General

Profile

Activity

From 08/26/2022 to 09/24/2022

09/24/2022

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

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

09/23/2022

03:17 PM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> I think the way to go is to create a FWD client in-process from the JUnit @TestEngine@ code:
>...
Vladimir Tsichevski
08:55 AM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> There is no patch posted for the hints changes.
Strangely enough :-(
Vladimir Tsichevski
08:28 AM Conversion Tools Feature #6237: OEUnit support
There is no patch posted for the hints changes. Greg Shah
05:57 AM Conversion Tools Feature #6237: OEUnit support
Vladimir Tsichevski wrote:
> Greg Shah wrote:
>
> > For now, just implement the multilevel configuration approach...
Vladimir Tsichevski
02:24 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
That if end of the switch is... Igor Skornyakov
02:07 PM Database 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 Database 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 Database 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 Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
Wouldn't... Eric Faulhaber
12:58 PM Database 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 Database 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 Database 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
10:12 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
The latest update is attached. All projects look OK.
To fix the @p2j.oo@ code, I've analyzed it using a crude spo...
Constantin Asofiei
09:48 AM Database 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 Database 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 Database 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 Database 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 Database Bug #6767: Possible name clashes in DMO classes
Here is the list of matching by name methods:... Vladimir Tsichevski
10:16 AM Database 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 Database 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 Database 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 Database 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 Database 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 Database 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:25 PM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> For now, just implement the multilevel configuration approach. If it gets to the point where w...
Vladimir Tsichevski
12:24 PM Conversion Tools Feature #6237: OEUnit support
I've created a custom JUnit5 testing engine (see @junit5-custom-engine.zip@).
This is the first version, kind of P...
Vladimir Tsichevski
12:11 PM Conversion Tools Feature #6237: OEUnit support
> If we can define this configuration parameter at any level, using also file and directory hints, then we do not nee... Greg Shah
11:55 AM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> I think we need to know on a per-file level which unit testing framework is used. This is not ha...
Vladimir Tsichevski
11:28 AM Conversion Tools Feature #6237: OEUnit support
I think we need to know on a per-file level which unit testing framework is used. This is not hard to do. As noted ... Greg Shah
11:15 AM Conversion Tools Feature #6237: OEUnit support
Marian Edu wrote:
> Vladimir Tsichevski wrote:
> > So, you propose to pre-scan *all* classes in conversion project ...
Vladimir Tsichevski
08:59 AM Conversion Tools Feature #6237: OEUnit support
Vladimir Tsichevski wrote:
> So, you propose to pre-scan *all* classes in conversion project to find any @assertXXX@...
Marian Edu
08:44 AM Conversion Tools Feature #6237: OEUnit support
> you propose to pre-scan all classes in conversion project to find any assertXXX statement
This is pretty easy. ...
Greg Shah
08:19 AM Conversion Tools Feature #6237: OEUnit support
Marian Edu wrote:
> Vladimir Tsichevski wrote:
>
> > So, since neither of these methods is reliable
>
> I real...
Vladimir Tsichevski
08:09 AM Conversion Tools Feature #6237: OEUnit support
> adding implementation for OEUnit Assert in FWD would be the easier path.
We will provide the OEUnit Assert supp...
Greg Shah
07:21 AM Conversion Tools Feature #6237: OEUnit support
Vladimir Tsichevski wrote:
> So, since neither of these methods is reliable
I really fail to see the issue here...
Marian Edu
12:11 PM Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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:30 AM Base Language Feature #6772: increase usage of ASSIGN bracketing
Please see #6740 - we had an attempt to lock/unlock the frame for the duration of the widget ASSIGN, but this posed p... Constantin Asofiei
09:33 AM Base Language Feature #6772: increase usage of ASSIGN bracketing
In #6726, we found that a @CREATE <widget> ASSIGN ...@ was being handled with decreased performance because we are no... Greg Shah
09:30 AM Base Language Feature #6772 (New): increase usage of ASSIGN bracketing
Greg Shah
11:29 AM Database 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
07:35 AM Conversion Tools Feature #6237: OEUnit support
> emit a warning and ignore the unit test annotations.
This one.
Greg Shah
05:54 AM Conversion Tools Feature #6237: OEUnit support
Marian Edu wrote:
> Vladimir Tsichevski wrote:
>
> > I think, our goal is to have neither original @OEUnit@ nor @...
Vladimir Tsichevski
02:56 AM Conversion Tools Feature #6237: OEUnit support
Vladimir Tsichevski wrote:
> I think, our goal is to have neither original @OEUnit@ nor @ABLUnit@ in the @PROPATH@...
Marian Edu

09/19/2022

06:43 PM Database 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 Database 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 Database Bug #6767 (Review): Possible name clashes in DMO classes
Vladimir Tsichevski
03:15 PM Database 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 Database 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
02:52 PM Conversion Tools Bug #6768 (Rejected): End of comment "butted" against double-quote fails to parse
It is already fixed in the latest version of FWD. Greg Shah
01:44 PM Conversion Tools Bug #6768: End of comment "butted" against double-quote fails to parse
I updated @uast/comment_test0.p@ to include some additional tests:... Roger Borrello
12:27 PM Conversion Tools Bug #6768: End of comment "butted" against double-quote fails to parse
If this isn't an issue in FWD v4, then we can close this. Greg Shah
11:17 AM Conversion Tools Bug #6768: End of comment "butted" against double-quote fails to parse
It was reported that this yields a conversion error (with an older version of FWD):... Roger Borrello
10:28 AM Conversion Tools Bug #6768 (Rejected): End of comment "butted" against double-quote fails to parse
Roger Borrello
02:22 PM Conversion Tools Feature #6237: OEUnit support
Marian Edu wrote:
> Greg Shah wrote:
> > Define a global parameter (in @cfg/p2j.cfg.xml@) for @OEUnit@ vs @ABLUnit@...
Vladimir Tsichevski
01:36 PM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> Define a global parameter (in @cfg/p2j.cfg.xml@) for @OEUnit@ vs @ABLUnit@. Then add an override...
Marian Edu
11:35 AM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> The code is going to be very specific to converted 4GL code so it should be @com.goldencode.p2j.t...
Vladimir Tsichevski
09:26 AM Conversion Tools Feature #6237: OEUnit support
The code is going to be very specific to converted 4GL code so it should be @com.goldencode.p2j.testengine@. Greg Shah
09:20 AM Conversion Tools Feature #6237: OEUnit support
I am implementing a specialized JUnit5 test engine for FWD. The code works, and now I need some permanent Java packag... Vladimir Tsichevski

09/18/2022

05:32 AM Database 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 Database 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 Database Bug #6766 (WIP): before-table options not inherited from the after-table (like NO-UNDO, SHARED, etc)
Constantin Asofiei
05:22 AM Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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
01:59 PM Conversion Tools Feature #6237: OEUnit support
> How global parameters in @cfg/p2j.cfg.xml@ do relate to uast hints?
They are read from @UastHints@ as the defau...
Greg Shah
01:16 PM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> Define a global parameter (in @cfg/p2j.cfg.xml@) for @OEUnit@ vs @ABLUnit@. Then add an override...
Vladimir Tsichevski
11:58 AM Conversion Tools Feature #6237: OEUnit support
Define a global parameter (in @cfg/p2j.cfg.xml@) for @OEUnit@ vs @ABLUnit@. Then add an override in the @UastHints@ ... Greg Shah
11:49 AM Conversion Tools Feature #6237: OEUnit support
We have some difficulty if we are going to implement both @OEUnit@ and @ABLUnit@.
There is a difference in the usa...
Vladimir Tsichevski
09:14 AM Conversion Tools Feature #6237: OEUnit support
Marian Edu wrote:
> this is the only OEUnit I'm aware of - [[https://github.com/CameronWills/OEUnit]]
Yes, I m...
Vladimir Tsichevski
01:55 AM Conversion Tools Feature #6237: OEUnit support
Vladimir Tsichevski wrote:
> So we need to answer the following questions:
>
> # Whether or not and how class-l...
Marian Edu
09:48 AM Database 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 Database Feature #6418: represent extent fields as arrays
The above is my opinion. Eric makes the final decision here. Greg Shah
08:36 AM Database 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 Database 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 Database Feature #6695 (WIP): Multi-table preselect query may underperform due to repetitive fetching
Alexandru Lungu
02:26 AM Database 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 Database 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 Database 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 Database 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 Database 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 Database 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
05:06 PM Conversion Tools Feature #6237: OEUnit support
> # Whether or not and how class-level annotations (@@BeforeClass@, @@AfterClass@) are used in 4gl procedures?
Ass...
Greg Shah
04:41 PM Conversion Tools Feature #6237: OEUnit support
The latest problem reveals that we need to convert 4gl procedure annotation either.
So we need to answer the follo...
Vladimir Tsichevski
04:55 PM Database 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 Database 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 Database Bug #6699 (WIP): TemporaryBuffer$Multiplexer memory leak in global block
There is still a leak in the @TransactionManager$WorkArea.globalBlock.finalizables@. Constantin Asofiei
08:17 AM User Interface Feature #6764: Improve trigger selection for keyboard events.
For keyboard events there is a specific order on which 4GL is looking for the right trigger to fire:
- key label
- ...
Marian Edu
08:15 AM User Interface Feature #6764 (Review): Improve trigger selection for keyboard events.
Marian Edu
07:54 AM Database Feature #6763 (Rejected): implement configurable sizes (in the directory) for FastFindCache and O...
Greg Shah

09/14/2022

03:33 PM Database 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 Database 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 Database 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 Database 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
12:26 PM Conversion Tools Feature #6237: OEUnit support
To add JUnit support to converted projects, the following patch has to be applied to @build.gradle@:... Vladimir Tsichevski
11:29 AM Database 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 Database 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
07:02 AM Base Language Feature #6754: complete BOM support for XmlHelper.readXMLEncoding()
The "BOM":https://en.wikipedia.org/wiki/Byte_order_mark is bypassed in @XmlHelper.readXMLEncoding()@ but not yet hono... Greg Shah
07:00 AM Base Language Feature #6754 (New): complete BOM support for XmlHelper.readXMLEncoding()
Greg Shah

09/13/2022

07:27 PM Database 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 Database Feature #6457: finish COPY-LOB support
The BOM handling has a testcase already written. See @testcases/copy_lob/tests/bom.p@. Greg Shah
02:22 PM Conversion Tools Feature #6237: OEUnit support
Constantin Asofiei wrote:
> The code previously meant to allow @@LegacyService@ annotation in the 4GL code. Now i...
Vladimir Tsichevski
01:43 PM Conversion Tools Feature #6237: OEUnit support
Vladimir Tsichevski wrote:
> Constantin Asofiei wrote:
> > legacy_services.rules is built to allow @LegacyService@ ...
Constantin Asofiei
01:40 PM Conversion Tools Feature #6237: OEUnit support
Constantin Asofiei wrote:
> legacy_services.rules is built to allow @LegacyService@ annotations written directly in ...
Vladimir Tsichevski
01:16 PM Conversion Tools Feature #6237: OEUnit support
legacy_services.rules is built to allow @LegacyService@ annotations written directly in FWD code - these must be kept... Constantin Asofiei
12:59 PM Conversion Tools Feature #6237: OEUnit support
Constantin Asofiei wrote:
> Regarding 3821c/14239:
> * please format @annotations/unit_test_support.rules@ by inden...
Vladimir Tsichevski
06:10 AM Conversion Tools Feature #6237: OEUnit support
Regarding 3821c/14239:
* please format @annotations/unit_test_support.rules@ by indenting the nested @rules@ tags - ...
Constantin Asofiei
01:49 PM Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database Feature #6453 (WIP): temp-table features
Eric Faulhaber

09/12/2022

05:42 PM Conversion Tools Feature #6237: OEUnit support
Conversion of 4gl annotations to JUnit5 Java annotations implemented in 3821c rev. 14239. Vladimir Tsichevski
04:05 PM Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database Feature #6453: temp-table features
6129a Greg Shah
04:53 AM Database Feature #6453: temp-table features
Ovidiu,
Which branch should I use for this task?
Thank you.
Igor Skornyakov

09/10/2022

04:24 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
I've reviewed @ca_upd_20220909a_3821c_14233.zip@ update (the persistence portions, mostly).
I think overall this l...
Eric Faulhaber

09/09/2022

12:38 PM Base Language Bug #6743: fix GET-SIGNATURE for all parameter modes and types
6129a/14390 fixes TABLE-HANDLE, DATASET, DATASET-HANDLE parameters reported by GET-SIGNATURE.
Other part which I d...
Constantin Asofiei
11:39 AM Base Language Bug #6743: fix GET-SIGNATURE for all parameter modes and types
FWD doesn't report properly the signature; we need to check and fix this for all parameter types, extent, DATASET,DAT... Constantin Asofiei
11:38 AM Base Language Bug #6743 (New): fix GET-SIGNATURE for all parameter modes and types
Constantin Asofiei
12:13 PM Database 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 Database Bug #6744 (New): rollback when there are catch/finally blocks opening their own transactions
Constantin Asofiei
12:08 PM Database 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 Database 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 Database Feature #6453: temp-table features
Igor, please see #6453-3 and ask Ovidiu any questions you have. Eric Faulhaber
12:05 PM Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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
02:11 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
Eric, I'm attaching the changes directly, please apply them over 3821c/14233 and review the p2j.persist part. Thanks. Constantin Asofiei
01:43 AM Database Bug #6741: Word index support for MariaDB.
Implement word index support for MariaDB using word tables Igor Skornyakov
01:41 AM Database Bug #6741 (New): Word index support for MariaDB.
Igor Skornyakov
01:40 AM Database 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 Database 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 Database 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 Database 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 Database 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
12:58 PM User Interface Bug #6740: re-enable FRAME_LOCK in annotations/embedded_attribute_assign_rewrite and determine wh...
In #6726, it was measured ~10k calls of @LT.flushEnqueuedWidgetAttrs@. Some of these calls are part of a @CREATE <wi... Constantin Asofiei
12:55 PM User Interface Bug #6740 (New): re-enable FRAME_LOCK in annotations/embedded_attribute_assign_rewrite and determ...
Constantin Asofiei
10:13 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
Eric Faulhaber wrote:
> Code Review scopeable_6650_patch_20220901a.patch:
>
> I did not find a revised patch with...
Eric Faulhaber
10:38 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
Code Review scopeable_6650_patch_20220901a.patch:
I did not find a revised patch with the #6650-14 changes after G...
Eric Faulhaber
03:37 AM Conversion Tools Feature #6237: OEUnit support
I always use the @String@ methods directly (@equals()@ or @equalsIgnoreCase()@). Even if we did implement string con... Greg Shah

09/07/2022

04:16 PM Database 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 Database 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 Database 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 Database 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
02:02 PM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> In TRPL, are we mapping @annoName == "Before"@ to @String.equalsIgnoreCase()@?
I did not know th...
Vladimir Tsichevski
01:40 PM Conversion Tools Feature #6237: OEUnit support
Vladimir Tsichevski wrote:
> Greg Shah wrote:
>
> >
> > Does this make sense?
>
> If I get it right, then:
...
Greg Shah
01:39 PM Conversion Tools Feature #6237: OEUnit support
In TRPL, are we mapping @annoName == "Before"@ to @String.equalsIgnoreCase()@? If not then shouldn't we do that expl... Greg Shah
01:38 PM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
>
> Does this make sense?
If I get it right, then:
# We can execute on the server side an...
Vladimir Tsichevski
12:52 PM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> > The question is in which module this javaName is assigned? It would be better to calculate the ...
Vladimir Tsichevski
12:48 PM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> Please rename both @oeunit.rules@ files to @unit_test_support.rules@. Remember that we are imple...
Vladimir Tsichevski
12:35 PM Conversion Tools Feature #6237: OEUnit support
Vladimir: Please post questions or comments here. As a next step, I'd like to see the proposed design of the @Remote... Greg Shah
12:29 PM Conversion Tools Feature #6237: OEUnit support
Please rename both @oeunit.rules@ files to @unit_test_support.rules@. Remember that we are implementing support for ... Greg Shah
12:27 PM Conversion Tools Feature #6237: OEUnit support
Vladimir Tsichevski wrote:
> I suppose, the Java method, produced by conversion of a 4gl class, must be called in so...
Greg Shah
11:56 AM Conversion Tools Feature #6237: OEUnit support
> The question is in which module this javaName is assigned? It would be better to calculate the correct value for th... Greg Shah
01:25 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
> Greg: I haven't yet decoupled TransactionManager from the direct references to BufferManager/LogicalTerminal, I'll ... Greg Shah
09:43 AM Database 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:37 AM Conversion Tools Bug #6738: incremental conversion when deleting program or class files
Allow incremental conversion to detect program or class files which have been deleted, and cleanup after it (includin... Constantin Asofiei
09:36 AM Conversion Tools Bug #6738 (Closed): incremental conversion when deleting program or class files
Constantin Asofiei
09:25 AM Database 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 Database 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 Database 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 Database 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 Database 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
02:25 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
The latest patch is attached, built on top of 3821c/14225. I need to finish testing with other apps, there is an iss... Constantin Asofiei
08:53 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
There is an inherent feature of @ScopedDictionary@, where 'global' scope is used: this is not something created by th... Constantin Asofiei
11:55 AM Conversion Tools Feature #6237: OEUnit support
I suppose, the Java method, produced by conversion of a 4gl class, must be called in some special way? Vladimir Tsichevski
11:35 AM Conversion Tools Feature #6237: OEUnit support
Now that I have all Junit5 annotations in place, I have another problem when I try to run the @SimpleTest@ class as J... Vladimir Tsichevski
11:26 AM Database 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 Database 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

06:27 PM Conversion Tools Feature #6237: OEUnit support
I've added support for JUnit 5 annotations generation from OEUnit annotations.
3 things changed:
# Code which d...
Vladimir Tsichevski
02:25 PM Conversion Tools Feature #6237: OEUnit support
The question is in which module this @javaName@ is assigned? It would be better to calculate the correct value for th... Vladimir Tsichevski
02:22 PM Conversion Tools Feature #6237: OEUnit support
Greg Shah wrote:
> > What am I doing wrong here? I know setting text works on the copy:
>
> The problem is subtle...
Vladimir Tsichevski
02:28 AM Conversion Tools Feature #6237: OEUnit support
> The first will be called from "annotations.xml", and do Java annotations preparation, the second will be called fro... Greg Shah
02:27 AM Conversion Tools Feature #6237: OEUnit support
> What am I doing wrong here? I know setting text works on the copy:
The problem is subtle. The @setText()@ you a...
Greg Shah
04:21 PM Database 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 Database 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 Database 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 Database 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 Database 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 Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
Ported the following UDF: ... Igor Skornyakov
03:55 AM Database 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 Database 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 Database 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
04:22 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
I think you can go ahead and check in your first pass changes from #6650-14. Or did you plan to check it in with the... Greg Shah
01:57 AM Database 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/03/2022

05:17 PM Conversion Tools Feature #6237: OEUnit support
Eric Faulhaber wrote:
> I think you are conflating the annotations phase of conversion (when @annotations.xml@ and a...
Vladimir Tsichevski
03:52 PM Conversion Tools Feature #6237: OEUnit support
I think you are conflating the annotations phase of conversion (when @annotations.xml@ and all its related rule-sets ... Eric Faulhaber
06:33 AM Conversion Tools Feature #6237: OEUnit support
Help needed.
I have to insert Java *import statements*. I gathered, I can use the @ConverterHelper.createImport()@...
Vladimir Tsichevski

09/02/2022

03:24 PM Conversion Tools Feature #6237: OEUnit support
I wrote an additional rule-set which replaces OEUnit 4gl annotation names to corresponding JUnit 5 names.
The prob...
Vladimir Tsichevski
02:14 PM Database 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 Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
Ported the following UDFs: ... Igor Skornyakov
04:06 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
Ported the following UDFs: ... Igor Skornyakov
12:14 PM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning"
I suppose that's how we got to this point. It's difficult if you don't keep the dependencies as light as possible as ... Roger Borrello
11:31 AM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning"
Roger Borrello wrote:
> Hynek Cihlar wrote:
> > Roger, you will have to add the required dependencies, previously i...
Hynek Cihlar
11:28 AM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning"
Hynek Cihlar wrote:
> Roger, you will have to add the required dependencies, previously included by Janus graph, man...
Roger Borrello
11:21 AM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning"
Roger, you will have to add the required dependencies, previously included by Janus graph, manually back to the Serve... Hynek Cihlar
11:11 AM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning"
I ran 2 builds of 3821c, the difference between them was build A had @janusgraph-core 0.1.0@ as part of both the Conv... Roger Borrello
10:47 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
> LT will still exist, but TC will be on the server-side. If we remove LT, this would mean frames are no longer being... Greg Shah
07:37 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
Greg Shah wrote:
> Code Review scopeable_6650_patch_20220901a.patch
>
> Overall, I think the changes are quite go...
Constantin Asofiei
06:39 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
Eric Faulhaber wrote:
> > Something I forgot to mention - there are some methods in BufferManager which are never ca...
Constantin Asofiei
06:27 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
Code Review scopeable_6650_patch_20220901a.patch
Overall, I think the changes are quite good.
My concern is m...
Greg Shah
06:22 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
Constantin Asofiei wrote:
> Eric: if you can give me some hints at extracting BufferManager's tx scope support, I ca...
Eric Faulhaber
10:26 AM Database 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 Database 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 Database Feature #6418 (WIP): represent extent fields as arrays
Alexandru Lungu
09:06 AM Database Support #6713 (WIP): check if it is faster to use separate temp-table instances instead of multip...
Alexandru Lungu
04:20 AM Base Language Feature #1970: improve ControlFlowOps method resolution by reflection
This makes sense. Greg Shah
02:47 AM Database 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 Database 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
11:48 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
Eric: if you can give me some hints at extracting BufferManager's tx scope support, I can give it a try. To me, it l... Constantin Asofiei
09:37 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
You can apply the patch using:... Constantin Asofiei
09:37 AM Base Language Feature #6650 (WIP): improve performance of Scopeable notification in TM.processScopeNotifications
The changes are attach. Greg/Eric: please review and let me know if you see something dangerous.
The patch is on ...
Constantin Asofiei
11:01 AM Base Language Feature #1970: improve ControlFlowOps method resolution by reflection
Greg Shah wrote:
> The tricky part is that at the call site, we would have some configuration/data that is dynamic o...
Constantin Asofiei
09:27 AM Runtime Infrastructure Support #5567: move FWD to Java 11
> But I think we should do an upgrade of all libraries to current/latest releases.
I agree with the idea that we w...
Greg Shah
07:21 AM Runtime Infrastructure Support #5567: move FWD to Java 11
Greg Shah wrote:
>
> Otherwise, if we need more analysis, please suggest the next steps.
I have another idea - ta...
Tomasz Domin

08/31/2022

02:50 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
Ported the following UDFs: ... Igor Skornyakov
09:33 AM Database 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 Database Feature #6729 (New): improve database and temp-table toString to write all records without relyin...
Constantin Asofiei
08:51 PM Runtime Infrastructure Support #5567: move FWD to Java 11
To be more clear, the customer has not done any further testing or analysis and they are not planning to do so. Your... Greg Shah

08/30/2022

07:51 PM Runtime Infrastructure Feature #5776: reduce memory requirements for the FWD client
Will this change the results of our testing in #6560? Greg Shah
07:51 PM Runtime Infrastructure Feature #5776: reduce memory requirements for the FWD client
Tomasz: Go ahead and merge the 5776-3.diff changes. Greg Shah
03:33 PM Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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

02:53 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
I can not find a good way to limit BufferManager/ChangeBroker. I have changes which sync them (so they are always no... Constantin Asofiei
12:56 PM Database 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 Database 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 Database 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
08:28 AM Runtime Infrastructure Support #5567: move FWD to Java 11
Tomasz Domin wrote:
> Greg Shah wrote:
> > OK, so far this looks like it is consistent with the customer's early fi...
Greg Shah
08:21 AM Runtime Infrastructure Support #5567: move FWD to Java 11
Greg Shah wrote:
> OK, so far this looks like it is consistent with the customer's early findings (i.e. Java 8 is 10...
Tomasz Domin
06:32 AM Runtime Infrastructure Support #5567: move FWD to Java 11
Rebased to 3821c/14205, pushed 5567a/14223
Tomasz Domin
07:21 AM Database 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 Database Feature #6720 (WIP): lazy hydration
Greg Shah
07:03 AM Database 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 Database Feature #6721 (New): calculate field lists at conversion time where possible
Greg Shah
06:21 AM Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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 Database 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
09:41 PM Database Bug #6275 (Review): SKIP-DELETED-RECORD implementation
Stanislav Lomany
09:41 PM Database Bug #6275 (WIP): SKIP-DELETED-RECORD implementation
Stanislav Lomany
09:40 PM Database Bug #6275: SKIP-DELETED-RECORD implementation
> A single question: calls to @stopOnSkippedRecord@ occur on @first@, @next@, and @previous@ navigation. Shouldn't th... Stanislav Lomany

08/26/2022

03:06 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
Ported the following UDFs: ... Igor Skornyakov
12:55 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
Eric Faulhaber wrote:
> For the initial application (at least based on static code analysis), only @r-index@ and @ri...
Igor Skornyakov
10:53 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
For the initial application (at least based on static code analysis), only @r-index@ and @right-trim@ are used in con... Eric Faulhaber
04:01 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
Eric Faulhaber wrote:
> The following is a list of 4GL builtin functions used within WHERE clauses, based on their p...
Igor Skornyakov
12:12 PM Database Feature #6371: implement SAVE CACHE statement
Yes, something like that, but please note I've already stubbed out @DatabaseManager.schemaChanged@ in 6371a/14098. Pl... Eric Faulhaber
12:02 PM Database Feature #6371: implement SAVE CACHE statement
So, the integration part should be something like that, right?... Boris Schegolev
03:17 AM Database Feature #6371: implement SAVE CACHE statement
6371a/14098 contains a first pass implementation of conversion support for SAVE CACHE. The statement converts to a st... Eric Faulhaber
10:56 AM Database Bug #6715: BufferManager.validate throws IllegalStateException if a validation fails via a Valida...
Converting a legacy error into an abend seems like something easily avoided. Greg Shah
03:47 AM Database Bug #6715: BufferManager.validate throws IllegalStateException if a validation fails via a Valida...
If validation fails in @BufferManager.validate@, this abends:... Constantin Asofiei
03:45 AM Database Bug #6715 (New): BufferManager.validate throws IllegalStateException if a validation fails via a ...
Constantin Asofiei
04:08 AM Database Bug #6703: loading schema table DMO interface with no defined fields
A fix for the DMO interface loading (for runtime and DB import) is in 6129a/14273.
This does not solve all issues,...
Constantin Asofiei
 

Also available in: Atom