Activity

From 08/06/2022 to 09/04/2022

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

08/25/2022

06:03 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> This list comes from an application which we must support fully on MariaDB in September. P... Igor Skornyakov
05:59 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > So, porting these final 10 gets us to parity with the other dial... Eric Faulhaber
05:41 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> Does this mean 306 of 316 Maria UDFs are implemented now? As I understand it, the 316 total ... Igor Skornyakov
05:26 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> Ported the following UDFs:
> [...]
>
> Committed to 3821c/14199.
>
> The following ... Eric Faulhaber
04:08 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ported the following UDFs: ... Igor Skornyakov
01:06 PM Database Bug #6688 (Closed): ASSIGN trigger conversion when field has DECIMALS clause: Constantin Asofiei wrote:
> Ovidiu Maxiniuc wrote:
> > With 3821c your testcases correctly converts to
> > [...]
... Constantin Asofiei
12:30 PM Database Support #6714: check if there is an optimization opportunity when copying temp-tables based on mu...: It seems to me that when processing certain temp-table copying use cases, there may be an opportunity for optimizatio... Greg Shah
12:24 PM Database Support #6714 (Review): check if there is an optimization opportunity when copying temp-tables ba...: Greg Shah
12:18 PM Database Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id: It seems like for tables with very large numbers of records might be slow when using a multiplex approach as opposed ... Greg Shah
12:17 PM Database Support #6713 (WIP): check if it is faster to use separate temp-table instances instead of multip...: Greg Shah
12:15 PM Database Support #6712: check generated dynamic temp-table caching to ensure that all cache keys work when...: Greg Shah wrote:
> Recently, Eric found a flaw in our cache key implementation which resulted in the cache entry not... Eric Faulhaber
12:12 PM Database Support #6712: check generated dynamic temp-table caching to ensure that all cache keys work when...: Recently, Eric found a flaw in our cache key implementation which resulted in the cache entry not being properly foun... Greg Shah
12:09 PM Database Support #6712 (New): check generated dynamic temp-table caching to ensure that all cache keys wor...: Greg Shah
11:58 AM Database Feature #6711: skip schema AST creation and go directly to .p2o in dynamic temp-table generation: With relatively minor changes to the conversion, we could skip schema AST creation and go directly to .p2o in dynamic... Greg Shah
11:57 AM Database Feature #6711 (New): skip schema AST creation and go directly to .p2o in dynamic temp-table gener...: Greg Shah
11:56 AM Database Feature #6710: persist dynamic temp-tables across server restarts: A customer (thank you Stefan!) suggested that we could cache the generated DMOs etc... for dynamic temp-tables such t... Greg Shah
11:55 AM Database Feature #6710 (New): persist dynamic temp-tables across server restarts: Greg Shah
11:54 AM Database Support #6709: track nested FIND inside a related FOR loop: We have the perception that we have a problem with nested FINDs that reference a buffer or buffers controlled by a co... Greg Shah
11:49 AM Database Support #6709 (Review): track nested FIND inside a related FOR loop: Greg Shah
11:47 AM Database Support #6708: track/report at runtime when AdaptiveQuery shifts into dynamic mode: It seems that we may shift into dynamic mode in @AdaptiveQuery@ more frequently than one might expect. I would have ... Greg Shah
11:42 AM Database Support #6708 (Review): track/report at runtime when AdaptiveQuery shifts into dynamic mode: Greg Shah
11:37 AM Database Support #6707: evaluate the effectiveness of the current approach to ProgressiveResults: Currently @ProgressiveResults@ always starts with a set size of 1. This was done because the following idiom was see... Greg Shah
11:30 AM Database Support #6707 (New): evaluate the effectiveness of the current approach to ProgressiveResults: Greg Shah
11:33 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block: Actually, the previous patch is incorrect. I think this code in @TemporaryBuffer.define@ at line 1668 (branch 6129a)... Constantin Asofiei
10:26 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block: The fix is this:... Constantin Asofiei
09:25 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block: The recreate is this:... Constantin Asofiei
11:19 AM Conversion Tools Bug #6706: preserve existing camel-case usage in program names: We have a customer that deliberately uses camel-case in their program names (especially in OO classes). The current ... Greg Shah
11:17 AM Conversion Tools Bug #6706 (New): preserve existing camel-case usage in program names: Greg Shah
10:05 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: I had forgotten too. It was Alexandru's note in #6695-11 that reminded me. ;) Greg Shah
09:36 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-Instrumen... Igor Skornyakov
09:28 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: Igor Skornyakov wrote:
> Greg Shah wrote:
> > Yes, no problem.
>
> Greg,
> It looks that I need some time to re... Greg Shah
07:45 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: Greg Shah wrote:
> Yes, no problem.
Greg,
It looks that I need some time to recall the details. Maybe I will pre... Igor Skornyakov
05:34 AM Database Bug #6703: loading schema table DMO interface with no defined fields: If the .df has a table with no fields defined, import or loading this DMO interface fails with this:... Constantin Asofiei
05:33 AM Database Bug #6703 (WIP): loading schema table DMO interface with no defined fields: Constantin Asofiei
03:49 AM Database Feature #6582: implement multi-table AdaptiveQuery: I attached here the query conversion tests I used for reference. These are procedures which have structures involving... Alexandru Lungu
03:13 AM Runtime Infrastructure Support #5567: move FWD to Java 11: I am done with performance comparison between Java 8 and Java 11 in real-life like test scenarios.
I've managed to g... Tomasz Domin

08/24/2022

05:39 PM Runtime Infrastructure Feature #6364: implement an option to use Tomcat instead of Jetty as the embedded webserver/servl...: The customer that requested this feature is mentioned that they depend upon a peculiar behavior of Tomcat. Tomcat lo... Greg Shah
05:19 PM Database Feature #6700: refactor prodataset conversion to generate a separate/common class which can be re...: Similar to how we convert temp-tables, the idea is to refactor the code to have datasets convert as a separate class ... Greg Shah
05:11 PM Database Feature #6700 (New): refactor prodataset conversion to generate a separate/common class which can...: Greg Shah
04:56 PM Conversion Tools Feature #6237: OEUnit support: Constantin Asofiei wrote:
> Vladimir, the OE annotations (any kind) are processed in @annotations/legacy_services.ru... Vladimir Tsichevski
01:31 PM Conversion Tools Feature #6237: OEUnit support: Vladimir, the OE annotations (any kind) are processed in @annotations/legacy_services.rules@. At the time, I did not... Constantin Asofiei
01:21 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> Vladimir Tsichevski wrote:
> > OEUnit uses 4gl annotations to mark methods. I do not see these a... Vladimir Tsichevski
01:11 PM Conversion Tools Feature #6237: OEUnit support: Vladimir Tsichevski wrote:
> OEUnit uses 4gl annotations to mark methods. I do not see these annotations in AST file... Greg Shah
12:40 PM Conversion Tools Feature #6237: OEUnit support: Tomasz Domin wrote:
> Vladimir Tsichevski wrote:
> > Greg Shah wrote:
> > > We took a short cut, which is why it s... Vladimir Tsichevski
11:11 AM Conversion Tools Feature #6237: OEUnit support: Vladimir Tsichevski wrote:
> Greg Shah wrote:
> > We took a short cut, which is why it smells. Yes, there is techn... Tomasz Domin
11:03 AM Conversion Tools Feature #6237: OEUnit support: OEUnit uses 4gl annotations to mark methods. I do not see these annotations in AST files. It seems, these annotation ... Vladimir Tsichevski
06:05 AM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> We took a short cut, which is why it smells. Yes, there is technical debt.
>
> Can you use th... Vladimir Tsichevski
03:04 AM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> Tomasz: Please see #6237-30 for a possible regression from the recent @SourceNameMapper@ changes.... Tomasz Domin
04:52 PM Conversion Tools Feature #6320: sharded schemata: One customer that uses this feature extensively organizes all activity in apps (each one like an independent module).... Greg Shah
03:38 PM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block: Constantin Asofiei wrote:
> Eric: do you recall if the @global@ parameter at the @TemporaryBuffer.define@ is used ... Eric Faulhaber
02:14 PM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block: For a very long-running FWD context, there is an accumulation of @TemporaryBuffer$Multiplexer@ instances in the @fina... Constantin Asofiei
02:11 PM Database Bug #6699 (WIP): TemporaryBuffer$Multiplexer memory leak in global block: Constantin Asofiei
03:36 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ported the following UDFs: ... Igor Skornyakov
03:01 PM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: Alexandru, I had missed your description of the tracing in #6695-11 when I posted my note.
If the hit/miss counts ... Eric Faulhaber
02:50 PM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: Alexandru Lungu wrote:
> I locally added JMX beans for cache hits and misses and I get the same results (@4.99@ on @... Eric Faulhaber
10:24 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: Greg Shah wrote:
> Make sure that the 4GL code is compiled before you run it. Otherwise the compilation cost in the... Alexandru Lungu
09:52 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: Greg Shah wrote:
> > I locally added JMX beans for cache hits and misses and I get the same results (4.99 on PRESELE... Alexandru Lungu
09:50 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: Yes, no problem. Greg Shah
09:45 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: Greg Shah wrote:
> Igor: Please add details to [[p2j:JMX Instrumentation]] to allow the rest of the team to easily f... Igor Skornyakov
09:41 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: > I locally added JMX beans for cache hits and misses and I get the same results (4.99 on PRESELECT NO-UNDO, 0.0 on @... Greg Shah
09:28 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: I locally added JMX beans for cache hits and misses and I get the same results (@4.99@ on @PRESELECT NO-UNDO@, @0.0 o... Alexandru Lungu
06:47 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: > > I also instrumented FWD with the attached patch (based on 3821c/14190),
>
> Forgot to attach the patch. This m... Greg Shah
05:33 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: These are some very insightful results!
@0.499@ rate for @PRESELECT NO-UNDO@ is exactly what I expected: only the ... Alexandru Lungu
10:46 AM Database Support #6679: H2 general performance tuning: Dănuț Filimon wrote:
> I ran a test on the sql statements obtained from the Hotel GUI application.
>
> The prepar... Eric Faulhaber
08:32 AM Database Support #6679: H2 general performance tuning: I ran a test on the sql statements obtained from the Hotel GUI application.
The prepared statements obtained from ... Dănuț Filimon
10:24 AM Database Feature #6348: implement support for MariaDB: The Hotel GUI project is broken, when running @./prepare_hotel.sh@ on a fresh checkout (interestingly, running again ... Constantin Asofiei

08/23/2022

06:32 PM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: Eric Faulhaber wrote:
> I also instrumented FWD with the attached patch (based on 3821c/14190),
Forgot to attac... Eric Faulhaber
06:25 PM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: I wanted to see where the time was being spent in both the @PreselectQuery@ case and the @CompoundQuery@ case. I also... Eric Faulhaber
12:25 PM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching: There is a case in which the multi-table @PreselectQuery@ works slower than a @CompoundQuery@:... Alexandru Lungu
12:18 PM Database Feature #6695 (Review): Multi-table preselect query may underperform due to repetitive fetching: Alexandru Lungu
05:26 PM Conversion Tools Feature #6237: OEUnit support: We took a short cut, which is why it smells. Yes, there is technical debt.
Can you use the version from rev 14184... Greg Shah
05:22 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> We create the @name_map.xml@ during annotations. We used to store the data in a binary serialize... Vladimir Tsichevski
05:07 PM Conversion Tools Feature #6237: OEUnit support: We create the @name_map.xml@ during annotations. We used to store the data in a binary serialized object called @nam... Greg Shah
04:47 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> It is very unlikely that this is unrelated. It may just be an additional regression since @Sourc... Vladimir Tsichevski
04:45 PM Conversion Tools Feature #6237: OEUnit support: Tomasz: Please see #6237-30 for a possible regression from the recent @SourceNameMapper@ changes. Greg Shah
04:43 PM Conversion Tools Feature #6237: OEUnit support: It is very unlikely that this is unrelated. It may just be an additional regression since @SourceNameMapper@ is used... Greg Shah
04:41 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> Let's not spend time on conversion of OEUnit. We know we are not going to use it in FWD.
>
> ... Vladimir Tsichevski
03:16 PM Conversion Tools Feature #6237: OEUnit support: Let's not spend time on conversion of OEUnit. We know we are not going to use it in FWD.
> First, I see warnings ... Greg Shah
02:54 PM Conversion Tools Feature #6237: OEUnit support: I cannot compile 3 base OEUnit classes.
First, I see warnings like these:... Vladimir Tsichevski
11:52 AM Conversion Tools Feature #6237: OEUnit support: Constantin Asofiei wrote:
> Vladimir, please create a 4GL package for the class - I think FWD has problems convertin... Vladimir Tsichevski
06:17 AM Conversion Tools Feature #6237: OEUnit support: Vladimir Tsichevski wrote:
> Greg Shah wrote:
> > I don't object to the change, but we don't want to spent time on ... Vladimir Tsichevski
06:07 AM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> I don't object to the change, but we don't want to spent time on making external files work at th... Vladimir Tsichevski
03:15 AM Conversion Tools Feature #6237: OEUnit support: Vladimir, please create a 4GL package for the class - I think FWD has problems converting .cls files without a packag... Constantin Asofiei
02:30 PM Database Bug #6275: SKIP-DELETED-RECORD implementation: > A single question: calls to @stopOnSkippedRecord@ occur on @first@, @next@, and @previous@ navigation. Shouldn't th... Greg Shah
01:55 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ported the following UDFs: ... Igor Skornyakov
12:34 PM Database Feature #6582: implement multi-table AdaptiveQuery: > I should note that in a real application, it would be very unusual to have a wide open cross join like this, which ... Alexandru Lungu
11:10 AM Database Feature #6582: implement multi-table AdaptiveQuery: Alexandru Lungu wrote:
> > I am facing a three times slower query in @AdaptiveQuery@ comparing to @CompoundQuery@ (a... Eric Faulhaber
08:22 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
04:45 AM Database Support #6679: H2 general performance tuning: Committed 3821c/rev.14187 where I replaced @.nextvalue@ with @next value for@ in order to prepare for the 2.1.210 H2 ... Dănuț Filimon
03:52 AM Database Support #6679: H2 general performance tuning: Eric Faulhaber wrote:
> What is currently calling .nextval?
@P2JH2Dialect.getSequencePrefetchString()@, @FastCopy... Dănuț Filimon
01:56 AM Base Language Bug #6693: StringFormat fixes - finish up and merge branch 4880a|b|c: Although the main fix for a @<complex_gui_application>@ is done (see #4880), a lot of improvements have already been ... Tijs Wickardt
01:52 AM Base Language Bug #6693 (New): StringFormat fixes - finish up and merge branch 4880a|b|c: Tijs Wickardt

08/22/2022

07:46 PM Conversion Tools Feature #6237: OEUnit support: I don't object to the change, but we don't want to spent time on making external files work at this time. We have ma... Greg Shah
07:03 PM Conversion Tools Feature #6237: OEUnit support: Got a classic error when compiling OEUnit: @FileNotFoundException@ when a propath has an entry outside the project su... Vladimir Tsichevski
06:46 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> > > In list mode, you may only have a portion of the dependencies in the object graph. That will... Vladimir Tsichevski
06:22 PM Conversion Tools Feature #6237: OEUnit support: > > In list mode, you may only have a portion of the dependencies in the object graph. That will fail. In non-list ... Greg Shah
05:34 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> In list mode, you may only have a portion of the dependencies in the object graph. That will fai... Vladimir Tsichevski
05:22 PM Conversion Tools Feature #6237: OEUnit support: In list mode, you may only have a portion of the dependencies in the object graph. That will fail. In non-list mode... Greg Shah
05:07 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> > # this does not help
> > # the skeleton is located outside of @testcases@ either, but classe... Vladimir Tsichevski
04:54 PM Conversion Tools Feature #6237: OEUnit support: Vladimir Tsichevski wrote:
> Greg Shah wrote:
> > Pointing to a skeletons directory outside of your project root ma... Greg Shah
04:43 PM Conversion Tools Feature #6237: OEUnit support: Classes can be converted by @ant convert@, but by @ant convert.list@. Vladimir Tsichevski
04:30 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> Pointing to a skeletons directory outside of your project root may be causing the issue or at lea... Vladimir Tsichevski
04:25 PM Conversion Tools Feature #6237: OEUnit support: Pointing to a skeletons directory outside of your project root may be causing the issue or at least an issue. The sk... Greg Shah
04:23 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> Is your current directory @/home/vvt/Projects/@? In other words, your conversion project top-lev... Vladimir Tsichevski
04:20 PM Conversion Tools Feature #6237: OEUnit support: Is your current directory @/home/vvt/Projects/@? In other words, your conversion project top-level directory is @/ho... Greg Shah
04:17 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> Are you working with the new testcases project ([[p2j:Testcases]])? This is already configured p... Vladimir Tsichevski
04:10 PM Conversion Tools Feature #6237: OEUnit support: Are you working with the new testcases project ([[p2j:Testcases]])? This is already configured properly to convert O... Greg Shah
03:55 PM Conversion Tools Feature #6237: OEUnit support: Greg Shah wrote:
> > I want to convert OEUnit 4gl sources
>
> Are you trying to convert OEUnit itself?
In genera... Vladimir Tsichevski
04:11 PM Base Language Bug #6640: parsing bug for initial ",0000" for decimal variables or fields: > Also, we need to check if this must be configured in p2j.cfg.xml or not (i.e. if it must consider -numsep at the 4G... Greg Shah
03:42 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ported matches, matcheslist, lookup.
Committed to 3821c/14184. Igor Skornyakov
01:35 PM Runtime Infrastructure Feature #6692: move FWD to Java 17: "Java 17 Release Notes":https://www.oracle.com/java/technologies/javase/17-relnotes.html
"Java 17 Features":https://... Greg Shah
01:27 PM Runtime Infrastructure Feature #6692 (Test): move FWD to Java 17: Greg Shah
01:25 PM Runtime Infrastructure Support #5567: move FWD to Java 11: OK, so far this looks like it is consistent with the customer's early findings (i.e. Java 8 is 10-20% faster than Jav... Greg Shah
11:49 AM Runtime Infrastructure Support #5567: move FWD to Java 11: Rebased to 3821c/14173, pushed 5567a/14191 for performance comparison tests.
Tomasz Domin
11:48 AM Runtime Infrastructure Support #5567: move FWD to Java 11: Greg Shah wrote:
> Let me know when you have some results on the performance comparison. I think that is the remain... Tomasz Domin
11:22 AM Database Support #6679: H2 general performance tuning: Dănuț Filimon wrote:
> Regarding the syntax difference about nextval in #6679-11.
>
> Since we can't use @.nextva... Eric Faulhaber
10:09 AM Database Support #6679: H2 general performance tuning: Regarding the syntax difference about nextval in #6679-11.
Since we can't use @.nextval@ in version 2.1.210 of H2,... Dănuț Filimon
10:38 AM Database Feature #6582: implement multi-table AdaptiveQuery: > I am facing a three times slower query in @AdaptiveQuery@ comparing to @CompoundQuery@ (a read-only example). This ... Alexandru Lungu
08:40 AM Database Feature #6348: implement support for MariaDB: > The dialect generates now string columns as varchar(100). I did not push the system intentionally, but with the scr... Greg Shah

08/20/2022

07:45 AM Database Feature #6582: implement multi-table AdaptiveQuery: Eric Faulhaber wrote:
> Alexandru Lungu wrote:
>> Initially, I expect to see the AdaptiveQuery working out-of-the-b... Alexandru Lungu
06:42 AM Database Support #6679: H2 general performance tuning: > OTOH, I am a bit concerned that the performance drops off again in versions >210. Does the H2 history log suggest t... Alexandru Lungu
09:22 PM Database Feature #6348: implement support for MariaDB: Committed revision 14182.
Eric Faulhaber wrote:
> Any update on the status of running Hotel GUI with MariaDB?
Th... Ovidiu Maxiniuc

08/19/2022

03:47 PM Database Support #6679: H2 general performance tuning: Alexandru, I'll leave it to you to set the assignee. If both gentlemen are working on this task, you can leave it bla... Eric Faulhaber
03:39 PM Database Support #6679 (WIP): H2 general performance tuning: The fact that there are so many transactions being executed in the tests actually is encouraging to me. Since transac... Eric Faulhaber
03:17 PM Database Support #6679: H2 general performance tuning: Around 20 transactions are done by one user per iteration. There are 200 users per tests (except one test with 10 use... Alexandru Lungu
10:58 AM Database Support #6679: H2 general performance tuning: Just curious: do the tests use a lot of transactions? This is where we have seen a serious bottleneck in the past. Eric Faulhaber
10:13 AM Database Support #6679: H2 general performance tuning: I tested version 210 patched with the Hotel_GUI application and there were no major problems, except a syntax differe... Dănuț Filimon
08:28 AM Database Support #6679: H2 general performance tuning: > Yes, the tests for 1.4.200 patched use PageStore and the later versions use MVStore.
Fantastic! I think it is f... Greg Shah
05:26 AM Database Support #6679: H2 general performance tuning: Greg Shah wrote:
> Are the above comparisons using 1.4.200 patched in PageStore mode versus the later versions in mv... Dănuț Filimon
03:28 PM Conversion Tools Feature #6237: OEUnit support: > I want to convert OEUnit 4gl sources
Are you trying to convert OEUnit itself? There is likely to be code in the... Greg Shah
03:22 PM Conversion Tools Feature #6237: OEUnit support: There's something else wrong with your config:... Constantin Asofiei
03:06 PM Conversion Tools Feature #6237: OEUnit support: Constantin Asofiei wrote:
> You need to add the skeleton project in cfg/p2j.cfg.xml via:
> [...]
Skeleton source... Vladimir Tsichevski
02:52 PM Conversion Tools Feature #6237: OEUnit support: You need to add the skeleton project in cfg/p2j.cfg.xml via:... Constantin Asofiei
02:41 PM Conversion Tools Feature #6237 (WIP): OEUnit support: I want to convert @OEUnit@ 4gl sources, and I do not know how to convert 4gl classes with FWD. I think, I miss someth... Vladimir Tsichevski
03:00 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> According to https://dev.mysql.com/doc/refman/8.0/en/signal.html, using SIGNAL with a SQLSTA... Igor Skornyakov
02:54 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: According to https://dev.mysql.com/doc/refman/8.0/en/signal.html, using SIGNAL with a SQLSTATE which begins with @01@... Eric Faulhaber
01:58 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Does anybody know a replacement of PostgreSQL @RAISE NOTICE@ statement for MariaDB?
I've used it for debugging compl... Igor Skornyakov
11:40 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Update.
Here is the complete list of MariaDB UDFs to be implemented:... Igor Skornyakov
11:27 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> What is the revised total number of UDFs for this dialect, and how many currently have a fir... Igor Skornyakov
09:58 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: What is the revised total number of UDFs for this dialect, and how many currently have a first pass implementation? I... Eric Faulhaber
03:00 PM Database Feature #6348: implement support for MariaDB: Ovidiu Maxiniuc wrote:
> My attempt to add a new guest caused a @Guest Accommodation Report@ with 225 entries (eve... Eric Faulhaber
11:37 AM Database Feature #6348: implement support for MariaDB: Now that you are working with Hotel GUI (i.e., something that, while not a "real" application, is more than a simple ... Eric Faulhaber
09:49 AM Database Feature #6348: implement support for MariaDB: Ovidiu Maxiniuc wrote:
> With hotel_gui/r248 and 3821c/14168, I am able to start the client and authenticate. The @G... Eric Faulhaber
10:36 AM Database Feature #6582: implement multi-table AdaptiveQuery: Alexandru Lungu wrote:
> Initially, I expect to see the @AdaptiveQuery@ working out-of-the-box with the current im... Eric Faulhaber
07:55 AM Database Bug #6688: ASSIGN trigger conversion when field has DECIMALS clause: Ovidiu Maxiniuc wrote:
> With 3821c your testcases correctly converts to
> [...]
>
> This was fixed recently r1... Constantin Asofiei
07:54 AM Database Bug #6688: ASSIGN trigger conversion when field has DECIMALS clause: With 3821c your testcases correctly converts to ... Ovidiu Maxiniuc
03:33 AM Database Bug #6688: ASSIGN trigger conversion when field has DECIMALS clause: There is a problem when converting a runtime ASSIGN database trigger, with a field having DECIMALS and/or INITIAL cla... Constantin Asofiei
03:31 AM Database Bug #6688 (Closed): ASSIGN trigger conversion when field has DECIMALS clause: Constantin Asofiei

08/18/2022

05:25 PM Database Support #6679: H2 general performance tuning: Dănuț Filimon wrote:
> The tests have 200 threads with 5/10 loops. The full tests have 200-2000 randomly generated... Eric Faulhaber
05:18 PM Database Support #6679: H2 general performance tuning: Greg Shah wrote:
> This sounds quite exciting.
>
> Are the above comparisons using 1.4.200 patched in PageStore m... Eric Faulhaber
03:23 PM Database Support #6679: H2 general performance tuning: This sounds quite exciting.
Are the above comparisons using 1.4.200 patched in PageStore mode versus the later ver... Greg Shah
10:01 AM Database Support #6679: H2 general performance tuning: Using the resources available in [[p2j:Performance Testing the H2 Database]] I have done tests using Apache JMeter an... Dănuț Filimon

08/17/2022

04:06 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ovidiu Maxiniuc wrote:
> Please expand to see {{collapse(the full list of expected UDF in FWD)
> [...]
> }}
>
>... Igor Skornyakov
04:04 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Please expand to see {{collapse(the full list of expected UDF in FWD)... Ovidiu Maxiniuc
01:57 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ovidiu Maxiniuc wrote:
> I used @meld@ to compare two text captions:
> # as the 'file name' suggests, I executed a ... Igor Skornyakov
01:53 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ovidiu Maxiniuc wrote:
> Now, as I wrote the text above, I noticed that the UDFs are defined once for *ALL* database... Igor Skornyakov
01:46 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Greg Shah wrote:
> > I think it would be better to decide on a name casing (all lowercase maybe?)
>
> +1 for all ... Igor Skornyakov
01:45 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> Added placeholder for the error handling UDFs in 3821c/14169.
>
> Please note that some ... Ovidiu Maxiniuc
01:40 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ovidiu Maxiniuc wrote:
> > Anyway, I think that it is a little late to change the approach.
> I am not sure what yo... Igor Skornyakov
01:26 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> Well, this is a possible option. It is a natural choice since UDFs a 4GL functions' counter... Ovidiu Maxiniuc
12:11 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ovidiu Maxiniuc wrote:
> I think the best would be to scan for @@HQLFunction@ annotation in the list of @public st... Igor Skornyakov
12:03 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: > I think it would be better to decide on a name casing (all lowercase maybe?)
+1 for all lowercase names. Greg Shah
11:59 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Greg Shah wrote:
> Why would this emit into the converted code? Our converted code should not be dialect-specific t... Ovidiu Maxiniuc
11:53 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> I've generated templates for MariaDB UDFs from PostgreSQL ones. This is why we have no e.g.... Ovidiu Maxiniuc
11:16 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: > Devil's advocate point: there already are significant differences in syntax and builtin function names across datab... Greg Shah
11:12 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Please note however, that adding "signature" suffix to the UDF names increases their total number by ~50%.
For examp... Igor Skornyakov
11:09 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> Please note also that I decided do not add underscore to the names of UDFs w/o argument. So... Eric Faulhaber
11:05 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Devil's advocate point: there already are significant differences in syntax and builtin function names across databas... Eric Faulhaber
09:12 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Greg Shah wrote:
> If I understand correctly, different database "dialects" (in FWD) will have different function na... Igor Skornyakov
08:19 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: If I understand correctly, different database "dialects" (in FWD) will have different function names for the same 4GL... Greg Shah
06:54 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Added additional UDFs' signatures in 3821c/14171.
@fwdsession@ UDF does not exist for PostgreSQL. Actually I do no... Igor Skornyakov
03:40 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Please note also that I decided do not add underscore to the names of UDFs w/o argument. So it should be @getfwdversi... Igor Skornyakov
02:48 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Added placeholder for the error handling UDFs in 3821c/14169.
Please note that some native UDFs (such as @totimest... Igor Skornyakov
01:30 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ovidiu Maxiniuc wrote:
> Igor,
>
> I implemented the decoration of the UDFs as described in note-31. I encountere... Igor Skornyakov
10:57 AM Database Support #6679 (Internal Test): H2 general performance tuning: Alexandru Lungu
03:45 AM Database Feature #6582: implement multi-table AdaptiveQuery: Committed 6582a/rev. 14160 including some fixes for order by clause and iteration type in multi-table @AdaptiveQuery@... Alexandru Lungu
08:14 PM Database Feature #6348: implement support for MariaDB: With hotel_gui/r248 and 3821c/14168, I am able to start the client and authenticate. The @Guests@, @Rates@ and @Rooms... Ovidiu Maxiniuc

08/16/2022

07:39 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor,
I implemented the decoration of the UDFs as described in note-31. I encountered some differences. I know you... Ovidiu Maxiniuc
01:20 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Refactored @ScriptRunner@ moving dialect-specific logic into the corresponding subclasses. Added support for MariaDB ... Igor Skornyakov
01:10 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> No, I do not work on this. In fact I've planned to finish with porting UDFs first.
Ovi... Eric Faulhaber
12:17 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > OK. Switching to the @ScriptRunner@ and most commonly used UDFs... Igor Skornyakov
10:42 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> OK. Switching to the @ScriptRunner@ and most commonly used UDFs.
> Please note however tha... Ovidiu Maxiniuc
02:41 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Changed @build.gradle@ to add MariaDB @udfs.sql@ to the p2j.jar in 3821c/14165. Igor Skornyakov
01:31 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: OK. Switching to the @ScriptRunner@ and most commonly used UDFs.
Please note however that we also need UDFs names re... Igor Skornyakov
11:22 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Ovidiu Maxiniuc wrote:
> Igor,
> Please do a check-out of the hotel_gui project (@~/secure/code/p2j_repo/samples/ho... Eric Faulhaber
11:17 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: The following is a list of 4GL builtin functions used within WHERE clauses, based on their presence in the applicatio... Eric Faulhaber
03:25 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications: Constantin Asofiei wrote:
> * @DatabaseTriggerManager@ - the problem here is that the context-local instance is refe... Ovidiu Maxiniuc
02:55 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications: Ovidiu and Eric: Please review the persistence related Scopeables in #6650-2 and see if you can offer some guidance. Greg Shah
02:54 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications: > For some cases (like UnnamedStreams and SharedVariableManager), the decision is easy - if the context-local WorkAre... Greg Shah
09:01 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications: The complex part of the task is to determine where and when to register a Scopeable with the next (or current) block.... Constantin Asofiei
10:50 AM Database Feature #6348: implement support for MariaDB: Ovidiu Maxiniuc wrote:
> I can confirm the char r-trimming is provided out-of-the-box and char-indexes seems to wo... Eric Faulhaber
08:17 PM Database Feature #6348: implement support for MariaDB: Please upgrade to FWD r14164 if you want to convert, import and start the hotel_gui test application. However, connec... Ovidiu Maxiniuc
10:34 AM User Interface Bug #6676 (Review): BACK-TAB jumps by two widgets at once: Stanislav Lomany
10:34 AM User Interface Bug #6676 (WIP): BACK-TAB jumps by two widgets at once: Fixed by Eugenie in 3821c revision 14163. Stanislav Lomany
07:07 AM Base Language Feature #4065: server-side processing of client platform dependencies: Yes, this is a flaw but it is better than the alternative.
Can we detect when the same lvalue is re-assigned a new... Greg Shah
06:57 AM Base Language Feature #4065: server-side processing of client platform dependencies: Greg Shah wrote:
> We don't actually allocate any additional memory, but there will be an extra entry in our registr... Constantin Asofiei
06:56 AM Base Language Feature #4065: server-side processing of client platform dependencies: > FWD will keep it allocated in the context's address space, as it 'allocated' this address space when the RETURN or ... Greg Shah
06:47 AM Base Language Feature #4065: server-side processing of client platform dependencies: Greg Shah wrote:
> > My point is if the memory is not deallocated on FWD server, this will lead to a memory leak in ... Constantin Asofiei
06:45 AM Base Language Feature #4065: server-side processing of client platform dependencies: > I understand, but I have at least a case in #6277 where the RETURN parameter is not being deallocated on the FWD se... Greg Shah
06:28 AM Base Language Feature #4065: server-side processing of client platform dependencies: Constantin Asofiei wrote:
> ... in this case, the library call is https://www.openssl.org/docs/man1.1.1/man3/EVP_sha... Constantin Asofiei
06:26 AM Base Language Feature #4065: server-side processing of client platform dependencies: Greg Shah wrote:
> In this case, we can augment the RETURN or OUTPUT parameter with additional size information. Ac... Constantin Asofiei
06:21 AM Base Language Feature #4065: server-side processing of client platform dependencies: > The only solution I see is to disable the address space check for RETURN and OUTPUT parameters, in the FWD runtime.... Greg Shah
05:46 AM Base Language Feature #4065: server-side processing of client platform dependencies: Greg Shah wrote:
> Perhaps we should require that the 4GL code is modified to tell us the size of the returned point... Constantin Asofiei
05:39 AM Base Language Feature #4065: server-side processing of client platform dependencies: > But the deregistration of this pointer from the FWD context's address space may not happen, if the memptr is not de... Greg Shah
05:06 AM Base Language Feature #4065: server-side processing of client platform dependencies: Another approach would be to allow memptr to be assigned addresses returned by the native API calls, and not register... Constantin Asofiei
05:05 AM Base Language Feature #4065: server-side processing of client platform dependencies: There is an issue with server-side memptr which affects #6277. The problem is related to memptr used at @define retu... Constantin Asofiei

08/15/2022

07:21 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor,
Please do a check-out of the hotel_gui project (@~/secure/code/p2j_repo/samples/hotel_gui/@). Use the latest F... Ovidiu Maxiniuc
01:28 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> But if I understand now, the functions work with Julian day values, just not those that wo... Igor Skornyakov
01:20 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: I initially was confused by the statement:
> So at this moment FWD @todate(integer)@ and @toint(date)@ UDFs work o... Eric Faulhaber
01:10 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> The parameter passed to @todate(integer)@ is the number of days since 12/31/-4714 (the Julia... Igor Skornyakov
01:03 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> According to the MariaDB documentation its date functions do not work correctly with non-gr... Eric Faulhaber
06:16 PM User Interface Bug #6676: BACK-TAB jumps by two widgets at once: Testcase:... Stanislav Lomany
06:09 PM User Interface Bug #6676 (Review): BACK-TAB jumps by two widgets at once: Stanislav Lomany
01:11 PM Database Bug #6599: minimal mode conversion problem with DMO name collision: Ovidiu, this is related to 6129a branch, where DMO annotations are registered in NameConverter. Constantin Asofiei
12:52 PM Database Bug #6599: minimal mode conversion problem with DMO name collision: Sorry, I was focused on the very last entry here. I just saw the solution I proposed after clicking submit. However, ... Ovidiu Maxiniuc
12:50 PM Database Bug #6599: minimal mode conversion problem with DMO name collision: Constantin Asofiei wrote:
> Eric Faulhaber wrote:
> > Constantin Asofiei wrote:
> > > I think the correct way is... Ovidiu Maxiniuc
12:00 PM Database Bug #6599: minimal mode conversion problem with DMO name collision: Eric Faulhaber wrote:
> Constantin Asofiei wrote:
>
> > I think the correct way is to not link the DMO name with ... Constantin Asofiei
11:34 AM Database Bug #6599: minimal mode conversion problem with DMO name collision: Constantin Asofiei wrote:
> I think the correct way is to not link the DMO name with the SQL table name, for minim... Eric Faulhaber
10:09 AM Database Feature #6582: implement multi-table AdaptiveQuery: I created 6582a as a branch of 3821c. I committed (rev. 14159) some conversion related work and minimal runtime chang... Alexandru Lungu
08:27 AM Runtime Infrastructure Feature #6673: rework appserver agent approach to use a shared queue instead of a check-in/check-...: In #6672, the simple test case shows significant performance degradation between the single-user and multi-user cases... Greg Shah
08:12 AM Runtime Infrastructure Feature #6673 (New): rework appserver agent approach to use a shared queue instead of a check-in/...: Greg Shah
07:55 AM Runtime Infrastructure Support #5567: move FWD to Java 11: Greg Shah wrote:
> Let me know when you have some results on the performance comparison. I think that is the remain... Tomasz Domin
07:33 AM Runtime Infrastructure Support #5567: move FWD to Java 11: Let me know when you have some results on the performance comparison. I think that is the remaining blocker. Even i... Greg Shah
06:20 AM Runtime Infrastructure Support #5567: move FWD to Java 11: That is probably within "normal range" of results. The ChUI test set is not 100% reliable. There are false negative... Greg Shah
03:15 AM Runtime Infrastructure Support #5567: move FWD to Java 11: Greg Shah wrote:
> Tomasz: Do you have comparable ChUI regression test results between 3821c and 5567a?
Yes I hav... Tomasz Domin

08/14/2022

11:55 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: According to the MariaDB documentation its date functions do not work correctly with non-gregorian dates (before Octo... Igor Skornyakov
11:40 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: In 3821c/14154. *174* of *219* UDFs are ported from PostrgreSQL to MariaDB.
Started working on format-driven conve... Igor Skornyakov

08/13/2022

09:31 PM Database Feature #6348: implement support for MariaDB: The revision 14156 brings several improvements for the dialect:
* I noticed they released a new GA JDBC driver (3.0.... Ovidiu Maxiniuc

08/12/2022

04:47 PM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning": The @3821c_14154@ revision allows the Hotel ChUI server to start using the @fwdServer@ deployment, and the client to ... Roger Borrello
10:50 AM Runtime Infrastructure Bug #6671 (New): Build configurations need "fine tuning": Roger Borrello
04:22 PM Database Feature #6450: buffer/buffer-field features: I did not work with 6129a lately so I had to update the branch and review those changes. Constantin did the rebase ag... Ovidiu Maxiniuc
10:47 AM Database Feature #6450: buffer/buffer-field features: Ovidiu, I see there was a review cycle in #6502 and a commit of your changes to 6129a. Given that, is there anything ... Eric Faulhaber
03:19 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: In 3821c/14153. *157* of *219* UDFs are ported from PostrgreSQL to MariaDB.
So, all 'simple' UDFs have been ported... Igor Skornyakov
03:11 PM Runtime Infrastructure Support #5567: move FWD to Java 11: Tomasz: Do you have comparable ChUI regression test results between 3821c and 5567a? Greg Shah
01:49 PM Database Feature #6348: implement support for MariaDB: How to configure your test project to work with @MariaDb@:
* update your @cfg/p2j.cfg.xml@ to add generation of DDL ... Ovidiu Maxiniuc
01:33 PM Database Feature #6348: implement support for MariaDB: I did a basic write/read from database test. It seems to be working, but I did not use any fancy queries.
I used t... Ovidiu Maxiniuc

08/11/2022

03:17 PM Conversion Tools Feature #6670: Implement empty-argument preprocessor quirk: Consider the following include (test.i):... Hynek Cihlar
03:13 PM Conversion Tools Feature #6670 (New): Implement empty-argument preprocessor quirk: Hynek Cihlar
02:32 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > Exactly. Any objections?
>
> No, seems like a good approa... Igor Skornyakov
02:27 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> Exactly. Any objections?
No, seems like a good approach.
I would like to get the in... Eric Faulhaber
02:19 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> If I understand your process correctly, it looks like you are doing an automated port of the... Igor Skornyakov
02:17 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: If I understand your process correctly, it looks like you are doing an automated port of the "scaffolding" from the P... Eric Faulhaber
02:13 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> Igor Skornyakov wrote:
> > It appears that we should use @DECIMAL(65, 38)@ instead of @NUME... Igor Skornyakov
02:05 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> It appears that we should use @DECIMAL(65, 38)@ instead of @NUMERIC@ in UDFs.
Shouldn't ... Eric Faulhaber
01:59 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: In 3821c/14150. *55* of *219* UDFs are ported from PostrgreSQL to MariaDB.
Please do not be too optimistic. The po... Igor Skornyakov
12:45 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: It appears that we should use @DECIMAL(65, 38)@ instead of @NUMERIC@ in UDFs. Igor Skornyakov
03:13 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> Igor Skornyakov wrote:
> I just looked at this again and noticed that some of the mappings ... Igor Skornyakov
01:14 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> [...]
> In fact the MariaDB data types a not very different from PostgreSQL ones. See the ... Eric Faulhaber
11:23 AM Conversion Tools Feature #6669: load all conversion rules from the jar by default and honor the file system if it ...: It should be possible to run conversion with just the FWD jar(s) in place. Today, I think we actually need the @p2j/... Greg Shah
11:21 AM Conversion Tools Feature #6669 (New): load all conversion rules from the jar by default and honor the file system ...: Greg Shah

08/10/2022

05:24 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> > I'm ok with your naming convention, though where the mapped data types differ in name for... Ovidiu Maxiniuc
03:12 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Created MariaDB UDFs templates.
Committed to 3821c/14145. Igor Skornyakov
02:39 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Eric Faulhaber wrote:
> We had a similar issue with H2 and we resolved it by prepending an underscore followed by a ... Igor Skornyakov
02:06 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: We had a similar issue with H2 and we resolved it by prepending an underscore followed by a unique integer (for that ... Eric Faulhaber
01:38 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: Igor Skornyakov wrote:
> I've realized that in MariaDB we cannot have two UDFs with the same name but different sign... Igor Skornyakov
01:24 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: I've realized that in MariaDB we cannot have two UDFs with the same name but different signatures.
This requires cha... Igor Skornyakov
08:01 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: At this moment I see the following plan
# Create an @AWK@ script for automatic conversion of the udfs.sql script for... Igor Skornyakov
05:10 PM Database Feature #6371: implement SAVE CACHE statement: Pushed revision 6371a/14096 with JavaDoc and indexes. Boris Schegolev
01:14 PM Database Feature #6371: implement SAVE CACHE statement: If the cost is not high, making an implicit @SAVE CACHE@ call at server startup will make the system more resilient/s... Greg Shah
01:11 PM Database Feature #6371: implement SAVE CACHE statement: The persistence of the DMOs is a good point. We would want these to load like any other DMOs, if no schema changes ha... Eric Faulhaber
12:49 PM Database Feature #6371: implement SAVE CACHE statement: Also, I wonder if we should even do this persisting for generated DMOs for dynamic temp-tables (at least if they are ... Greg Shah
12:47 PM Database Feature #6371: implement SAVE CACHE statement: Another difference from dynamic temp-tables: the generated DMOs must survive server restarts (or must be recreated on... Greg Shah
12:35 PM Database Feature #6371: implement SAVE CACHE statement: After detecting schema differences, we need to inspect/apply/walk these to generate the correct DMO interfaces. DMO i... Eric Faulhaber
11:19 AM Database Feature #6371: implement SAVE CACHE statement: Let's go with XML for persisting each "snapshot" state, which will be used for later comparisons. TBD: do we need to ... Eric Faulhaber
11:17 AM Conversion Tools Feature #6237: OEUnit support: OEUnit includes quite a bit of UI code (including GUI) for running tests. Early parsing of this code shows that it m... Greg Shah
09:09 AM Runtime Infrastructure Support #5567: move FWD to Java 11: If 5567a has the same ChUI regression testing results as 3821c, then the only thing holding us back from merging 5567... Greg Shah
04:10 AM Runtime Infrastructure Support #5567: move FWD to Java 11: Roger Borrello wrote:
> Tomasz, I just checked @build.gradle@ into @3821c_14140@ with the update mentioned above. Is... Tomasz Domin

08/09/2022

05:45 PM Database Feature #6371: implement SAVE CACHE statement: XML is more consistent with the rest of the configuration in FWD. Greg Shah
04:59 PM Database Feature #6371: implement SAVE CACHE statement: I pushed revision 6371a/14095 with code to support comparison for tables and columns. Also, extended the javadoc on t... Boris Schegolev
11:20 AM Database Feature #6371: implement SAVE CACHE statement: Eric Faulhaber wrote:
> Boris Schegolev wrote:
> > Saved state will consist of tables, columns and index lists. Thi... Tijs Wickardt
11:02 AM Database Feature #6371: implement SAVE CACHE statement: Eric Faulhaber wrote:
> Boris, please commit all your updates to 6371a. You are the only one changing this branch, s... Eric Faulhaber
10:56 AM Database Feature #6371: implement SAVE CACHE statement: Boris Schegolev wrote:
> Saved state will consist of tables, columns and index lists. This object can be serialized ... Eric Faulhaber
10:47 AM Database Feature #6371: implement SAVE CACHE statement: Boris, please commit all your updates to 6371a. You are the only one changing this branch, so it is safe. This will m... Eric Faulhaber
02:02 PM Runtime Infrastructure Support #5567: move FWD to Java 11: Tomasz, I just checked @build.gradle@ into @3821c_14140@ with the update mentioned above. Is there any way both 3821c... Roger Borrello
12:18 PM Conversion Tools Feature #6661: OCX: Implement support for conversion of VARTYPE parameters and properties: Hynek Cihlar wrote:
> ... If it finds a match, it will emit native Java method call
It must be an error if more t... Vladimir Tsichevski
09:28 AM Conversion Tools Feature #6661: OCX: Implement support for conversion of VARTYPE parameters and properties: Implement conversion and runtime support for the polymorphic @VARTYPE@ data type used in OCX interfaces.
A possibl... Hynek Cihlar
09:08 AM Conversion Tools Feature #6661 (New): OCX: Implement support for conversion of VARTYPE parameters and properties: Hynek Cihlar
11:55 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB: If the JSON array approach seems to be the only viable option, I think we have to use it for now. Another alternative... Eric Faulhaber

08/08/2022

01:23 PM Runtime Infrastructure Support #5567: move FWD to Java 11: > It took some time as each run takes about 6-7 hours (build + database import + tests).
From my memory about expe... Greg Shah
07:43 AM Runtime Infrastructure Support #5567: move FWD to Java 11: weekly rebase to 3821c/14131, committed 5821c/14149
Tomasz Domin
04:05 AM Runtime Infrastructure Support #5567: move FWD to Java 11: Roger Borrello wrote:
> This results in the usage of @xml-apis-1.4.01.jar@, which seems to alleviate a conversion er... Tomasz Domin
02:28 AM Runtime Infrastructure Support #5567: move FWD to Java 11: I've made it to run main_regression tests on my local workstation. It took some time as each run takes about 6-7 hour... Tomasz Domin

« Previous

Also available in: Atom

Project

General

Profile

FWD

Activity

Activity

09/03/2022

09/02/2022

09/01/2022

08/31/2022

08/30/2022

08/29/2022

08/28/2022

08/27/2022

08/26/2022

08/25/2022

08/24/2022

08/23/2022

08/22/2022

08/20/2022

08/19/2022

08/18/2022

08/17/2022

08/16/2022

08/15/2022

08/14/2022

08/13/2022

08/12/2022

08/11/2022

08/10/2022

08/09/2022

08/08/2022