Activity
From 01/31/2023 to 03/01/2023
03/01/2023
- 01:31 PM Feature #6444: dataset improvements
- Added support for the RESTART-ROW attribute.
Committed to 6444a/14499. - 05:19 AM Feature #7061: Enable the use of lazy result sets in H2
- This is not the way to do it. @AdaptiveQuery.open@ is called only by explicit queries, usually dynamic (@QUERY-OPEN@ ...
- 03:46 AM Feature #7061: Enable the use of lazy result sets in H2
- Alexandru Lungu wrote:
> Further in my tests, I've got a crash when checking the dialect of the buffer in @AdaptiveQ... - 02:12 AM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries
- Thanks, I was thinking of something else and I recalled in the wrong way; in a customer app, buffer names are generat...
02/28/2023
- 06:50 PM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries
- Constantin, we are already doing this. After the query is parsed, the constants are extracted as variables. Each time...
- 05:33 PM Feature #6371: implement SAVE CACHE statement
- Pushed initial implementation of @DTTZ@ support in @SchemaCheck@ as revision 6371b/14486. I am just not sure where th...
- 07:23 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- > One of the problems I have right now is that the rows are missing parameters when comparing in H2 and I am looking ...
- 02:49 AM Feature #7062: Direct access to H2 internals to solve basic queries
- Committed 7026a/14507 removing some tracing variables - missed them on my first check.
02/27/2023
- 05:05 PM Feature #6371: implement SAVE CACHE statement
- Tested and pushed Sequences and validations as revision 6371b/14485. Proceeding with timezone support.
- 09:24 AM Feature #7062: Direct access to H2 internals to solve basic queries
- Done, committed 7026a/rev. 14506.
- 08:04 AM Feature #7062: Direct access to H2 internals to solve basic queries
- Alexandru Lungu wrote:
> [...]
> I will also allow such optimization for queries without client-where, joins and ex... - 08:01 AM Feature #7062: Direct access to H2 internals to solve basic queries
- ...
- 07:58 AM Feature #7062: Direct access to H2 internals to solve basic queries
- This was a last minute modification and the @LOCK_MODE 0@ from H2 was stuck in my head. It struck me at some point th...
- 07:47 AM Feature #7062: Direct access to H2 internals to solve basic queries
- Alexandru, the changes in RandomAccessQuery will not set the lock properly on a record found in the cache:...
- 08:53 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- Integrated the patch into 7062a. Also, the H2 changes made it to trunk.
I've reviewed the changes again and I have... - 08:45 AM Bug #7132: Eliminate for-each loops and lambda in FWD-H2 code
- Done several testing iterations with 7132a_h2/rev. 15 and the issue is solved. The bad news are that I couldn't notic...
- 04:58 AM Feature #6444: dataset improvements
- Tested the (de)serialization of recursive data relation for the remote calls.
Works OK. - 03:56 AM Feature #6582: implement multi-table AdaptiveQuery
- #7061 is mostly finished and now we have a @lazy@ keyword in FWD-H2 which works as a H2 database-cursor allowing us t...
- 03:15 AM Feature #7061: Enable the use of lazy result sets in H2
- Radu, I merged your changes from 7061a to 7026a. Note that 7026a is frozen right now.
First of all, I moved @suppo...
02/25/2023
- 07:16 AM Feature #6444: dataset improvements
- Finished re-testing fixes for this task and #6453 after rebasing 6444a branch to the new trunk is finished.
Committe...
02/24/2023
- 03:12 PM Bug #6812 (WIP): fix FastFindCache to use a shared instance per persistent database
- I converted the code to use @Database@ object directly and reverted changes I made initially to visibility modifiers....
- 09:18 AM Bug #6812: fix FastFindCache to use a shared instance per persistent database
- I pushed the patch as revision 6812a/14485, working on better implementation (@Database@ object as key, cleanup, etc.)
- 11:06 AM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries
- Another point related to #6813-9 with query predicates which differ just with inlined literals. After the predicate ...
- 06:58 AM Feature #7062: Direct access to H2 internals to solve basic queries
- I merged the changes from 7062a into 7026a - the branch names are quite confusing :)
I have good results, similar ... - 06:02 AM Feature #7061: Enable the use of lazy result sets in H2
- > I'll wait for a final decision on this.
Well, it definitely looks like it really depends on the converted code. I ... - 05:46 AM Feature #7061: Enable the use of lazy result sets in H2
- Alexandru Lungu wrote:
> Alexandru Lungu wrote:
> > ** Count how many actual lazy queries are there in a large appl... - 04:21 AM Feature #7061: Enable the use of lazy result sets in H2
- Alexandru Lungu wrote:
> ** Count how many actual lazy queries are there in a large application: static vs dynamic, ... - 04:42 AM Bug #7132: Eliminate for-each loops and lambda in FWD-H2 code
- Alexandru Lungu wrote:
> Please make a new commit which reverts the changes for that less used classes. I would like...
02/23/2023
- 05:17 PM Bug #6812: fix FastFindCache to use a shared instance per persistent database
- Please create a 6812a branch from trunk and apply the diff. This will make it easier to review in context.
I've on... - 04:40 PM Bug #6812: fix FastFindCache to use a shared instance per persistent database
- I am attaching a suggested solution. It's somewhat raw (I had to make some elements public), but I can fix that for t...
- 12:35 PM Feature #6444: dataset improvements
- I'm re-testing temp-table ans data-set changes from #6453 and this task with 6444a rebased to the trunk.
After fixin... - 11:08 AM Bug #7132 (WIP): Eliminate for-each loops and lambda in FWD-H2 code
- *This is a review for 7132a_h2, rev. 14*
There are many changes in several files, so I've done a skim review of th... - 09:24 AM Bug #7132: Eliminate for-each loops and lambda in FWD-H2 code
- Alexandru Lungu wrote:
> Lastly, I think there may be an overhead by using @synchronized@ even in single-user H2 ins... - 09:39 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2
- I recall a scenario in which some records were updated in a for-loop and their new values were the same as the old va...
- 08:13 PM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2
- These should not occur since we create the @SET@ part of statement based only on changed properties (@BaseRecord.dirt...
- 04:53 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Ovidiu Maxiniuc wrote:
> I altered your tests and remove the index for both tables: in this case we have the more lo...
02/22/2023
- 04:34 PM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- I am really puzzled about this fact. I found the article in a parallel investigation. It really shocked my understand...
- 07:00 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Alexandru Lungu wrote:
> Danut, please extract this into a separate 4GL test: CI database field with CS query parame... - 03:33 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Ovidiu Maxiniuc wrote:
> Yes, this could be an improvement if the strings are really different at their beginning. T... - 11:23 AM Feature #7061: Enable the use of lazy result sets in H2
- I reverted your latest changes to H2 because I wanted to merge a tested, profiled version (rev. 15).
* The null che... - 03:44 AM Feature #7061: Enable the use of lazy result sets in H2
- Alexandru Lungu wrote:
> > If the dependency is the H2 dialect on its own, then I think the condition should be some... - 08:57 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2
- I encountered several fake-updates in large customer applications. A fake-update is something like @UPDATE tt SET f1 ...
- 08:50 AM Bug #7138 (Closed): Short circuit fake-update (update with a new value eqaul to the old value) in H2
02/21/2023
- 03:40 PM Feature #6371: implement SAVE CACHE statement
- Please create a 6371b branch from trunk for this patch and the other remaining features. Thanks.
- 02:36 PM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Alexandru Lungu wrote:
> I agree that we still need to use the @Collator@, but maybe we could have done something li... - 05:17 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Ovidiu Maxiniuc wrote:
> I looked again at your results in #7108-8. They do not seem alright. There are several case... - 05:04 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Ovidiu Maxiniuc wrote:
> Yes, I think we need that. I do not have an exact example (when I was working with these I ... - 12:26 PM Bug #7113 (Review): Problem with nested CAN-FIND conversion
- Fixed SQL generation.
Committed to 7113a/14896.
Please review.
Thank you. - 11:57 AM Bug #7047: Problem with AdaptiveQuery and ScrollableResults
- Alexandru Lungu wrote:
> I can't say why PostgreSQL behaves differently, but logically all non-scrolling 4GL queri... - 09:34 AM Bug #7047: Problem with AdaptiveQuery and ScrollableResults
- As a side investigation which may help here:
@AdaptiveQuery@ is not considering @recid@ index as a sorting index. ... - 10:00 AM Bug #7132: Eliminate for-each loops and lambda in FWD-H2 code
- Committed rev. 13 finishing replacements from for-each loops to classical for loops. I've done some tests, but there ...
- 07:14 AM Bug #7132: Eliminate for-each loops and lambda in FWD-H2 code
- Created 7132a_h2 from trunk rev. 11. Committed rev. 12 including lots of replacements from for-each loops to classica...
- 08:26 PM Feature #7020 (Review): always use "expanded" extent fields
- I attempted to rebase 7020a to trunk, but that proved to be a very time consuming task, practically duplicating Const...
02/20/2023
- 03:45 PM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Alexandru Lungu wrote:
> I am facing a hot-spot in my profiling that may actual affect #7108 effort as well. It is r... - 02:24 PM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Dănuț Filimon wrote:
> The tests from #7108-8 were done *without any patch applied*. I retested with the patch appli... - 08:48 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Ovidiu, I recall that you had done some work with locale at some point. Please let me know if you can help me on this...
- 02:28 PM Bug #7113: Problem with nested CAN-FIND conversion
- The only remaining issue is that generated SQL statement contains extra closing brackets @)@ at the end of the WHERE ...
- 11:20 AM Bug #7113: Problem with nested CAN-FIND conversion
- Committed fix for the nested CAN-FIND to 7113a/14485.
- 10:55 AM Bug #7113: Problem with nested CAN-FIND conversion
- Created task branch 7113a.
- 09:48 AM Bug #7113: Problem with nested CAN-FIND conversion
- Igor Skornyakov wrote:
> Igor Skornyakov wrote:
> > Fixed nested CAN-FIND conversion (see attached .diff).
> > Ple... - 08:52 AM Bug #7113: Problem with nested CAN-FIND conversion
- Igor Skornyakov wrote:
> Fixed nested CAN-FIND conversion (see attached .diff).
> Please review.
> Thank you.
>
... - 08:40 AM Bug #7113: Problem with nested CAN-FIND conversion
- Fixed nested CAN-FIND conversion (see attached .diff).
Please review.
Thank you.
Working on runtime issue (#7113... - 08:56 AM Bug #7132: Eliminate for-each loops and lambda in FWD-H2 code
- Alexandru Lungu wrote:
> Second, there is an overhead with using lambdas, especially the ones which reference local ... - 04:10 AM Bug #7132: Eliminate for-each loops and lambda in FWD-H2 code
- There is an overhead in using foreach loops: @for (Object obj : objs)@. This is because an iterator object is generat...
- 03:47 AM Bug #7132 (WIP): Eliminate for-each loops and lambda in FWD-H2 code
- 03:32 AM Feature #7061: Enable the use of lazy result sets in H2
- Radu:
* I've created 7061a branched from trunk to commit your changes to.
* Please notify me once you address the r...
02/17/2023
- 09:49 AM Feature #7061: Enable the use of lazy result sets in H2
- Alexandru Lungu wrote:
> As the patch and H2 modifications are mostly complete, in the sense that I have no obvious ...
02/16/2023
- 05:36 PM Bug #6887: improve performance of dataset/table[-handle] parameters
- The methods/attributes implemented by #6444 are not related to parameters. They perform the same regardless the datas...
- 04:31 PM Bug #6887: improve performance of dataset/table[-handle] parameters
- I didn't make any changes for this task. Not sure if there are any relevant changes coming from #6444.
- 03:23 PM Bug #6887: improve performance of dataset/table[-handle] parameters
- Has any of this implementation been touched by the recent waves of performance work in 3821c and 6129c, or are we ess...
- 03:26 PM Bug #6812: fix FastFindCache to use a shared instance per persistent database
- Boris, please look at the @FastFindCache@ implementation and ask any questions you may have as it pertains to this task.
- 03:19 PM Bug #6919: fix ErrorManager.displayError in TempTableBuilder
- Is there anything left to do on this task, or can we close it?
- 09:34 AM Feature #7061: Enable the use of lazy result sets in H2
- Eric Faulhaber wrote:
> One clarification to this point. It is not so much the fact that the new lazy mode should be... - 09:11 AM Support #7058: get the FWD fork of the H2 code base under version control
- *UPDATE*: regression testing passed; merged 7062a_h2 to FWD-H2 trunk including support for direct access to internal ...
- 06:18 AM Support #7058: get the FWD fork of the H2 code base under version control
- Eric Faulhaber wrote:
> Alexandru, if there is any change to the build process, beyond just checking out the trunk F... - 09:07 AM Feature #7062 (Review): Direct access to H2 internals to solve basic queries
- Merged 7062a_h2 into trunk after adding support for some extra data-types from FWD (object as resourceId and decimal ...
- 07:48 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- The tests from #7108-8 were done *without any patch applied*. I retested with the patch applied and there is no diffe...
02/15/2023
- 03:01 PM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Alexandru Lungu wrote:
> Do you mean the case where the field is case-insensitive and the field is case-sensitive, b... - 09:04 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- I found several mismatched between FWD and 4GL. All of the tests are done in the following manner:...
- 03:53 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Danut, please make a complete set of independent *4GL tests* for each of these cases - or *search the testcases proje...
- 03:28 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Ovidiu Maxiniuc wrote:
> The problem is I do not think forcing the character substitutions to be case-sensitive is t... - 01:54 PM Feature #7061: Enable the use of lazy result sets in H2
- Radu Apetrii wrote:
> I modified the patch from the last post a bit, because the change with the removal of @Prog... - 08:51 AM Feature #7061: Enable the use of lazy result sets in H2
- Update: I've committed a fix to 7061a_h2, rev. 12. *I no longer have issues when testing a large customer application...
- 12:58 PM Support #7058: get the FWD fork of the H2 code base under version control
- Alexandru Lungu wrote:
> Once we have the pending branches merged into the FWD-H2 trunk, we will have a new build ... - 06:08 AM Support #7058: get the FWD fork of the H2 code base under version control
- For H2, Eric will push this when it is ready.
- 03:56 AM Support #7058: get the FWD fork of the H2 code base under version control
- *UPDATE*: regression testing passed; merged 6829a_h2 to FWD-H2 trunk including performance improvements regarding les...
- 12:01 PM Feature #7037: remove dirty share manager
- Guys, I want to commit the dirty sharing changes, but I want to know what dirty share state should be for the existin...
- 10:52 AM Feature #6444: dataset improvements
- Branch 6444a was rebased to the trunk rev. 14484.
Pushed up to revision 14493. - 09:13 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Error handler support for MariaDB committed to 6628a/14485
See also #6628-175.
Please review.
Thank you. - 08:24 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Created task branch 6628a from the trunk rev.14484
- 06:53 AM Feature #7062: Direct access to H2 internals to solve basic queries
- Alexandru Lungu wrote:
> I am planning to make some final changes to 7062a (javadoc and small performance changes), ... - 03:59 AM Bug #6829 (Review): H2 forces re-parse of all prepared statements when metadata is changed
- Merged 6829a_h2 to FWD-H2 trunk including performance improvements regarding less recompiling of prepared statements ...
- 03:35 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed
- There are no problems with rev.11. I checked @psCache@ hit/miss with rev.6 and rev.11 and didn't get very different r...
- 03:58 AM Bug #7120 (Test): NO-UNDO dynamic temp-table does not set the NO-UNDO at the .schema
- Changes look good. Thanks.
02/14/2023
- 06:29 PM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Review of @ffCache-20230214.patch@.
Nice detective work. Indeed, there seems to be a key collision which causes th... - 06:18 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- I've done some changes to how strings are compared in H2. I included a @rtrim@ parameter that, if set to true (by def...
- 04:08 PM Bug #7120 (WIP): NO-UNDO dynamic temp-table does not set the NO-UNDO at the .schema
- Good analysis!
Actually, the value of the @undo@ table attribute is not copied from the source table. It is by defau... - 07:00 AM Bug #7120: NO-UNDO dynamic temp-table does not set the NO-UNDO at the .schema
- This test:...
- 06:58 AM Bug #7120 (Test): NO-UNDO dynamic temp-table does not set the NO-UNDO at the .schema
- 12:28 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> Finished with error Handler support for MariaDB.
> Because of #7113 it was tested with a s... - 08:12 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed
- Dănuț Filimon wrote:
> Committed 6829a_h2/rev.7. Stopped forced re-parsing for prepared statements.
>
> Each SELE... - 07:10 AM Support #7058: get the FWD fork of the H2 code base under version control
- Will pre-built FWD-H2 revisions jars be uploaded into GCD repository ?
- 07:00 AM Support #7058: get the FWD fork of the H2 code base under version control
- *UPDATE*: regression testing passed; merged 6928a_h2 to FWD-H2 trunk including performance improvements for UPDATE st...
- 07:01 AM Feature #6928 (Test): H2 UPDATE performance improvement
- Merged 6928a_h2 to FWD-H2 trunk including performance improvements for UPDATE statement, with in-memory and PageStore...
- 06:52 AM Feature #6928: H2 UPDATE performance improvement
- Thanks, the change is OK. It can be merged to trunk.
- 06:26 AM Feature #6928: H2 UPDATE performance improvement
- Constantin Asofiei wrote:
> Was the branch bound? I don't see rev 11 for 6928a_h2.
What a quick response! My bzr ... - 06:23 AM Feature #6928: H2 UPDATE performance improvement
- Alexandru Lungu wrote:
> Tested 6928a_h2/rev. 10 and found a regression: the old-row stored by @deltaChangeCollector... - 06:20 AM Feature #6928: H2 UPDATE performance improvement
- Tested 6928a_h2/rev. 10 and found a regression: the old-row stored by @deltaChangeCollector@ inside the H2 update sta...
- 06:48 AM Feature #7061: Enable the use of lazy result sets in H2
- I've added the option to execute queries in a lazy manner. Alongside this change, @AdaptiveQuery@ now uses only @Scro...
- 01:22 AM Bug #7113: Problem with nested CAN-FIND conversion
- Ovidiu Maxiniuc wrote:
> The nested CAN-FIND is an old issue. There were some fixes in time (see #3040, #3465, #3771... - 09:22 PM Feature #7037: remove dirty share manager
- Review of @7037b.diff@.
A clean implementation. Nice job. The patch should work as described in note #7037-35.
Pl...
02/13/2023
- 06:17 PM Feature #6371: implement SAVE CACHE statement
- Attaching a working version of sequences support in @SchemaCheck@ and @SchemaValidator@ for review.
- 05:20 PM Bug #7113: Problem with nested CAN-FIND conversion
- The nested CAN-FIND is an old issue. There were some fixes in time (see #3040, #3465, #3771, and others) and the issu...
- 09:13 AM Bug #7113 (WIP): Problem with nested CAN-FIND conversion
- 05:19 AM Bug #7113: Problem with nested CAN-FIND conversion
- Thank you for checking, you can continue with your normal tasks.
- 05:03 AM Bug #7113: Problem with nested CAN-FIND conversion
- Igor Skornyakov wrote:
> Constantin Asofiei wrote:
> > One more thing: is this a regression in 6129c compared to tr... - 05:02 AM Bug #7113: Problem with nested CAN-FIND conversion
- Constantin Asofiei wrote:
> One more thing: is this a regression in 6129c compared to trunk?
No, I get the same e... - 04:54 AM Bug #7113: Problem with nested CAN-FIND conversion
- One more thing: is this a regression in 6129c compared to trunk?
- 04:52 AM Bug #7113: Problem with nested CAN-FIND conversion
- Constantin Asofiei wrote:
> So instead of @?@ it should be @Order.OrderNum@ and @OrderLine.ItemNum@, respectively? I... - 04:25 AM Bug #7113: Problem with nested CAN-FIND conversion
- Igor Skornyakov wrote:
> Constantin Asofiei wrote:
> > What's the problem with the query? What would be the correct... - 04:23 AM Bug #7113: Problem with nested CAN-FIND conversion
- Constantin Asofiei wrote:
> What's the problem with the query? What would be the correct variant? If you change the ... - 04:16 AM Bug #7113: Problem with nested CAN-FIND conversion
- What's the problem with the query? What would be the correct variant? If you change the FQL manually to the correct v...
- 03:02 AM Bug #7113: Problem with nested CAN-FIND conversion
- The problem is at the program conversion (not only runtime).
The query from the previous noye is converted to... - 09:14 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Greg Shah wrote:
> > Because of #7113 it was tested with a simple test only
>
> Go ahead and fix this now.
OK... - 08:48 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- > Because of #7113 it was tested with a simple test only
Go ahead and fix this now.
02/12/2023
- 11:03 AM Feature #6628 (Review): port PostgreSQL native user defined functions to MariaDB
- 11:03 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Finished with error Handler support for MariaDB.
Because of #7113 it was tested with a simple test only
Please rev... - 07:45 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> I've encoutered a weird problem with MariaDB that makes the error handling based on @initEr... - 07:01 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- I've encoutered a weird problem with MariaDB that makes the error handling based on @initError@/@checkError@ impossib...
- 04:25 AM Bug #7113: Problem with nested CAN-FIND conversion
- Consider the following statement:...
- 04:18 AM Bug #7113 (Review): Problem with nested CAN-FIND conversion
02/11/2023
- 10:59 AM Feature #6928: H2 UPDATE performance improvement
- Rebased 6928a_h2 rev 8 from fwd-h2.trunk rev 8 - new rev 10.
- 09:38 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- I tried using the call stack you provided but it seems different from 6129c/14808. The code at @FqlToSqlConverter.jav...
02/10/2023
- 10:56 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- I've experienced problem with CAN-FIND (6129c/14808).
When creating the query from the attached test I get the follo... - 09:54 AM Feature #7062: Direct access to H2 internals to solve basic queries
- I committed 7062a_h2/rev. 9 the changes to H2 to allow direct access.
There is a patch here on the changes required ... - 08:22 AM Feature #7062: Direct access to H2 internals to solve basic queries
- I've redone the tests with direct access:
* Computed columns are now marked as invisible in H2.
* Before returning ... - 05:08 AM Feature #7037: remove dirty share manager
- Ovidiu: Please review.
02/09/2023
- 12:53 PM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns
- Please test how the right-padding spaces are handled. An important element in the expressions above is the @rtrim@ fu...
- 10:49 AM Bug #7108 (WIP): Simulate upper/rtrim directly in H2 using case specific columns
- Consider supporting case specific operators directly in H2 for character fields. For case-insensitive character field...
- 10:42 AM Bug #7108 (Closed): Simulate upper/rtrim directly in H2 using case specific columns
- 10:54 AM Feature #6995 (Review): possibly support NO-UNDO temporary tables directly in H2
- Rebased from trunk and merged 6995a_h2 to FWD-H2 trunk: includes the addition of a NO-UNDO keyword being natively sup...
- 10:53 AM Support #7058: get the FWD fork of the H2 code base under version control
- *UPDATE*: regression testing passed; merged 6995a_h2 to FWD-H2 trunk including the addition of a NO-UNDO keyword bein...
- 10:42 AM Feature #7062: Direct access to H2 internals to solve basic queries
- Alexandru Lungu wrote:
> > In the absence of a SQL option to SELECT * EXCEPT __ifield1, __sfield2 FROM... I think we... - 06:55 AM Bug #7035: Extract query parameters from statically converted FQL
- Alexandru Lungu wrote:
> I get a NPE in com.goldencode.p2j.persist.ParameterDiff.getSubstParameters(ParameterDiff.ja...
02/08/2023
- 10:56 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed
- Eric Faulhaber wrote:
> Has anyone who has looked inside H2 gotten a sense of how that cache interacts with our prep... - 10:09 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed
- Dănuț Filimon wrote:
> Committed 6829a_h2/rev.7. Stopped forced re-parsing for prepared statements.
>
> Each SELE... - 09:46 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- Alexandru Lungu wrote:
> Radu, please redo the FWD patch considering my first comment in #6995-16 regarding @getCrea... - 03:41 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- Code review @6995-6129b.patch@ and @fwd-h2-6995.patch@:
Nice work, Radu!
I agree with Alexandru's comments in #... - 08:48 AM Support #7058: get the FWD fork of the H2 code base under version control
- Alexandru Lungu wrote:
> I am planning to merge 7046_h2 to the FWD-H2 trunk after handling #7085-3 (test suite segre... - 04:00 AM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it
- Ovidiu Maxiniuc wrote:
> Unless this can be configured somewhere else. Or if there is another data type for this?
...
02/07/2023
- 06:44 AM Bug #6829: H2 forces re-parse of all prepared statements when metadata is changed
- Committed 6829a_h2/rev.7. Stopped forced re-parsing for prepared statements.
Each SELECT/DELETE/UPDATE/INSERT quer... - 06:34 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- Radu, please redo the FWD patch considering my first comment in #6995-16 regarding @getCreateTemporaryTablePostfix@ o...
- 06:33 AM Support #7058: get the FWD fork of the H2 code base under version control
- I am planning to merge 7046_h2 to the FWD-H2 trunk after handling #7085-3 (test suite segregation). There are still s...
02/06/2023
- 06:45 PM Feature #7037: remove dirty share manager
- Please review the diff (for the trunk 14478) which adds the following directory configuration parameters:
# In addit... - 03:50 PM Feature #6371: implement SAVE CACHE statement
- Boris Schegolev wrote:
> Currently, my best option is adding SQLs to retrieve sequence information into individual... - 02:50 PM Feature #6371: implement SAVE CACHE statement
- I am working on support for sequences in @SchemaCheck@ for use in validations and I wanted to have a confirmation tha...
- 04:43 AM Feature #7062: Direct access to H2 internals to solve basic queries
- > Actually the prefixes for the computed columns in H2 dialect are __i and __s (for i gnore casing and case- s ensiti...
02/04/2023
- 07:32 PM Feature #7062: Direct access to H2 internals to solve basic queries
- Eric Faulhaber wrote:
> Ultimately, we create the SQL forms of the column names. So, we can use whatever we want as ...
02/03/2023
- 06:53 PM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it
- Thank you. I tried it now and it worked. I was able to create a table and execute a quick select statement over a cou...
- 06:17 PM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it
- I'm pretty sure @citext@ existed as an extension before PostgreSQL 11. I thought it was one of the core data types af...
- 05:25 PM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it
- The changes are necessary only if/when we decide to switch from case-sensitive character data types to case-insensiti...
- 10:51 AM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it
- It seems like note 11 is suggesting some changes to encode the logic in the dialects and fix the DDL generation.
- 10:49 AM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it
- It sounds like this task can be closed, then, correct?
- 05:17 PM Feature #7062: Direct access to H2 internals to solve basic queries
- Ultimately, we create the SQL forms of the column names. So, we can use whatever we want as an identifier, if we find...
- 04:20 PM Feature #7062: Direct access to H2 internals to solve basic queries
- Actually the prefixes for the computed columns in H2 dialect are @__i@ and @__s@ (for *i* gnore casing and case- *s* ...
- 10:34 AM Feature #7062: Direct access to H2 internals to solve basic queries
- I extended my solution to cover all unique indexes. Most of the processing is done in @FQLPreprocessor@ to identify w...
- 10:50 AM Feature #6348: implement support for MariaDB
- Ovidiu Maxiniuc wrote:
> Committed revision 14396 / 6129b.
The change looks good. Can we close this task?
02/02/2023
- 03:47 PM Feature #7062: Direct access to H2 internals to solve basic queries
- Greg Shah wrote:
> You're saying that in the 4GL these have separate @recid@ values when a temp-table is passed as a... - 11:56 AM Feature #7062: Direct access to H2 internals to solve basic queries
- Alexandru Lungu wrote:
> I may have misinterpreted FWD's behavior. I have seen multiple fields like "some_field" a... - 11:46 AM Feature #7062: Direct access to H2 internals to solve basic queries
- Greg Shah wrote:
> > I only consider tables without computed-columns (date-time, extent or case-insensitive char fie... - 09:54 AM Feature #7062: Direct access to H2 internals to solve basic queries
- > I only consider tables without computed-columns (date-time, extent or case-insensitive char fields)
In regard to... - 05:51 AM Feature #7062: Direct access to H2 internals to solve basic queries
- > Please also consider #6720; I don't yet know if lazy hydration should be applied to H2 embedded databases. I have t...
- 03:26 PM Feature #7037: remove dirty share manager
- Stanislav Lomany wrote:
> FYI I've found @uast/shared-dirty-records/p*.p@ and @uast/shared-dirty-records/leaking*.p@... - 03:24 PM Feature #7037: remove dirty share manager
- FYI I've found @uast/shared-dirty-records/p*.p@ and @uast/shared-dirty-records/leaking*.p@ testcases which "demonstra...
- 01:18 PM Feature #6371: implement SAVE CACHE statement
- Boris Schegolev wrote:
> Branch 6129b is frozen for now, so, let's take a look at what we know was not implemented b... - 08:27 AM Feature #6371: implement SAVE CACHE statement
- > EXTENT support (currently, expanded mode only...
I think we only need expanded mode support. The old "denormali... - 06:40 AM Bug #7088: Lazily initialize activeBundle inside RandomAccessQuery
- I've done a slim test with ~40,000 find queries. ~13.000 of them used @ffCache@. The total time spent on activation w...
02/01/2023
- 06:11 PM Feature #6371: implement SAVE CACHE statement
- Branch 6129b is frozen for now, so, let's take a look at what we know was not implemented by now:
* more validatio... - 04:28 PM Feature #6348: implement support for MariaDB
- The update I was talking in #6348-54 was committed the next day in revision 14308 (see @MariaDbSequenceHandler.java@)...
- 01:29 PM Feature #7062: Direct access to H2 internals to solve basic queries
- > A copy in a separate logical or physical temp-table should have a distinct primary key (recid) value. This is the i...
- 01:26 PM Feature #7062: Direct access to H2 internals to solve basic queries
- Eric Faulhaber wrote:
> Alexandru, one other thing to consider, which I suppose you've already noticed: we don't act... - 01:25 PM Feature #7062: Direct access to H2 internals to solve basic queries
- Greg Shah wrote:
> > I empirically discovered that (recid) is always the primary key of our temp-tables in H2; multi... - 01:15 PM Feature #7062: Direct access to H2 internals to solve basic queries
- Alexandru, one other thing to consider, which I suppose you've already noticed: we don't actually create unique indic...
- 01:09 PM Feature #7062: Direct access to H2 internals to solve basic queries
- > I empirically discovered that (recid) is always the primary key of our temp-tables in H2; multiplex is irrelevant. ...
- 12:54 PM Feature #7062: Direct access to H2 internals to solve basic queries
- Alexandru Lungu wrote:
> I've finished implementing a simple mean of H2 direct access for @RAQ@ with simple @recid@ ... - 10:54 AM Feature #7062: Direct access to H2 internals to solve basic queries
- I've finished implementing a simple mean of H2 direct access for @RAQ@ with simple @recid@ look-up. The results are f...
- 01:00 PM Bug #7088: Lazily initialize activeBundle inside RandomAccessQuery
- This makes sense. Although the cost currently is mitigated to some degree by caching in @FQLHelper@, there is still w...
- 04:23 AM Bug #7088: Lazily initialize activeBundle inside RandomAccessQuery
- There is relevant activity when building an @activeBundle@ in general, mostly related to FQL composition (@createBund...
- 04:09 AM Bug #7088 (New): Lazily initialize activeBundle inside RandomAccessQuery
- 10:11 AM Feature #6444: dataset improvements
- Rebased task branch 6444a to the trunk rev.14483.
Suspended working on this task while the trunk and 6129b are frozen. - 09:49 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- Eric Faulhaber wrote:
> I have not yet reviewed the changes in detail, but my opinion is that removing all SQL redo ... - 09:40 AM Support #7058: get the FWD fork of the H2 code base under version control
- Greg Shah wrote:
> See if you can just do some limited edits to Source Code Management to explain branching for FWD ... - 09:38 AM Bug #7035: Extract query parameters from statically converted FQL
- *Review for patch #7035-9*
There is consistent work going on with this extraction and I am pleased with this new @Pa... - 04:23 AM Bug #7035: Extract query parameters from statically converted FQL
- Eric Faulhaber wrote:
> Please add a test with such an extent field reference, and make sure it still works, both in...
01/31/2023
- 05:11 PM Feature #6348: implement support for MariaDB
- Ovidiu, are all the sequence features working now? Based on #6348-54 and the entries leading up to it, it seemed this...
- 04:12 PM Feature #6348: implement support for MariaDB
- Committed revision 14396 / 6129b.
- 01:35 AM Feature #6348: implement support for MariaDB
- Ovidiu Maxiniuc wrote:
> ... there are a few methods which still use @UnimplementedFeature@ to report missing featur... - 03:59 PM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it
- The current implementation injects the upper/rtrim into FQLs of the queries at conversion time because it assumes at ...
- 01:59 AM Bug #6837: prevent unnecessary upper/rtrim injection in queries if the data type doesn't require it
- What is left to do on the MariaDB side for:
* lenient mode?
* strict mode? - 03:55 PM Feature #6371: implement SAVE CACHE statement
- I pushed revision 6129b/14395 with comment cleaning procedure and some JavaDoc that was missing.
- 02:13 AM Feature #6371: implement SAVE CACHE statement
- Boris, please continue implementing the remaining items in #6371-119.
I've also noticed in the code that the colum... - 11:25 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- I have not yet reviewed the changes in detail, but my opinion is that removing all SQL redo code from FWD is OK as lo...
- 08:59 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- > I am not necessarily sensitive with huge chunks of code being removed (less is faster), but should we keep some of ...
- 08:36 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- Eric, I added you as a watcher now.
- 08:27 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- I tested 6995a_h2 with your FWD patch against a large customer application and there was no regression.
The performa... - 05:06 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- I committed to 6995a_h2, rev.7 the changes that you asked for.
Also, when running @build.sh test@, the errors were ... - 03:49 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2
- Radu, based on our new FWD-H2 branching system #7058, I've created 6995a_h2 to hold your patch from #6995-13. However...
- 09:08 AM Support #7058: get the FWD fork of the H2 code base under version control
- See if you can just do some limited edits to Source Code Management to explain branching for FWD vs H2.
- 05:09 AM Support #7058: get the FWD fork of the H2 code base under version control
- Greg, I've done only one documentation change to "Patching and Building Customized 3rd Party Libraries":/projects/p2j...
- 08:25 AM Feature #7037: remove dirty share manager
- Greg Shah wrote:
> > Cross-session use for the small set of tables (currently, only one I know of) which needs it.
... - 05:38 AM Feature #7037: remove dirty share manager
- > Cross-session use for the small set of tables (currently, only one I know of) which needs it.
Tomasz may have fo... - 01:56 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > I think that error handling can be finished in 2-3 days.
>... - 01:32 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> I think that error handling can be finished in 2-3 days.
Please finish this when you ...
Also available in: Atom