FWD » Core Development » Database

12/12/2019

04:52 PM Feature #4011: database/persistence layer performance improvements

I have a not-yet-stable UPDATE implementation in @Persister@. It uses a combination of both @RecordState@ and @Proper... Ovidiu Maxiniuc

03:29 PM Bug #4450: implement shared query and shared browse

Roger Borrello wrote:
> Roger Borrello wrote:
> > I'm not sure that that logic is attempting to do, but it looks wr... Roger Borrello

02:30 PM Bug #4450: implement shared query and shared browse

Roger Borrello wrote:
> I'm not sure that that logic is attempting to do, but it looks wrong.
The information in ... Roger Borrello

01:29 PM Bug #4450: implement shared query and shared browse

Roger Borrello wrote:
> Just a little thing to mention, as I was looking through how orphan frames are created/detec... Roger Borrello

10:46 AM Bug #4450: implement shared query and shared browse

Just a little thing to mention, as I was looking through how orphan frames are created/detected:
There is a commen... Roger Borrello

10:42 AM Feature #2156: datetime-tz and hibernate

The fix from #2156-66 is in 3809e rev 11440. Constantin Asofiei

12/11/2019

06:46 PM Feature #2156: datetime-tz and hibernate

Constantin Asofiei wrote:
> Ovidiu Maxiniuc wrote:
> > Constantin,
> > I inspected how DTZ are converted (with sli... Constantin Asofiei

04:54 PM Feature #2156: datetime-tz and hibernate

Ovidiu Maxiniuc wrote:
> Constantin,
> I inspected how DTZ are converted (with slightly modified FWD code, to aviod... Constantin Asofiei

05:00 PM Bug #4450: implement shared query and shared browse

Stanislav Lomany wrote:
> > I check with you on the issue #4450 to see if you have any help you can provide me to fi... Roger Borrello

12:05 PM Bug #4450: implement shared query and shared browse

Constantin Asofiei wrote:
> Roger Borrello wrote:
> > Constantin Asofiei wrote:
> > > Roger, any external program ... Roger Borrello

11:40 AM Bug #4450: implement shared query and shared browse

Roger Borrello wrote:
> Constantin Asofiei wrote:
> > Roger, any external program which defines a simple @shared@ r... Constantin Asofiei

11:40 AM Bug #4450: implement shared query and shared browse

Constantin Asofiei wrote:
> Roger, any external program which defines a simple @shared@ resource needs to be invoked... Roger Borrello

11:33 AM Bug #4450: implement shared query and shared browse

Roger, any external program which defines a simple @shared@ resource needs to be invoked from another program which d... Constantin Asofiei

11:31 AM Bug #4450: implement shared query and shared browse

Stanislav Lomany wrote:
> > I check with you on the issue #4450 to see if you have any help you can provide me to fi... Roger Borrello

04:39 PM Feature #4011: database/persistence layer performance improvements

In the previous post, I meant to refer to the @PropertyState@ and the @BaseRecord.propState@ array w.r.t. individual ... Eric Faulhaber

02:42 PM Feature #4011: database/persistence layer performance improvements

Ovidiu, I saw you were working on the update statement part of the process. Please discuss your thoughts here. My int... Eric Faulhaber

04:26 AM Feature #4011: database/persistence layer performance improvements

Ovidiu wrote (in email):
> At this moment (at least for _temp database, but I believe the permanent databases beha... Eric Faulhaber

12/06/2019

02:09 PM Bug #4450: implement shared query and shared browse

> I check with you on the issue #4450 to see if you have any help you can provide me to fix this.
Roger, it seems ... Stanislav Lomany

09:40 AM Bug #4450: implement shared query and shared browse

h1. Description
There are missing parameters in the generated registerQuery() as a result of a SHARED BROWSE
<p... Roger Borrello

09:18 AM Bug #4450 (Closed): implement shared query and shared browse

Roger Borrello

12/04/2019

12:29 PM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

Roger Borrello wrote:
> [...]
> It sounds like this is a _Base Language_ issue, related to the conversion, rather t... Eric Faulhaber

12:14 PM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

Eric Faulhaber wrote:
> Eric Faulhaber wrote:
> > Roger Borrello wrote:
> > > [...]
> > > What do you make of tha... Roger Borrello

12:07 PM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

Eric Faulhaber wrote:
> Roger Borrello wrote:
> > [...]
> > What do you make of that?
>
> It converts incorrect... Eric Faulhaber

11:47 AM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

Roger Borrello wrote:
> [...]
> What do you make of that?
It converts incorrectly: looks like the where clause o... Eric Faulhaber

09:49 AM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

Eric Faulhaber wrote:
> What I'm trying to figure out is whether it is safe to move the FIND's where clause to the R... Roger Borrello

12/03/2019

06:57 PM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

What I'm trying to figure out is whether it is safe to move the FIND's where clause to the REPEAT PRESELECT level, ei... Eric Faulhaber

03:52 PM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

Roger Borrello wrote:
> Eric Faulhaber wrote:
> > Which construct controls sorting? That is, if the REPEAT PRESELEC... Roger Borrello

03:10 PM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

Eric Faulhaber wrote:
> Which construct controls sorting? That is, if the REPEAT PRESELECT specifies one index and t... Roger Borrello

02:53 PM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

Which construct controls sorting? That is, if the REPEAT PRESELECT specifies one index and the inner FIND a different... Eric Faulhaber

10:16 AM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

This is by far the most prevalent use of this syntax in customer code (@PRESELECT@ doesn't filter anything, and lets ... Roger Borrello

09:47 AM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

Eric Faulhaber wrote:
> We could add an API which accepts a client-side where clause in the form of a lambda, to be ... Roger Borrello

06:09 AM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

So, the problem is that we don't anticipate the where clause for the inner FIND statement. In every other case we've ... Eric Faulhaber

12/02/2019

03:37 PM Bug #4422: h2.sortNullsHigh in page-store mode

Eric Faulhaber wrote:
> Are you saying it isn't working in the version of H2 we're using now, but it _is_ working in... Constantin Asofiei

03:28 PM Bug #4422: h2.sortNullsHigh in page-store mode

Are you saying it isn't working in the version of H2 we're using now, but it _is_ working in 1.4.200? Eric Faulhaber

09:55 AM Bug #4422: h2.sortNullsHigh in page-store mode

Constantin Asofiei wrote:
> H2 1.4.200 doesn't have support for sortNullsHigh.
Scratch that, sortNullsHigh in page-... Constantin Asofiei

09:41 AM Bug #4422: h2.sortNullsHigh in page-store mode

H2 1.4.200 doesn't have support for sortNullsHigh. Constantin Asofiei

09:21 AM Bug #4421: blob/clob access with H2

H2 1.4.200 with page-store still has the LOB bugs. Constantin Asofiei

11/26/2019

01:44 PM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

@database_access.rules@ is one of the nastier persistence rule sets, because it tries to handle so many related but s... Eric Faulhaber

11/25/2019

04:35 AM Bug #4421: blob/clob access with H2

Constantin Asofiei wrote:
> ... then the abend is seen, but only if the LOB size exceeds the H2's BLOCK_LENGTH (2000... Constantin Asofiei

11/24/2019

12:32 PM Bug #4421: blob/clob access with H2

Eric, my conclusion is this: LOB in page-store is broken, only in MVStore is working - if I remove the @mv_store=fal... Constantin Asofiei

08:42 AM Bug #4421: blob/clob access with H2

Eric Faulhaber wrote:
> You can invoke @session.getInterceptor()@, which will return an instance of @ChangeBroker$Se... Constantin Asofiei

11/22/2019

05:03 PM Bug #4421: blob/clob access with H2

Constantin Asofiei wrote:
> @BlobUserType@ and @ClobUserType@ need to be changed, so that the LOB access is done in ... Eric Faulhaber

03:53 PM Bug #4421: blob/clob access with H2

Even after I added the @:_temp@ exclusion (so that only dirty and meta will use the stream lob APIs), it still fails.... Constantin Asofiei

03:39 PM Bug #4421: blob/clob access with H2

Ovidiu, your solution is working, but I need one more criteria, to distinguish between session-local tables and physi... Constantin Asofiei

02:44 PM Bug #4421: blob/clob access with H2

Constantin,
As a temporary workaround until a better solution is found, try to use @session.connection().getMetaData... Ovidiu Maxiniuc

01:43 PM Bug #4421: blob/clob access with H2

For reference, this is the kind of error H2 throws, when using the LOB setters:... Constantin Asofiei

09:45 AM Bug #4421: blob/clob access with H2

The Hibernate dialect has a method named @useInputStreamToInsertBlob@ - the implementation for H2 returns true, while... Constantin Asofiei

09:39 AM Bug #4421 (WIP): blob/clob access with H2

Constantin Asofiei

04:17 PM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

h1. General
Expression execution error when there is a @preselect@ qualifier on @repeat@.
*20191231 Update: Cus... Roger Borrello

04:05 PM Bug #4426 (New): Cannot find parent when processing REPEAT PRESELECT

Roger Borrello

12:59 PM Bug #4422: h2.sortNullsHigh in page-store mode

Eric Faulhaber wrote:
> For our development/testing use of H2, I think it is ok to switch to the MV_STORE storage en... Constantin Asofiei

12:55 PM Bug #4422: h2.sortNullsHigh in page-store mode

For our development/testing use of H2, I think it is ok to switch to the MV_STORE storage engine when using H2 as the... Eric Faulhaber

10:32 AM Bug #4422: h2.sortNullsHigh in page-store mode

With #3961, we disabled MVCC and moved to page-store. But with page-store, the h2.sortNullsHigh is not working - thi... Constantin Asofiei

10:29 AM Bug #4422 (New): h2.sortNullsHigh in page-store mode

Constantin Asofiei

12:56 PM Bug #3961: "Unexpected code path" failure when using H2 in MVCC mode

Eric Faulhaber wrote:
> Please refresh my memory on this issue. Is there a production use case where this is a probl... Constantin Asofiei

12:43 PM Bug #3961: "Unexpected code path" failure when using H2 in MVCC mode

Please refresh my memory on this issue. Is there a production use case where this is a problem?
We do not support ... Eric Faulhaber

11/19/2019

10:35 AM Feature #3574: finish implementation of temp-table XML support

Methods:
* read-xmlschema() method
** file | memptr | handle | longchar %{color:#6080FF}OM: only file and longchar%... Ovidiu Maxiniuc

09:24 AM Feature #3574: finish implementation of temp-table XML support

How much of this task is complete as of branch 3809e? Greg Shah

09:42 AM Bug #4200: verify and fix all temp-table options which must result in different DMO implementatio...

Another part I needed to add is BEFORE-TABLE - if this doesn't match between two tables, then we must emit two differ... Constantin Asofiei

09:19 AM Feature #4418: improve/fix temp-table naming approach

As much as possible, I prefer for the temp-table names to retain the name given in the business logic definition. It... Greg Shah

09:17 AM Feature #4418: improve/fix temp-table naming approach

Ovidiu made changes to temp-table naming in #3324 which have been merged to trunk. However, there remains some issue... Greg Shah

09:15 AM Feature #4418 (New): improve/fix temp-table naming approach

Greg Shah

11/14/2019

12:47 PM Feature #3815 (WIP): more temp-table options

> Code page is properly resolved and set, but data it is not actually converted: when a @longchar/clob@ value is ass... Greg Shah

11/13/2019

05:58 PM Bug #3651 (Closed): regression in server startup when _connect metadata is active and a database ...

Greg Shah wrote:
> I see that 3791c was arched as merged on 20191025. What revision of trunk includes this change?
... Eric Faulhaber

05:26 PM Bug #3651: regression in server startup when _connect metadata is active and a database is loaded...

I see that 3791c was arched as merged on 20191025. What revision of trunk includes this change?
Can we close this? Greg Shah

04:17 PM Bug #3960 (Closed): localedef problems in Ubuntu 18.04

Task branch 4069a has been merged to trunk as revision 11339. Greg Shah

12:05 PM Feature #3759 (Closed): setup, test and document PostgreSQL on Windows

Greg Shah