Project

General

Profile

Activity

From 03/14/2024 to 04/12/2024

04/11/2024

03:56 PM Bug #8621: better resolution of ambiguous constructors/methods in RuntimeJastInterpreter
The caching mechanism is in place since the early implementation. Since the structure of the JAST in which the constr... Ovidiu Maxiniuc
01:07 PM Bug #8621: better resolution of ambiguous constructors/methods in RuntimeJastInterpreter
What we need to implement for method/constructor matching is actually the Java compiler's algorithm for linking the c... Constantin Asofiei
12:59 PM Bug #8621: better resolution of ambiguous constructors/methods in RuntimeJastInterpreter
@RuntimeJastInterpreter.findMatchingConstructor@ currently returns @null@ when it finds more than one c'tor whose sig... Eric Faulhaber
12:26 PM Bug #8621 (New): better resolution of ambiguous constructors/methods in RuntimeJastInterpreter
Eric Faulhaber

04/10/2024

02:38 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
Just a thing that was on my mind and wanted to have it here as well:
For NO-UNDO cases, we used to rollback (trans...
Alexandru Lungu
01:25 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
Alexandru Lungu wrote:
> Eric, even for a sub-transaction. We can simply delete and rollback to savepoint, right?
...
Eric Faulhaber
12:04 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
Eric, even for a sub-transaction. We can simply delete and rollback to savepoint, right? Alexandru Lungu
11:29 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
Greg Shah wrote:
> Seems like a long-standing leak of records. If that built up to a large number, it might be both...
Eric Faulhaber
08:52 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
Seems like a long-standing leak of records. If that built up to a large number, it might be both a memory leak and a... Greg Shah
07:59 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
Alexandru Lungu wrote:
> Still, why are we updating with a @<delete-multiplex>@ instead of actually deleting them? I...
Eric Faulhaber
07:30 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
> For MultiplexedScanIndex, the target batch in setRow(key, row) is calculated from the record's key (which is not ch... Alexandru Lungu
06:46 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
No, the @empty-temp-table@ is the problem, while executing in a transaction, for an undoable temp-table - this does n... Constantin Asofiei
06:41 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
Constantin Asofiei wrote:
> For an undoable temp-table, a @EMPTY-TEMP-TABLE@ results in a @UPDATE tt1 SET _multiplex...
Alexandru Lungu
05:11 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
The recreate is this:
* @mpid1.p@...
Constantin Asofiei
03:59 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
Constantin Asofiei wrote:
> Alexandru, the assumption was that the @MultiplexedBatchIndex$Batch@ holds data *only fo...
Alexandru Lungu

04/09/2024

01:07 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
Alexandru, the assumption was that the @MultiplexedBatchIndex$Batch@ holds data *only for a certain multiplex*. This... Constantin Asofiei

04/08/2024

03:40 PM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...
@WRITE-JSON@ will always leave the current/working buffer empty when it is finished, causing it content to be eventua... Ovidiu Maxiniuc
02:48 PM Bug #7473 (WIP): rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuil...
Ovidiu, are you aware if the @WRITE-JSON@ was finally rewritten without side-effects? Otherwise, Eduard B. can pick i... Alexandru Lungu
05:19 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
Constantin Asofiei wrote:
> You mean the Row.key is not the same as the internal PK?
I mean Row.key to be the same ...
Constantin Asofiei
05:15 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
You mean the Row.key is not the same as the internal PK?
Also, there is 'recid' index (with just this column) in H...
Constantin Asofiei
04:45 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'
> Created task branch 8593a_h2 which improves the @DELETE FROM tt1 WHERE tt1._multiplex = ?@. The reasoning is this:... Alexandru Lungu
03:08 AM Bug #8593 (Review): H2 performance improvement for table 'truncate by multiplex'
Created task branch 8593a_h2 which improves the @DELETE FROM tt1 WHERE tt1._multiplex = ?@. The reasoning is this:
...
Constantin Asofiei
02:56 AM Bug #8593 (Test): H2 performance improvement for table 'truncate by multiplex'
Constantin Asofiei
08:34 PM Bug #8554 (Test): resolving temp-tables in a class hierarchy
Greg Shah

04/06/2024

01:41 PM Bug #8554: resolving temp-tables in a class hierarchy
Branch 8554a was merged into trunk as rev. 15125 and archived. Constantin Asofiei
12:40 PM Bug #8554: resolving temp-tables in a class hierarchy
You can merge to trunk now.
Hynek: 8152a can merge after 8554a.
Greg Shah
03:15 AM Bug #8554 (Merge Pending): resolving temp-tables in a class hierarchy
Ovidiu, I've fixed the visibility in rev 15127 (after rebase).
ETF testing passed. It can be merged to trunk.
Constantin Asofiei

04/05/2024

06:11 PM Bug #8589: Deprecate the shared temporary database completely
Unless there is a _significant_ memory savings or some other substantial advantage of shared mode, I think we should ... Eric Faulhaber
03:45 AM Bug #8589: Deprecate the shared temporary database completely
In the original support for _temp database, one single in-memory database was created. All sessions used that single ... Alexandru Lungu
03:05 AM Bug #8589 (New): Deprecate the shared temporary database completely
Alexandru Lungu

04/04/2024

06:39 PM Bug #8554: resolving temp-tables in a class hierarchy
Review of 8554a, r15120-15122.
I am OK with the code. I'm sorry I made a mess with condition codes which do and do...
Ovidiu Maxiniuc
04:21 PM Bug #8554: resolving temp-tables in a class hierarchy
Ovidiu, please review this, I'll get ETF testing tomorrow and if is OK, I'd like to merge this tomorrow. Constantin Asofiei
07:41 AM Bug #8554 (Review): resolving temp-tables in a class hierarchy
15122 fixes some issues, javadocs and some errors which must not set ERROR-STATUS:ERROR. This can be reviewed.
I'...
Constantin Asofiei
05:31 AM Bug #8554 (WIP): resolving temp-tables in a class hierarchy
Created task branch 8554a from trunk rev 15119.
15120 and 15121 has a rough fix for this - need to validate it.
Constantin Asofiei

04/01/2024

08:49 AM Bug #8554: resolving temp-tables in a class hierarchy
@DATASET:CREATE-LIKE("<dataset-name>")@ needs to be checked, too. Constantin Asofiei

03/31/2024

10:35 AM Bug #8554: resolving temp-tables in a class hierarchy
There are some problems when resolving temp-tables in a hierarchy.
* @oo.Test1@:...
Constantin Asofiei
10:28 AM Bug #8554 (Test): resolving temp-tables in a class hierarchy
Constantin Asofiei

03/27/2024

11:39 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill
With 8363f where @DATASET:FILL@ is optimized to use @hintFullResults@, this test fails if @AdaptiveQuery.hintFullResu... Constantin Asofiei

03/25/2024

02:53 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
There should be a distinction between equality check when updating/inserting and the equality check when querying. We... Alexandru Lungu

03/22/2024

01:36 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Well, this is pretty bad in my opinion. I don't really have a solution for this, I need to think this through a bit m... Radu Apetrii
05:07 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Radu Apetrii wrote:
> Constantin Asofiei wrote:
> > The problem is this happens only when we do a unique validation...
Alexandru Lungu
04:22 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Alexandru Lungu wrote:
> Merged to trunk as rev. 15085.
Please post to #7847 also.
Constantin Asofiei
04:16 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Constantin Asofiei wrote:
> The problem is this happens only when we do a unique validation using SELECT, and not on...
Radu Apetrii
04:10 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Merged to trunk as rev. 15085. Alexandru Lungu
04:04 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Created 8459b and committed the disable for USE_NULL_EQUALITY.
Preparing for merge with trunk.
Alexandru Lungu
03:55 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
... Constantin Asofiei
03:52 AM Bug #8459 (WIP): investigate changing H2 to allow NULL to equal NULL (and the impact on the other...
There is a regression in #7143-784 related to the NULL changes in H2. If I comment @use_null_equality=true;@, then t... Constantin Asofiei
09:37 AM Bug #8496: investigate if a 'batch insert with deactivated index' in H2 is possible
Constantin Asofiei wrote:
> The idea is to have a mode in H2 where indexes are not *updated(?) after each insert*. ...
Ovidiu Maxiniuc
07:44 AM Bug #8496: investigate if a 'batch insert with deactivated index' in H2 is possible
Constantin, for FILL we do 50k independent inserts. Can we maybe bulk them? Or do we actually need the intermediate s... Alexandru Lungu
09:27 AM Bug #8500 (Test): dataset:set-buffers must use default-buffer-handle if a temp-table handle is used
Constantin Asofiei
09:27 AM Bug #8500: dataset:set-buffers must use default-buffer-handle if a temp-table handle is used
Branch 8500a was merged into trunk as rev. 15086 and archived. Constantin Asofiei
09:23 AM Bug #8500: dataset:set-buffers must use default-buffer-handle if a temp-table handle is used
Cor, please use this archive. Constantin Asofiei
09:19 AM Bug #8500 (Merge Pending): dataset:set-buffers must use default-buffer-handle if a temp-table han...
Created task branch 8500a from trunk rev 15085.
Ref 15086 fixes:
* @SET-BUFFERS(handle...)@ must use the DEFAULT...
Constantin Asofiei
09:13 AM Bug #8500 (Test): dataset:set-buffers must use default-buffer-handle if a temp-table handle is used
Constantin Asofiei

03/21/2024

03:32 PM Feature #7366: improve performance of buffer.fill
Idea of improvements:
* the data-source query may or may not use all record fields, depending on the mapping. We ca...
Constantin Asofiei
02:55 PM Bug #8496: investigate if a 'batch insert with deactivated index' in H2 is possible
Above 're-balance' actually means re-building the index... so this may be expensive on its own. Constantin Asofiei
02:52 PM Bug #8496: investigate if a 'batch insert with deactivated index' in H2 is possible
There are operations where we do lots of inserts. In some case, in a FILL operation, some 50k temp-table records are... Constantin Asofiei
02:43 PM Bug #8496 (New): investigate if a 'batch insert with deactivated index' in H2 is possible
Constantin Asofiei
02:47 PM Bug #8451 (Test): improve performance of H2 String column comparison
Greg Shah
02:23 PM Bug #8451: improve performance of H2 String column comparison
Branch 8451a was created from trunk rev 15082. Rev 15083 contains the FWD-H2 build.gradle upgrade to rev 1.43.
Br...
Constantin Asofiei
02:13 PM Bug #8451 (Merge Pending): improve performance of H2 String column comparison
ETF testing passed, starting merge. Constantin Asofiei
07:58 AM Bug #8451: improve performance of H2 String column comparison
Greg Shah wrote:
> Is more testing needed?
I'm doing ETF testing with it.
Constantin Asofiei
02:27 PM Bug #8488 (Test): improve performance of WRITE-JSON
Branch 8488a was merged into trunk as rev. 15084 and archived. Constantin Asofiei
02:24 PM Bug #8488 (Merge Pending): improve performance of WRITE-JSON
Merging now. Constantin Asofiei
12:42 PM Bug #8488: improve performance of WRITE-JSON
I have re-review the 8488a up to r15080 and I am OK with the changes.
The branch can be merged to trunk.
Ovidiu Maxiniuc
11:08 AM Bug #8488: improve performance of WRITE-JSON
I'm good with that plan. Greg Shah
10:59 AM Bug #8488 (Internal Test): improve performance of WRITE-JSON
There are regressions related to AdaptiveFind (from #8490), otherwise 8488a and #8451 passed.
I'm testing #8459 ne...
Constantin Asofiei
07:57 AM Bug #8488 (Review): improve performance of WRITE-JSON
Constantin Asofiei
07:42 AM Bug #8488: improve performance of WRITE-JSON
Ovidiu, in rev 15080 I have the review fixes. See bellow for notes:
> * In @P2JQuery.java@, you added @public defau...
Constantin Asofiei
02:12 PM Bug #8459 (Test): investigate changing H2 to allow NULL to equal NULL (and the impact on the othe...
Branch 8459a was merged into trunk as rev. 15082 and archived. Constantin Asofiei
02:04 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
I've started merge of 8459a. Constantin Asofiei
06:29 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
fwd-h2 1.42 is on projsrv01. Constantin Asofiei
05:42 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Constantin Asofiei wrote:
> Alexandru, I'm good.
>
> Radu: if unit tests/standalone tests are OK, please build fw...
Radu Apetrii
05:20 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Alexandru, I'm good.
Radu: if unit tests/standalone tests are OK, please build fwd-h2 and upload it to @devsrv01:/...
Constantin Asofiei
03:48 AM Bug #8459 (Internal Test): investigate changing H2 to allow NULL to equal NULL (and the impact on...
The unit tests in H2 suffice. I think you are good to go with the merge of 8459a_h2.
Constantin, anything to add h...
Alexandru Lungu
03:43 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Alexandru Lungu wrote:
> What about simple comparison with @EQUAL@ (instead of 0) and @NON_EQUAL@ (instead of 5)? Am...
Radu Apetrii
03:35 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
What about simple comparison with @EQUAL@ (instead of 0) and @NON_EQUAL@ (instead of 5)? Am I missing something? Alexandru Lungu
09:30 AM Feature #8494: rework XmlExport with the performance improvements from JsonExport
Implement the same performance improvements as were done in #8488. Greg Shah
09:29 AM Feature #8494 (New): rework XmlExport with the performance improvements from JsonExport
Greg Shah
08:43 AM Feature #7323 (Test): Implement soft unique index in FWD-H2
Got it! Alexandru Lungu
08:43 AM Feature #7323: Implement soft unique index in FWD-H2
Branch 7323b was merged into trunk as rev. 15075 and archived. Constantin Asofiei
08:41 AM Feature #7323: Implement soft unique index in FWD-H2
Constantin, unless you started the process, I will prepare for merge in ~10 mins. Alexandru Lungu

03/20/2024

06:51 PM Bug #8488: improve performance of WRITE-JSON
Constantin Asofiei wrote:
> Ovidiu, an early review is appreciated - I still need to regression test in standalone t...
Ovidiu Maxiniuc
03:52 PM Bug #8488 (WIP): improve performance of WRITE-JSON
Created branch 8488a from trunk rev 15077. In rev 15088 there are performance improvements for WRITE-JSON:
* Avoid ...
Constantin Asofiei
12:25 PM Bug #8488 (Test): improve performance of WRITE-JSON
Constantin Asofiei
04:54 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Alexandru Lungu wrote:
> Can we replace these with something more suggestive. Are these EQUAL and NON_EQUAL, or some...
Radu Apetrii
03:24 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
I am OK with 8459a_h2 changes. Good addition with the unit test!
The @getValue@ looks right to me. The only concer...
Alexandru Lungu
11:05 AM Feature #7323 (Merge Pending): Implement soft unique index in FWD-H2
You can merge to trunk now. Greg Shah
10:50 AM Feature #7323: Implement soft unique index in FWD-H2
Greg Shah wrote:
> What testing is needed?
I've tested with the #8363 app and there is no regression in performance...
Constantin Asofiei
07:36 AM Feature #7323 (Internal Test): Implement soft unique index in FWD-H2
What testing is needed? Greg Shah
06:47 AM Feature #7323: Implement soft unique index in FWD-H2
Alexandru, I agree, the change is in 7323b rev 15075. Constantin Asofiei
05:30 AM Feature #7323: Implement soft unique index in FWD-H2
Then I agree with Constantin's changes. Before, the 7323a changes, the flush (so the DB validation0 was done only if ... Alexandru Lungu
04:48 AM Feature #7323: Implement soft unique index in FWD-H2
Alexandru Lungu wrote:
> Radu/Constantin: can you share how the condition looked like before the 7323a changes?
Thi...
Radu Apetrii
04:40 AM Feature #7323: Implement soft unique index in FWD-H2
AFAIK, the condition there was rewritten to consider DBUniqueCheck, but remain equivalent to what was before. I prefe... Alexandru Lungu
02:58 AM Feature #7323 (Review): Implement soft unique index in FWD-H2
Created task 7323b from trunk rev 15073. The fix in previous note is in rev 15074. Please review. Constantin Asofiei
08:52 AM Bug #8451 (Internal Test): improve performance of H2 String column comparison
Is more testing needed? Greg Shah
07:53 AM Bug #8451: improve performance of H2 String column comparison
The changes are good:
* Good job in leveraging the @collationKeys@ caches with this @ValueString@ ci/cs keys.
* I...
Alexandru Lungu
07:43 AM Bug #8451: improve performance of H2 String column comparison
Checking out now. Alexandru Lungu
07:15 AM Bug #8451: improve performance of H2 String column comparison
Alexandru: can you review this today?
Greg: if review is OK, I'd like to get this merged.
Constantin Asofiei
08:43 PM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource
The hotel project built without any issues, without any additional changes. The @.meta.xml@ files had been generated ... Ovidiu Maxiniuc

03/19/2024

06:58 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
I've committed to 8459a_h2 rev. 43 changes that include:
* Added a case for handling equality between a null compone...
Radu Apetrii
04:03 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Also, one more thing. In @Comparison.getValue@, depending on the @compareType@ value, things should be treated for bo... Radu Apetrii
03:11 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
I am OK with the changes in 8459a (FWD branch).
For FWD-H2:
* In @compare@, you need to also explicitly handle th...
Alexandru Lungu
01:19 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Radu Apetrii wrote:
> Constantin Asofiei wrote:
> > Please rebase both 8459a_h2 and 8459a.
> On it.
Done. 8459a r...
Radu Apetrii
01:16 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Who should be doing the review? Greg Shah
12:57 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Constantin Asofiei wrote:
> Please rebase both 8459a_h2 and 8459a.
On it.
Radu Apetrii
12:56 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Please rebase both 8459a_h2 and 8459a. Constantin Asofiei
12:50 PM Bug #8459 (Review): investigate changing H2 to allow NULL to equal NULL (and the impact on the ot...
Constantin Asofiei wrote:
> Radu, do you have the FWD and H2 changes, for some early testing?
Yes, sorry for the de...
Radu Apetrii
12:20 PM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Radu, do you have the FWD and H2 changes, for some early testing? Constantin Asofiei
04:09 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Radu Apetrii wrote:
> Alexandru Lungu wrote:
> > Create a flag like in the [[internal-documentation:H2_Database_For...
Constantin Asofiei
04:05 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Alexandru Lungu wrote:
> Create a flag like in the [[internal-documentation:H2_Database_Fork]] Wiki and use it to di...
Radu Apetrii
04:09 PM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource
Eugenie Lyzenko wrote:
> Ovidiu Maxiniuc wrote:
> > Branch 7645a was merged into trunk as rev. 15070 and archived.
...
Eric Faulhaber
03:06 PM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource
Ovidiu Maxiniuc wrote:
> Branch 7645a was merged into trunk as rev. 15070 and archived.
>
> Reconversion is not m...
Eugenie Lyzenko
02:01 PM Bug #7645 (Test): Simplify _meta database initialization by removing <schema>.meta.xml resource
Branch 7645a was merged into trunk as rev. 15070 and archived.
Reconversion is not mandatory. But if done the @<db...
Ovidiu Maxiniuc
01:52 PM Feature #7323: Implement soft unique index in FWD-H2
Found a regression in 7323a changes:... Constantin Asofiei
10:31 AM Feature #7323 (Test): Implement soft unique index in FWD-H2
Branch 7323a was merged into trunk as rev. 15065 and archived.
7323b_h2 was merged into FWD-H2 trunk rev 41 and ar...
Constantin Asofiei
10:11 AM Feature #7323: Implement soft unique index in FWD-H2
Yes, working on it. Constantin Asofiei
09:52 AM Feature #7323: Implement soft unique index in FWD-H2
Constantin, you need to merge H2 first, build, upload the FWD binary, commit to the FWD branch the upgrade and *after... Alexandru Lungu
09:27 AM Feature #7323 (Merge Pending): Implement soft unique index in FWD-H2
You can merge now. Greg Shah
04:18 AM Feature #7323: Implement soft unique index in FWD-H2
*Review of 7323b_h2*
* I reviewed Radu's changes in the past and they were OK.
* Recent changes are fine to me. I...
Alexandru Lungu
12:36 AM Feature #7323: Implement soft unique index in FWD-H2
Code review 7323a/15068:
The changes look ok to me, though it is a little confusing that the SOFT_INDEX keyword is...
Eric Faulhaber
12:15 PM Bug #8451 (Review): improve performance of H2 String column comparison
Created 8451a_h2 from fwd-h2 trunk rev 41. In rev 42, I've implemented the idea in #8451-5 - cache the collation key... Constantin Asofiei

03/18/2024

06:35 AM Bug #8451: improve performance of H2 String column comparison
Please go ahead. I am quite -stuck- working with some heap dumps and #8380 at the moment. Alexandru Lungu
06:09 AM Bug #8451: improve performance of H2 String column comparison
Alexandru, the idea sounds promising - I can make the changes if you are busy with something else. Constantin Asofiei
06:00 AM Bug #8451: improve performance of H2 String column comparison
The idea I have for this task:
* As most of the (string) comparisons involve 1 or even 2 database fields, I sugges...
Alexandru Lungu
05:35 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Radu, I think we should restrict this with a flag. H2 is used with other goals in FWD and I don't what to make this c... Alexandru Lungu
05:34 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Radu Apetrii wrote:
> Alex/Constantin: Was the phrase @tt1.f1 is null@ added just for the H2 dialect, or is this nul...
Constantin Asofiei
04:45 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
Alex/Constantin: Was the phrase @tt1.f1 is null@ added just for the H2 dialect, or is this null equality an issue in ... Radu Apetrii
03:50 AM Bug #8459: investigate changing H2 to allow NULL to equal NULL (and the impact on the other compa...
I've attached a patch for H2 in order to allow null equality. It certainly needs a review and a set of performance te... Radu Apetrii

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
 

Also available in: Atom