Project

General

Profile

Activity

From 02/17/2024 to 03/17/2024

03/17/2024

03:04 PM Feature #7323: Implement soft unique index in FWD-H2
Constantin Asofiei wrote:
> I'm regression testing this with ETF.
ETF testing passed.
As a side note: we may wan...
Constantin Asofiei
12:22 PM Feature #7323: Implement soft unique index in FWD-H2
Created task branch 7323b_h2 from fwd-h2 trunk rev 40.
In rev 41, it adds a "soft_unique" option for index column...
Constantin Asofiei

03/16/2024

07:11 AM Feature #7323: Implement soft unique index in FWD-H2
What we need is to mark the @recid@ trailing component of a 'soft-unique' index as @soft-unique@, too - so this can b... Constantin Asofiei
08:47 PM Feature #7323: Implement soft unique index in FWD-H2
I committed to 7323a rev. 15067 a rebase fix for classes @Persistence@, @Persister@, and @Validation@. It seemed that... Radu Apetrii

03/15/2024

03:23 PM Feature #7323: Implement soft unique index in FWD-H2
I've placed on @devsrv01:/tmp/7323a_rev_14805_trunk_14789.7z@ the pre-rebase branch, in case you need it. Constantin Asofiei
01:06 PM Feature #7323: Implement soft unique index in FWD-H2
Constantin Asofiei wrote:
> @validateUniqueByQuery@ is still called for temp-tables. Why is that?
This shouldn't b...
Radu Apetrii
12:30 PM Feature #7323: Implement soft unique index in FWD-H2
I've discussed this morning with Radu what this task is meant to do and I think I understand it: let H2 throw an exce... Constantin Asofiei
01:30 PM Bug #7474: FindQuery provides the wrong result because the record is not updated in the database
I think I've implemented a fix on this.
The issue was related with a fact, that @RecordNursery@ was only involved in...
Tomasz Domin
08:29 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
This test shows the 'unknown equality' in OpenEdge:... Constantin Asofiei
07:38 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
If you have two big tables and none have indexes, on join, it should do scan on both tables (nested join - N * M comp... Alexandru Lungu
07:36 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Constantin Asofiei wrote:
> will make H2 use the scan index.
Constantin, is there a chance that you can point me to...
Radu Apetrii
07:03 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
I created branch 8459a_h2 for this matter. Radu Apetrii
04:12 AM Bug #8459 (WIP): investigate changing H2 to allow NULL to equal NULL (and the impact on the other...
With #8363, FWD now has a MANDATORY option allowed at temp-table fields. When using joins, this can have a huge impa... Constantin Asofiei
04:08 AM Bug #8459 (WIP): investigate changing H2 to allow NULL to equal NULL (and the impact on the other...
Constantin Asofiei

03/14/2024

03:48 PM Bug #8044: Fix "Failed direct-access due to Error direct accessing for finding record by unique i...
Just to notify - I am still getting a lot of "Failed direct-access due to Error direct accessing for finding record b... Tomasz Domin
10:46 AM Feature #7323: Implement soft unique index in FWD-H2
Alexandru/Radu, I think we may need a call to discuss the soft index approach.
Radu: I took a look again at 7323a ...
Constantin Asofiei
10:43 AM Bug #8451: improve performance of H2 String column comparison
When executing the #8363 scenarios, there are ~20 million calls of @CompareModeDefault.comapreString@. This relies o... Constantin Asofiei
10:37 AM Bug #8451 (Test): improve performance of H2 String column comparison
Constantin Asofiei

03/13/2024

12:43 PM Feature #7323: Implement soft unique index in FWD-H2
I've tested with #8363 and there is no impact or makes things slightly worse in some cases. Constantin Asofiei
06:45 AM Feature #7323: Implement soft unique index in FWD-H2
Radu Apetrii wrote:
> Constantin Asofiei wrote:
> > Radu Apetrii wrote:
> > > Done. Rebased 7323a with trunk rev.1...
Constantin Asofiei
06:42 AM Feature #7323: Implement soft unique index in FWD-H2
Constantin Asofiei wrote:
> Radu Apetrii wrote:
> > Done. Rebased 7323a with trunk rev.15051, meaning that 7323a is...
Radu Apetrii
06:36 AM Feature #7323: Implement soft unique index in FWD-H2
Radu Apetrii wrote:
> Done. Rebased 7323a with trunk rev.15051, meaning that 7323a is now at rev. 15066.
Please che...
Constantin Asofiei
06:34 AM Feature #7323: Implement soft unique index in FWD-H2
Done. Rebased 7323a with trunk rev.15051, meaning that 7323a is now at rev. 15066. Radu Apetrii
05:14 AM Feature #7323: Implement soft unique index in FWD-H2
OK, I'll handle this now since I'm waiting for an import anyways. Radu Apetrii
05:10 AM Feature #7323: Implement soft unique index in FWD-H2
Constantin Asofiei wrote:
> I'm rebasing 7323a and 7323a_h2 to check them with #8363.
7323a_h2 was already merged t...
Constantin Asofiei
04:56 AM Feature #7323: Implement soft unique index in FWD-H2
I'm rebasing 7323a and 7323a_h2 to check them with #8363. Constantin Asofiei
09:22 PM Bug #7645 (Review): Simplify _meta database initialization by removing <schema>.meta.xml resource
The fixes are done. I also did a bit of cleanup and code maintenance.
Here is a bit of code which dumps the metadata...
Ovidiu Maxiniuc

03/12/2024

03:57 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill
The changes in the patch were committed to trunk via 8363a, which was merged to trunk as revision 15049.
Constantin Asofiei
03:50 AM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource
Committed on 7645a, revision 15018.
In this commit I addressed most of the review issues, however I was investigat...
Eduard Soltan

03/11/2024

02:16 PM Bug #6997: OUTPUT BY-REFERENCE records are not cleared
The problem in this task still exists. Constantin Asofiei

03/07/2024

02:44 PM Bug #7645 (WIP): Simplify _meta database initialization by removing <schema>.meta.xml resource
Review of 7645a/15017.
So far, so good. I am OK with the revision, I like the splitting of the code in very specif...
Ovidiu Maxiniuc
02:49 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill
I've committed the patch to 8363a rev 15038. Constantin Asofiei
02:45 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill
Hmm, I am not 100% familiar of how the FILL works. I was supposing it can take any arbitrary query to do the fill. So... Alexandru Lungu
02:32 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill
Alexandru, using the patch helps #8363. But, I wonder if your patch is just something to do the same thing as inject... Constantin Asofiei

03/05/2024

10:09 AM Bug #7474: FindQuery provides the wrong result because the record is not updated in the database
I've hit the issue while working on intra session dirty share - in case record is modified in a transaction different... Tomasz Domin
06:01 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill
Constantin, this is the patch I used in an attempt to optimize @ProgressiveResults@ into @ScrollingResults@ when usin... Alexandru Lungu

03/04/2024

04:06 PM Bug #8101 (Closed): Issue with temp-table defined as reference-only
Fixed in trunk rev 15028 via 8329a. Constantin Asofiei
10:56 AM Bug #7645 (Review): Simplify _meta database initialization by removing <schema>.meta.xml resource
Alexandru Lungu
03:38 AM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource
Eduard Soltan wrote:
> Eric Faulhaber wrote:
> > Eduard, is this ready for review? Is there anything left to do on ...
Eduard Soltan
03:37 AM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource
Eric Faulhaber wrote:
> Eduard, is this ready for review? Is there anything left to do on this, other than regressio...
Eduard Soltan
09:08 PM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource
Eduard, is this ready for review? Is there anything left to do on this, other than regression testing? Eric Faulhaber

02/29/2024

04:13 AM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource
Committed on 7645a. revision 15017.
I moved the logic from metaschema.xml into MetadataManger class, and created a...
Eduard Soltan
03:21 AM Bug #7645 (WIP): Simplify _meta database initialization by removing <schema>.meta.xml resource
Eduard Soltan

02/20/2024

07:57 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
After testing POC with JMXs I found out that @(select count()) = 1@ is used often and a lot more than with @FIRST@ or... Dănuț Filimon
03:13 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
I've made a few examples to check if there are other methods used and got the following:
* @CAN-FIND(pt1)@ generated...
Dănuț Filimon

02/19/2024

02:13 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB
Checking for @exists@ in the FQL seems like a reasonable approach. Right now, it is only used to implement server-sid... Eric Faulhaber
 

Also available in: Atom