FWD » Core Development » Database

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... Ovidiu Maxiniuc

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? Eduard Soltan

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... Eduard Soltan

03:41 PM Bug #10171: Word Index/CONTAINS support for MS SQL Server.

Yes, please. Use 9456a. Ovidiu Maxiniuc

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... Stefanel Pezamosca

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... Greg Shah

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... Artur Școlnic

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. Alexandru Lungu

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... Alexandru Lungu

04:08 AM Support #10222: Is cross-session dirty share available through Fast Find Cache even if disabled?

... Artur Școlnic

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. Artur Școlnic

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... Ovidiu Maxiniuc

03:56 AM Bug #10171 (WIP): Word Index/CONTAINS support for MS SQL Server.

What I have so far.
* An improved @dbo.words@ function:... Stefanel Pezamosca

10:08 AM Bug #6767: Possible name clashes in DMO classes

6767c rebased to the current trunk, rev now is 16018. Vladimir Tsichevski

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... Vladimir Tsichevski

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... Ovidiu Maxiniuc

09:54 AM Bug #9078: emit FindQuery as (reused) variables

I looked at the fix in 16011. The changes are correct. Ovidiu Maxiniuc

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... Dănuț Filimon

02:18 AM Bug #9078: emit FindQuery as (reused) variables

Artur found a regression while converting a customer application, currently investigating. Dănuț Filimon

09:12 AM Feature #7020: always use "expanded" extent fields

*7020d* was rebased to *trunk revision 16013*. Last revision is 16033. Stefanel Pezamosca

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... Stefanel Pezamosca

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... Greg Shah

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... Artur Școlnic

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 ... Alexandru Lungu

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... Artur Școlnic

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... Alexandru Lungu

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 ... Artur Școlnic

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 ... Alexandru Lungu

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... Artur Școlnic

04:31 AM Support #10222 (WIP): Is cross-session dirty share available through Fast Find Cache even if disa...

Artur Școlnic

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:... Artur Școlnic

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... Alexandru Lungu

03:28 AM Support #10222 (WIP): Is cross-session dirty share available through Fast Find Cache even if disa...

Alexandru Lungu

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... Alexandru Lungu

06:49 AM Support #10226 (New): Consider creating one single dirty-share database per session to support in...

Alexandru Lungu

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. Ovidiu Maxiniuc

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... Lorian Sandu

09:44 AM Bug #10195 (Internal Test): Reset of query buffer in a nested function

I am OK with the changes in 10195a. Alexandru Lungu

08:05 AM Bug #10195 (Review): Reset of query buffer in a nested function

Eduard Soltan

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... Eduard Soltan

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... Eduard Soltan

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 ... Alexandru Lungu

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... Eduard Soltan

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 ... Stefanel Pezamosca

03:26 AM Feature #7020: always use "expanded" extent fields

#10215 is the task handling this. Alexandru Lungu

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... Artur Școlnic

09:01 AM Bug #9078: emit FindQuery as (reused) variables

I committed *9078b/16010* to address #9078-101 and #9078-102. Dănuț Filimon

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... Ovidiu Maxiniuc

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 ... Dănuț Filimon

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... Ovidiu Maxiniuc

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 ... Eduard Soltan

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 😕. Ovidiu Maxiniuc

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... Ovidiu Maxiniuc

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... Ovidiu Maxiniuc

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... Eduard Soltan

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 ... Ovidiu Maxiniuc

07:25 AM Bug #9078: emit FindQuery as (reused) variables

Rebased *9078b* to latest *trunk/16003*, the branch is now at revision *16008*. Dănuț Filimon

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 ... Dănuț Filimon

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... Vladimir Tsichevski

02:06 PM Bug #6767: Possible name clashes in DMO classes

The conversion with 6767c gives me this:... Constantin Asofiei

01:43 PM Bug #6767: Possible name clashes in DMO classes

Constantin Asofiei wrote:
> Vladimir Tsichevski wrote:
> > I updated @methodText@ from @getNextSibling@ to @nextSib... Vladimir Tsichevski

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... Constantin Asofiei

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... Roger Borrello

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... Stefanel Pezamosca

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. Roger Borrello

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... Roger Borrello

09:29 AM Feature #7020: always use "expanded" extent fields

Stefanel Pezamosca wrote:
> Roger Borrello wrote:
> > Stefanel Pezamosca wrote:
> > > Radu tested @7020d@ with @<p... Roger Borrello

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... Alexandru Lungu

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... Eduard Soltan

08:57 AM Bug #10049: UDF configuration regression in Persistence.java

Ovidiu Maxiniuc wrote:
> No intention. Sorry. Reverted back to old values.
Thank you! Roger Borrello

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... Eduard Soltan

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... Artur Școlnic

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.
... Artur Școlnic

06/25/2025

05:30 PM Feature #9455 (WIP): port native user defined functions to SQL Server

Yes, of course! Ovidiu Maxiniuc

08:27 AM Feature #9455: port native user defined functions to SQL Server

Ovidiu, should I commit my udfs implementation on 9456a? Eduard Soltan

05:28 PM Bug #10049: UDF configuration regression in Persistence.java

No intention. Sorry. Reverted back to old values. Ovidiu Maxiniuc

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... Roger Borrello

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... Alexandru Lungu

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 ... Artur Școlnic

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... Alexandru Lungu

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... Artur Școlnic

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... Artur Școlnic

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... Dănuț Filimon

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... Dănuț Filimon

04:56 AM Bug #9078: emit FindQuery as (reused) variables

Current rule-set:... Dănuț Filimon

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... Dănuț Filimon

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... Alexandru Lungu

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. Stefanel Pezamosca

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... Ovidiu Maxiniuc

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... Greg Shah

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... Constantin Asofiei

03:35 PM Bug #10198 (New): analyze FIND statements which use only a small number of fields

Constantin Asofiei

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... Greg Shah

05:05 PM Feature #10199 (New): implement a temp-table size limit such that usage above that limit is backe...

Greg Shah

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... Ovidiu Maxiniuc

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... Ovidiu Maxiniuc

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 ... Constantin Asofiei

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... Stefanel Pezamosca

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... Roger Borrello

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... Alexandru Lungu

04:05 AM Bug #10195 (Review): Reset of query buffer in a nested function

Eduard Soltan

04:04 AM Bug #10195 (WIP): Reset of query buffer in a nested function

Eduard Soltan

04:04 AM Bug #10195: Reset of query buffer in a nested function

Committed on 10195a, rev. 15996. Eduard Soltan

03:34 AM Bug #10195: Reset of query buffer in a nested function

I think this tests is a bit more accurate.... Eduard Soltan

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... Artur Școlnic

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... Alexandru Lungu

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... Artur Școlnic

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... Ovidiu Maxiniuc

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... Artur Școlnic

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... Alexandru Lungu

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... Artur Școlnic

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'... Alexandru Lungu

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 ... Artur Școlnic

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 ... Alexandru Lungu

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... Artur Școlnic

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... Ovidiu Maxiniuc

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... Lorian Sandu

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.... Eduard Soltan

01:54 PM Bug #10195 (Test): Reset of query buffer in a nested function

Eduard Soltan

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... Alexandru Lungu

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. Greg Shah

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... Artur Școlnic

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... Alexandru Lungu

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... Artur Școlnic

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 ... Dănuț Filimon

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... Dănuț Filimon

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... Stefanel Pezamosca

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... Lorian Sandu

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@ @... Ovidiu Maxiniuc

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... Lorian Sandu

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? Ovidiu Maxiniuc

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@ :... Lorian Sandu

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... Ovidiu Maxiniuc

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... Greg Shah

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... Dănuț Filimon

05:37 AM Bug #9078: emit FindQuery as (reused) variables

The following test:... Dănuț Filimon

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... Artur Școlnic

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... Artur Școlnic

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 ... Greg Shah

07:46 AM Feature #10169: result-set streaming (and asynchronous programming?)

Artur Școlnic wrote:
> I attached the source for this test.
Artur Școlnic

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... Artur Școlnic

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, ... Artur Școlnic

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... Artur Școlnic

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... Ovidiu Maxiniuc

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. Eduard Soltan

05:21 AM Feature #9455: port native user defined functions to SQL Server

What if you call a PROCEDURE from a FUNCTION? Constantin Asofiei

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... Eduard Soltan

03:52 AM Bug #10181: Date shifted one day earlier when importing data

Thanks, Ovidiu.
What testing should be performed for this change? Lorian Sandu

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... Ovidiu Maxiniuc

08:30 AM Bug #10181 (Review): Date shifted one day earlier when importing data

Lorian Sandu

08:30 AM Bug #10181 (WIP): Date shifted one day earlier when importing data

Lorian Sandu

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... Lorian Sandu

08:05 AM Bug #10181 (Test): Date shifted one day earlier when importing data

Lorian Sandu

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... Lorian Sandu

07:33 AM Bug #9078: emit FindQuery as (reused) variables

The following template worked:... Dănuț Filimon

07:20 AM Bug #9078: emit FindQuery as (reused) variables

I've adjusted the template in the following way:... Dănuț Filimon

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:... Dănuț Filimon

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... Artur Școlnic

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... Greg Shah

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... Artur Școlnic

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 ... Ovidiu Maxiniuc

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... Eric Faulhaber

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 ... Eric Faulhaber

07:56 AM Bug #10171: Word Index/CONTAINS support for MS SQL Server.

Another version without using the @dbo.Delimiters@ table:
{{Collapse(See sql ...)... Stefanel Pezamosca

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 ... Stefanel Pezamosca

04:14 AM Bug #10171 (Test): Word Index/CONTAINS support for MS SQL Server.

Stefanel Pezamosca

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... Greg Shah

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... Ovidiu Maxiniuc

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... Ovidiu Maxiniuc

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... Stefanel Pezamosca

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... Eric Faulhaber

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 ... Greg Shah

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... Greg Shah

12:20 PM Feature #10169 (WIP): result-set streaming (and asynchronous programming?)

Greg Shah

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,... Ovidiu Maxiniuc

05:22 AM Bug #10080: Temp-table records are leaking in can-find statements

Sure. Eduard Soltan

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. Dănuț Filimon

05:18 AM Bug #10080 (Test): Temp-table records are leaking in can-find statements

10080a was merged to trunk rev 15986 and archived. Eduard Soltan

04:38 AM Bug #10080 (Merge Pending): Temp-table records are leaking in can-find statements

Go ahead and merge now. Constantin Asofiei

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... Lorian Sandu

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... Eduard Soltan

03:45 AM Bug #10080: Temp-table records are leaking in can-find statements

Can this be queued for merge? Constantin Asofiei

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... Ovidiu Maxiniuc

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. Eduard Soltan

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... Stefanel Pezamosca

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... Ovidiu Maxiniuc

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... Vladimir Tsichevski

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... Constantin Asofiei

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... Vladimir Tsichevski

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... Constantin Asofiei

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 ... Vladimir Tsichevski

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... Vladimir Tsichevski

12:02 PM Bug #6767: Possible name clashes in DMO classes

Vladimir Tsichevski wrote:
> Constantin Asofiei wrote:
> > Review of 6767c rev 15980.
> > * @AbstractTempTable@
>... Constantin Asofiei

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... Vladimir Tsichevski

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... Constantin Asofiei

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... Alexandru Lungu

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... Dănuț Filimon

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... Vladimir Tsichevski

05:22 PM Bug #6767 (Review): Possible name clashes in DMO classes

Committed as 6767c rev. 15980. Please, review. Vladimir Tsichevski

12:13 PM Bug #6767: Possible name clashes in DMO classes

For @HandleChain@ and its ancestors I found 8 matching methods:... Vladimir Tsichevski

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... Vladimir Tsichevski

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 ... Eric Faulhaber

04:16 PM Feature #10142 (New): allow UDFs to live in the public schema instead a UDF-specific schema

Eric Faulhaber

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... Alexandru Lungu

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 ... Dănuț Filimon

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... Dănuț Filimon

07:59 AM Feature #7504 (Internal Test): Export data tool from FWD into .d files

Lorian Sandu

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... Stefanel Pezamosca

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... Constantin Asofiei

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.
... Ovidiu Maxiniuc

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... Ovidiu Maxiniuc

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 ... Constantin Asofiei

02:14 PM Bug #6767 (WIP): Possible name clashes in DMO classes

Vladimir Tsichevski

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... Vladimir Tsichevski

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... Constantin Asofiei

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... Eric Faulhaber

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... Ovidiu Maxiniuc

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 ... Greg Shah

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... Ovidiu Maxiniuc

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... Greg Shah

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 ... Andrei Plugaru

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... Ovidiu Maxiniuc

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... Andrei Plugaru

06:33 AM Bug #10111 (WIP): All statements are logged to a single text file for P2JQueryLogger and SQLState...

Andrei Plugaru

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 ... Andrei Plugaru

04:58 AM Bug #10111 (Test): All statements are logged to a single text file for P2JQueryLogger and SQLStat...

Andrei Plugaru

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... Dănuț Filimon

05:55 AM Bug #9994 (Rejected): Err: Cannot run GET methods on query until it is opened.

Greg Shah

01:56 AM Bug #9994: Err: Cannot run GET methods on query until it is opened.

This can be closed/rejected. Stefanel Pezamosca

03:14 AM Feature #9440 (Test): get-codepage() function should work with CLOB fields

Branch 9440a was merged to trunk rev 15975 and archived. Teodor Gorghe

02:49 AM Feature #9440 (Merge Pending): get-codepage() function should work with CLOB fields

Please rebase and merge 9440a now. Constantin Asofiei

12:18 AM Bug #10080: Temp-table records are leaking in can-find statements

Updated @query/canfindmultiplex@ testcases. Eduard Soltan

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... Ovidiu Maxiniuc

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? Greg Shah

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... Ovidiu Maxiniuc

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... Ovidiu Maxiniuc

11:18 AM Bug #10083: Infinite loop when changing walking index fields

CHUI Regression tests passed with 10083a. ☑️
Large GUI Application unit tests passed. ☑️ Eduard Soltan

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... Eduard Soltan

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... Tomasz Domin

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... Eduard Soltan

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:... Tomasz Domin

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... Tomasz Domin

02:23 AM Bug #10083: Infinite loop when changing walking index fields

Tomasz, could you run it again with 10083-13 patch? Eduard Soltan

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... Eric Faulhaber

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... Andrei Iacob

01:58 AM Bug #10104 (New): Analyze performance drop after rev. 15963

Andrei Iacob

06/05/2025

03:51 PM Support #10101 (New): broader testing of various database performance configuration options

Eric Faulhaber

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... Eduard Soltan

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 ... Eduard Soltan

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... Constantin Asofiei

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@ ... Tomasz Domin

09:54 AM Bug #10083: Infinite loop when changing walking index fields

... Eduard Soltan

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... Eduard Soltan

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)
> ... Eduard Soltan

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... Tomasz Domin

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... Eduard Soltan

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@.... Tomasz Domin

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... Roger Borrello

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:... Roger Borrello

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... Greg Shah

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... Lorian Sandu

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... Lorian Sandu

09:15 AM Bug #9078: emit FindQuery as (reused) variables

Rebased *9078b* to latest *trunk/15969*, the branch is now at revision *15973*. Dănuț Filimon

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".
... Constantin Asofiei

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 Greg Shah

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... Roger Borrello

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 ... Roger Borrello

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... Roger Borrello

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... Lorian Sandu

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... Ovidiu Maxiniuc

05:04 AM Bug #10080 (Review): Temp-table records are leaking in can-find statements

Eduard Soltan

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... Eduard Soltan

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... Ovidiu Maxiniuc

07:31 AM Feature #10094 (Test): RECIDs from different tenants of same logical database should not overlap

Ovidiu Maxiniuc

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... Stefanel Pezamosca

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... Tomasz Domin

01:47 AM Bug #10083 (Review): Infinite loop when changing walking index fields

Eduard Soltan

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... Eduard Soltan

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... Lorian Sandu

03:44 AM Bug #10080: Temp-table records are leaking in can-find statements

The scenario from #10076-1 is:... Șerban Bursuc

06/02/2025

04:38 PM Bug #10083: Infinite loop when changing walking index fields

Manage to create a small test case for infinite loop in unit tests in customer application. Please also look at the *... Eduard Soltan

04:37 PM Bug #10083 (Test): Infinite loop when changing walking index fields

Eduard Soltan

02:50 PM Feature #7504: Export data tool from FWD into .d files

Roger: Please review @export.sh@. Greg Shah

12:49 PM Feature #7504: Export data tool from FWD into .d files

I added the support for exporting using @ant export.db@ .
The changes are in @build.xml@ and @build_db.xml@.
Sh... Lorian Sandu

10:34 AM Feature #7504: Export data tool from FWD into .d files

I created @export.sh@ and committed it to -@7504b / rev 15910@- @7504b / rev 15911@.
It it stored in @tools/script... Lorian Sandu

09:16 AM Bug #10080: Temp-table records are leaking in can-find statements

Original test case can be found in #8308-505. There are also more tests committed in xfer testcases/1753.
The chan... Dănuț Filimon

09:13 AM Bug #10080 (Test): Temp-table records are leaking in can-find statements

Dănuț Filimon

07:44 AM Feature #9440: get-codepage() function should work with CLOB fields

Ok, thanks.
Related to this task, I noticed that the task status become "Internal Test".
What tests do I need to run? Teodor Gorghe

07:40 AM Feature #9440 (Internal Test): get-codepage() function should work with CLOB fields

I'm OK with the changes. Constantin Asofiei