FWD » Core Development » Database

11/23/2025

05:42 AM Bug #10920: String concatenation doesn't work in WHERE clause for permanent databases

I used H2 permanent database. No records are found in FWD.... Stanislav Lomany

05:40 AM Bug #10920 (New): String concatenation doesn't work in WHERE clause for permanent databases

Stanislav Lomany

11/21/2025

09:48 AM Feature #4369: implement stateless FWD server clustering

Greg Shah wrote:
> The tables we could expect to be used frequently are not the same tables that are editable. @_fi... Eric Faulhaber

08:09 AM Feature #4369: implement stateless FWD server clustering

The tables we could expect to be used frequently are not the same tables that are editable. @_file@, @_field@, @_ind... Greg Shah

06:09 AM Feature #4369: implement stateless FWD server clustering

I am just writing here a discussion that happened in the daily yesterday.
Back when we tested performance for a la... Alexandru Lungu

11/20/2025

01:55 PM Feature #4369: implement stateless FWD server clustering

> In the end, it all comes down to the number of queries executed for the metadata tables for the current and future ... Greg Shah

12:52 PM Feature #4369: implement stateless FWD server clustering

Today I have made some experiments for understanding the time taken for inserting a large number of records in a meta... Andrei Plugaru

11/19/2025

02:07 PM Feature #4369: implement stateless FWD server clustering

> Over the solution presented by you, this has the advantage that the tables don't need to be recreated before each q... Greg Shah

01:14 PM Feature #4369: implement stateless FWD server clustering

Greg Shah wrote:
> For the tables that need to represent state that can change at runtime, I am suggesting that the ... Andrei Plugaru

11:02 AM Feature #4369: implement stateless FWD server clustering

> Greg, just to be clear, do you suggest to give up on the H2 metadata tables all together?
No. There is value i... Greg Shah

06:52 AM Feature #4369: implement stateless FWD server clustering

Greg Shah wrote:
> I repeat my points of #4369-46 and #4369-54. The existing approach to metadata is overcomplicate... Andrei Plugaru

11/18/2025

05:36 PM Feature #4369: implement stateless FWD server clustering

I repeat my points of #4369-46 and #4369-54. The existing approach to metadata is overcomplicated and causes unneces... Greg Shah

04:52 PM Feature #4369: implement stateless FWD server clustering

Andrei Plugaru wrote:
> [...]
> IMHO, the versioning approach from @UserTableStatUpdater@ and @LockTableUpdater@ is... Eric Faulhaber

10:32 AM Feature #4369: implement stateless FWD server clustering

In the last note, I forgot to mentioned the new directory configurations introduced in my latest commits. Right under... Andrei Plugaru

07:42 AM Feature #4369: implement stateless FWD server clustering

I have committed @4369a/16232@. I have completed all the java docs, history entries all the file headers on the new f... Andrei Plugaru

11:34 AM Bug #10901: BEGINS trims the rvalue if the lvalue field is first in an index

Actually things are a little more complicated: what matters is that the field is part of the 4GL index associated wit... Constantin Asofiei

09:52 AM Bug #10901: BEGINS trims the rvalue if the lvalue field is first in an index

This test shows that if a field is part of a leading component, then it will trim the rvalue for @BEGINS@:... Constantin Asofiei

09:45 AM Bug #10901 (Closed): BEGINS trims the rvalue if the lvalue field is first in an index

Constantin Asofiei

11/17/2025

04:30 AM Bug #10890: merge-row-changes does not change the before/after image row-state correctly

Another issue is that after @merge-row-changes@, in OE there are scenarios in which the *before image is not deleted*... Artur Școlnic

04:27 AM Bug #10890: merge-row-changes does not change the before/after image row-state correctly

... Artur Școlnic

04:19 AM Bug #10890 (New): merge-row-changes does not change the before/after image row-state correctly

Artur Școlnic

11/15/2025

08:28 AM Feature #4369: implement stateless FWD server clustering

I have mainly finished all the changes necessary in @InMemoryLockManager@ regarding the @.wait()/.notify()@ construct... Andrei Plugaru

11/14/2025

05:56 AM Feature #9711: collation configuration cleanup

Alex, when talking _meta tables, the nuances you mentioned is a bit more complex.
There is some 'persistent' infor... Ovidiu Maxiniuc

05:33 AM Feature #9711: collation configuration cleanup

> I think we need a way to allow the H2's default collation and ignore completely the embedded-collation for the _tem... Alexandru Lungu

04:58 AM Feature #9711: collation configuration cleanup

I think we need a way to allow the H2's default collation and ignore completely the @embedded-collation@ for the _tem... Constantin Asofiei

11/13/2025

07:44 AM Bug #10385 (WIP): Incorrect reset of the cursor cache in Reposition

I run a large unit test suite and discovered a NPE in @RepositionCache$Node.getRow@, on @rows.floor(position.intValue... Alexandru Lungu

05:52 AM Feature #4369: implement stateless FWD server clustering

> If the requests are stateless, then they should be able to be distributed across the clustered servers without any ... Alexandru Lungu

11/12/2025

10:56 AM Feature #4369: implement stateless FWD server clustering

> if there are 1k requests at a time and 10 servers, it is completely valid to balance 100 across these 10 servers?
... Greg Shah

10:54 AM Feature #4369: implement stateless FWD server clustering

I don't think we need the @RemoteLockManager@ if we have proper clustering. Greg Shah

09:15 AM Feature #4369: implement stateless FWD server clustering

> Within single-server mode and cluster mode, the server should still handle multiple requests in parallel? I mean, i... Andrei Plugaru

07:59 AM Feature #4369: implement stateless FWD server clustering

Review of 4369a:
h4. Model
* I spot some changes in the synchronization in general and I want to better underst... Alexandru Lungu

11/10/2025

08:41 AM Feature #4369: implement stateless FWD server clustering

Queuing it up! Alexandru Lungu

08:33 AM Feature #4369 (Review): implement stateless FWD server clustering

Eric/Alex: Please do this first review. Greg Shah

07:35 AM Bug #10838: Unique index violation should be cured even at flush time

Make a @tbl@ persistent table with unique index of (f1, f2).... Alexandru Lungu

07:32 AM Bug #10838 (New): Unique index violation should be cured even at flush time

Alexandru Lungu

11/07/2025

08:46 AM Bug #9950 (Review): Upgrade the metadata schema to a newer version

Constantin Asofiei

08:34 AM Feature #9305: Replace begins with interval based conditional

Please do the tests requested in #9305-25 in 4GL and PG with LIKE / < and > / with BETWEEN. We need to take a decisio... Alexandru Lungu

07:42 AM Feature #9305: Replace begins with interval based conditional

The range check follows the field collation or is byte-by-byte?
If it is after collation, there are some cases like ... Teodor Gorghe

07:11 AM Feature #9305: Replace begins with interval based conditional

Teodor Gorghe wrote:
> You told yesterday and in #9305-10 that the default database configuration, with @en_us.UTF... Eduard Soltan

07:01 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

When the changes from this task are regression tested, please also include the following scenario mentioned in #10763... Lorian Sandu

11/06/2025

04:55 PM Bug #9950: Upgrade the metadata schema to a newer version

I added backward compatibility with projects that have not upgraded from OE 11.6. By default 11.6 is the default meta... Ovidiu Maxiniuc

10:45 AM Feature #4369 (WIP): implement stateless FWD server clustering

*Update on the current status.*
Up until now, I have synchronized the *tracker for records in unique indices* and th... Andrei Plugaru

05:36 AM Feature #9305: Replace begins with interval based conditional

Alexandru,
You told yesterday and in #9305-10 that the default database configuration, with @en_us.UTF8@ collation, ... Teodor Gorghe

04:04 AM Bug #10822: Lock is not acquired if the update field value is the same as the current one

If a no-lock is set on a record it cannot be modified, 4GL does not allow any assignment and raises ... Artur Școlnic

03:58 AM Bug #10822 (New): Lock is not acquired if the update field value is the same as the current one

Artur Școlnic

03:56 AM Support #10664: Develop a multi session test suite in harness

I agree, I will open related tasks for every issue found during testing. Artur Școlnic

03:53 AM Support #10664: Develop a multi session test suite in harness

> Alex/Eric can determine if we do this now or if we do this in a separate task.
IMHO, related tasks should be ope... Alexandru Lungu

02:34 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> The tests that are not running properly have this pattern:
> [...]
>
> The test relies on... Greg Shah

02:12 AM Support #10664: Develop a multi session test suite in harness

Razvan pointed out an issue with lock scopes in #10796, @locking@ test suite already includes lock release/downgrade ... Artur Școlnic

11/04/2025

06:50 AM Support #10664: Develop a multi session test suite in harness

+ Ovidiu Alexandru Lungu

06:50 AM Support #10664: Develop a multi session test suite in harness

I computed some topics to look into based on recent work we've done for customers on High/Urgent priority. This list ... Alexandru Lungu

05:05 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> I will change the tests to assign a different value.
After this and ignoring the error num... Artur Școlnic

04:38 AM Support #10664: Develop a multi session test suite in harness

The tests that are not running properly have this pattern:... Artur Școlnic

01:32 AM Support #10664: Develop a multi session test suite in harness

Eric,
For review purposes, the actual test classes are in @flushing_and_validation@ and @locking@ directories in the... Artur Școlnic

01:28 AM Support #10664: Develop a multi session test suite in harness

The tests are not checked in testcases, but I uploaded them to 10664a root directory for preliminary reviews. I figur... Artur Școlnic

11/03/2025

12:26 PM Support #10664: Develop a multi session test suite in harness

Are the tests checked in? Eric/Alex should do a code review on the tests. Greg Shah

11:13 AM Support #10664: Develop a multi session test suite in harness

I finished the locking tests, here is what they include:
* Lock type: no-lock, share-lock, exclusive-lock / no-wait
... Artur Școlnic

05:23 AM Bug #10806: Presort queries can sometimes dynamically find records created after opening the query

Part of #10737, I discovered that BY clause index overlapping resolution is influenced by WHERE clause. This happens ... Alexandru Lungu

05:13 AM Bug #10806 (New): Presort queries can sometimes dynamically find records created after opening th...

Alexandru Lungu

10/31/2025

03:15 PM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
>
> It seems the rules are:
> 1. If a test does database operations committed or not, a tran... Tomasz Domin

07:38 AM Support #10664: Develop a multi session test suite in harness

Greg Shah wrote:
> Sorry, I still need to catch up here. Are you saying that in OE, the ABLUnit test code in #10664... Artur Școlnic

07:30 AM Support #10664: Develop a multi session test suite in harness

Sorry, I still need to catch up here. Are you saying that in OE, the ABLUnit test code in #10664-86 fails to compile... Greg Shah

07:19 AM Support #10664: Develop a multi session test suite in harness

... Artur Școlnic

06:28 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> Tomasz Domin wrote:
> > Dont we need tests running on level 0 ? Or test when we control when... Tomasz Domin

06:26 AM Support #10664: Develop a multi session test suite in harness

Tomasz Domin wrote:
> Dont we need tests running on level 0 ? Or test when we control when level 1 is entered ?
> ... Artur Școlnic

06:21 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> Tomasz Domin wrote:
> > I meant something different - if starting a test case implicitly sta... Tomasz Domin

06:20 AM Support #10664: Develop a multi session test suite in harness

Tomasz Domin wrote:
> I meant something different - if starting a test case implicitly starts transaction we can onl... Artur Școlnic

06:12 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> Maybe I am not explaining myself clear, this is what fails:
> [...]
> This doesn't even mak... Tomasz Domin

05:42 AM Support #10664: Develop a multi session test suite in harness

Maybe I am not explaining myself clear, this is what fails:... Artur Școlnic

05:39 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> Tomasz Domin wrote:
> > Isnt each ABLUnit test case started within an implicit transaction a... Tomasz Domin

05:28 AM Support #10664: Develop a multi session test suite in harness

Tomasz Domin wrote:
> Isnt each ABLUnit test case started within an implicit transaction already ?
AFAIK yes, but... Artur Școlnic

05:26 AM Support #10664: Develop a multi session test suite in harness

Tomasz Domin wrote:
> Possible solution is moving subtransaction into a sub-procedure. But that would make tests har... Artur Școlnic

05:25 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> In a simple program, constructs like:
> [...]
> are perfectly legal and cause no trouble.
... Tomasz Domin

05:22 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> From my investigation, this is not a true warning and cannot be suppressed with @SESSION:SUPP... Tomasz Domin

03:21 AM Support #10664: Develop a multi session test suite in harness

In a simple program, constructs like:... Artur Școlnic

08:37 PM Support #10664: Develop a multi session test suite in harness

> there were some hard limits with abl unit and nested explicit transactions
Please provide more details. What ar... Greg Shah

10/30/2025

08:49 AM Support #10664: Develop a multi session test suite in harness

I have to mention an issue I was having in case anybody else encounters it.
If an abl unit class has all capital let... Artur Școlnic

08:41 AM Support #10664: Develop a multi session test suite in harness

I solved all the issues with @flushing_and_validation@ tests, there were some hard limits with abl unit and nested ex... Artur Școlnic

04:29 AM Bug #10399: Index selection in dirty database

Eduard Soltan wrote:
> This issue can also be rejected, as it refers to a unit test rejected from customer applicati... Constantin Asofiei

04:28 AM Bug #10399: Index selection in dirty database

This issue can also be rejected, as it refers to a unit test rejected from customer application. Eduard Soltan

10/29/2025

04:55 PM Bug #10470 (Rejected): Wrong order of records fetching when index modification

Constantin Asofiei

04:50 PM Bug #10470: Wrong order of records fetching when index modification

Teodor Gorghe wrote:
> This issue was solved by #10480?
This issue can be rejected or closed. The test I was inve... Eduard Soltan

03:28 PM Bug #10470: Wrong order of records fetching when index modification

Teodor Gorghe wrote:
> This issue was solved by #10480?
Eduard? Constantin Asofiei

04:42 PM Feature #10491: Tool to standardize PG cluster creation

I have a proposed change so that @max_connections@ can be updated from the default of 100. It would involve adding @-... Roger Borrello

05:14 AM Bug #10560: Wrong buffer picking for ReadXml when seralization name of a buffer correspond to the...

Rebased task branch *10560a* to trunk revision *16250*. Teodor Gorghe

05:01 AM Bug #10560: Wrong buffer picking for ReadXml when seralization name of a buffer correspond to the...

Teodor: please rebase 10560a. Constantin Asofiei

10/27/2025

09:39 AM Bug #9633 (WIP): bulk delete for permanent tables

Branch 9633a was rebased with trunk/16246, current revision is 16248. I'm handing this over to Stefanel, I'll walk hi... Andrei Iacob

09:27 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Constantin Asofiei wrote:
>
> For now, please upgrade build.gradle to 1.63 in 10526a.
Sure. In rev. 16151. Eduard Soltan

09:20 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Eduard Soltan wrote:
> Constantin Asofiei wrote:
> > Eduard: please merge 10526a_h2 to fwd-h2 trunk.
>
> Done, i... Constantin Asofiei

09:06 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Constantin Asofiei wrote:
> Eduard: please merge 10526a_h2 to fwd-h2 trunk.
Done, is there a task for notificatio... Eduard Soltan

08:09 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Eduard: please merge 10526a_h2 to fwd-h2 trunk. Constantin Asofiei

07:57 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Constantin Asofiei wrote:
> Alexandru: can we merge 10526a_h2 to fwd-h2-trunk so 10526a can upgrade the fwd-h2 rev?
... Alexandru Lungu

07:44 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Alexandru: can we merge 10526a_h2 to fwd-h2-trunk so 10526a can upgrade the fwd-h2 rev? Constantin Asofiei

07:37 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Constantin Asofiei wrote:
> Eduard, what's the state of 10526a_h2 ? I assume this is mandatory for the original cus... Eduard Soltan

07:35 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Eduard, what's the state of 10526a_h2 ? I assume this is mandatory for the original customer scenario to be solved? Constantin Asofiei