FWD

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

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 ... Roger Borrello

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... Tomasz Domin

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... Greg Shah

02:35 PM Database Feature #6371: implement SAVE CACHE statement

Implemented @DatabaseState@ object, @Difference@ object and loading / comparison for tables. Please, review. Boris Schegolev

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... Igor Skornyakov

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... Eugenie Lyzenko

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... Greg Shah

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.
>
... Igor Skornyakov

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... Greg Shah

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'... Igor Skornyakov

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... Eric Faulhaber

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... Boris Schegolev

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:
>
> [... Eric Faulhaber

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... Ovidiu Maxiniuc

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... Igor Skornyakov

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 ... Tomasz Domin

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... Igor Skornyakov

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. Eric Faulhaber

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... Igor Skornyakov

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... Vladimir Tsichevski

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... Roger Borrello

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... Tomasz Domin

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... Marian Edu

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:... Boris Schegolev

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... Igor Skornyakov

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

I used the following command:... Ovidiu Maxiniuc

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

Working with version 10.8.3 Igor Skornyakov

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... Eric Faulhaber

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

Which version of MariaDB should I work with?
Thank you. Igor Skornyakov

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... Constantin Asofiei

12:54 PM Base Language Feature #6650 (WIP): improve performance of Scopeable notification in TM.processScopeNotifications

Constantin Asofiei

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 ... Constantin Asofiei

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... Greg Shah

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 ... Constantin Asofiei

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... Constantin Asofiei

10:21 AM Base Language Feature #6649 (Test): improve the performance or SourceNameMapper runtime

Constantin Asofiei

10:22 AM Base Language Support #4061: base language performance work

* #4149 - BlockManager and TransactionManager handle TransactionType.NONE incorrectly
* #6649 - SourceNameMapper per... Constantin Asofiei

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... Greg Shah

08:03 AM Runtime Infrastructure Feature #6646 (New): short circuit legacy REST program invocation

Greg Shah

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... Greg Shah

07/31/2022

03:41 PM Database Feature #6628 (WIP): port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov

05:58 AM Base Language Feature #4350: method overload when they differ by a temp-table, dataset, buffer or object or ext...

Runtime for constructor overload with @object@ arguments is not yet complete. Having two constructors like:... Constantin Asofiei

07/29/2022

08:05 AM Conversion Tools Bug #6644: OpenClient proxy does not sanitize the names for legacy mode

With @proxy-legacy-names="true"@ true setting, any 4GL programs exposed as OpenClient proxy, will have the Java code ... Constantin Asofiei

08:03 AM Conversion Tools Bug #6644 (New): OpenClient proxy does not sanitize the names for legacy mode

Constantin Asofiei

08:02 AM Conversion Tools Bug #6612: Extent input-output arguments of functions are not correctly wrapped

This may be solved in 6129a. Constantin Asofiei

06:51 AM Conversion Tools Bug #6642: improve parsing memory footprint

I've fixed some issues in 6129a/14249 in 12450, the customer's app now completes full conversion with 10g of heap.
... Constantin Asofiei

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

Igor Skornyakov wrote:
> I understand that MariaDB does not have arrays
Not as a first class data type, no, but p... Eric Faulhaber

07/27/2022

04:02 PM Database Bug #6599: minimal mode conversion problem with DMO name collision

Eric, minimal mode conversion was added after I my @NameConverter.java@ change - and conversion was fine, until the r... Constantin Asofiei

03:43 PM Database Bug #6599: minimal mode conversion problem with DMO name collision

Constantin, it looks like you made this change very early in 6129a (rev 13815), apparently to address cases of confli... Eric Faulhaber

06:15 AM Database Bug #6599: minimal mode conversion problem with DMO name collision

Eric, can this be fixed? Although is not a problem when running the converted code, this is a problem when executing... Constantin Asofiei

01:09 PM Conversion Tools Bug #6642 (Review): improve parsing memory footprint

The changes are in 6129a/14249. Please review.
This will be committed to 6129a.3821c.13813, too, once I'm finishe... Constantin Asofiei

11:59 AM Conversion Tools Bug #6642: improve parsing memory footprint

In #6627-4 it was found that the parsing phase keeps a lot of state in the heap. This required for a large customer ... Constantin Asofiei

11:39 AM Conversion Tools Bug #6642 (Review): improve parsing memory footprint

Constantin Asofiei

05:10 AM Base Language Feature #4350: method overload when they differ by a temp-table, dataset, buffer or object or ext...

The fix in 6129a.3821c.13813 revision 13956 was committed to main 6129a branch revision 14248.
Other fixes in 6129... Constantin Asofiei

04:36 AM Base Language Feature #4350: method overload when they differ by a temp-table, dataset, buffer or object or ext...

Fixed an issue with OUTPUT arguments, when the argument is an interface and the parameter is a class implementing the... Constantin Asofiei

03:57 AM Base Language Bug #6640: parsing bug for initial ",0000" for decimal variables or fields

There is a problem with parsing an initial value of ",0000" for decimal variables or fields.
For example:... Constantin Asofiei

03:53 AM Base Language Bug #6640 (New): parsing bug for initial ",0000" for decimal variables or fields

Constantin Asofiei

03:33 AM Database Support #4701: try to improve H2 transaction commit performance

I just noticed that H2 is moving kinda fast with no more than 5 releases in the last couple of months. I can't tell i... Alexandru Lungu

07/25/2022

04:56 PM Conversion Tools Bug #6627: improve conversion memory footprint for AstKey persistent maps

Experimenting showed that the impact of these changes didn't have the magnitude I first assumed. The changes I have ... Constantin Asofiei

11:44 AM User Interface Bug #6636: Unwanted selection due to direct manipulation

Eugenie, the changed condition ... Stanislav Lomany

11:24 AM User Interface Bug #6636: Unwanted selection due to direct manipulation

Read #5644-23 and #5644-25 for a start. Stanislav Lomany

11:23 AM User Interface Bug #6636 (WIP): Unwanted selection due to direct manipulation

Stanislav Lomany

09:34 AM User Interface Feature #4837: Add javascript keyboard test application for the virtual desktop

Committed rev 14105 added gui elements for test keys js application to implement replay keystrokes functionality. The... Sergey Ivanovskiy

03:56 AM Database Feature #6582: implement multi-table AdaptiveQuery

Alexandru Lungu wrote:
> I've done a bit of query exploring. I converted the following example:
>
> [...]
>
> ... Igor Skornyakov

03:38 AM Database Feature #6582: implement multi-table AdaptiveQuery

I've done a bit of query exploring. I converted the following example:... Alexandru Lungu

07/24/2022

01:28 PM Database Feature #6582: implement multi-table AdaptiveQuery

Alexandru Lungu wrote:
> I was rather thinking if there are implications of @FIRST/LAST@ and @OUTER-JOIN@ when doing... Igor Skornyakov

06:06 AM Database Feature #6582: implement multi-table AdaptiveQuery

Eric Faulhaber wrote:
> The ideal scenario is that we start in preselect (fast) mode and we only ever transition to ... Alexandru Lungu

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

It looks that in migration of the PostgreSQL native UDFs to MariaDB the most efforts will require those UDFs that use... Igor Skornyakov

07/23/2022

01:50 PM Database Feature #6582: implement multi-table AdaptiveQuery

As far as I understand the approach described in #6582-9 works with MariaDB 10.2+ as well. Igor Skornyakov

07:44 AM Database Feature #6582: implement multi-table AdaptiveQuery

Alexandru Lungu wrote:
>Also, I didn't consider yet other aspects as: FIRST/LAST or OUTER-JOIN.
I can suggest the f... Igor Skornyakov

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

Eric Faulhaber wrote:
> Igor, can you think of a way to generate a list of the PostgreSQL built-in functions (includ... Igor Skornyakov

07/22/2022

06:07 PM Database Feature #6630: optimize return of table parameter

While working on a related issue I noticed the following stack trace:... Ovidiu Maxiniuc

05:55 PM Database Feature #6630 (Closed): optimize return of table parameter

Ovidiu Maxiniuc

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

Eric Faulhaber wrote:
> So far, so good...
>
> [...]
Please note the PostreSQL UDF raise both @ERROR@ and @NOT... Igor Skornyakov

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

So far, so good...... Eric Faulhaber

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

Eric Faulhaber wrote:
> Igor, can you think of a way to generate a list of the PostgreSQL built-in functions (includ... Igor Skornyakov

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

Eric Faulhaber wrote:
> Greg Shah wrote:
>
> > I suspect that error handling will be a problem.
>
> I guess yo... Eric Faulhaber

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

Eric Faulhaber wrote:
> What are the technical prerequisites a database implementation must have for word index su... Igor Skornyakov

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

Greg Shah wrote:
> I suspect that error handling will be a problem.
I guess you're right, based on the answers ... Eric Faulhaber

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

Igor, can you think of a way to generate a list of the PostgreSQL built-in functions (including signatures) upon whic... Eric Faulhaber

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

Igor Skornyakov wrote:
> Please note also that it is makes sense to check how the words tables' support can be porte... Eric Faulhaber

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

Looping in SQL can be simulated using "Common Table Expressions":https://en.wikipedia.org/wiki/Hierarchical_and_recur... Greg Shah

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

Please note also that it is makes sense to check how the words tables' support can be ported to MariaDB. Igor Skornyakov

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

We need a robust library of UDFs for MariaDB to represent 4GL built-in functions used in WHERE clauses, which referen... Eric Faulhaber

11:50 AM Database Feature #6628 (WIP): port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber

01:53 PM Conversion Tools Bug #6629: incremental conversion for OpenClient proxy programs

Incremental conversion for OpenClient proxy Java code is not possible at this time. If a 4GL program configured as p... Constantin Asofiei

01:50 PM Conversion Tools Bug #6629 (Test): incremental conversion for OpenClient proxy programs

Constantin Asofiei

12:07 PM Database Feature #6348: implement support for MariaDB

Greg Shah wrote:
> > Greg: I know Roger was keeping the documentation/license project up-to-date, but is there a wik... Ovidiu Maxiniuc

07:50 AM Database Feature #6348: implement support for MariaDB

> Greg: I know Roger was keeping the documentation/license project up-to-date, but is there a wiki with the steps nee... Greg Shah

04:00 AM Database Feature #6348: implement support for MariaDB

With 3821c/14095 change of build.gradle, this was added:... Constantin Asofiei

11:53 AM Runtime Infrastructure Support #5567: move FWD to Java 11

I did a whole lot of smoke testing on <app_c>. Most of the issue were pilot error where I forgot to change from Java ... Roger Borrello

11:46 AM Database Feature #6582: implement multi-table AdaptiveQuery

Alexandru Lungu wrote:
> I got the time to familiarize myself with @AdaptiveQuery@. I understood the motivation for ... Eric Faulhaber

10:41 AM Database Feature #6582: implement multi-table AdaptiveQuery

I got the time to familiarize myself with @AdaptiveQuery@. I understood the motivation for the "adaptive" part, but n... Alexandru Lungu

10:07 AM Database Feature #6582: implement multi-table AdaptiveQuery

Alexandru Lungu wrote:
> Eric Faulhaber wrote:
> > Alexandru, please review the existing @AdaptiveQuery@ implementa... Eric Faulhaber

09:17 AM Conversion Tools Bug #6627: improve conversion memory footprint for AstKey persistent maps

It is a good plan and a reasonable trade-off. Greg Shah

08:59 AM Conversion Tools Bug #6627: improve conversion memory footprint for AstKey persistent maps

There are these persistent (in the H2 conversion database) maps:... Constantin Asofiei

08:47 AM Conversion Tools Bug #6627 (Review): improve conversion memory footprint for AstKey persistent maps

Constantin Asofiei

07/21/2022

07:59 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Greg Shah wrote:
> Tomasz: It would be great if you post a list of the items to handle/consider when shifting a FWD ... Tomasz Domin

07:55 PM Runtime Infrastructure Support #5567: move FWD to Java 11

CTRL-C tests for 5567a + @5739-4.diff@ + @5737a.diff@ completed successfully on my local workstation, I've uploaded... Tomasz Domin

07:01 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Tomasz Domin wrote:
> > > Seems like @ctx = SSLContext.getInstance("TLSv1.2",...@ resolves the issue. Let me @10-15@... Tomasz Domin

06:55 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Greg Shah wrote:
> Questions for Tomasz:
>
> # Is this branch ready for wider testing? If so, I'd like to make a... Tomasz Domin

06:33 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Greg Shah wrote:
> > I'd like to code up a check on the Java version, and make the decision in the server.sh script... Roger Borrello

05:55 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Tomasz: It would be great if you post a list of the items to handle/consider when shifting a FWD installation from Ja... Greg Shah

05:53 PM Runtime Infrastructure Support #5567: move FWD to Java 11

I think so. Tomasz never mentioned this, but it wouldn't have been possible for any of our teammates to do testing o... Greg Shah

05:49 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Greg Shah wrote:
> Roger: After Tomasz has the latest changes checked in, please do a quick check of @<app_c>@.
T... Roger Borrello

05:16 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Roger: After Tomasz has the latest changes checked in, please do a quick check of @<app_c>@.
Tomasz: What is the s... Greg Shah

04:57 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Eugenie Lyzenko wrote:
> Eugenie Lyzenko wrote:
> > Tomasz,
> >
> > Seems like @ctx = SSLContext.getInstance("TL... Tomasz Domin

03:41 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Eugenie Lyzenko wrote:
> Tomasz,
>
> Seems like @ctx = SSLContext.getInstance("TLSv1.2",...@ resolves the issue. ... Eugenie Lyzenko

03:31 PM Runtime Infrastructure Support #5567: move FWD to Java 11

My tests for @<app_s>@ were done with this; I did not apply any other TLS patch, was done with 5567a as in rev 14102
... Constantin Asofiei

03:28 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Tomasz,
Seems like @ctx = SSLContext.getInstance("TLSv1.2",...@ resolves the issue. Let me @10-15@ min to test. Eugenie Lyzenko

03:22 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Eugenie Lyzenko wrote:
> Tomasz Domin wrote:
> > Eugenie Lyzenko wrote:
> > > No difference, same errors. I will t... Eugenie Lyzenko

03:21 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Tomasz Domin wrote:
> Constantin Asofiei wrote:
> > and syslog will show this:
> > [...]
>
> Check @ldd /opt/sp... Constantin Asofiei

03:10 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Constantin Asofiei wrote:
> and syslog will show this:
> [...]
Check @ldd /opt/spawner/spawn@
It should be:
<p... Tomasz Domin

03:01 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Tomasz Domin wrote:
> Constantin Asofiei wrote:
> > Tomasz, are you able to run the FWD web client in Hotel GUI, us... Constantin Asofiei

02:57 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Tomasz Domin wrote:
> Eugenie Lyzenko wrote:
> > No difference, same errors. I will try previous release of the @JD... Eugenie Lyzenko

02:51 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Eugenie Lyzenko wrote:
> No difference, same errors. I will try previous release of the @JDK11@.
My Java version
<... Tomasz Domin

02:36 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Eugenie Lyzenko wrote:
> Tomasz Domin wrote:
> > Eugenie Lyzenko wrote:
> > > Testing update:
> > >
> > > So I ... Eugenie Lyzenko

02:24 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Tomasz Domin wrote:
> Eugenie Lyzenko wrote:
> > Testing update:
> >
> > So I think only @NIO@ issue left here.
... Eugenie Lyzenko

02:24 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Constantin Asofiei wrote:
> Tomasz, are you able to run the FWD web client in Hotel GUI, using 5567a and Java 11?
... Tomasz Domin

02:16 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Constantin Asofiei wrote:
> Tomasz, are you able to run the FWD web client in Hotel GUI, using 5567a and Java 11?
... Tomasz Domin

02:11 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Tomasz, are you able to run the FWD web client in Hotel GUI, using 5567a and Java 11? Constantin Asofiei

02:07 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Eugenie Lyzenko wrote:
> Testing update:
>
> So I think only @NIO@ issue left here.
Please Try @5567-1.diff@
Tomasz Domin

01:54 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Testing update:
1. Compilation is OK.
2. The @Swing@ client works. I did some smoke tests with @app_m@ and found ... Eugenie Lyzenko

01:11 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Greg Shah wrote:
> Yes, we are testing 5567a which is rebased from 3821c rev 14087.
I'll update the environment a... Eugenie Lyzenko

01:02 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Yes, we are testing 5567a which is rebased from 3821c rev 14087. Greg Shah

01:01 PM Runtime Infrastructure Support #5567: move FWD to Java 11

> I had to switch TLS Context from TLS to TLSv3, Greg - was I allowed to do this ?
I don't have an objection, as l... Greg Shah

01:01 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Tomasz Domin wrote:
> Eugenie Lyzenko wrote:
> > The problems found in starting @app_m@ with @JDK11@:
> >
> Than... Eugenie Lyzenko

12:50 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Eugenie Lyzenko wrote:
> The problems found in starting @app_m@ with @JDK11@:
>
Thank you Eugenie.
> 1. The @F... Tomasz Domin

10:12 AM Runtime Infrastructure Support #5567: move FWD to Java 11

The problems found in starting @app_m@ with @JDK11@:
1. The @FWD@ can not be compiled with @Java 11@ (to be fixed)... Eugenie Lyzenko

09:06 AM Runtime Infrastructure Support #5567: move FWD to Java 11

Code review 5567a revisions 14099..14102. The changes look good. Hynek Cihlar

09:05 AM Runtime Infrastructure Support #5567: move FWD to Java 11

> I'd like to code up a check on the Java version, and make the decision in the server.sh script.
This is a good ... Greg Shah

09:04 AM Runtime Infrastructure Support #5567: move FWD to Java 11

If I understand correctly, the old way only works for Java 8 and the new way works for Java 9 and above. Greg Shah

09:03 AM Runtime Infrastructure Support #5567: move FWD to Java 11

Tomasz Domin wrote:
> Constantin Asofiei wrote:
> > What's the equivalent for @-Djava.ext.dirs=null:../lib/spi@ in ... Roger Borrello

08:13 AM Runtime Infrastructure Support #5567: move FWD to Java 11

Spawner fails:... Constantin Asofiei

08:00 AM Runtime Infrastructure Support #5567: move FWD to Java 11

Constantin Asofiei wrote:
> What's the equivalent for @-Djava.ext.dirs=null:../lib/spi@ in Java 11? I get this error... Tomasz Domin

07:54 AM Runtime Infrastructure Support #5567: move FWD to Java 11

What's the equivalent for @-Djava.ext.dirs=null:../lib/spi@ in Java 11? I get this error when starting @<app_s>@:
<p... Constantin Asofiei

06:54 AM Runtime Infrastructure Support #5567: move FWD to Java 11

Questions for Tomasz:
# Is this branch ready for wider testing? If so, I'd like to make a push on testing for thi... Greg Shah

05:44 AM Runtime Infrastructure Support #5567: move FWD to Java 11

This is great! When you have equivalent results, please report on the performance between Java 8 and 11. Greg Shah

11:54 AM User Interface Bug #6053: Widget realisation

Hynek Cihlar wrote:
> Igor, do you remember the test cases for which you needed the @canAccess@ method and @wasReali... Igor Skornyakov

03:08 AM Base Language Bug #6623: validate the memptr bytes in "copy-lob from memptr to clob/longchar" statement

According to https://knowledgebase.progress.com/articles/Article/P110518 , COPY-LOB will try to translate the memptr ... Constantin Asofiei

03:03 AM Base Language Bug #6623 (New): validate the memptr bytes in "copy-lob from memptr to clob/longchar" statement

Constantin Asofiei

07/20/2022

07:53 PM Database Feature #6348: implement support for MariaDB

A first revision of FWD with partial support for MariaDb dialect was committed in 14095:
* the build script will fet... Ovidiu Maxiniuc

08:20 PM Database Feature #6348: implement support for MariaDB

Some observations on data types resulted from the attempt to create a (partial) database from generated DDL for Maria... Ovidiu Maxiniuc

06:06 PM Runtime Infrastructure Support #5567: move FWD to Java 11

Found working regression test and p2j combination (rev *14087*).
Rebased to *14087* and pushed to *5567a*/*14102*
... Tomasz Domin

05:01 PM User Interface Bug #5622: TREEVIEW widget issues

Vladimir Tsichevski wrote:
> In FWD both icons and checkboxes are visible, but they are displayed the opposite order... Vladimir Tsichevski

12:51 PM User Interface Bug #5622: TREEVIEW widget issues

Vladimir Tsichevski wrote:
> In FWD both icons and checkboxes are visible, but they are displayed the opposite order... Vladimir Tsichevski

04:51 AM Database Bug #6577 (Review): move RecordBuffer.ooFields at the DMO meta

3821c/14090 - RecordBuffer instance fields can not be accessed directly from static methods - their getter must be us... Constantin Asofiei

07/19/2022

03:20 PM Database Feature #6418: represent extent fields as arrays

Downsides of the JSON approach:
* The syntax is pretty messy since you have to use functions to access/set element... Greg Shah

01:57 PM Database Feature #6418: represent extent fields as arrays

Eric Faulhaber wrote:
> AFAICT, MariaDB offers no native array data type which can be assigned to a column. The re... Eric Faulhaber

12:55 PM Database Feature #6584: implement schema hint which generates a POJO in addition to a DMO interface

Greg Shah wrote:
> This is a reasonable restriction. Let's just make sure the limitation is clearly documented.
I a... Ovidiu Maxiniuc

11:53 AM Database Feature #6584 (Review): implement schema hint which generates a POJO in addition to a DMO interface

Greg Shah wrote:
> I made some minor edits to the doc. Please review.
Thank you for your contribution. I moved t... Ovidiu Maxiniuc

08:41 AM Database Feature #6584: implement schema hint which generates a POJO in addition to a DMO interface

I made some minor edits to the doc. Please review. Greg Shah

08:36 AM Database Feature #6584: implement schema hint which generates a POJO in addition to a DMO interface

I took a quick look at the docs. It looks good. Please move it to here:
"Using POJOs for Database Entities":/pro... Greg Shah

09:14 PM Database Feature #6584: implement schema hint which generates a POJO in addition to a DMO interface

The documentation can be found at:
https://proj.goldencode.com/projects/timco/wiki/POJOs_-_Tutorial#section-8
I c... Ovidiu Maxiniuc

10:44 AM User Interface Bug #5118: TREELIST widget issues

Vladimir Tsichevski wrote:
> Vladimir Tsichevski wrote:
> > In original OCX, an attempt to remove the hidden tree r... Hynek Cihlar

07/18/2022

02:30 PM Database Feature #6371: implement SAVE CACHE statement

Constantin Asofiei wrote:
> There is a compile error in 3821c/14083:
> [...]
>
> Boris: when committing somethin... Boris Schegolev

09:50 AM Database Feature #6371: implement SAVE CACHE statement

There is a compile error in 3821c/14083:... Constantin Asofiei

12:50 PM Conversion Tools Bug #6612: Extent input-output arguments of functions are not correctly wrapped

The following 4GL code converts to Java code which doesn't compile.... Alexandru Lungu

12:46 PM Conversion Tools Bug #6612 (New): Extent input-output arguments of functions are not correctly wrapped

Alexandru Lungu

12:28 PM Database Bug #5673: Additional support for INDEXED REPOSITION open query attribute

The issue which required support for @INDEXED-REPOSITION@ was using a @REPOSITION-TO-ROWID@. I can't recall if this w... Alexandru Lungu

12:06 PM User Interface Bug #5622: TREEVIEW widget issues

In FWD both icons and checkboxes are visible, but they are displayed the opposite order:
In OE icons are right fro... Vladimir Tsichevski

10:40 AM User Interface Bug #6607: OCX: Implement comparison of OCX object references with 0 (zero) integer

> But still if it is formally valid 4GL code we should conform to that.
Yes, let's solve this once. Greg Shah

10:10 AM User Interface Bug #6607: OCX: Implement comparison of OCX object references with 0 (zero) integer

Vladimir Tsichevski wrote:
> Hynek Cihlar wrote:
> > Vladimir Tsichevski wrote:
> > > In OE, it is possible to tes... Hynek Cihlar

10:00 AM User Interface Bug #6607: OCX: Implement comparison of OCX object references with 0 (zero) integer

Hynek Cihlar wrote:
> Vladimir Tsichevski wrote:
> > In OE, it is possible to test if an COM object is valid by com... Vladimir Tsichevski

09:55 AM User Interface Bug #6607: OCX: Implement comparison of OCX object references with 0 (zero) integer

Vladimir Tsichevski wrote:
> In OE, it is possible to test if an COM object is valid by comparing object references ... Hynek Cihlar

09:10 AM User Interface Bug #6607: OCX: Implement comparison of OCX object references with 0 (zero) integer

In OE, it is possible to test if an COM object is valid by comparing object references returned by COM calls with 0 (... Vladimir Tsichevski

09:02 AM User Interface Bug #6607 (New): OCX: Implement comparison of OCX object references with 0 (zero) integer

Vladimir Tsichevski

08:12 AM Base Language Bug #6555 (Closed): SECURITY-POLICY:SET-CLIENT fails with an imported CLIENT-PRINCIPAL

Greg Shah wrote:
> Constantin: Are you OK with the change?
The changes are OK and solves the #6531 problem. I'm clo... Constantin Asofiei

07:56 AM Base Language Bug #6555: SECURITY-POLICY:SET-CLIENT fails with an imported CLIENT-PRINCIPAL

Greg Shah wrote:
> Igor: Is there anything else to do in this task?
I don't think so.
Igor Skornyakov

07:48 AM Base Language Bug #6555: SECURITY-POLICY:SET-CLIENT fails with an imported CLIENT-PRINCIPAL

Constantin: Are you OK with the change?
Igor: Is there anything else to do in this task? Greg Shah

04:59 AM Database Feature #6584: implement schema hint which generates a POJO in addition to a DMO interface

In 3821c/14082 I've added support for Java enums and, if there is no FWD serializer registered for the given type, de... Constantin Asofiei

02:54 AM User Interface Bug #6053: Widget realisation

A relevant info, #6523-29. Hynek Cihlar

07/17/2022

11:03 AM Runtime Infrastructure Feature #5776: reduce memory requirements for the FWD client

If I understand correctly, we are good to go with the proposed change. Is there any reason to *not* commit this? Greg Shah

07/16/2022

05:49 PM Database Feature #6348 (WIP): implement support for MariaDB

Started adding support for the new database by implementation of the @MariaDbDialect.java@. On Monday I will continue... Ovidiu Maxiniuc

07/15/2022

03:35 PM Database Feature #6584: implement schema hint which generates a POJO in addition to a DMO interface

Constantin,
I know you worked with JSON probably more than any of us. Do you have an API which serialize a POJOs an... Ovidiu Maxiniuc

01:38 PM Database Feature #6584: implement schema hint which generates a POJO in addition to a DMO interface

I committed the (final ?) version of the POJO/DMO marshalling solution. Revision is 14075.
To summarize:
* the PO... Ovidiu Maxiniuc

09:13 AM Database Feature #6584: implement schema hint which generates a POJO in addition to a DMO interface

Constantin Asofiei wrote:
> I don't think is OK to be using the SQL types:
> * date/datetime/datetime-tz should all... Ovidiu Maxiniuc

01:50 PM User Interface Feature #6604: Complete support for list-items/list-item-pairs for combo-box as part of the brows...

Regarding implementation, read #6598-25. Stanislav Lomany

08:40 AM User Interface Bug #6605: OCX property assignment conversion error

The following line assigns the @Selected@ property of an OCX object @node@:... Vladimir Tsichevski

08:32 AM User Interface Bug #6605 (New): OCX property assignment conversion error

Vladimir Tsichevski

12:14 AM Database Feature #6574 (Closed): auto-detect native UDFs at server startup and install them if missing

The changes in 3821c/14066 look good.
Note: to ensure missing native UDFs are installed, entries for @admin_userna... Eric Faulhaber