FWD » Core Development » Database

09/03/2021

05:35 PM Feature #3814: more schema metadata

Igor, I'm re-familiarizing myself with @MetadataManager@ for changes we need for #3912. Can you please help me unders... Eric Faulhaber

11:52 AM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

I changes the code which sets these attributes like this:... Ovidiu Maxiniuc

11:15 AM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

Constantin Asofiei wrote:
> Eric Faulhaber wrote:
> > The intended design was that "normal" records would not be up... Eric Faulhaber

09/02/2021

03:07 PM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

Eric Faulhaber wrote:
> Is the peer record supposed to follow the usual validation/flushing rules, which are based o... Constantin Asofiei

12:39 PM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

Constantin Asofiei wrote:
> Eric Faulhaber wrote:
> > If the issue is that the bulk copy does not pick up changes i... Eric Faulhaber

11:59 AM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

Eric Faulhaber wrote:
> If the issue is that the bulk copy does not pick up changes in process in related buffers, c... Constantin Asofiei

11:57 AM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

Or is the issue that there is a version of the record which represents a "snapshot" of the state (i.e., not the curre... Eric Faulhaber

11:53 AM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

If the issue is that the bulk copy does not pick up changes in process in related buffers, can we use the @ChangeBrok... Eric Faulhaber

09/01/2021

04:35 PM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

Indeed, the extra line caused the testcase to work correctly, hiding the flaw by reloading the @CHANGED@ record into ... Ovidiu Maxiniuc

01:10 PM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

Sorry, I had a @message tt1.f1 buffer tt1:error-string.@ in the first program, which confused you, that should not ha... Constantin Asofiei

12:54 PM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

Your second test program works fine for me, except that it lacks one line. When @message tt1.f1 buffer tt1:error-stri... Ovidiu Maxiniuc

02:43 AM Bug #5625 (WIP): changing a before-table reserved field does not flush the change in the after-table

Ovidiu, this doesn't solves my issue. The original scenario involved using SQLs like @insert into ... select from@ t... Constantin Asofiei

10:58 AM Feature #5491: custom locale/collation implementations

The main work of creating the locales and collations to cover current projects is complete.
Some related work desc... Eric Faulhaber

10:36 AM Feature #5491: custom locale/collation implementations

Can we close this task or is there something remaining to work on, review or test? Greg Shah

08/31/2021

06:54 PM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

I identified two issues here.
The first was the NPE. This happened when the peer buffer was not found in cache. Th... Ovidiu Maxiniuc

08/30/2021

05:45 PM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

Constantin Asofiei wrote:
> Ovidiu/Eric: can someone look at this? Is a show-stopper for #5505.
I will do it tomorr... Ovidiu Maxiniuc

05:41 PM Bug #5625: changing a before-table reserved field does not flush the change in the after-table

In OE, the @error-string@ attribute is in sync between the before-table record and the after-table record. In FWD, t... Constantin Asofiei

05:28 PM Bug #5625 (WIP): changing a before-table reserved field does not flush the change in the after-table

Constantin Asofiei

08/25/2021

03:42 PM Feature #5491: custom locale/collation implementations

Ovidiu Maxiniuc wrote:
> I think you should keep the setting(s) for @_temp@ database until #5491-20 is done.
Yes,... Eric Faulhaber

03:31 PM Feature #5491: custom locale/collation implementations

Indeed, @load_at_startup@ is not needed for @_temp@. It is actually skipped for this database.
It seems logical to... Ovidiu Maxiniuc

03:27 PM Feature #5491: custom locale/collation implementations

Roger Borrello wrote:
> Is @load_at_startup@ necessary?
No, not for the @_temp@ database.
BTW, I plan to elimi... Eric Faulhaber

03:23 PM Feature #5491: custom locale/collation implementations

Ovidiu Maxiniuc wrote:
> The @p2jspi.jar@ is used only by H2 databases. The @_temp@ databases are always H2. The @Lo... Roger Borrello

01:12 PM Feature #5491: custom locale/collation implementations

I have changed manually the access mode of @deploy/lib/spi@ to 644 and I got the exception. However, it complained ab... Ovidiu Maxiniuc

08/24/2021

06:42 PM Feature #5491: custom locale/collation implementations

Thanks. Have you tried setting permissions on @spi/fwdspi.jar@ to see if it "breaks" you, too? Roger Borrello

04:54 PM Feature #5491: custom locale/collation implementations

Roger Borrello wrote:
> why the US collation?
This is a good question. Even if the @p2jspi.jar@ is inaccessible, th... Ovidiu Maxiniuc

04:38 PM Feature #5491: custom locale/collation implementations

Roger Borrello wrote:
> Where might this check for @p2jspi.jar@ be coming from, and why the US collation?
Looks l... Roger Borrello

04:28 PM Feature #5491: custom locale/collation implementations

Team... I was working with my VM and moved to the new custom locale @en_GB@iso88591_fwd_basic@. The cluster was creat... Roger Borrello

08/20/2021

04:48 PM Bug #5615: Project builds should copy out p2jpl.jar from FWD

I encountered a related issue while setting up the pg database on Windows. My installation is on a dedicated drive @Z... Ovidiu Maxiniuc

02:36 PM Bug #5615: Project builds should copy out p2jpl.jar from FWD

Vlad had this suggestion:
> Hi Roger.
>
> The goal ant import.db relies on the file p2jpl.jar is located in /us... Roger Borrello

02:36 PM Bug #5615 (New): Project builds should copy out p2jpl.jar from FWD

Roger Borrello

08/18/2021

06:37 PM Feature #5491: custom locale/collation implementations

Roger Borrello wrote:
> Will the custom locale part of the "Database Server Setup":/projects/p2j/wiki/Database_Serve... Ovidiu Maxiniuc

05:34 PM Feature #5491: custom locale/collation implementations

> is this an OS locale customization
It is at the OS level. Greg Shah

03:04 PM Feature #5491: custom locale/collation implementations

Will the custom locale part of the "Database Server Setup":/projects/p2j/wiki/Database_Server_Setup_for_PostgreSQL_on... Roger Borrello

08/10/2021

05:53 PM Feature #4723: make it significantly easier to run database import

Greg Shah wrote:
> Even if some records are dropped, the system should be left in a workable state. In my opinion, ... Eric Faulhaber

05:35 PM Feature #4723: make it significantly easier to run database import

Even if some records are dropped, the system should be left in a workable state. In my opinion, the @p2j_id_generato... Greg Shah

05:35 PM Feature #4723: make it significantly easier to run database import

Yes, I think it is possible to launch @DatabaseDumpChecker@ during import process and passing the current byte mappin... Ovidiu Maxiniuc

04:39 PM Feature #4723: make it significantly easier to run database import

I recently noticed that upon importing test data into a PostgreSQL database, I got errors about bytes that could not ... Eric Faulhaber