Activity
From 08/01/2022 to 08/30/2022
08/31/2022
- 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...
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?
- 07:51 PM Runtime Infrastructure Feature #5776: reduce memory requirements for the FWD client
- Tomasz: Go ahead and merge the 5776-3.diff changes.
- 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...
- 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... - 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...
- 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...
- 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... - 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... - 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... - 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 @... - 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 ... - 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 ... - 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...
- 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?
... - 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...
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...
- 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... - 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 ... - 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:
... - 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... - 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... - 06:32 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- Rebased to 3821c/14205, pushed 5567a/14223
- 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...
- 06:39 AM Database Feature #6720 (WIP): lazy hydration
- 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 (...
- 06:54 AM Database Feature #6721 (New): calculate field lists at conversion time where possible
- 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...
- 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...
- 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...
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...
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 ...
- 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. - 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 ... - 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...
- 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 ... - 09:41 PM Database Bug #6275 (Review): SKIP-DELETED-RECORD implementation
- 09:41 PM Database Bug #6275 (WIP): SKIP-DELETED-RECORD implementation
- 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...
08/26/2022
- 03:06 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 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... - 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...
- 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... - 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...
- 12:02 PM Database Feature #6371: implement SAVE CACHE statement
- So, the integration part should be something like that, right?...
- 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...
- 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.
- 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:...
- 03:45 AM Database Bug #6715 (New): BufferManager.validate throws IllegalStateException if a validation fails via a ...
- 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,...
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... - 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... - 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 ... - 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 ... - 04:08 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 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
> > [...]
... - 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...
- 12:24 PM Database Support #6714 (Review): check if there is an optimization opportunity when copying temp-tables ba...
- 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 ...
- 12:17 PM Database Support #6713 (WIP): check if it is faster to use separate temp-table instances instead of multip...
- 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... - 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...
- 12:09 PM Database Support #6712 (New): check generated dynamic temp-table caching to ensure that all cache keys wor...
- 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...
- 11:57 AM Database Feature #6711 (New): skip schema AST creation and go directly to .p2o in dynamic temp-table gener...
- 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...
- 11:55 AM Database Feature #6710 (New): persist dynamic temp-tables across server restarts
- 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...
- 11:49 AM Database Support #6709 (Review): track nested FIND inside a related FOR loop
- 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 ...
- 11:42 AM Database Support #6708 (Review): track/report at runtime when AdaptiveQuery shifts into dynamic mode
- 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...
- 11:30 AM Database Support #6707 (New): evaluate the effectiveness of the current approach to ProgressiveResults
- 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)...
- 10:26 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- The fix is this:...
- 09:25 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- The recreate is this:...
- 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 ...
- 11:17 AM Conversion Tools Bug #6706 (New): preserve existing camel-case usage in program names
- 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. ;)
- 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... - 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... - 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... - 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:...
- 05:33 AM Database Bug #6703 (WIP): loading schema table DMO interface with no defined fields
- 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...
- 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...
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...
- 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 ...
- 05:11 PM Database Feature #6700 (New): refactor prodataset conversion to generate a separate/common class which can...
- 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... - 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...
- 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... - 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... - 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... - 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... - 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 ...
- 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... - 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.... - 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)....
- 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 ... - 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...
- 02:11 PM Database Bug #6699 (WIP): TemporaryBuffer$Multiplexer memory leak in global block
- 03:36 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 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 ... - 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 @... - 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... - 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... - 09:50 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Yes, no problem.
- 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... - 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 @...
- 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...
- 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... - 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 ... - 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... - 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 ... - 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 ...
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... - 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...
- 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@:...
- 12:18 PM Database Feature #6695 (Review): Multi-table preselect query may underperform due to repetitive fetching
- 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... - 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... - 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...
- 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... - 04:45 PM Conversion Tools Feature #6237: OEUnit support
- Tomasz: Please see #6237-30 for a possible regression from the recent @SourceNameMapper@ changes.
- 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...
- 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.
>
> ... - 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 ... - 02:54 PM Conversion Tools Feature #6237: OEUnit support
- I cannot compile 3 base OEUnit classes.
First, I see warnings like these:... - 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... - 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 ... - 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... - 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...
- 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...
- 01:55 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 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 ...
- 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... - 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... - 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 ...
- 03:52 AM Database Support #6679: H2 general performance tuning
- Eric Faulhaber wrote:
> What is currently calling .nextval?
@P2JH2Dialect.getSequencePrefetchString()@, @FastCopy... - 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 ...
- 01:52 AM Base Language Bug #6693 (New): StringFormat fixes - finish up and merge branch 4880a|b|c
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...
- 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...
- 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... - 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 ...
- 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... - 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...
- 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... - 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... - 04:43 PM Conversion Tools Feature #6237: OEUnit support
- Classes can be converted by @ant convert@, but by @ant convert.list@.
- 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... - 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...
- 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... - 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...
- 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... - 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...
- 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... - 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...
- 03:42 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported matches, matcheslist, lookup.
Committed to 3821c/14184. - 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://... - 01:27 PM Runtime Infrastructure Feature #6692 (Test): move FWD to Java 17
- 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...
- 11:49 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- Rebased to 3821c/14173, pushed 5567a/14191 for performance comparison tests.
- 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... - 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... - 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,... - 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 ...
- 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...
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... - 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...
- 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...
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...
- 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...
- 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...
- 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.
- 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...
- 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... - 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... - 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... - 03:22 PM Conversion Tools Feature #6237: OEUnit support
- There's something else wrong with your config:...
- 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... - 02:52 PM Conversion Tools Feature #6237: OEUnit support
- You need to add the skeleton project in cfg/p2j.cfg.xml via:...
- 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...
- 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... - 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@...
- 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... - 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:... - 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... - 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...
- 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... - 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 ...
- 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... - 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... - 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... - 07:54 AM Database Bug #6688: ASSIGN trigger conversion when field has DECIMALS clause
- With 3821c your testcases correctly converts to ...
- 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...
- 03:31 AM Database Bug #6688 (Closed): ASSIGN trigger conversion when field has DECIMALS clause
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... - 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... - 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... - 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...
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)
> [...]
> }}
>
>... - 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)...
- 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 ... - 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... - 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 ... - 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 ... - 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... - 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... - 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... - 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. - 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... - 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.... - 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...
- 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... - 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... - 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...
- 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... - 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...
- 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... - 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...
- 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... - 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... - 10:57 AM Database Support #6679 (Internal Test): H2 general performance tuning
- 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@...
- 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...
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... - 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 ...
- 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... - 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... - 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... - 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.
- 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... - 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... - 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...
- 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... - 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.
- 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...
- 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....
- 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... - 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...
- 10:34 AM User Interface Bug #6676 (Review): BACK-TAB jumps by two widgets at once
- 10:34 AM User Interface Bug #6676 (WIP): BACK-TAB jumps by two widgets at once
- Fixed by Eugenie in 3821c revision 14163.
- 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... - 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... - 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 ...
- 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 ... - 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...
- 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... - 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... - 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....
- 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... - 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...
- 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...
- 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...
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... - 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... - 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... - 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... - 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... - 06:16 PM User Interface Bug #6676: BACK-TAB jumps by two widgets at once
- Testcase:...
- 06:09 PM User Interface Bug #6676 (Review): BACK-TAB jumps by two widgets at once
- 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.
- 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, ...
- 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...- 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 ... - 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... - 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...
- 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...
- 08:12 AM Runtime Infrastructure Feature #6673 (New): rework appserver agent approach to use a shared queue instead of a check-in/...
- 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... - 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...
- 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...
- 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...
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...
- 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...
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....
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 ...
- 10:50 AM Runtime Infrastructure Bug #6671 (New): Build configurations need "fine tuning"
- 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...
- 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 ...
- 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... - 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?
- 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 ... - 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...
08/11/2022
- 03:17 PM Conversion Tools Feature #6670: Implement empty-argument preprocessor quirk
- Consider the following include (test.i):...
- 03:13 PM Conversion Tools Feature #6670 (New): Implement empty-argument preprocessor quirk
- 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... - 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... - 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... - 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...
- 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... - 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 ... - 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... - 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.
- 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 ... - 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 ... - 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/...
- 11:21 AM Conversion Tools Feature #6669 (New): load all conversion rules from the jar by default and honor the file system ...
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... - 03:12 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Created MariaDB UDFs templates.
Committed to 3821c/14145. - 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 ... - 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 ...
- 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... - 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... - 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... - 05:10 PM Database Feature #6371: implement SAVE CACHE statement
- Pushed revision 6371a/14096 with JavaDoc and indexes.
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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...
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.
- 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...
- 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... - 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... - 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 ... - 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...
- 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...
- 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... - 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... - 09:08 AM Conversion Tools Feature #6661 (New): OCX: Implement support for conversion of VARTYPE parameters and properties
- 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...
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... - 07:43 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- weekly rebase to 3821c/14131, committed 5821c/14149
- 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... - 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...
08/05/2022
- 03:47 PM Runtime Infrastructure Support #5567: move FWD to Java 11
- Tomasz Domin wrote:
> I've made changes to build scripts to make this branch compatible with Java 8 again
> So now ... - 07:12 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- I've made changes to build scripts to make this branch compatible with Java 8 again
So now JVM used during compiling... - 06:47 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- > The performance decrease from shifting to Java 11 is an expected feature. This is not a bug but cost for using more...
- 02:35 PM Database Feature #6371: implement SAVE CACHE statement
- Implemented @DatabaseState@ object, @Difference@ object and loading / comparison for tables. Please, review.
- 12:04 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- There is a about a couple of dozens of PostgreSQL native UDFs (~10%) that heavily use arrays and/or user-defined data...
08/04/2022
- 10:41 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- Two notes here:
1. The patch in @5567-2.diff@ is need to be applied even for further versions of the @Java 8@, not... - 05:47 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- We have indeed done a large amount of testing of the persistence layer/database performance in FWD. There are many a...
- 06:18 AM Database Feature #6348: implement support for MariaDB
- Greg Shah wrote:
> > However supporing word indexes for non-normalized extent fields can be not strightforward.
>
... - 05:50 AM Database Feature #6348: implement support for MariaDB
- > However supporing word indexes for non-normalized extent fields can be not strightforward.
Is it possible to use... - 12:38 AM Database Feature #6348: implement support for MariaDB
- Eric Faulhaber wrote:
> Agreed, we should not have logic that begins @if (dialect instanceof *Dialect) ...@.
>
I'... - 10:59 PM Database Feature #6348: implement support for MariaDB
- Ovidiu Maxiniuc wrote:
> Yes, I noticed that @WordTable@ class and some methods of @DDLGeneratorWorker@ are not full...
08/03/2022
- 04:39 PM Database Feature #6371: implement SAVE CACHE statement
- Saved state will consist of tables, columns and index lists. This object can be serialized using common methods (YAML...
- 12:41 AM Database Feature #6371: implement SAVE CACHE statement
- Boris Schegolev wrote:
> I am attaching a proposal for Schema Comparator service. It would be invoked like:
>
> [... - 03:52 PM Database Feature #6348: implement support for MariaDB
- Yes, I noticed that @WordTable@ class and some methods of @DDLGeneratorWorker@ are not fully dialect independent. The...
- 02:56 PM Database Feature #6348: implement support for MariaDB
- Please note that @CONTAINS@ (word tables') support for MariaDB will also need some some efforts (we need MariaDB-spec...
- 02:03 PM Runtime Infrastructure Support #5567: move FWD to Java 11
- Greg Shah wrote:
> A customer did some testing on Java 11. They ran branch 6129a which is a modified version of an ... - 01:10 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> Please see #6348-7. In fact, it would be good to review that whole task.
Thank you, revie... - 12:52 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Please see #6348-7. In fact, it would be good to review that whole task.
- 12:11 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Have we already made a decision about datatypes' mapping for MariaDB?
At this moment the most important for me are s... - 11:17 AM User Interface Bug #3015: Frame scrolling is broken
- The screens for @lastevent_mouse_coords.p@ in FWD (left) and OE (right):
!3015.png!
besides the missing scrollb...
08/02/2022
- 03:56 PM Runtime Infrastructure Support #5567: move FWD to Java 11
- Tomasz Domin wrote:
> I'll do the same for other applications instead of making java version related branches.
We... - 03:35 PM Runtime Infrastructure Support #5567: move FWD to Java 11
- Rebased to 3821c/14122, pushed 5567a/14138
Roger Borrello wrote:
> Greg Shah wrote:
> > > I'd like to code up a... - 09:57 AM Base Language Feature #6416: explore and implement ideas to make OO 4GL more efficient
- Constantin Asofiei wrote:
> A part of the problem is the instance initialization in 4GL; the constructors are calle...
08/01/2022
- 03:42 PM Database Feature #6371: implement SAVE CACHE statement
- I am attaching a proposal for Schema Comparator service. It would be invoked like:...
- 02:32 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ovidiu Maxiniuc wrote:
> I used the following command:
> [...]
>
> That installed for me:
> [...]
>
> I do n... - 02:22 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- I used the following command:...
- 01:27 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Working with version 10.8.3
- 12:45 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> Which version of MariaDB should I work with?
The most recent production build (10.8, AFA... - 04:14 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Which version of MariaDB should I work with?
Thank you. - 12:58 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- I've tried a simple looping block executed (via Java FOR statement) 100k times and the times are with/without executi...
- 12:54 PM Base Language Feature #6650 (WIP): improve performance of Scopeable notification in TM.processScopeNotifications
- 10:44 AM Base Language Feature #6416: explore and implement ideas to make OO 4GL more efficient
- Greg Shah wrote:
> What specific features of the constructor processing are impacted if we used direct construction ... - 10:35 AM Base Language Feature #6416: explore and implement ideas to make OO 4GL more efficient
- What specific features of the constructor processing are impacted if we used direct construction (did not properly du...
- 10:19 AM Base Language Feature #6416: explore and implement ideas to make OO 4GL more efficient
- A part of the problem is the instance initialization in 4GL; the constructors are called *after* the initialization ...
- 10:25 AM Base Language Feature #6649: improve the performance or SourceNameMapper runtime
- @SourceNameMapper@ APIs like @getExternalProgram@ or @getInternalEntry@ get called each time something dynamic is exe...
- 10:21 AM Base Language Feature #6649 (Test): improve the performance or SourceNameMapper runtime
- 10:22 AM Base Language Support #4061: base language performance work
- * #4149 - BlockManager and TransactionManager handle TransactionType.NONE incorrectly
* #6649 - SourceNameMapper per... - 08:04 AM Runtime Infrastructure Feature #6646: short circuit legacy REST program invocation
- > When registering the REST/SOAP services, FWD knows exactly what Java method should be invoked - this should allow t...
- 08:03 AM Runtime Infrastructure Feature #6646 (New): short circuit legacy REST program invocation
- 07:38 AM Base Language Feature #1970: improve ControlFlowOps method resolution by reflection
- In regard to my idea to use a call-site specific "token" (e.g. @private static final Object _CALL_SITE_TOKEN_xyz = ne...
Also available in: Atom