FWD

05/26/2021

08:23 PM Database Support #5183: database collation

I've reviewed the output of the @cp_coll.p@ program from several environments:
* en_US / 8859-1
** Linux
** Wind... Eric Faulhaber

05/25/2021

03:53 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

The functionality is implemented and tested with the test app. Will test with the real customer app.
Committed to ... Igor Skornyakov

03:22 PM Runtime Infrastructure Feature #4405: provide the capability to deliver static HTML and resources via the FWD server's J...

Sergey: Please edit the "Web Server":/projects/p2j/wiki/Web_Server page to clarify these questions:
* What is @web... Greg Shah

11:33 AM User Interface Bug #5118: TREELIST widget issues

Vladimir Tsichevski wrote:
> In the original @TREELIST@ it is possible to reset column sorting by clicking on the co... Vladimir Tsichevski

08:58 AM Runtime Infrastructure Support #5221: Initialization failure during server runtime

Deividas: Is everything working? I'd like to close this task if it is resolved. Greg Shah

07:30 AM User Interface Bug #5214: Broken z-order for all driver widgets (including SPREADSHEET, HTML-BROWSER, etc.)

Replaced the HTML-BROWSER with a SPREADSHEET in my testcase and the result is as expected. I will try to look into a ... Adrian Lungu

05/24/2021

07:28 PM User Interface Bug #5118: TREELIST widget issues

In FWD, if a child node is added, and a sorting by some column is set, nodes are automatically sorted. In the origina... Vladimir Tsichevski

07:23 PM User Interface Bug #5118: TREELIST widget issues

In FWD, if a child node is added, the parent node always expands. In the original OCX this does not happen. Vladimir Tsichevski

07:19 PM User Interface Bug #5118: TREELIST widget issues

Unimplemented OCX call: @GetNodeVisibleInViewPort@. This call return value of the @logical@ type is used in customer ... Vladimir Tsichevski

07:16 PM User Interface Bug #5118: TREELIST widget issues

FIXED in rev. 12481
Narrow column alignment is incorrect in FWD: in original OCX, it the column text does not fit ... Vladimir Tsichevski

02:56 PM User Interface Bug #5118: TREELIST widget issues

FIXED in rev. 12481
Rendering trelist icon columns: in FWD icons are always centered regardless of the column alig... Vladimir Tsichevski

11:43 AM User Interface Bug #5118: TREELIST widget issues

No, but I don't want to remove stuff that will need to be added back later. Greg Shah

11:37 AM User Interface Bug #5118: TREELIST widget issues

Greg Shah wrote:
> Our intention is to have a completed and compatible OCX replacement. We don't want to have to ad... Vladimir Tsichevski

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

Our intention is to have a completed and compatible OCX replacement. We don't want to have to add features with ever... Greg Shah

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

Vladimir Tsichevski wrote:
> Hynek Cihlar wrote:
> > > There is no such method in @vmacmtree1@.
> >
> > There is... Hynek Cihlar

08:03 AM User Interface Bug #5118: TREELIST widget issues

Hynek Cihlar wrote:
> Vladimir Tsichevski wrote:
> > Hynek Cihlar wrote:
> >
> > > If there is an API method in ... Vladimir Tsichevski

05:09 PM User Interface Bug #5383: The web client deadlock

The web client deadlock was found in #5028-35, #5028-44 ... Sergey Ivanovskiy

05:01 PM User Interface Bug #5383 (New): The web client deadlock

Sergey Ivanovskiy

10:59 AM User Interface Bug #5214: Broken z-order for all driver widgets (including SPREADSHEET, HTML-BROWSER, etc.)

Adrian Lungu wrote:
> I checked a custom testcase and can't reproduce anything suspicious. I used 3821c/rev. 12446 a... Hynek Cihlar

10:52 AM User Interface Bug #5214: Broken z-order for all driver widgets (including SPREADSHEET, HTML-BROWSER, etc.)

I checked a custom testcase and can't reproduce anything suspicious. I used 3821c/rev. 12446 and the attached files. ... Adrian Lungu

09:15 AM User Interface Bug #5214 (WIP): Broken z-order for all driver widgets (including SPREADSHEET, HTML-BROWSER, etc.)

Adrian Lungu

05/23/2021

06:28 PM User Interface Support #2674: list of HTML5, CSS and Javascript features in use in the web client (both ChUI and...

h2. Web Client Known Limitations
1. Browser shortcuts such as @ALT-F4@ cannot be captured as events. This means t... Greg Shah

01:39 PM User Interface Bug #5118: TREELIST widget issues

Vladimir Tsichevski wrote:
> Hynek Cihlar wrote:
>
> > If there is an API method in the original treeview and tre... Hynek Cihlar

05/22/2021

01:54 PM User Interface Bug #5118: TREELIST widget issues

Hynek Cihlar wrote:
> If there is an API method in the original treeview and treelist native controls to toggle so... Vladimir Tsichevski

05/21/2021

06:24 PM User Interface Bug #5381: Backing buffers should be filled in SELECT* functions of a multi-selection BROWSE

Testcases attached. When one of the @SELECT*@ browse functions is called, it should reposition the browsed query to t... Stanislav Lomany

06:12 PM User Interface Bug #5381 (New): Backing buffers should be filled in SELECT* functions of a multi-selection BROWSE

Stanislav Lomany

05:20 PM User Interface Bug #5118: TREELIST widget issues

Vladimir Tsichevski wrote:
> Hynek,
>
> there is the following field in @TreeConfig@
> [...]
>
> It seems, th... Hynek Cihlar

05:15 PM User Interface Bug #5118: TREELIST widget issues

FIXED
In the original @TREELIST@ it is possible to reset column sorting by clicking on the column header with the ... Vladimir Tsichevski

05:06 PM User Interface Bug #5118: TREELIST widget issues

Hynek,
there is the following field in @TreeConfig@... Vladimir Tsichevski

04:46 PM User Interface Bug #5118: TREELIST widget issues

Scrollbar visibility and (sometimes) displayed values are wrong:
@WrongHorizontalScrollbar.mp4@
In this video a... Vladimir Tsichevski

03:51 PM User Interface Bug #5118: TREELIST widget issues

Tree element positions differs from the original:
In original tree the horizontal distance between the columns (ve... Vladimir Tsichevski

01:39 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> That being said, I'm not sure that code looks right now...what if we had two @database@ keys... Igor Skornyakov

01:33 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

That being said, I'm not sure that code looks right now...what if we had two @database@ keys mapped to the same @Sess... Eric Faulhaber

01:13 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> The current @deregisterDatabase@ code is just about cleaning up local data structures when a... Igor Skornyakov

01:12 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

The current @deregisterDatabase@ code is just about cleaning up local data structures when a database connection ends... Eric Faulhaber

01:05 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > As far as I understand the same logic is used for local data... Igor Skornyakov

01:02 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> As far as I understand the same logic is used for local databases as well. Should I fix i... Eric Faulhaber

12:56 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> IIRC, for remote connections, we create one virtual session between server A and server B, r... Igor Skornyakov

12:40 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

IIRC, for remote connections, we create one virtual session between server A and server B, regardless of how many use... Eric Faulhaber

06:51 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

I'm confused with the following code in the @ConnectionManager.disconnectImmediately()@:... Igor Skornyakov

03:04 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Constantin Asofiei wrote:
> Igor, as I mentioned - Agents can reset their context (for State-reset mode) - in this c... Igor Skornyakov

02:01 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor, as I mentioned - Agents can reset their context (for State-reset mode) - in this case, I think these databases ... Constantin Asofiei

01:07 PM Base Language Feature #4350: method overload when they differ by a temp-table, dataset, buffer or object or ext...

Greg Shah wrote:
> I've noticed that @convert_member_name@ in @annotations_prep.xml@ is only ever called with @mtype... Constantin Asofiei

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

I've noticed that @convert_member_name@ in @annotations_prep.xml@ is only ever called with @mtype == names.method@. ... Greg Shah

12:46 PM Database Support #5183 (WIP): database collation

Eric Faulhaber

05/20/2021

05:29 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Initialization of the transient auto-connected databases in @StandardServer.standardEntry()@ (before @startupProc@ p... Igor Skornyakov

02:19 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> Constantin: How do we avoid the @StandardServer.standardEntry()@ connection logic when it is call... Constantin Asofiei

02:17 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Constantin, where would the disconnect occur? I don't think @ContextLocal.cleanup@ would wor... Constantin Asofiei

02:00 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Constantin: How do we avoid the @StandardServer.standardEntry()@ connection logic when it is called for an appserver ... Greg Shah

02:00 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> But to your question: Constantin was answering in the context of appserver agents. For non... Eric Faulhaber

01:59 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> But to your question: Constantin was answering in the context of appserver agents. For non-a... Igor Skornyakov

01:57 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > Igor Skornyakov wrote:
> >
> > > Eric: is it correct that the... Eric Faulhaber

01:51 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > Eric: is it correct that the entry point mentioned by Consta... Igor Skornyakov

01:48 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> Eric: is it correct that the entry point mentioned by Constantin is the only one where th... Eric Faulhaber

01:29 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Constantin Asofiei wrote:
> Greg Shah wrote:
> > Constantin: Is there a different entry point for appserver agents?... Igor Skornyakov

01:27 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Igor, I would follow Greg's advice here instead of my earlier comments on the @SessionListen... Igor Skornyakov

01:26 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> I don't object to the non-database changes in @BaseSession@. But I wonder if we need such a thin... Igor Skornyakov

01:24 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> Constantin: Is there a different entry point for appserver agents?
In case of appserver Agents, ... Constantin Asofiei

01:21 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> Instead of looking at the session level stuff (which is generic), please look at the places in ... Eric Faulhaber

01:18 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

> How can we avoid any changes at least in the @RouterSessionManager@ if the databases are supposed to be connected o... Greg Shah

01:18 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

The way I would approach this would be to:
# Take a working, test configuration which currently connects a databas... Eric Faulhaber

01:11 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> I think you were on the right track with using the @SessionListener@ interface. If we find b... Igor Skornyakov

01:10 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> Greg Shah wrote:
> > There should not be any changes in the @com.goldencode.p2j.net@ packa... Eric Faulhaber

12:54 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> There should not be any changes in the @com.goldencode.p2j.net@ package. It is not appropriate t... Igor Skornyakov

12:43 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> There should not be any changes in the @com.goldencode.p2j.net@ package. It is not appropriate t... Igor Skornyakov

12:42 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

There should not be any changes in the @com.goldencode.p2j.net@ package. It is not appropriate to have database-spec... Greg Shah

12:28 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> It is hard to know what is going on without seeing the changes you've made. If they are most... Igor Skornyakov

12:21 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

It is hard to know what is going on without seeing the changes you've made. If they are mostly isolated to @DatabaseM... Eric Faulhaber

11:05 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

I've implemented the session-local databases' activation in the @SessionListener.initialize()@ method of the @Session... Igor Skornyakov

09:49 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

From Igor via email:
---
At this moment I've implemented most of the functionality except timed meta-database d... Eric Faulhaber

05/19/2021

02:26 PM User Interface Bug #5118: TREELIST widget issues

FIXED
Vladimir Tsichevski wrote:
> Another issue regarding @SORTED-COLUMNS@.
>
> Calling @TreeListWidget.setSo... Vladimir Tsichevski

01:47 PM User Interface Bug #5118: TREELIST widget issues

FIXED in rev. 12481
The first tree column is rendered and active outside its bounds!
See the @5118-34.mp4@ vide... Vladimir Tsichevski

01:00 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

I agree. The disabled code related to Hibernate can be dropped at this moment.
Ovidiu Maxiniuc

12:23 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > These were left over from the shift from Hibernate. I think at t... Eric Faulhaber

12:15 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Igor Skornyakov wrote:
> > When I'm trying to connect to a database in the session start (i... Igor Skornyakov

12:15 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> These were left over from the shift from Hibernate. I think at this point, they can be remov... Igor Skornyakov

12:08 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> When I'm trying to connect to a database in the session start (in my case it was a connecti... Eric Faulhaber

12:06 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> There is a lot of commented code in the @DatabaseManager@. This makes reading and understan... Eric Faulhaber

10:10 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eric: Did you ever test the Enterprise version of GraalVM? Greg Shah

03:31 AM Base Language Feature #4384: Builtin OO Implementation

Trying some 4GL code for the same and how it gets converted guess the easiest is to simply not use any 'local' variab... Marian Edu

03:16 AM Base Language Feature #4384: Builtin OO Implementation

Greg Shah wrote:
> Branch 4384j was merged into branch 3821c as revision 12363.
>
> Created new branch 4384k from... Marian Edu

05/18/2021

06:47 PM User Interface Bug #5118: TREELIST widget issues

FIXED in rev. 12481
Text cell value are left-trimmed in FWD. They should not. Vladimir Tsichevski

03:13 PM User Interface Bug #5118: TREELIST widget issues

FIXED
There is also an unimplemented "icon column datatype" feature described in #5282-5. Vladimir Tsichevski

01:42 PM User Interface Bug #5118: TREELIST widget issues

Vladimir Tsichevski wrote:
> Another issue described first in #5282: the node value can be of a type other than @Str... Vladimir Tsichevski

12:43 PM User Interface Bug #5118: TREELIST widget issues

The problem in #5118-19 is true for other calls, for example, for at least the last two arguments of @SetCellIconValu... Vladimir Tsichevski

12:31 PM User Interface Bug #5118: TREELIST widget issues

Another issue: scrolling by mouse wheel does not work: with Swing the tree can usually be scrolled by at most one row... Vladimir Tsichevski

12:08 PM User Interface Bug #5118 (WIP): TREELIST widget issues

Vladimir Tsichevski

12:08 PM User Interface Bug #5118: TREELIST widget issues

FIXED
Another issue described first in #5282: the node value can be of a type other than @String@.
As the result,... Vladimir Tsichevski

05/17/2021

06:47 PM Database Bug #5377: H2 might block in certain conditions

The investigations from #4479 proved that some methods were not correctly handling locking on its internal @meta@ tab... Ovidiu Maxiniuc

06:38 PM Database Bug #5377 (New): H2 might block in certain conditions

Ovidiu Maxiniuc

06:14 PM Database Bug #5376: Reintroduce UDFs for handling special date-related operators

The investigation from #5325 lead to conclusion that in the current revision FWD lacks support for some @+@ / @-@ ope... Ovidiu Maxiniuc

05:28 PM Database Bug #5376 (New): Reintroduce UDFs for handling special date-related operators

Ovidiu Maxiniuc

03:06 PM User Interface Bug #5375: Window resizing by mouse dragging problem in WEB client

See the @5375.mp4@ video. After mouse button is released, the mouse position seems to return to that when the mouse b... Vladimir Tsichevski

02:59 PM User Interface Bug #5375 (New): Window resizing by mouse dragging problem in WEB client

Vladimir Tsichevski

08:44 AM User Interface Bug #5373: BROWSE issues when QUERY is re-assigned to different buffers, and the original buffers...

I'm moving this to the UI project snce the behavior is primarily (perhaps only) associated with @BROWSE@. Greg Shah

07:41 AM User Interface Bug #5373: BROWSE issues when QUERY is re-assigned to different buffers, and the original buffers...

In OpenEdge, a static BROWSE can have its query changed, and this query can uses different buffers (for which their t... Constantin Asofiei

07:29 AM User Interface Bug #5373 (New): BROWSE issues when QUERY is re-assigned to different buffers, and the original b...

Constantin Asofiei

05/15/2021

06:19 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

When I'm trying to connect to a database in the session start (in my case it was a connection from the application se... Igor Skornyakov

05/14/2021

06:18 PM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

FWD complains on the very first test with @Incompatible datatypes found during runtime conversion. (5729)@... Roger Borrello

06:07 PM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

Here is the completed testcase, along with the expected outcomes. Checked in as @uast/compare_various_buffer-values.p... Roger Borrello

12:27 PM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

Now try with int, logical, decimal, character, etc fields. Constantin Asofiei

12:20 PM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

This testcase:... Roger Borrello

10:54 AM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

Roger, I think for the POLY case 4GL doesn't convert the right operand to the left operand's type.
We currently fo... Constantin Asofiei

10:52 AM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

The 4GL doesn't make a conversion of the @"today"@ string to a date when performing the comparison, so @h:buffer-fiel... Roger Borrello

06:13 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

There is a lot of commented code in the @DatabaseManager@. This makes reading and understanding the code difficult. D... Igor Skornyakov

11:52 AM Build and Source Control Bug #5371: All aspects from p2j.jar applied to project builds indiscriminately

At least when I build my testcases, I get the following:... Roger Borrello

11:47 AM Build and Source Control Bug #5371 (New): All aspects from p2j.jar applied to project builds indiscriminately

Roger Borrello

09:36 AM User Interface Bug #5363 (Closed): Incorrect initial value in lastkey

Greg Shah

05/13/2021

05:24 PM User Interface Bug #5118: TREELIST widget issues

FIXED. Another issue regarding @SORTED-COLUMNS@.
Calling @TreeListWidget.setSortedColumns(NumberType value)@ cause... Vladimir Tsichevski

01:35 PM User Interface Bug #5363: Incorrect initial value in lastkey

I don't know. But my history entry may not have been referring to the default value at startup. Greg Shah

12:06 PM User Interface Bug #5363 (Feedback): Incorrect initial value in lastkey

Committed in rev 12413. I was trying to figure out why @F1@ would be the initial value, especially with your comment ... Roger Borrello

11:55 AM User Interface Bug #5363: Incorrect initial value in lastkey

I have no objection to the change. You can put it in 3821c. Greg Shah

11:26 AM User Interface Bug #5363: Incorrect initial value in lastkey

Testcase @uast/messages_test.p@ illustrates we have the incorrect initial value in @lastkey@ (which is set in the @Ke... Roger Borrello

11:03 AM User Interface Bug #5363 (Closed): Incorrect initial value in lastkey

Roger Borrello

07:26 AM Runtime Infrastructure Bug #5362: Handshake failure while testing the simple web cllient

If this is non-fatal, then perhaps we should reduce the logging level so that it is only seen when there is a more de... Greg Shah

07:25 AM Runtime Infrastructure Bug #5362: Handshake failure while testing the simple web cllient

From Igor:
> I've not seen this, but, as far as I remember, in such situation a new SSL handshake will be initiate... Greg Shah

07:25 AM Runtime Infrastructure Bug #5362: Handshake failure while testing the simple web cllient

From Sergey:
> Could you observe the same exceptions while working with the web client?
>
> ... Greg Shah

05/12/2021

07:41 PM Runtime Infrastructure Bug #5362 (Closed): Handshake failure while testing the simple web cllient

Sergey Ivanovskiy

03:18 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Since we are rewriting this logic now, I think we should plan for this eventuality. I tried ... Igor Skornyakov

03:15 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> At this moment we initialize the meta-database for all configured local databases regardl... Eric Faulhaber

02:36 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> The concept of "transient" databases is old and is not really something I care to preserve. ... Igor Skornyakov

02:21 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

The concept of "transient" databases is old and is not really something I care to preserve. It was developed back whe... Eric Faulhaber

01:24 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

I'm trying to understand the logic around reference counting with @DatabseManager.transientDatabases@. It looks prett... Igor Skornyakov

04:23 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> Actually, we really do implement this same limit. Our parser will not properly parse database re... Igor Skornyakov

08:05 PM Conversion Tools Feature #4076: remove empty triggers during conversion

> Maybe I am too evil-ish but a similar scenario can happen when an unexpected procedure is called because the design... Greg Shah

05/11/2021

06:57 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Actually, we really do implement this same limit. Our parser will not properly parse database references unless the ... Greg Shah

06:30 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

> > BTW: how do we support this restriction? It looks weird to me.
> I do not think we do. FWD connects the database... Greg Shah

05:59 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Ovidiu Maxiniuc wrote:
> Sorry, I am afraid I was not very clear here. What I intended to say is that FWD does not s... Igor Skornyakov

05:30 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> Ovidiu Maxiniuc wrote:
> > Igor Skornyakov wrote:
> > > BTW: how do we support this restr... Ovidiu Maxiniuc

05:21 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric/Greg.
At this moment we initialize the meta-database for all configured local databases regardless of the @lo... Igor Skornyakov

05:06 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > BTW: how do we support this restriction? It looks weird to me.
... Igor Skornyakov

05:02 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> BTW: how do we support this restriction? It looks weird to me.
I do not think we do. FWD c... Ovidiu Maxiniuc

04:37 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Ovidiu Maxiniuc wrote:
> Just as a remainder, although you are probably already aware of this: you cannot use the da... Igor Skornyakov

04:34 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

These things happen. I did this myself and not even once.
Just as a remainder, although you are probably already a... Ovidiu Maxiniuc

04:25 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> Ovidiu Maxiniuc wrote:
> > I was looking at the last line of exception you posted. It says... Igor Skornyakov

04:16 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Ovidiu Maxiniuc wrote:
> I was looking at the last line of exception you posted. It says: @org.h2.jdbc.JdbcSQLSyntax... Igor Skornyakov

04:15 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

I was looking at the last line of exception you posted. It says: @org.h2.jdbc.JdbcSQLSyntaxErrorException@.
Yet, H2 ... Ovidiu Maxiniuc

04:09 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Ovidiu Maxiniuc wrote:
> Igor,
> Does the database already exist? Because if there is no physical file at the mome... Igor Skornyakov

04:05 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor,
Does the database already exist? Because if there is no physical file at the moment the connection is made, H... Ovidiu Maxiniuc

03:44 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

It seems that at this moment a @CONNECT@ statement support for the local databases is broken.
For example, if the @h... Igor Skornyakov

06:34 PM Database Bug #4945 (Feedback): Optimize indexes for H2 dialect

My changes were committed to a newly created bzr repository located at @devsrv01:/opt/secure/code/p2j_repo/fwd-h2/@, ... Ovidiu Maxiniuc

06:15 PM Conversion Tools Feature #4076: remove empty triggers during conversion

In my initial implementation of schema triggers, the linking between the event and the invoked trigger class/method w... Ovidiu Maxiniuc

03:43 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

See attached. Constantin Asofiei

02:59 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Constantin,
Do you use discrete GPU or integrated in CPU?
Can you please publish chrome://gpu content? Here or ... Eugenie Lyzenko

02:14 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Constantin Asofiei wrote:
> The screen is opening in ~3.2 seconds on Chrome Version 90.0.4430.85 (Official Build) un... Eugenie Lyzenko

02:04 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

The screen is opening in ~3.2 seconds on Chrome Version 90.0.4430.85 (Official Build) unknown (64-bit).
I haven't ... Constantin Asofiei

11:18 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Constantin,
What timing do you have for sample screen opening with remote system?
I still think the result is s... Eugenie Lyzenko

10:27 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

> Greg: for the remote system, as this is accessed over the internet, I wonder how much impact the network transfer h... Greg Shah

10:12 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Constantin Asofiei wrote:
> Eugenie: in your 'bare metal system' case, do you run the web client there, too?
>
... Eugenie Lyzenko

10:08 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eugenie: in your 'bare metal system' case, do you run the web client there, too?
Greg: for the remote system, as t... Constantin Asofiei

10:01 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Greg Shah wrote:
> The customer is probably testing based on the DOWN event since the user's perception is that at t... Eugenie Lyzenko

09:00 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

The customer is probably testing based on the DOWN event since the user's perception is that at that moment they have... Greg Shah

08:57 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Greg Shah wrote:
> > 2. The time started just after click mouse on screen initiation.
>
> Why "just after"? This... Eugenie Lyzenko

08:44 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

> 2. The time started just after click mouse on screen initiation.
Why "just after"? This will introduce a bias t... Greg Shah

08:26 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eugenie Lyzenko wrote:
> Greg Shah wrote:
> > Yes, please do.
>
> OK. I'm stopping the server for set it up.
... Eugenie Lyzenko

07:56 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Greg Shah wrote:
> Yes, please do.
OK. I'm stopping the server for set it up. Eugenie Lyzenko

07:38 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Yes, please do. Greg Shah

03:10 PM Database Bug #5306: AdaptiveQuery sets a found record into the buffer twice in dynamic mode

I have investigated this issue but I cannot reproduce it. I took the isolated testcase from #3814-406, converted and ... Ovidiu Maxiniuc

07:14 AM User Interface Bug #5357 (Closed): SPREADSHEET widget abends with invalid format

Greg Shah

02:57 AM User Interface Bug #5357 (Feedback): SPREADSHEET widget abends with invalid format

Hynek Cihlar

02:57 AM User Interface Bug #5357: SPREADSHEET widget abends with invalid format

The Keikai ticket for this issue is https://potix.freshdesk.com/support/tickets/12479. They suggest to trim the white... Hynek Cihlar

05/10/2021

06:45 PM User Interface Bug #5357: SPREADSHEET widget abends with invalid format

On 5/11/21 12:37 AM, Hynek Cihlar wrote:
>
> Hello Jean,
>
> thank you for the update.
>
> We have one issue, w... Hynek Cihlar

06:44 PM User Interface Bug #5357 (Closed): SPREADSHEET widget abends with invalid format

Hynek Cihlar

05:29 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Greg Shah wrote:
> The enterprise edition is supposed to have some extra optimizations. We also have not yet tested... Eugenie Lyzenko

05:08 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Greg Shah wrote:
> The enterprise edition is supposed to have some extra optimizations. We also have not yet tested... Eugenie Lyzenko

04:10 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

The enterprise edition is supposed to have some extra optimizations. We also have not yet tested the benefits of AOT... Greg Shah

03:48 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eric Faulhaber wrote:
> That is a bit surprising. Which VM were we using when I first tested (May 5)?
@AdoptOpenJ... Eugenie Lyzenko

03:47 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

That is a bit surprising. Which VM were we using when I first tested (May 5)? Eric Faulhaber

03:31 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Well, a kind of surprise for me.
Case 1 - @GraalVM CE 21.1.0@
Case 2 - @AdoptOpenJDK 1.8.0_292-b10@ Eugenie Lyzenko

03:24 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Case 2 Results:
Same browser, same test procedure. I didn't notice any dramatic difference with this VM. After war... Eric Faulhaber

03:07 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eric Faulhaber wrote:
> Case 1 Results:
>
> Using Chrome (same set up as before, no config changes), I logged on ... Eugenie Lyzenko

02:59 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Case 1 Results:
Using Chrome (same set up as before, no config changes), I logged on and opened every screen from ... Eric Faulhaber

02:19 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eric Faulhaber wrote:
> Eugenie Lyzenko wrote:
>
> > It is ready for fast switch (5-10 min including server resta... Eugenie Lyzenko

02:09 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eugenie Lyzenko wrote:
> It is ready for fast switch (5-10 min including server restart).
OK, let's do a blind ... Eric Faulhaber

01:43 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eugenie Lyzenko wrote:
> Greg Shah wrote:
> > Eugenie: Please do whatever setup is needed in the VM so that you can... Eugenie Lyzenko

01:28 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Greg Shah wrote:
> Eugenie: Please do whatever setup is needed in the VM so that you can easily switch between OpenJ... Eugenie Lyzenko

01:23 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eugenie: Please do whatever setup is needed in the VM so that you can easily switch between OpenJDK and GraalVM. Onc... Greg Shah

01:01 PM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

I've made some additional testing and benchmarking for Java versions. Especially comparing @AdoptOpenJDK@ I used befo... Eugenie Lyzenko

03:40 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> > Actually, my question was not about the name but if you're planning to implement auto-conn... Igor Skornyakov

03:38 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> Actually, my question was not about the name but if you're planning to implement auto-con... Eric Faulhaber

03:30 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Greg Shah wrote:
>
> > Change the name of the directory node in the new configuration to ... Igor Skornyakov

03:27 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> Change the name of the directory node in the new configuration to make it less confusing.
I ... Eric Faulhaber

03:22 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

At this time, we don't care about this "auto-connect" 4GL feature at all. It has nothing to do with our work and can... Greg Shah

02:44 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> This looks not exactly the same we've discussed here. Is this difference intentional?
... Eric Faulhaber

02:18 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

As I can see in the OpenEdge documentation (https://docs.progress.com/bundle/openedge-programmimg-interfaces-117/page... Igor Skornyakov

09:15 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> Greg Shah wrote:
> > No. In my opinion, this is not a very risky change. If you disagree... Greg Shah

08:28 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> No. In my opinion, this is not a very risky change. If you disagree, please help us understand ... Igor Skornyakov

08:08 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

No. In my opinion, this is not a very risky change. If you disagree, please help us understand what parts are risky. Greg Shah

08:02 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> Don't get hung up on this aspect of things. The helper methods for lookup in the directory will ... Igor Skornyakov

07:54 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

> But in your examples, we have only one configuration.
His example is the equivalent of the current approach whi... Greg Shah

02:25 PM Database Feature #5355: _Usertablestat metadata improvements

Eric Faulhaber wrote:
> Support for this VST was mostly implemented in #3814, however a few things remain to be addr... Igor Skornyakov

01:43 PM Database Feature #5355: _Usertablestat metadata improvements

Regarding the temp-table support, there are cases where conversion optimizes 4GL code which deletes temp-table record... Eric Faulhaber

01:32 PM Database Feature #5355: _Usertablestat metadata improvements

Support for this VST was mostly implemented in #3814, however a few things remain to be addressed:
* add update co... Eric Faulhaber

01:25 PM Database Feature #5355 (WIP): _Usertablestat metadata improvements

Eric Faulhaber

01:34 PM Database Feature #3814 (Closed): more schema metadata

Any remaining work related to the @_Usertablestat@ VST will be managed in #5355. Eric Faulhaber

11:36 AM Base Language Bug #5296: output parameters are cleared if an argument is another function call

I think the @wrap@ methods for the field, property and other cases should return a BDT anon-class which overrides a @... Constantin Asofiei

06:10 AM Base Language Bug #5296: output parameters are cleared if an argument is another function call

Greg, I remembered the reason why this @wrap@ was needed and the registration was done at the caller, and not the def... Constantin Asofiei

05/09/2021

03:56 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > My question was about the session attribute the selection of... Igor Skornyakov

05/08/2021

06:06 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> My question was about the session attribute the selection of the connection profile shoul... Eric Faulhaber

02:26 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Igor Skornyakov wrote:
> It is up to the person who configures the directory for a given pr... Igor Skornyakov

02:08 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> Eric, thank you very much for the detailed explanations.
You're welcome.
> However,... Eric Faulhaber

09:45 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Let's take a step back and focus on the actual goal of this task, which is not so much about... Igor Skornyakov

05/07/2021

05:59 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Let's take a step back and focus on the actual goal of this task, which is not so much about partitioned applications... Eric Faulhaber

01:40 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

It is difficult to follow the discussion in #2475. It seems that it is mostly about conversion.
Here is my underst... Igor Skornyakov

01:01 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Any work done so far on this concept is in #2475. There is no other documentation per se.
>... Igor Skornyakov

12:49 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Any work done so far on this concept is in #2475. There is no other documentation per se.
The requirements which l... Eric Faulhaber

12:34 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> It is the same thing we have now. I'm just referring to the *concept* that it is a logical and n... Igor Skornyakov

12:20 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

It is the same thing we have now. I'm just referring to the *concept* that it is a logical and not physical session. Greg Shah

12:06 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> Your work is about the logical database session, which is different.
Sorry, what is a _logical... Igor Skornyakov

12:00 PM Database Feature #3930: allow session level control over the database(s) which are auto-connected

> I understood that in FWD the CONNECT does not mean establishing the JDBC connection to the relational database,
... Greg Shah

11:27 AM Database Feature #3930: allow session level control over the database(s) which are auto-connected

Greg Shah wrote:
> To implement this, we must separate database auto-connect from server startup. Then we must allo... Igor Skornyakov

02:05 PM Database Bug #5322 (WIP): FqlToSqlConverter fails to identify property

Exactly. Ovidiu Maxiniuc

11:51 AM Database Bug #5322: FqlToSqlConverter fails to identify property

Ovidiu, I understand this logs a warning, but it is not detrimental, correct? If so, let's lower the priority. Eric Faulhaber

11:47 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

> I cannot imagine how it is possible to convert to a native form an application that heavily uses AspectJ, Reflectio... Greg Shah

11:12 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eugenie Lyzenko wrote:
> Greg Shah wrote:
> > Did you test AOT (ahead of time) compilation? Or was your result pur... Igor Skornyakov

11:05 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Greg Shah wrote:
> Did you test AOT (ahead of time) compilation? Or was your result purely based on swappng out the... Eugenie Lyzenko

10:52 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Eric: It is worth having you try this out. If a different JDK can provide 25% improvement, then we should know it an... Greg Shah

10:49 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

Did you test AOT (ahead of time) compilation? Or was your result purely based on swappng out the runtime? Greg Shah

10:48 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

> Is it a stopper?
For runtime usage, customers would need to obtain a license/subscription. Oracle has "added Gr... Greg Shah

10:44 AM Runtime Infrastructure Support #5354: usage of GraalVM for better performance

From Eugenie:
> Thinking about the ways to speed up the @<large_gui_application>@ I've found the option previously... Greg Shah

10:43 AM Runtime Infrastructure Support #5354 (New): usage of GraalVM for better performance

Greg Shah

02:45 AM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> Code review 3814a/12395:
>
> I don't understand why you renamed the original @RecordBuffe... Igor Skornyakov

05/06/2021

07:58 PM Database Feature #3814: more schema metadata

Code review 3814a/12395:
I don't understand why you renamed the original @RecordBuffer@ method @delete@ to @_delet... Eric Faulhaber

04:09 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> See the call hierarchy for @RecordBuffer.delete(Supplier<logical> valexp, Supplier<character... Igor Skornyakov

03:02 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > I cannot find a better place for updating the 'delete' count... Igor Skornyakov

02:56 PM Database Feature #3814: more schema metadata

Igor Skornyakov wrote:
> I cannot find a better place for updating the 'delete' counter (see #3814-413).
The de... Eric Faulhaber

02:33 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> I believe a good solution is to:
>
> * remove all flushing logic from the various @P2JQue... Igor Skornyakov

05/05/2021

01:50 PM Base Language Feature #4350: method overload when they differ by a temp-table, dataset, buffer or object or ext...

I don't recall the @table-handle for@ version, but from what I can see, this case just specifies the real handle var ... Constantin Asofiei

01:35 PM Base Language Feature #4350: method overload when they differ by a temp-table, dataset, buffer or object or ext...

Wait, I see 1 difference. The initialization of the @gh@ handle. Is that the only difference that is supposed to be... Greg Shah

01:34 PM Base Language Feature #4350: method overload when they differ by a temp-table, dataset, buffer or object or ext...

Constantin: I think the "table-handle for" case has been regressed. Or perhaps I misunderstand the idea.
I found ... Greg Shah

08:21 PM Database Bug #5305 (Closed): dynamic function detection in RuntimeJastInterpreter

Fixed in 3821c/12370. Confirmed the fix in a customer scenario. Eric Faulhaber

05/04/2021

07:52 PM Database Bug #5305 (WIP): dynamic function detection in RuntimeJastInterpreter

Eric Faulhaber

07:41 PM Database Bug #5322: FqlToSqlConverter fails to identify property

There are known warnings printed by @FqlToSqlConverter@ into log about @Property '<identifier>' not found to extract ... Ovidiu Maxiniuc

07:40 PM Database Bug #5322 (WIP): FqlToSqlConverter fails to identify property

Ovidiu Maxiniuc

02:45 PM User Interface Feature #4164: implement misc UI features (frame options, misc attributes)

Yes. Greg Shah

02:28 PM User Interface Feature #4164: implement misc UI features (frame options, misc attributes)

I assume than implementation of @SCROLL-NOTIFY@ should include @SCROLL-HORIZONTAL@ and @SCROLL-VERTICAL@ events (they... Stanislav Lomany

12:17 PM User Interface Feature #4164: implement misc UI features (frame options, misc attributes)

@AUTO-INDENT@ committed 3821c rev 12364. Stanislav Lomany

10:17 AM Base Language Feature #4384: Builtin OO Implementation

Branch 4384j was merged into branch 3821c as revision 12363.
Created new branch 4384k from 3821c rev 12363. The n... Greg Shah

08:05 AM Base Language Feature #4384: Builtin OO Implementation

Greg Shah wrote:
> It is not merged yet. I just pushed the latest 3821c to xfer (rev 12362). Please post the @bzr ... Marian Edu

07:47 AM Base Language Feature #4384: Builtin OO Implementation

It is not merged yet. I just pushed the latest 3821c to xfer (rev 12362). Please post the @bzr send@ of the merged ... Greg Shah

06:05 AM Base Language Feature #4384: Builtin OO Implementation

@Greg, did you merged that already and created a new branch that we need to pick-up or not just yet? I have local cha... Marian Edu

05/03/2021

07:16 PM Database Bug #5305: dynamic function detection in RuntimeJastInterpreter

Eric Faulhaber wrote:
> Is it safe for me to modify the @DYNAMIC_CALL@ condition to check for any of these variants?... Ovidiu Maxiniuc

03:39 PM Database Bug #5305: dynamic function detection in RuntimeJastInterpreter

Ovidiu, while recreating a separate issue, I am getting many messages like this in the terminal:... Eric Faulhaber

03:30 PM Database Bug #5305 (Closed): dynamic function detection in RuntimeJastInterpreter

Eric Faulhaber

06:01 PM Database Feature #3814: more schema metadata

Igor Skornyakov wrote:
> > For now, let's get the flushing part of this settled and we'll consider this task compl... Eric Faulhaber

05:16 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> They may do that for performance considerations, and we may need to do something similar if ... Igor Skornyakov

04:51 PM Database Feature #3814: more schema metadata

Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > My point is: isn't this already working for temp-tables, without... Eric Faulhaber

04:06 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> My point is: isn't this already working for temp-tables, without further implementation? Is ... Igor Skornyakov

03:55 PM Database Feature #3814: more schema metadata

Igor Skornyakov wrote:
> Well, I planned to ignore the statistics updates for temp-tables but it looks that I forg... Eric Faulhaber

03:50 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> AFAICT, we make no distinction between persistent and temp-tables in the current implementat... Igor Skornyakov

03:27 PM Database Feature #3814: more schema metadata

AFAICT, we make no distinction between persistent and temp-tables in the current implementation. So, I am just wonder... Eric Faulhaber

03:17 PM Database Feature #3814: more schema metadata

Greg Shah wrote:
> > I do not think that it is a big deal. But I need to analyze how 4GL supports counters for the t... Igor Skornyakov

03:11 PM Database Feature #3814: more schema metadata

> I do not think that it is a big deal. But I need to analyze how 4GL supports counters for the temp-tables first.
... Greg Shah

03:08 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> > Unfortunatelly, FqlToSQLConverter is not used in the @AdaptiveQuery@ and @RandomAccessQuer... Igor Skornyakov

02:53 PM Database Feature #3814: more schema metadata

Igor Skornyakov wrote:
> Unfortunatelly, FqlToSQLConverter is not used in the @AdaptiveQuery@ and @RandomAccessQue... Eric Faulhaber

06:17 AM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> > Updating the counter in the @BufferImpl.deleteRecord@ works for the DELETE statement as w... Igor Skornyakov

05:17 AM Database Feature #3814: more schema metadata

Code review 3821c/12341:
Igor Skornyakov wrote:
> Updating the counter in the @BufferImpl.deleteRecord@ works ... Eric Faulhaber

04:48 PM Database Bug #5307: AdaptiveQuery goes into dynamic mode too aggressively

While implementing #3814, we used the following code in a test case:... Eric Faulhaber

03:58 PM Database Bug #5307 (WIP): AdaptiveQuery goes into dynamic mode too aggressively

Eric Faulhaber

03:53 PM Database Bug #5306: AdaptiveQuery sets a found record into the buffer twice in dynamic mode

When @AdaptiveQuery@ finds a record in dynamic mode, it sets it into @RecordBuffer@ via @setRecord@ twice. This was d... Eric Faulhaber

03:44 PM Database Bug #5306 (Closed): AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Eric Faulhaber

04/30/2021

04:23 PM Database Feature #3814: more schema metadata

> Code review 3814a rev 12304-12307, part 2.
>
> *Functional:*
>
> I understand your term for persisting the st... Igor Skornyakov

07:25 AM Database Feature #3814: more schema metadata

I've noticed one more discrepancy between 4GL and FWD.
If a record is updated twice w/o commit like this:... Igor Skornyakov

03:51 AM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> The root cause of the double-counting of the retrieve statistic is that we are setting the r... Igor Skornyakov

02:53 PM User Interface Bug #5300: 4GL quirk about assigning SCREEN-VALUE in an editable browse

Testcases are attached. 4GL allows to set @SCREEN-VALUE@ for a column (even for an non-ediable browse) and then save ... Stanislav Lomany

02:35 PM User Interface Bug #5300 (New): 4GL quirk about assigning SCREEN-VALUE in an editable browse

Stanislav Lomany

12:33 PM Base Language Feature #4384: Builtin OO Implementation

> there are some compatibility and 'business entity' handlers as well as some extra classes I don't remember right no... Greg Shah

12:14 PM Base Language Feature #4384: Builtin OO Implementation

Greg Shah wrote:
> > I'm working on dynamic invoke (class/method/ctor) - right now trying to close @ParameterList@
... Marian Edu

12:01 PM Base Language Feature #4384: Builtin OO Implementation

> I'm working on dynamic invoke (class/method/ctor) - right now trying to close @ParameterList@
Are the @WebHandle... Greg Shah

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

As part of the shift to a subclass approach for @TableParameter@ and @DataSetParameter@, I'm also making the followin... Greg Shah

04/29/2021

06:36 PM Database Feature #3814: more schema metadata

Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > This observation is not directly to the problem at hand, but it ... Eric Faulhaber

06:09 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> This observation is not directly to the problem at hand, but it is curious that there isn't ... Igor Skornyakov

05:34 PM Database Feature #3814: more schema metadata

This observation is not directly to the problem at hand, but it is curious that there isn't anything I see about your... Eric Faulhaber

05:12 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> Please post the original 4GL code and the converted code (not the whole program, just the sn... Igor Skornyakov

04:58 PM Database Feature #3814: more schema metadata

Please post the original 4GL code and the converted code (not the whole program, just the snippets relevant to this q... Eric Faulhaber

03:54 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> Is the same record being set into the buffer in both calls to @RecordBuffer.setRecord@?
I... Igor Skornyakov

03:51 PM Database Feature #3814: more schema metadata

Is the same record being set into the buffer in both calls to @RecordBuffer.setRecord@? Eric Faulhaber

03:43 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> Sorry I forgot to respond to this yesterday. Are you sure these code paths are not mutually ... Igor Skornyakov

03:38 PM Database Feature #3814: more schema metadata

Igor Skornyakov wrote:
> Indeed, @RecordBuffer.setRecord@ looks to be a better place. However I've encountered a p... Eric Faulhaber

03:00 PM Database Feature #3814: more schema metadata

@GET-CURRENT@ has an interesting effect on the @_UserTableStat_read@ counter.
* The combination @GET-CURRENT@/@DEL... Igor Skornyakov

11:04 AM Base Language Feature #4384: Builtin OO Implementation

> was that done on purpose, is there a catch or I can just replace that with @BaseDataType.incompatibleTypesOnConvers... Greg Shah

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

Greg Shah wrote:
> Don't we already process parent interfaces before child interfaces and imlemented interfaces be... Constantin Asofiei

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

> But non-override methods will need to not collide with any Java method name from the hierarchy (this includes prope... Greg Shah

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

Hmm... a two-pass approach I think it might work.
But non-override methods will need to not collide with any Java ... Constantin Asofiei

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

My idea was this:
* We already convert the entire parent hierarchy before any child classes.
* In the parent, we ... Greg Shah

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

The main reason this is JVM wide is because I couldn't find a way to solve this case.
You have a @Foo.m1@ and @Foo... Constantin Asofiei

08:24 AM Base Language Bug #5296: output parameters are cleared if an argument is another function call

Since we are making this change, we could modify the @wrap()@ to be @outputParm()@ or @inputOututParm()@ and remove t... Greg Shah

08:08 AM Base Language Bug #5296: output parameters are cleared if an argument is another function call

It doesn't work to move this registration at @init()@, because the reference needs to change - and in lambda we can't... Constantin Asofiei

07:43 AM Base Language Bug #5296: output parameters are cleared if an argument is another function call

Code Review Task Branch 3821c Revision 12345
The changes themselves should do what you intend.
The biggest issu... Greg Shah

05:57 AM Base Language Bug #5296: output parameters are cleared if an argument is another function call

The current changes are too aggressive, I need to limit them for only if there are OUTPUT/INPUT-OUTPUT parameters on ... Constantin Asofiei

04/28/2021

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

@SymbolResolver.WorkArea.javaMethodCollisions@ is a JVM-wide map that stores the javaname mapped to a given Java sign... Greg Shah

03:19 PM Base Language Bug #5296 (WIP): output parameters are cleared if an argument is another function call

The fix is in 3821c rev 12345
An improvement would be to emit @evaluate(() -> ...)@ only if there are no output/in... Constantin Asofiei

02:10 PM Base Language Bug #5296: output parameters are cleared if an argument is another function call

If a call has output/input-output parameters, and also a function call, then the output argument registration is lost... Constantin Asofiei

02:01 PM Base Language Bug #5296 (Closed): output parameters are cleared if an argument is another function call

Constantin Asofiei

12:57 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> Code review 3814a rev 12304-12307, part 1.
> *Update*
>
> Does the VST count each indi... Igor Skornyakov

06:31 AM Database Feature #3814: more schema metadata

I've noticed what looks like incompatibility.
In 4GL if inside a transaction block two records are inserted where ... Igor Skornyakov

11:02 AM Base Language Bug #5294: parsing problems for assign-style statements with a OO chained lvalue

In OE, is possible to use an OO property or variable as the lvalue for an assign-style-statement. FWD can't parse th... Constantin Asofiei

10:59 AM Base Language Bug #5294 (Closed): parsing problems for assign-style statements with a OO chained lvalue

Constantin Asofiei

07:14 AM Base Language Feature #4384: Builtin OO Implementation

I'm working on dynamic invoke (class/method/ctor) - right now trying to close @ParameterList@ - and one aspect we're ... Marian Edu

04/27/2021

04:55 PM Database Feature #3814: more schema metadata

It looks that if a trigger rejects CREATE/DELETE/FIND/WRITE operation the corresponding @_UserTableStat@ counter is n... Igor Skornyakov

12:46 PM Database Bug #5289: Misc. problems with triggers

In addition.
The REPLICATION triggers are not invoked in FWD. See the same test as above. Just add the following tr... Igor Skornyakov

07:20 AM Database Bug #5289: Misc. problems with triggers

How to reproduce:
Just run @stat1.p@ with our standard "customer" table and two triggers (see @sftp://<userid>@xfer... Igor Skornyakov

03:43 AM Base Language Feature #4384: Builtin OO Implementation

Marian Edu wrote:
> There should be plenty of calls like @hCall:set-parameter@ in that file, hCall is a handle and t... Marian Edu

03:31 AM Base Language Feature #4384: Builtin OO Implementation

Constantin Asofiei wrote:
> I don't see @call:set-parameter@ used here.
There should be plenty of calls like @hCa... Marian Edu

03:21 AM Base Language Feature #4384: Builtin OO Implementation

Marian Edu wrote:
> Constantin Asofiei wrote:
> > Marian, please point me to the test which fails.
>
> oo/progre... Constantin Asofiei

03:14 AM Base Language Feature #4384: Builtin OO Implementation

Constantin Asofiei wrote:
> Marian, please point me to the test which fails.
oo/progress/lang/parameter_list/test... Marian Edu

03:11 AM Base Language Feature #4384: Builtin OO Implementation

Marian, please point me to the test which fails. Constantin Asofiei

01:45 AM Base Language Feature #4384: Builtin OO Implementation

Marian Edu wrote:
> It gives "No param_index annotation found"... hmm, looking at it in our tests we also use @set-p... Marian Edu

01:37 AM Base Language Feature #4384: Builtin OO Implementation

Constantin, we have an issue with the conversion for tests that uses @Progress.Lang.ParameterList.setParameter@ metho... Marian Edu

04/26/2021

06:11 PM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

This use case actually comes back true instead of false, as happens in 4GL:... Roger Borrello

04:33 PM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

I think I understand what you are saying. This situations comes up when a new @date@ is created in an effort to perfo... Roger Borrello

01:15 PM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

This testcase isn't about regular date processing. It is about polymorphic type processing. All the @buffer-field()... Greg Shah

12:07 PM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

This update to the @date(BaseDataType)@ constructor does create @Unknown@ when an empty string is passed in:... Roger Borrello

10:55 AM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

Roger Borrello wrote:
> Just swapping the comparison operands so we go into @text.compareTo@ instead of @date.compar... Roger Borrello

09:38 AM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

Constantin Asofiei wrote:
> Roger Borrello wrote:
> > Also, still awaiting review of the update mentioned in #5215-... Roger Borrello

09:27 AM Base Language Bug #5288: Some date field character comparisons have runtime incompatibilities during runtime

Comparisons of @date@ fields to certain characters have problems. See testcase:... Roger Borrello

09:19 AM Base Language Bug #5288 (New): Some date field character comparisons have runtime incompatibilities during runtime

Roger Borrello

05:14 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> Code review 3814a rev 12304-12307, part 2.
>
> *Functional:*
>
> I understand your ter... Igor Skornyakov

05:01 PM Database Feature #3814: more schema metadata

It seems we have enough trigger-related items to warrant a separate issue. Please open a normal priority bug issue in... Eric Faulhaber

04:58 PM Database Feature #3814: more schema metadata

Code review 3814a rev 12304-12307, part 2.
*Functional:*
I understand your term for persisting the state from t... Eric Faulhaber

04:56 PM Database Feature #3814: more schema metadata

Igor Skornyakov wrote:
> In some situations, the @FIND@ rejected by the trigger causes NPE in the @PreselectQuery@ l... Igor Skornyakov

04:36 PM Database Feature #3814: more schema metadata

In some situations, the @FIND@ rejected by the trigger causes NPE in the @PreselectQuery@ line 5630 (@results@ field ... Igor Skornyakov

03:59 PM Database Feature #3814: more schema metadata

Eric Faulhaber wrote:
> Does the 4GL return @false/no@ from this BUFFER-CREATE method call? If so, then that looks l... Igor Skornyakov

03:58 PM Database Feature #3814: more schema metadata

Igor Skornyakov wrote:
> After rebasing 3814a to 3821c/12334 the trigger is working but contrary to 4GL behavior the... Igor Skornyakov

03:53 PM Database Feature #3814: more schema metadata

Does the 4GL return @false/no@ from this BUFFER-CREATE method call? If so, then that looks like a bug in our create t... Eric Faulhaber

03:32 PM Database Feature #3814: more schema metadata

After rebasing 3814a to 3821c/12334 the trigger is working but contrary to 4GL behavior the converted @RETURN ERROR@ ... Igor Skornyakov

03:13 PM Database Feature #3814: more schema metadata

Constantin Asofiei wrote:
> I've tested with 3821c:
> * added the @TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "cr... Igor Skornyakov

03:06 PM Database Feature #3814: more schema metadata

Constantin Asofiei wrote:
> I've tested with 3821c:
> * added the @TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "cr... Igor Skornyakov

03:01 PM Database Feature #3814: more schema metadata

I've tested with 3821c:
* added the @TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "create-trg.p" CRC "30042" @ line ... Constantin Asofiei

02:51 PM Database Feature #3814: more schema metadata

Here is the result of the table conversion:... Igor Skornyakov

02:45 PM Database Feature #3814: more schema metadata

Constantin Asofiei wrote:
> Please post here the create-trg.p program and the program which tests this trigger.
>
... Igor Skornyakov

02:42 PM Database Feature #3814: more schema metadata

Please post here the create-trg.p program and the program which tests this trigger.
I assume you are *not* running... Constantin Asofiei

02:41 PM Database Feature #3814: more schema metadata

Add the path inside your trigger definition in the @.df@ otherwise it cannot be found in the propath since the propat... Greg Shah

02:36 PM Database Feature #3814: more schema metadata

Greg Shah wrote:
> OK, so your code should not just be dropped in the root directory of the project. It should be i... Igor Skornyakov

02:28 PM Database Feature #3814: more schema metadata

OK, so your code should not just be dropped in the root directory of the project. It should be in some structured pa... Greg Shah

02:24 PM Database Feature #3814: more schema metadata

Greg Shah wrote:
> Those are both conversion-time values and they have no meaning at runtime. What project are you ... Igor Skornyakov

02:22 PM Database Feature #3814: more schema metadata

Those are both conversion-time values and they have no meaning at runtime. What project are you using? Greg Shah

02:20 PM Database Feature #3814: more schema metadata

Constantin Asofiei wrote:
> What is the PROPATH in directory.xml? That one is used at runtime.
>
> Is @create-trg... Igor Skornyakov

02:11 PM Database Feature #3814: more schema metadata

What is the PROPATH in directory.xml? That one is used at runtime.
Is @create-trg.p@ in some folder? If so, add th... Constantin Asofiei

02:07 PM Database Feature #3814: more schema metadata

Greg Shah wrote:
> It must be found in the propath.
Greg.
In my environment the @PROPATH@ is defined in @p2j.cfg... Igor Skornyakov

01:50 PM Database Feature #3814: more schema metadata

It must be found in the propath. Greg Shah

01:21 PM Database Feature #3814: more schema metadata

I've added a trigger to the test table:... Igor Skornyakov

05:13 PM Database Bug #5289: Misc. problems with triggers

I've found a number of issues with triggers' support in FWD:
* In 4GL if the @CREATE@ trigger rejects the operation ... Igor Skornyakov

05:05 PM Database Bug #5289 (WIP): Misc. problems with triggers

Igor Skornyakov

05:06 PM Database Feature #4175 (Closed): add support for -1 (single user) option for CONNECT statement

I did some additional code cleanup in 3821c/12333. Considering #5279, this issue can be closed. Eric Faulhaber

09:04 AM Database Feature #4175: add support for -1 (single user) option for CONNECT statement

Eric Faulhaber wrote:
> Warning added, functionally looks fine, but please follow coding standards when formatting (... Igor Skornyakov

08:21 AM Database Feature #4175: add support for -1 (single user) option for CONNECT statement

Code review 3821c/12313:
Warning added, functionally looks fine, but please follow coding standards when formattin... Eric Faulhaber