Activity
From 06/03/2025 to 07/02/2025
07/02/2025
- 10:49 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.
- I have the function to generate the necessary triggers for word index table updates. I attached a generated DDL to se...
- 05:46 AM Feature #9455: port native user defined functions to SQL Server
- Eduard Soltan wrote:
> Question, can the tests from @testcases/udfs@ be adopted to SQL Server and properly tested?
... - 03:11 AM Bug #6767: Possible name clashes in DMO classes
- Vladimir, please look into TreeFace.java and TreeWidgetBase.java - these define i.e. @get/setPrivateData@, while the ...
- 02:32 AM Bug #10083: Infinite loop when changing walking index fields
- Constantin Asofiei wrote:
> I'll run ETF with this. Eduard, what's the state of the #10083-17 tests?
Passed with... - 02:31 AM Bug #10083: Infinite loop when changing walking index fields
- I'll run ETF with this. Eduard, what's the state of the #10083-17 tests?
07/01/2025
- 07:42 PM Feature #9455: port native user defined functions to SQL Server
- Yes, I think so. That's a good idea. Although, at a quick look they are not very extensive, but it's better than noth...
- 04:09 AM Feature #9455: port native user defined functions to SQL Server
- Question, can the tests from @testcases/udfs@ be adopted to SQL Server and properly tested?
- 01:43 AM Feature #9455: port native user defined functions to SQL Server
- Ovidiu Maxiniuc wrote:
> Eduard,
>
> Do you have any pending changes to 9456a as part of this task?
For now n... - 03:41 PM Bug #10171: Word Index/CONTAINS support for MS SQL Server.
- Yes, please. Use 9456a.
- 05:04 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.
- I have an untested prototype for @P2JSQLServer2012Dialect.generateWordTablesDDLImpl@ method. I guess I should work ov...
- 08:13 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- Artur Școlnic wrote:
> I used the temp table for simplicity, the behavior of the @find@ should be similar. I am just... - 06:27 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- I used the temp table for simplicity, the behavior of the @find@ should be similar. I am just trying to understand wh...
- 06:18 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- PS: FWD is trying to do its best to cover such "no cost" with the FF cache.
- 06:17 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- > Is this accurate?
> find tt1 where tt1.f1 = 1. //no op? record already in buffer
Not really. We can't tell if... - 04:08 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- ...
- 02:56 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- I made the change, the code is in 10222a/16013.
06/30/2025
- 10:12 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.
- Yes, there are a few changes in the UDFs for word tables. To check their existence the right type is @IF@ not @FN@ an...
- 03:56 AM Bug #10171 (WIP): Word Index/CONTAINS support for MS SQL Server.
- What I have so far.
* An improved @dbo.words@ function:... - 10:08 AM Bug #6767: Possible name clashes in DMO classes
- 6767c rebased to the current trunk, rev now is 16018.
- 08:29 AM Bug #6767: Possible name clashes in DMO classes
- Tested the branch with our big customer application, and no issues were identified. We can also validate using our Ch...
- 09:59 AM Feature #9455: port native user defined functions to SQL Server
- Eduard,
Do you have any pending changes to 9456a as part of this task?
The reason to ask is that I have some o... - 09:54 AM Bug #9078: emit FindQuery as (reused) variables
- I looked at the fix in 16011. The changes are correct.
- 02:26 AM Bug #9078: emit FindQuery as (reused) variables
- Dănuț Filimon wrote:
> Artur found a regression while converting a customer application, currently investigating.
I... - 02:18 AM Bug #9078: emit FindQuery as (reused) variables
- Artur found a regression while converting a customer application, currently investigating.
- 09:12 AM Feature #7020: always use "expanded" extent fields
- *7020d* was rebased to *trunk revision 16013*. Last revision is 16033.
- 02:00 AM Feature #7020: always use "expanded" extent fields
- All regression testing has passed. The previous found regression for ChUI tests has been fixed.
I'd say *7020d* is... - 07:59 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- Artur Școlnic wrote:
> I agree, in a hypothetical scenario where someone changes a record and immediately attempts t... - 07:47 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- I agree, in a hypothetical scenario where someone changes a record and immediately attempts to find it more than once...
- 07:43 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- Yes, this is what happens in trunk and is a valid scenario. Removing this will be functionally OK, but we will see a ...
- 07:42 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- So to be clear, in the same session, If a record is modified, but not yet committed, it should be cached and be found...
- 07:39 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- Artur Școlnic wrote:
> It is my understanding that this is correct behavior, if the data is changed (and uncommitted... - 07:37 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- Alexandru Lungu wrote:
> I one session runs a FIND multiple times, then it won't benefit from the cache considering ... - 07:34 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- After writing #10222-1 I reckon that such change can introduce some performance penalty for same-session case. I one ...
- 07:21 AM Support #10222 (Review): Is cross-session dirty share available through Fast Find Cache even if d...
- I added a new dmo state @COMMITED@, it indicates that a record contains committed data, dafault value is true. The fa...
- 04:31 AM Support #10222 (WIP): Is cross-session dirty share available through Fast Find Cache even if disa...
- 04:03 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- There are two changes we should consider implementing to prevent transaction isolation violations in Fast Find Cache:...
- 03:39 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?
- The Fast Find Cache is a cache that targets FIND queries. It is cross-session and per-database. If a session does a F...
- 03:28 AM Support #10222 (WIP): Is cross-session dirty share available through Fast Find Cache even if disa...
- 06:53 AM Support #10226: Consider creating one single dirty-share database per session to support intra-se...
- Similar to #10222, I think that @DefaultDirtyShareManager@ is still able to leak records in between sessions. I am no...
- 06:49 AM Support #10226 (New): Consider creating one single dirty-share database per session to support in...
06/27/2025
- 12:43 PM Bug #10181 (Test): Date shifted one day earlier when importing data
- Branch 10181a was merged into trunk on behalf of Lorian (ls) as rev. 16010 and archived.
- 09:24 AM Bug #10181: Date shifted one day earlier when importing data
- Update on the regression testing:
* harness ✅
* large app with fwd tests -- unittests ✅
* large GUI app unittest... - 09:44 AM Bug #10195 (Internal Test): Reset of query buffer in a nested function
- I am OK with the changes in 10195a.
- 08:05 AM Bug #10195 (Review): Reset of query buffer in a nested function
- 05:16 AM Bug #10195: Reset of query buffer in a nested function
- Committed on 10195a, rev. 15997.
Changed iterateReleaseOverrideScope into a stack of scopes. A new level is added... - 03:55 AM Bug #10195: Reset of query buffer in a nested function
- Alexandru Lungu wrote:
> This is a problem, right?
Of course this is a problem, I am currently giving a try to... - 03:25 AM Bug #10195: Reset of query buffer in a nested function
- Eduard Soltan wrote:
> Alexandru Lungu wrote:
> > > It is not affected since the RecordBuffer will not be included ... - 03:24 AM Bug #10195: Reset of query buffer in a nested function
- Alexandru Lungu wrote:
> > It is not affected since the RecordBuffer will not be included in the of the nested for-e... - 09:33 AM Feature #7020: always use "expanded" extent fields
- Stefanel Pezamosca wrote:
> There may be a regression showing in the ChUI tests. I need to double check.
I might ... - 03:26 AM Feature #7020: always use "expanded" extent fields
- #10215 is the task handling this.
- 09:23 AM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
- I did a small investigation into this issue, my main conclusions are:
1. Unix sockets cannot be used to communicat... - 09:01 AM Bug #9078: emit FindQuery as (reused) variables
- I committed *9078b/16010* to address #9078-101 and #9078-102.
- 07:29 AM Bug #9078: emit FindQuery as (reused) variables
- I think @downPath(this, prog.kw_find, prog.record_phrase)@ will cover all @FIND@ statements. For example, a @FIND FIR...
- 04:16 AM Bug #9078: emit FindQuery as (reused) variables
- Ovidiu Maxiniuc wrote:
> I looked at 9078b / r16008.
>
> The code looks pretty much solid. But it's difficult to ... - 08:42 AM Feature #9456: implement SQL Server dialect and helpers
- As reported previously, I encountered some issues while fixing the FWD support for logical/boolean expressions in MSS...
- 02:51 AM Feature #9455: port native user defined functions to SQL Server
- Changed udfs names and comments formats in *rev. 16007*. I confused the formats with @mariadb@ udfs, and it is a bit ...
06/26/2025
- 07:10 PM Feature #9455: port native user defined functions to SQL Server
- Sorry, I did these changes unintentionally. I do not have an explanation for them 😕.
- 07:02 PM Feature #9455: port native user defined functions to SQL Server
- Eduard,
I looked a bit over the UDFs you wrote. There is a bit of work still to be done. Please see my 5 notes blo... - 08:11 AM Feature #9455: port native user defined functions to SQL Server
- Eduard Soltan wrote:
> Committed on 9456a, rev. *16006*.
Thank you, I am grabbing the changes right now.
> Add m... - 05:07 AM Feature #9455: port native user defined functions to SQL Server
- Committed on 9456a, rev. *16006*.
Add most of the remaining udfs. There still some edge cases to handle, especiall... - 04:35 PM Bug #9078: emit FindQuery as (reused) variables
- I looked at 9078b / r16008.
The code looks pretty much solid. But it's difficult to spot all possible issues only ... - 07:25 AM Bug #9078: emit FindQuery as (reused) variables
- Rebased *9078b* to latest *trunk/16003*, the branch is now at revision *16008*.
- 06:57 AM Bug #9078 (Review): emit FindQuery as (reused) variables
- Committed *9078b/15974*, Added rules to count the number of FindQuery instances in a top level block, but also added ...
- 02:45 PM Bug #6767: Possible name clashes in DMO classes
- Constantin Asofiei wrote:
> The conversion with 6767c gives me this:
> [...]
>
> The compile error is on @getPri... - 02:06 PM Bug #6767: Possible name clashes in DMO classes
- The conversion with 6767c gives me this:...
- 01:43 PM Bug #6767: Possible name clashes in DMO classes
- Constantin Asofiei wrote:
> Vladimir Tsichevski wrote:
> > I updated @methodText@ from @getNextSibling@ to @nextSib... - 12:35 PM Bug #6767: Possible name clashes in DMO classes
- Vladimir Tsichevski wrote:
> I updated @methodText@ from @getNextSibling@ to @nextSibling@. However, this change did... - 01:22 PM Feature #7020: always use "expanded" extent fields
- Stefanel Pezamosca wrote:
> Roger Borrello wrote:
> > An I apologize if this isn't related to expanded extents at a... - 01:09 PM Feature #7020: always use "expanded" extent fields
- Roger Borrello wrote:
> An I apologize if this isn't related to expanded extents at all. I can post to #7143, if nec... - 01:00 PM Feature #7020: always use "expanded" extent fields
- And I apologize if this isn't related to expanded extents at all. I can post to #7143, if necessary.
- 12:58 PM Feature #7020: always use "expanded" extent fields
- I am not sure if this is related, but I the *ReportDriver* gives a NPE error getting the @"extent"@ annotation.
{{co... - 09:29 AM Feature #7020: always use "expanded" extent fields
- Stefanel Pezamosca wrote:
> Roger Borrello wrote:
> > Stefanel Pezamosca wrote:
> > > Radu tested @7020d@ with @<p... - 10:18 AM Bug #10195: Reset of query buffer in a nested function
- > It is not affected since the RecordBuffer will not be included in the of the nested for-each block or any other ite...
- 10:01 AM Bug #10195: Reset of query buffer in a nested function
- Alexandru Lungu wrote:
> I am OK with the changes in 10195a.
>
> The point here is that the buffer can have its s... - 08:57 AM Bug #10049: UDF configuration regression in Persistence.java
- Ovidiu Maxiniuc wrote:
> No intention. Sorry. Reverted back to old values.
Thank you! - 08:56 AM Bug #10083: Infinite loop when changing walking index fields
- Rebased to latests trunk, and performed the following tests:
- smoke tests of a GUI application ☑️
- smoke and un... - 08:06 AM Feature #10169: result-set streaming (and asynchronous programming?)
- I want this to also be documented in case the discussion about using one connection in a multithreaded environment ar...
- 07:29 AM Feature #10169: result-set streaming (and asynchronous programming?)
- I want to document on the task what exactly could the async 'for each' achieve and when it is especially beneficial.
...
06/25/2025
- 05:30 PM Feature #9455 (WIP): port native user defined functions to SQL Server
- Yes, of course!
- 08:27 AM Feature #9455: port native user defined functions to SQL Server
- Ovidiu, should I commit my udfs implementation on 9456a?
- 05:28 PM Bug #10049: UDF configuration regression in Persistence.java
- No intention. Sorry. Reverted back to old values.
- 05:03 PM Bug #10049: UDF configuration regression in Persistence.java
- I am a little concerned with how Hotel GUI has changed. I have been enabling the capability to modify the password fo...
- 10:37 AM Feature #10169: result-set streaming (and asynchronous programming?)
- > To answer Alexandru's questions, the JDBC driver does not allow for concurrent result set traversal within a single...
- 10:28 AM Feature #10169: result-set streaming (and asynchronous programming?)
- To answer Alexandru's questions, the JDBC driver does not allow for concurrent result set traversal within a single ...
- 09:23 AM Feature #10169: result-set streaming (and asynchronous programming?)
- I really don't want to purge some historical philosophy from FWD (JDBC + connection pooling + one connection per thre...
- 05:33 AM Feature #10169: result-set streaming (and asynchronous programming?)
- I also think we can determine if the queries in the for each alter the iterated table, if not, enable async, but crea...
- 05:26 AM Feature #10169: result-set streaming (and asynchronous programming?)
- I think I have hit a wall with the current approach. When you're using the same JDBC Connection and have an open Resu...
- 09:05 AM Bug #9078: emit FindQuery as (reused) variables
- Dănuț Filimon wrote:
> I managed to get a working version for #9078-95 and started working on a version where it use... - 08:18 AM Bug #9078: emit FindQuery as (reused) variables
- I managed to get a working version for #9078-95 and started working on a version where it uses an array in case too m...
- 04:56 AM Bug #9078: emit FindQuery as (reused) variables
- Current rule-set:...
- 04:53 AM Bug #9078: emit FindQuery as (reused) variables
- Constantin mentioned that I could count the number of FindQueries for each top level block and emit the array only wh...
- 03:10 AM Bug #10195 (Internal Test): Reset of query buffer in a nested function
- I am OK with the changes in 10195a.
The point here is that the buffer can have its scope opened several times. Usi... - 02:05 AM Feature #7020: always use "expanded" extent fields
- There may be a regression showing in the ChUI tests. I need to double check.
06/24/2025
- 05:38 PM Bug #10198: analyze FIND statements which use only a small number of fields
- > * at runtime, a mode (when activated) will allow tracking and reporting buffer's field usage (how many fields are r...
- 05:21 PM Bug #10198: analyze FIND statements which use only a small number of fields
- #4400 is a mechanism to identify every query back to its original definition in source code. We could do a similar t...
- 03:45 PM Bug #10198: analyze FIND statements which use only a small number of fields
- In a customer application, there are patterns where FIND is used to get a record, and from that record only its recid...
- 03:35 PM Bug #10198 (New): analyze FIND statements which use only a small number of fields
- 05:11 PM Feature #10199: implement a temp-table size limit such that usage above that limit is backed by d...
- Unlimited temp-table usage causes an OOME for the server. OE "spills" to disk when temp-table usage is too large. W...
- 05:05 PM Feature #10199 (New): implement a temp-table size limit such that usage above that limit is backe...
- 04:43 PM Feature #9456: implement SQL Server dialect and helpers
- Created a table with SQL Server specific issues in "Limitations and Workarounds":https://proj.goldencode.com/projects...
- 04:38 PM Feature #9455: port native user defined functions to SQL Server
- As noted in the Monday technical meet, revision 16004 of 9456 contains full support for recognising and parsing custo...
- 03:33 PM Support #6709: track nested FIND inside a related FOR loop
- This needs to be brought back into focus. What we need is a mode (when activated) which will track FIND queries, at ...
- 12:33 PM Feature #7020: always use "expanded" extent fields
- Roger Borrello wrote:
> Stefanel Pezamosca wrote:
> > Radu tested @7020d@ with @<parameter name="expand-extents" va... - 12:08 PM Feature #7020: always use "expanded" extent fields
- Stefanel Pezamosca wrote:
> Radu tested @7020d@ with @<parameter name="expand-extents" value="false" />@ in @p2j.cfg... - 10:02 AM Bug #10195: Reset of query buffer in a nested function
- Eduard, it will take me a bit more time to review, so I may not make it by EOD. I need to get some tests ongoing on O...
- 04:05 AM Bug #10195 (Review): Reset of query buffer in a nested function
- 04:04 AM Bug #10195 (WIP): Reset of query buffer in a nested function
- 04:04 AM Bug #10195: Reset of query buffer in a nested function
- Committed on 10195a, rev. 15996.
- 03:34 AM Bug #10195: Reset of query buffer in a nested function
- I think this tests is a bit more accurate....
- 07:26 AM Feature #10169: result-set streaming (and asynchronous programming?)
- Ok, I revised the code, indeed I am creating one thread each time a @for each@ is called and leaking threads, but jus...
- 07:16 AM Feature #10169: result-set streaming (and asynchronous programming?)
- > Well, it may be a bit more complex to implement but a solution would be to use a pool of worker threads. Consider t...
- 07:05 AM Feature #10169: result-set streaming (and asynchronous programming?)
- Ovidiu Maxiniuc wrote:
> But when FWD decided the code from a client requires a background execution, the context is... - 06:56 AM Feature #10169: result-set streaming (and asynchronous programming?)
- Well, it may be a bit more complex to implement but a solution would be to use a pool of worker threads. Consider the...
- 05:42 AM Feature #10169: result-set streaming (and asynchronous programming?)
- My goal is to delegate as much work as possible to the secondary thread, ideally the whole @query.next@, this include...
- 03:36 AM Feature #10169: result-set streaming (and asynchronous programming?)
- I see. I wonder if you can't simply pass the result-set to the main thread and use it from there rather than using it...
- 03:22 AM Feature #10169: result-set streaming (and asynchronous programming?)
- !async_for_each.png!
Each line is a result set access for a given thread, but the connection is shared, so the acc... - 03:03 AM Feature #10169: result-set streaming (and asynchronous programming?)
- > I meant the access to any result set by a thread should not overlap with the access of another result set
I don'... - 03:00 AM Feature #10169: result-set streaming (and asynchronous programming?)
- Artur Școlnic wrote:
> we will need to synchronize the access to the result sets so that there is no overlap.
I ... - 02:56 AM Feature #10169: result-set streaming (and asynchronous programming?)
- > we will need to synchronize the access to the result sets so that there is no overlap.
I don't quite understand ... - 02:31 AM Feature #10169: result-set streaming (and asynchronous programming?)
- After a quick investigation, I found out that most JDBC drivers support multiple opened result sets on a single conne...
- 06:18 AM Feature #7504: Export data tool from FWD into .d files
- I think that should be enough. If the extracted data was identical to original .d files in the cases where these were...
- 05:46 AM Feature #7504: Export data tool from FWD into .d files
- An update on the testing :
* multitenant app : exported the data from a multitenant db ✅
* large GUI app : expor...
06/23/2025
- 02:02 PM Bug #10195: Reset of query buffer in a nested function
- Found a problem in unit tests of a customer application....
- 01:54 PM Bug #10195 (Test): Reset of query buffer in a nested function
- 10:33 AM Feature #10169: result-set streaming (and asynchronous programming?)
- > I am not sure how we could end up retrieving more records than indented. We still have the progressive results, the...
- 10:12 AM Feature #10169: result-set streaming (and asynchronous programming?)
- We might want some kind of "read ahead" limit to avoid doing too much on the secondary thread.
- 10:11 AM Feature #10169: result-set streaming (and asynchronous programming?)
- Alexandru Lungu wrote:
> But with an implementation of async fetching, you may end up gathering record 100.000th and... - 09:59 AM Feature #10169: result-set streaming (and asynchronous programming?)
- Using different connections is a big NO from my POV. If you have X nested FOR EACH, then you may end up with a sessio...
- 08:40 AM Feature #10169: result-set streaming (and asynchronous programming?)
- At the meeting, Alexandru raised a valid concern regarding the async execution for the foreach query. In my initial i...
- 09:15 AM Bug #9078: emit FindQuery as (reused) variables
- I've made some progress, but I will have to refactor all of the changes for the FindQuery. If I am using an array to ...
- 03:11 AM Bug #9078: emit FindQuery as (reused) variables
- Ovidiu Maxiniuc wrote:
> I was thinking about @fqueryArray[0] = new FindQuery();@ initialization. To have a more com... - 09:07 AM Feature #9305: Replace begins with interval based conditional
- From #10165:
For temp-table (H2 database), @LIKE 'prefix%'@ does not use an index at the moment. I suspect it is bec... - 07:28 AM Feature #7504: Export data tool from FWD into .d files
- Ovidiu Maxiniuc wrote:
> I am OK with the changes.
> Please update the @%Done@.
>
> Just out of my curiosity, wh... - 07:23 AM Feature #7504: Export data tool from FWD into .d files
- I am OK with the changes.
Please update the @%Done@.
Just out of my curiosity, why the need to check for @null@ @... - 03:11 AM Feature #7504: Export data tool from FWD into .d files
- Ovidiu Maxiniuc wrote:
> I cannot update to those revisions. The latest I see on branch 7504b is 15914. Maybe you fo...
06/21/2025
- 06:45 PM Feature #7504: Export data tool from FWD into .d files
- I cannot update to those revisions. The latest I see on branch 7504b is 15914. Maybe you forgot to bind / push?
- 07:54 AM Feature #7504: Export data tool from FWD into .d files
- After exporting data from different customer databases, i've rebase to latest trunk and made two commits to @7504b@ :...
06/20/2025
- 04:28 PM Bug #9078: emit FindQuery as (reused) variables
- I was thinking about @fqueryArray[0] = new FindQuery();@ initialization. To have a more compact code, we could emit i...
- 07:39 AM Bug #9078: emit FindQuery as (reused) variables
- > will the template above do to generate FindQuery[] fqueryArray = new FindQuery[5]; or is there a way to make it sim...
- 05:45 AM Bug #9078: emit FindQuery as (reused) variables
- The solution would be to move @fqueryArray[0] = new FindQuery();@ in the @body()@, emit the FindQuery normally withou...
- 05:37 AM Bug #9078: emit FindQuery as (reused) variables
- The following test:...
- 10:46 AM Feature #10169: result-set streaming (and asynchronous programming?)
- The java test cases show that the benefit of running the query in a separate thread is similar with running the busin...
- 08:02 AM Feature #10169: result-set streaming (and asynchronous programming?)
- Well, this changes things. If the for each body cannot be executed in a new thread, I will go the other way and try t...
- 07:57 AM Feature #10169: result-set streaming (and asynchronous programming?)
- I don't think we should look at pushing 4GL logic into other threads. Our core design will not allow this without a ...
- 07:46 AM Feature #10169: result-set streaming (and asynchronous programming?)
- Artur Școlnic wrote:
> I attached the source for this test.
- 07:44 AM Feature #10169: result-set streaming (and asynchronous programming?)
- Artur Școlnic wrote:
> I started working on introducing async in @forEachWorker@, currently there are issues with ou... - 07:35 AM Feature #10169: result-set streaming (and asynchronous programming?)
On another note, I found a way to introduce artificial latency on a network adapter.
The delay is per tcp packet, ...- 07:32 AM Feature #10169: result-set streaming (and asynchronous programming?)
- I believe another way to utilize the result set streaming and async programming is streaming results in a for each wh...
- 06:38 AM Feature #9455: port native user defined functions to SQL Server
- At the time I wrote @CREATE FUNCTION dbo.modulo_ii (@p1 INT, @p2 INT) RETURNS BIGINT AS@ I was not able to test it. A...
- 05:44 AM Feature #9455: port native user defined functions to SQL Server
- Constantin Asofiei wrote:
> What if you call a PROCEDURE from a FUNCTION?
This could be done. And error is raised. - 05:21 AM Feature #9455: port native user defined functions to SQL Server
- What if you call a PROCEDURE from a FUNCTION?
- 05:21 AM Feature #9455: port native user defined functions to SQL Server
- I see that in T-SQL, statements like @RAISERROR('Dates before October 15, 1582 are not yet supported', 16, 1);@. coul...
- 03:52 AM Bug #10181: Date shifted one day earlier when importing data
- Thanks, Ovidiu.
What testing should be performed for this change?
06/19/2025
- 10:24 AM Bug #10181 (Internal Test): Date shifted one day earlier when importing data
- I am OK with the change because the UTC will leave the data unaffected by the TZ.
However, I think all occurrences... - 08:30 AM Bug #10181 (Review): Date shifted one day earlier when importing data
- 08:30 AM Bug #10181 (WIP): Date shifted one day earlier when importing data
- 08:26 AM Bug #10181: Date shifted one day earlier when importing data
- In #7504-31 :
> I also encountered a potential bug during *import*:
> * I imported a .d file containing the value... - 08:05 AM Bug #10181 (Test): Date shifted one day earlier when importing data
- 08:25 AM Feature #7504: Export data tool from FWD into .d files
- When testing the export tool and importing/exporting the db from a large gui app i encountered again this type of err...
- 07:33 AM Bug #9078: emit FindQuery as (reused) variables
- The following template worked:...
- 07:20 AM Bug #9078: emit FindQuery as (reused) variables
- I've adjusted the template in the following way:...
- 07:06 AM Bug #9078: emit FindQuery as (reused) variables
- I found the @named_array@ template in @java_templates.tpl@ and managed to generate something like:...
- 06:07 AM Feature #10169: result-set streaming (and asynchronous programming?)
- I think this implies tracking and storing the time of execution for queries and iterative blocks that have queries (a...
- 05:44 AM Feature #10169: result-set streaming (and asynchronous programming?)
- One approach for implementation would be to measure conditions at runtime and shift into this streaming/async mode wh...
- 04:59 AM Feature #10169 (WIP): result-set streaming (and asynchronous programming?)
- Below you can find the result of testing async execution for db queries combined with result set streaming.
To simul...
06/18/2025
- 04:14 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- Eric Faulhaber wrote:
> @ImportWorker$TenantIdContext.prepareNextBracket@: Why is it safe to fall back to using the ... - 02:22 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- One other thing I noticed in my last review, though it already existed in the code before your recent changes. In @Im...
- 02:14 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- Code review 10094a/15985-15988:
@ImportWorker$TenantIdContext.prepareNextBracket@: Why is it safe to fall back to ... - 07:56 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.
- Another version without using the @dbo.Delimiters@ table:
{{Collapse(See sql ...)... - 05:10 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.
- This task is for implementing support for word indexing and CONTAINS statements in Microsoft SQL Server.
As part of ... - 04:14 AM Bug #10171 (Test): Word Index/CONTAINS support for MS SQL Server.
- 07:06 AM Feature #9456: implement SQL Server dialect and helpers
- > * I hit another MSSQL implementation restriction, one we were not aware of in the iteration of several years ago: t...
- 06:56 AM Feature #9456: implement SQL Server dialect and helpers
- Related to my note #9456-8: with my current changes in 9456a, I encountered in @hotel_runtime@ a query where predicat...
- 08:12 PM Feature #9456: implement SQL Server dialect and helpers
- The @ORDER BY@ issue was partially resolved. In case of @UNIQUE@ finds, the HQL bundle was expressly setting the sort...
- 11:32 PM Feature #7020: always use "expanded" extent fields
- Eric Faulhaber wrote:
> Stefanel, did we ever get these ChUI test results? Is there any other testing needed?
Unf...
06/17/2025
- 04:01 PM Feature #7020: always use "expanded" extent fields
- Stefanel Pezamosca wrote:
> Radu tested @7020d@ with @<parameter name="expand-extents" value="false" />@ in @p2j.cfg... - 12:25 PM Feature #10169: result-set streaming (and asynchronous programming?)
- This seems quite promising, I especially like the idea of adding threading in to keep the data transfer happening in ...
- 12:23 PM Feature #10169: result-set streaming (and asynchronous programming?)
- From Artur in #9802-210:
As already discussed, one of the main reasons for the differences in performance we see i... - 12:20 PM Feature #10169 (WIP): result-set streaming (and asynchronous programming?)
- 08:00 AM Feature #9456: implement SQL Server dialect and helpers
- One more thing, related to paging. We knew that MSSQL does not have a @LIMIT@ / @OFFSET@ syntax for query pagination,...
- 05:22 AM Bug #10080: Temp-table records are leaking in can-find statements
- Sure.
- 05:21 AM Bug #10080: Temp-table records are leaking in can-find statements
- Eduard, 8308f wasn't backed out from 7156c/e. Please commit the necessary changes from 10080a to 7156c and 7156e.
- 05:18 AM Bug #10080 (Test): Temp-table records are leaking in can-find statements
- 10080a was merged to trunk rev 15986 and archived.
- 04:38 AM Bug #10080 (Merge Pending): Temp-table records are leaking in can-find statements
- Go ahead and merge now.
- 04:32 AM Bug #10080: Temp-table records are leaking in can-find statements
- Eduard Soltan wrote:
> Still haven't got an response from harness/web/report of an application testing.
Testing... - 03:49 AM Bug #10080: Temp-table records are leaking in can-find statements
- unit tests and smoke tests of a large gui application ✅
- chui regression tests ✅
- smoke tests of a gui appl...- 03:45 AM Bug #10080: Temp-table records are leaking in can-find statements
- Can this be queued for merge?
06/16/2025
- 04:58 AM Feature #9456: implement SQL Server dialect and helpers
- A 'new' old issue: the MSSQL and lack of support for boolean literals. That is the reason the @Dialect.supportsBoolea...
- 02:40 AM Bug #10080: Temp-table records are leaking in can-find statements
- Yes, they are passing and received the news from Danut that ETF has passed.
- 02:39 AM Bug #10080: Temp-table records are leaking in can-find statements
- Eduard Soltan wrote:
> Tested performed:
>
> - unit tests of a large gui application ✅
> - chui regression tests...
06/13/2025
- 05:56 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- I upgraded the project of the single customer to be MT-enabled. Committed to r89.
Here are the changes in @build.pro... - 04:13 PM Bug #6767: Possible name clashes in DMO classes
- I’m struggling to get the conversion to work as intended. For example, I’d like the @NEXT-SIBLING@ attribute converte...
- 02:20 PM Bug #6767: Possible name clashes in DMO classes
- Vladimir Tsichevski wrote:
> We should distinguish these cases within the conversion rules, perhaps using conditiona... - 02:13 PM Bug #6767: Possible name clashes in DMO classes
- Constantin Asofiei wrote:
> Vladimir Tsichevski wrote:
> > We need to update the conversion rules, as the correct m... - 01:40 PM Bug #6767: Possible name clashes in DMO classes
- Vladimir Tsichevski wrote:
> We need to update the conversion rules, as the correct method names are now @privateDat... - 09:52 AM Bug #6767: Possible name clashes in DMO classes
- Vladimir Tsichevski wrote:
> Constantin Asofiei wrote:
>
> > Looks like you don't need to revert.
> Good, now I ...
06/12/2025
- 12:11 PM Bug #6767: Possible name clashes in DMO classes
- Constantin Asofiei wrote:
> Looks like you don't need to revert.
Good, now I am running a customer big applicatio... - 12:02 PM Bug #6767: Possible name clashes in DMO classes
- Vladimir Tsichevski wrote:
> Constantin Asofiei wrote:
> > Review of 6767c rev 15980.
> > * @AbstractTempTable@
>... - 07:24 AM Bug #6767: Possible name clashes in DMO classes
- Constantin Asofiei wrote:
> Review of 6767c rev 15980.
> * @AbstractTempTable@
> ** line 2938 - please add back @d... - 05:05 AM Bug #6767: Possible name clashes in DMO classes
- Review of 6767c rev 15980.
* @AbstractTempTable@
** line 2938 - please add back @defBuffer.bufferManager@ instead o... - 10:22 AM Bug #9078: emit FindQuery as (reused) variables
- Danut, just keep in mind that a Map has a higher overhead than a plain array. That is why I am suggesting creating an...
- 02:24 AM Bug #9078: emit FindQuery as (reused) variables
- Alexandru Lungu wrote:
> Dănuț Filimon wrote:
> > I did not take into account that there might be a limitation to t...
06/11/2025
- 05:28 PM Bug #6767: Possible name clashes in DMO classes
- Eric Faulhaber wrote:
> Vladimir, this is a large set of changes. What testing do you propose?
I think, convert... - 05:22 PM Bug #6767 (Review): Possible name clashes in DMO classes
- Committed as 6767c rev. 15980. Please, review.
- 12:13 PM Bug #6767: Possible name clashes in DMO classes
- For @HandleChain@ and its ancestors I found 8 matching methods:...
- 11:43 AM Bug #6767: Possible name clashes in DMO classes
- Eric, Constantin,
I need you to confirm this:
*DMO setters* do not use *Java built-in types*. For example, we can... - 04:28 PM Feature #10142: allow UDFs to live in the public schema instead a UDF-specific schema
- A customer using PostgreSQL in the cloud requested that the native SQL UDFs representing Progress built-in functions ...
- 04:16 PM Feature #10142 (New): allow UDFs to live in the public schema instead a UDF-specific schema
- 10:39 AM Bug #9078: emit FindQuery as (reused) variables
- Dănuț Filimon wrote:
> I did not take into account that there might be a limitation to the number of local variables... - 09:14 AM Bug #9078: emit FindQuery as (reused) variables
- I did not take into account that there might be a limitation to the number of local variables that can be defined in ...
- 08:36 AM Bug #9078: emit FindQuery as (reused) variables
- I discussed with Artur and took time to take a look at all find queries from the problematic class. I took each one a...
- 07:59 AM Feature #7504 (Internal Test): Export data tool from FWD into .d files
- 07:50 AM Feature #7020: always use "expanded" extent fields
- Constantin Asofiei wrote:
> Is @expand-extents=true@ now the default and we need to configure projects which can't u... - 07:47 AM Feature #7020: always use "expanded" extent fields
- Is @expand-extents=true@ now the default and we need to configure projects which can't use this mode explicitly in p2...
- 07:17 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- I made sure the tables are not skipped if the @.d@ files are empty. Replacing all @System.out@ with proper logging.
... - 08:07 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- Greg Shah wrote:
> We will need to have tested that as well to confirm that it resolves everything safely.
As a fir...
06/10/2025
- 03:07 PM Bug #6767: Possible name clashes in DMO classes
- > And this refactor can be done automatically (with CTRL+SHIFT+G) in Eclipse, although each one needs to be done 'by ...
- 02:14 PM Bug #6767 (WIP): Possible name clashes in DMO classes
- 02:13 PM Bug #6767: Possible name clashes in DMO classes
- Constantin Asofiei wrote:
> Vladimir, did you use some script to 'sed' the changes?
No. I used Java reflection to c... - 01:17 PM Bug #6767: Possible name clashes in DMO classes
- Vladimir, did you use some script to 'sed' the changes? As Eric mentioned, there are lots of unintended changes. The...
- 12:59 PM Bug #6767: Possible name clashes in DMO classes
- Code review 6767b/15628-15629 (apologies for the long delay):
Overall, the changes look good, though I think we ar... - 09:08 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- The ideal test 10094a would be to have a logical database with the shared db at least two tenant dbs. The customer di...
- 08:50 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- > Please let me know if I got your question right.
Yes, mostly.
If the schema can be incorrect from prior runs ... - 08:24 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- What 10094a adds is that the empty tables from the (re-)imported database are guaranteed to be indexed.
Do you thi... - 05:53 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- I'm trying to determine if we need to write a migration script to cleanup existing MT installations so that they matc...
- 09:02 AM Bug #10111 (WIP): All statements are logged to a single text file for P2JQueryLogger and SQLState...
- Addressed the 1st and 2nd point in @10111a/15979@.
For the 3rd, I am thinking of creating a super class for those 2 ... - 07:57 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...
- +Review of 10111a/15978.+
The changes are logical. The reason is explained in 1st note above. Good catch!
The c... - 06:34 AM Bug #10111 (Review): All statements are logged to a single text file for P2JQueryLogger and SQLSt...
- Committed @10111a/15978@. The changes are quite simple: just removing the static keyword for @fileLogger@ in @SQLStat...
- 06:33 AM Bug #10111 (WIP): All statements are logged to a single text file for P2JQueryLogger and SQLState...
- 06:02 AM Bug #10111: All statements are logged to a single text file for P2JQueryLogger and SQLStatementLo...
- While using @SQLStatementLogger@ for multiple databases, I discovered that all the statements are logged to a single ...
- 04:58 AM Bug #10111 (Test): All statements are logged to a single text file for P2JQueryLogger and SQLStat...
- 06:39 AM Bug #9078: emit FindQuery as (reused) variables
- Artur ran a conversion for a customer application and found a conversion issue. I plan to work with Artur to identify...
- 05:55 AM Bug #9994 (Rejected): Err: Cannot run GET methods on query until it is opened.
- 01:56 AM Bug #9994: Err: Cannot run GET methods on query until it is opened.
- This can be closed/rejected.
- 03:14 AM Feature #9440 (Test): get-codepage() function should work with CLOB fields
- Branch 9440a was merged to trunk rev 15975 and archived.
- 02:49 AM Feature #9440 (Merge Pending): get-codepage() function should work with CLOB fields
- Please rebase and merge 9440a now.
- 12:18 AM Bug #10080: Temp-table records are leaking in can-find statements
- Updated @query/canfindmultiplex@ testcases.
06/09/2025
- 07:37 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- I am not sure I fully understand the question.
TL;DR: If the import decides that a table is processed, the indexes... - 08:03 AM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- Does this mean that existing imported databases may have some indexes which need to be dropped?
06/06/2025
- 06:55 PM Feature #10094: RECIDs from different tenants of same logical database should not overlap
- As discussed with Constantin, I did a bit of reworking on the import to be sure the indexes of the tables are correct...
- 08:14 PM Feature #10094 (Review): RECIDs from different tenants of same logical database should not overlap
- I have created branch 10094a and committed the changes as revision 15970.
The implementation was actually easier t... - 11:18 AM Bug #10083: Infinite loop when changing walking index fields
- CHUI Regression tests passed with 10083a. ☑️
Large GUI Application unit tests passed. ☑️ - 07:11 AM Bug #10083 (Internal Test): Infinite loop when changing walking index fields
- Tomasz Domin wrote:
> Do you mean @10083a/15961@ as I can confirm that, results are fine with @10083a/15961@.
> Why... - 06:41 AM Bug #10083: Infinite loop when changing walking index fields
- Eduard Soltan wrote:
> Tomasz Domin wrote:
> > Eduard Soltan wrote:
> > > Tomasz, could you run it again with 1008... - 05:40 AM Bug #10083: Infinite loop when changing walking index fields
- Tomasz Domin wrote:
> Eduard Soltan wrote:
> > Tomasz, could you run it again with 10083-13 patch?
>
> The resul... - 02:46 AM Bug #10083: Infinite loop when changing walking index fields
- Eduard Soltan wrote:
> Tomasz, could you run it again with 10083-13 patch?
The result stays the same:... - 02:34 AM Bug #10083: Infinite loop when changing walking index fields
- Eduard Soltan wrote:
> Tomasz, could you run it again with 10083-13 patch?
I am working on this. Is this patch fo... - 02:23 AM Bug #10083: Infinite loop when changing walking index fields
- Tomasz, could you run it again with 10083-13 patch?
- 10:55 AM Support #10101: broader testing of various database performance configuration options
- Different database implementations offer various performance tuning configuration settings. For example, PostgreSQL o...
- 02:08 AM Bug #10104: Analyze performance drop after rev. 15963
- This task aims to analyze the performance drop of trunk rev 15963.
In one of our testing, a performance decrease of... - 01:58 AM Bug #10104 (New): Analyze performance drop after rev. 15963
06/05/2025
- 03:51 PM Support #10101 (New): broader testing of various database performance configuration options
- 02:09 PM Bug #10080: Temp-table records are leaking in can-find statements
- Tested performed:
- unit tests of a large gui application ✅
- chui regression tests ✅
Is any additional testin... - 02:00 AM Bug #10080: Temp-table records are leaking in can-find statements
- Constantin Asofiei wrote:
> Eduard, please see #10088-57 - is this task fixing the CAN-FIND sub-select, so that now ... - 01:51 AM Bug #10080: Temp-table records are leaking in can-find statements
- Eduard, please see #10088-57 - is this task fixing the CAN-FIND sub-select, so that now it correctly has the _multipl...
- 12:39 PM Bug #10083: Infinite loop when changing walking index fields
- Eduard Soltan wrote:
> Tomasz Domin wrote:
> > No wiki yet.
> > See #9270, #6860#80, @support/harness/readme.txt@ ... - 09:54 AM Bug #10083: Infinite loop when changing walking index fields
- ...
- 09:23 AM Bug #10083: Infinite loop when changing walking index fields
- Tomasz Domin wrote:
> I've run @support/harness/test/cross_session_test.xml@ dirty share tests and they fail much mo... - 09:12 AM Bug #10083: Infinite loop when changing walking index fields
- Tomasz Domin wrote:
> No wiki yet.
> See #9270, #6860#80, @support/harness/readme.txt@ (that will go into Wiki)
> ... - 05:53 AM Bug #10083: Infinite loop when changing walking index fields
- No wiki yet.
See #9270, #6860#80, @support/harness/readme.txt@ (that will go into Wiki)
Attached @zfile_set.txt@ fo... - 05:04 AM Bug #10083: Infinite loop when changing walking index fields
- Is there a wiki to run @support/harness/test/cross_session_test.xml@?. I tried to run them myself it was giving me al...
- 04:54 AM Bug #10083: Infinite loop when changing walking index fields
- I've run @support/harness/test/cross_session_test.xml@ dirty share tests and they fail much more compared to @trunk@....
- 12:12 PM Feature #7504: Export data tool from FWD into .d files
- Lorian Sandu wrote:
> *Roger*, when you are available, please have a look.
Updates look good. Again, the use case f... - 12:08 PM Feature #7504: Export data tool from FWD into .d files
- Greg Shah wrote:
> Roger: I would prefer if @import.sh@ *did not* work on multiple database at once. The reasoning:... - 10:00 AM Feature #7504: Export data tool from FWD into .d files
- Roger: I would prefer if @import.sh@ *did not* work on multiple database at once. The reasoning: separate logs for e...
- 06:58 AM Feature #7504: Export data tool from FWD into .d files
- Committed to @7504b / rev 15912@ :
@export.sh@:
* added support for multiple databases export
* added support fo... - 04:01 AM Feature #7504: Export data tool from FWD into .d files
- Roger Borrello wrote:
> I'm also curious why you don't allow a list of DBs to be passed in, same as @import.sh@? I'm... - 09:15 AM Bug #9078: emit FindQuery as (reused) variables
- Rebased *9078b* to latest *trunk/15969*, the branch is now at revision *15973*.
- 03:20 AM Feature #9440: get-codepage() function should work with CLOB fields
- Teodor Gorghe wrote:
> Ok, thanks.
> Related to this task, I noticed that the task status become "Internal Test".
...
06/04/2025
- 02:19 PM Feature #7504: Export data tool from FWD into .d files
- > I don't think adding as a reviewer adds as a watcher... is that a function that can be added?
No - 11:07 AM Feature #7504: Export data tool from FWD into .d files
- I'm also curious why you don't allow a list of DBs to be passed in, same as @import.sh@? I'm not sure I understand th...
- 10:44 AM Feature #7504: Export data tool from FWD into .d files
- Lorian Sandu wrote:
> Greg Shah wrote:
> > Roger: Please review @export.sh@.
>
> Roger, the revisions that need ... - 08:56 AM Feature #7504: Export data tool from FWD into .d files
- Greg Shah wrote:
> Roger: Please review @export.sh@.
Sorry I missed this. I don't think adding as a reviewer adds... - 08:22 AM Feature #7504: Export data tool from FWD into .d files
- Attached the @build.properties@, @build.xml@ and @build_db.xml@ from @hotel@ with support for @export@.
After revi... - 10:01 AM Bug #10080 (Internal Test): Temp-table records are leaking in can-find statements
- I see nothing wrong with 10080a r15964.
Please proceed with testing (those from #8308 should do it) if the regress... - 05:04 AM Bug #10080 (Review): Temp-table records are leaking in can-find statements
- 05:02 AM Bug #10080 (WIP): Temp-table records are leaking in can-find statements
- Committed on 10080a, rev. *15964*.
The parameters where not updating in case there were a multiplex id injected in... - 08:05 AM Feature #10094 (WIP): RECIDs from different tenants of same logical database should not overlap
- During the runtime, the PKs even from different private tenants are unique across the logical database since all of t...
- 07:31 AM Feature #10094 (Test): RECIDs from different tenants of same logical database should not overlap
- 05:01 AM Feature #7020: always use "expanded" extent fields
- Radu tested @7020d@ with @<parameter name="expand-extents" value="false" />@ in @p2j.cfg.xml@ for the large GUI Appli...
06/03/2025
- 03:01 PM Bug #10083: Infinite loop when changing walking index fields
- I am not sure, but I think I made similar change in past and there was a problem. Let me check it with testcases/dirt...
- 01:47 AM Bug #10083 (Review): Infinite loop when changing walking index fields
- 01:46 AM Bug #10083 (WIP): Infinite loop when changing walking index fields
- With the patch from #10083-1, unit tests of a customer application does not get stuck in a infinite loop. Committed m...
- 04:05 AM Feature #7504: Export data tool from FWD into .d files
- Greg Shah wrote:
> Roger: Please review @export.sh@.
Roger, the revisions that need to be reviewed from @7504b@ a... - 03:44 AM Bug #10080: Temp-table records are leaking in can-find statements
- The scenario from #10076-1 is:...
Also available in: Atom