FWD » Core Development » Database

12/18/2023

10:02 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Branch 4722b was rebased to trunk_14882 and is at revision 14888. Roger Borrello

09:51 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Roger Borrello wrote:
> Great! Don't forget to update the @ImportWorker.java@ header. I'll test it out this AM.
I... Roger Borrello

09:22 AM Bug #8101: Issue with temp-table defined as reference-only

The failure comes from the line @boolean hasRecords = local.nonEmptyTableFlags.contains(multiplexID);@ in @TemporaryB... Theodoros Theodorou

12/15/2023

09:10 AM Bug #7496 (WIP): finish support for query:forward-only attribute

POC tests still fail, I am trying to setup the fwdtests project in Eclipse and debug. Dănuț Filimon

07:10 AM Bug #7496: finish support for query:forward-only attribute

First things first, there are a lot of @23/12/15 12:47:11.619+0200 | SEVERE | com.goldencode.p2j.persist.ForwardResu... Dănuț Filimon

04:07 AM Bug #7496: finish support for query:forward-only attribute

I am picking up work on this issue for #7991 and will be testing the changes first to see if there are any obvious pr... Dănuț Filimon

07:43 AM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

Committed on 8967a, revision 14872.
Added an annotation @internalfields@ with fields used in a @FOR EACH@ block to... Eduard Soltan

12/14/2023

10:07 AM Feature #6720: lazy hydration

Adapted 6720b according to the row structure architecture. Continuing with testing and tracking. Alexandru Lungu

08:05 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Ovidiu Maxiniuc wrote:
> Roger,
> Please update to latest 4922b. There are two issues fixed, which in fact, were pr... Roger Borrello

08:16 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Roger,
Please update to latest 4922b. There are two issues fixed, which in fact, were present in trunk:
* changing ... Ovidiu Maxiniuc

12/13/2023

04:30 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Greg Shah wrote:
> It is clear there is a regression that needs to be fixed here.
Well... not really. The culprit... Roger Borrello

03:51 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

It is clear there is a regression that needs to be fixed here. Greg Shah

03:49 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Just want to log the *reservation.d* processing from non-4722b:... Roger Borrello

02:11 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Greg Shah wrote:
> I'd like to get this into trunk. What is the effort to make this safe?
If Ovidiu could verify... Roger Borrello

06:59 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

I'd like to get this into trunk. What is the effort to make this safe? Greg Shah

10:55 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

Done. Branch 7416b was merged into trunk as rev. 14872 and archived. Radu Apetrii

10:10 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

Greg Shah wrote:
> You can go ahead.
I'll quickly rebase the branch and then proceed with the merging.
Radu Apetrii

10:03 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

You can go ahead. Greg Shah

06:31 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

After re-running the performance tests for both the baseline and the changed version, I got the following result:
* ... Radu Apetrii

04:23 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

Radu Apetrii wrote:
> Alexandru Lungu wrote:
> > Radu, first "batch" of logging refactoring didn't show any downgra... Radu Apetrii

12/12/2023

06:17 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Branch 4722b was rebased to trunk_14870 and is at revision 14874. Roger Borrello

11:13 AM Feature #6720: lazy hydration

Branch 6720c was merged to trunk rev 14869 and archived.
Resuming work on 6720b Alexandru Lungu

10:59 AM Feature #6720: lazy hydration

You can merge to trunk now. Greg Shah

10:40 AM Feature #6720: lazy hydration

Completely fixed 6720c. I had some "invisible" regressions there. Also, it was quite confusing why the @AdaptiveRowSt... Alexandru Lungu

03:37 AM Feature #6720: lazy hydration

Fixed the last concerns. Committed 6720c / rev. 14848.
Redoing quick profiling and regression tests now for 6720c... Alexandru Lungu

12/11/2023

12:13 PM Feature #6720: lazy hydration

I am glad you already tested the implementation and you found no regressions. I re-analysed the iterator from @Ordere... Ovidiu Maxiniuc

06:02 AM Feature #6720: lazy hydration

Committed 6720c/14847 including the suggestions you made.
* Regarding @fieldCnt@, it should have been 1 to short ... Alexandru Lungu

02:12 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

Alexandru Lungu wrote:
> Radu, first "batch" of logging refactoring didn't show any downgrade. I didn't expect to se... Radu Apetrii

02:08 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

Eric Faulhaber wrote:
> Are you saying there is a 3.5% penalty when the implementation is passive, or when it is act... Radu Apetrii

12/08/2023

04:34 PM Feature #6720: lazy hydration

Alexandru, sorry for the delay. The size and the nature of changes (class tree, virtual methods) required ore time th... Ovidiu Maxiniuc

12:06 PM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

The original implementation (when Hibernate was involved) had a very high overhead. I don't know the exact number, bu... Eric Faulhaber

09:35 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

Greg Shah wrote:
> > The tests show a ~3.5% decrease in performance.
>
> No, we can't move ahead with this.
Ra... Alexandru Lungu

09:16 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

> The tests show a ~3.5% decrease in performance.
No, we can't move ahead with this. Greg Shah

08:47 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

Alexandru Lungu wrote:
> large customer application smoke tests
Done. Worked without any issue in all cases (sql lo... Radu Apetrii

07:52 AM Bug #8101: Issue with temp-table defined as reference-only

This isn't likely to be a FWD issue. Don't make edits there yet. It is more likely a dependency on the 4GL code side... Greg Shah

12/07/2023

06:08 PM Bug #8101: Issue with temp-table defined as reference-only

I think I found the issue. In the @TemporaryBuffer.java@... Theodoros Theodorou

08:34 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

Radu Apetrii wrote:
> I'm starting the rebase now. I'll update you when it is done so we can both do the tests.
Don... Radu Apetrii

08:13 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

I'm starting the rebase now. I'll update you when it is done so we can both do the tests. Radu Apetrii

08:07 AM Feature #7416 (Internal Test): Reiterate DatabaseStatistics and leverage to other database profli...

Lets move this into Internal Test and have it completely tested and merged. Even if these are refactorings, we still ... Alexandru Lungu

06:28 AM Feature #6496: add equivalent support for -trig command line option

Rebased 6496a to latest trunk. 6496a is now at rev. 14869
Alexandru [ad], please review @StartupParameters@ as there... Alexandru Lungu

04:08 AM Feature #6496: add equivalent support for -trig command line option

Commited the changes requested in branch 6496a rev 14748.
Also, should I add more comments inside the methods to exp... Alexandru Donica

08:57 PM Feature #6496: add equivalent support for -trig command line option

Had an idea for local optimisation: in @DTM.getSchemaTrigger()@, @proceduresClassMap@ is used to cache the converted ... Ovidiu Maxiniuc

12/06/2023

06:32 PM Feature #6496: add equivalent support for -trig command line option

Review of 6496a/14743-7:
Good job. I think the code is almost ready. Just a few minor things to adjust.
* @Data... Ovidiu Maxiniuc

05:28 AM Bug #8101: Issue with temp-table defined as reference-only

An exception is thrown when @TestCodepageConversions.cls@ is executed regarding temp-tables.
Ovidiu Maxiniuc wrote... Theodoros Theodorou

05:25 AM Bug #8101 (Closed): Issue with temp-table defined as reference-only

Theodoros Theodorou

05:08 AM Feature #7323: Implement soft unique index in FWD-H2

I've committed to 7323a rev. 14804-14805 some minor changes regarding:
* Fixed the validation condition in @Validati... Radu Apetrii

12/05/2023

09:55 AM Bug #8044 (Test): Fix "Failed direct-access due to Error direct accessing for finding record by u...

Branch 8044a was merged into trunk as rev. 14860 and archived. Alexandru Lungu

09:42 AM Bug #8044 (Merge Pending): Fix "Failed direct-access due to Error direct accessing for finding re...

You can merge now. Greg Shah

03:33 AM Bug #8044 (Internal Test): Fix "Failed direct-access due to Error direct accessing for finding re...

*Review of 8044a:*
* I am OK with the changes.
As long as you've done smoke tests with a large application and ... Alexandru Lungu

06:24 AM Feature #6496 (Review): add equivalent support for -trig command line option

I have commited an update to branch 6496a rev. 14747.
I saved a cache in @DatabaseTriggerManager@ to get the java cl... Alexandru Donica

12/04/2023

05:02 PM Feature #6414 (Test): ERROR attribute for buffer, dataset and temp-table

Committed revision 14859. The branch was archived. Ovidiu Maxiniuc

01:38 PM Feature #6414: ERROR attribute for buffer, dataset and temp-table

You can merge to trunk now. Greg Shah

12:17 PM Feature #6414 (Merge Pending): ERROR attribute for buffer, dataset and temp-table

Greg, I think this is ready for merge to trunk (Ovidiu, correct me if you think otherwise). Eric Faulhaber

12:15 PM Feature #6414: ERROR attribute for buffer, dataset and temp-table

The task branch was rebased to latest trunk. The current revision is 14861.
I also test with a large customer applic... Ovidiu Maxiniuc

10:47 AM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

This command assumes the .xml file is saved as @rules/reports/fields.xml@ and included in a p2j.jar build:... Constantin Asofiei

10:25 AM Feature #8067 (WIP): investigate adding automatically adding a FIELDS clause for simple record bl...

Constantin, can you provide some guidance on how to run your rule-set against a large customer application without ac... Alexandru Lungu

09:13 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Branch 4722b was rebased to trunk_14857 and is at revision 14861. Roger Borrello

04:14 AM Feature #6720: lazy hydration

Ovidiu Maxiniuc wrote:
> I grabbed 6720c and looked at the latest changes. Indeed, I do not see a reason for a chang... Alexandru Lungu

11/30/2023

10:21 PM Feature #6720: lazy hydration

I grabbed 6720c and looked at the latest changes. Indeed, I do not see a reason for a change in performance. The hydr... Ovidiu Maxiniuc

11/29/2023

11:56 AM Bug #7113: Problem with nested CAN-FIND conversion

Eric Faulhaber wrote:
> Ovidiu, 7259a was merged to trunk some time ago. Did it fix this issue?
7259a contained cha... Ovidiu Maxiniuc

11:10 AM Bug #7113: Problem with nested CAN-FIND conversion

Ovidiu, 7259a was merged to trunk some time ago. Did it fix this issue? If not, are the changes in 7113a needed? Eric Faulhaber

10:59 AM Bug #6812 (Internal Test): fix FastFindCache to use a shared instance per persistent database

Constantin, does it make sense to regression test this with the large POC? Eric Faulhaber

07:45 AM Feature #6720: lazy hydration

Ovidiu, I finished the implementation completely and tested it over a large POC. However, I created a separate branch... Alexandru Lungu

05:37 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

After running a large POC with *7156b/rev.14846* (which uses *FWD-H2/rev.33*) and the changes from *7138a_h2/rev.24 -... Dănuț Filimon

03:31 AM Bug #8030 (Test): unique index violation when creating a record in two sessions

Alexandru Lungu

12:36 AM Bug #8030: unique index violation when creating a record in two sessions

Code review 8030a/14829-14830:
The logic changes look fine to me. For clarity, I did change the name of the method... Eric Faulhaber

11/28/2023

04:29 PM Feature #6496: add equivalent support for -trig command line option

The (schema-)triggers are context specific because the @propath@ is context specific (@EnvironmentOps.getSearchPath()... Ovidiu Maxiniuc

08:54 AM Feature #6496: add equivalent support for -trig command line option

Are the trigger defs already context-specific? If so, let's avoid the map lookup. Greg Shah

12:15 PM Bug #8030: unique index violation when creating a record in two sessions

Eric Faulhaber wrote:
> Yes, please do.
Sorry, I misread your note. I'll review... Eric Faulhaber

11:31 AM Bug #8030: unique index violation when creating a record in two sessions

Yes, please do. Eric Faulhaber

11:21 AM Bug #8030: unique index violation when creating a record in two sessions

AFAIK, everything is done on 8030a (including MariaDB - I discussed with Danut and the issue in #8030-1 is no longer ... Alexandru Lungu

11:16 AM Bug #8030: unique index violation when creating a record in two sessions

Dănuț Filimon wrote:
> *Committed 8030a/rev.14830*. Modified @RecordBuffer.reportValidationException@.
>
> Alexan... Eric Faulhaber

03:11 AM Bug #8030 (Review): unique index violation when creating a record in two sessions

*Committed 8030a/rev.14830*. Modified @RecordBuffer.reportValidationException@.
Alexandru, the example provided di... Dănuț Filimon

10:19 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

Yes, please go ahead. Alexandru Lungu

08:35 AM Bug #7138 (Review): Short circuit fake-update (update with a new value eqaul to the old value) in H2

Branch 7454a was previously merged into trunk as rev. 14833. Alexandru, should I run the POC tests for this task befo... Dănuț Filimon

09:43 AM Bug #7731: performance improvements for FQLPreprocessor

[[p2j:Database Configuration#Cache-Sizes]] was updated with the necessary information for configuring the cache size ... Dănuț Filimon

09:37 AM Bug #7731 (Test): performance improvements for FQLPreprocessor

Branch 7731a was merged into trunk as rev. 14844 and archived. Alexandru Lungu

09:14 AM Bug #7731: performance improvements for FQLPreprocessor

You can merge now. Greg Shah

08:02 AM Feature #7323: Implement soft unique index in FWD-H2

Alexandru Lungu wrote:
> Radu, can you check if we are still hitting @validateUniqueByQuery@ for _temp? If so, how m... Radu Apetrii

06:46 AM Feature #7323: Implement soft unique index in FWD-H2

Radu, can you check if we are still hitting @validateUniqueByQuery@ for _temp? If so, how many times do we actually b... Alexandru Lungu

06:38 AM Feature #7323: Implement soft unique index in FWD-H2

I finished running the performance tests and the results are not very encouraging:
* 7323a rev. 14801 (*before* the ... Radu Apetrii

11/27/2023

04:50 PM Feature #6496: add equivalent support for -trig command line option

Most likely, not. A context-level map should do it. The only think that is missing is the invalidate event, when the ... Ovidiu Maxiniuc

08:08 AM Feature #6496: add equivalent support for -trig command line option

Ovidiu: Is it difficult for us to cache the results at the trigger definition? If not, I'd prefer that over the idea... Greg Shah

04:39 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

My last commit does not change business code in @ImportWorker@, just the logs are more verbose.
I had a look at th... Ovidiu Maxiniuc

11:12 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Roger Borrello wrote:
> This does not happen with trunk, so something in this branch is causing H2 word tables to be... Roger Borrello

10:59 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Roger Borrello wrote:
> Ovidiu, when I run @ant import.db@ using the H2 database, it is trying to import into the *r... Roger Borrello

10:42 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Ovidiu, when I run @ant import.db@ using the H2 database, it is trying to import into the *reservation__guest* table.... Roger Borrello

11:52 AM Bug #7731 (Merge Pending): performance improvements for FQLPreprocessor

This can merge to trunk after 7669a. Greg Shah

07:35 AM Bug #7731: performance improvements for FQLPreprocessor

I think the changes are OK. I've tested with a large POC performance run, and there was a visible improvement. Constantin Asofiei

10:15 AM Bug #8030: unique index violation when creating a record in two sessions

Danut, please move this into Review once you finish the implementation so we can move on with the review part. There ... Alexandru Lungu

09:23 AM Bug #8030: unique index violation when creating a record in two sessions

I can't recall exactly. We have some changes in #7323 that was doing the cause unwrapping for FWD-H2 *exactly* becaus... Alexandru Lungu

09:20 AM Bug #8030: unique index violation when creating a record in two sessions

Alexandru, in what case is required to unwrap the cause for P2JH2Dialect? I'll need a bit more context to adjust the ... Dănuț Filimon

09:04 AM Bug #8030: unique index violation when creating a record in two sessions

I committed the fix for #8030-3 in *8030a/rev.14829*, currently investigating @RecordBuffer.reportValidationException@. Dănuț Filimon

05:56 AM Bug #8030: unique index violation when creating a record in two sessions

I managed to reproduce the issue after fixing a configuration issue in @build_db.xml@. Working on it right now. Dănuț Filimon

04:43 AM Bug #8030: unique index violation when creating a record in two sessions

Danut, can you re-attempt to recreate this and fix? Please do some debugging to see where you are failing into recrea... Alexandru Lungu

10:14 AM Feature #7323: Implement soft unique index in FWD-H2

Theoretically yes. Practically, the flag will only take affect if there are violations. We need to check on our large... Alexandru Lungu

10:04 AM Feature #7323: Implement soft unique index in FWD-H2

I've addressed the review points and committed to 7323a rev. 14802-14803. Right now I'm running the performance tests... Radu Apetrii

11/26/2023

08:31 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Branch 4722b was rebased to trunk_14841 and is at revision 14845. Roger Borrello

11/24/2023

12:42 AM Feature #6496: add equivalent support for -trig command line option

#6649 already has a cache implementation which not only stores the results from @convertNametoClass()@, but also @con... Dănuț Filimon

09:03 PM Feature #6496: add equivalent support for -trig command line option

Greg Shah wrote:
> If we implement the solution in #6649, we still have to do a minimal cache lookup for each trigge... Ovidiu Maxiniuc

07:37 PM Feature #6720: lazy hydration

That is an interesting approach. I did not realized that level of specialization would be necessary. This class was a... Ovidiu Maxiniuc

11/23/2023

10:02 AM Feature #6720: lazy hydration

*Status update:*
Ovidiu, I followed your suggestion on having a @BitSet@ to store the selected fields. However, I ... Alexandru Lungu

09:09 AM Bug #7167: Associating records from opened buffers to new sessions is slow

Alexandru Lungu wrote:
> Danut, please re-test the large POC and see if why we are still having spikes on @BufferMan... Dănuț Filimon

08:54 AM Feature #6496: add equivalent support for -trig command line option

My point here is that by doing something in the database trigger manager itself, we can get an even better level of o... Greg Shah

08:52 AM Feature #6496: add equivalent support for -trig command line option

> However, it searches the root directory even after I seem to have removed it from propath (I even printed the propa... Greg Shah

07:54 AM Feature #6496: add equivalent support for -trig command line option

Small observation.
I had tried in progress developer studio to remove all from propath (right click on project, proj... Alexandru Donica

04:57 AM Feature #6496 (WIP): add equivalent support for -trig command line option

Alexandru Donica wrote:
> So in 4GL it definitely tries to append the trig location to every propath folder, because... Alexandru Lungu

04:49 AM Feature #6496: add equivalent support for -trig command line option

So in 4GL it definitely tries to append the trig location to every propath folder, because when I reordered the propa... Alexandru Donica

03:05 AM Feature #6496: add equivalent support for -trig command line option

Greg, what you are saying is a side-effect of #6649. Every @convertName@ (or @fastConvertName@) is added to one of th... Alexandru Lungu

06:03 AM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

I have not went further with this. The report I used is this:... Constantin Asofiei

05:20 AM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

Constantin, what kind of queries did you consider. FOR EACH loops with BREAK BY shouldn't be counted (or maybe can be... Alexandru Lungu

04:37 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

I've committed to 7416b rev. 14773 the changes suggested in #7416-41 with two exceptions: the two points related to @... Radu Apetrii

11/22/2023

11:06 AM Feature #6496: add equivalent support for -trig command line option

We should consider an approach similar to #1970, where we changed @ControlFlowOps@ and the converted code to cache th... Greg Shah

10:59 AM Feature #6496: add equivalent support for -trig command line option

> However I see now that in 4GL, it searches for the trigger location in every folder in propath, and uses the first ... Greg Shah

10:18 AM Feature #6496: add equivalent support for -trig command line option

Alexandru Donica wrote:
> I did some more tests in 4GL with the propath now that I may not have done a while ago, or... Alexandru Lungu

10:00 AM Feature #6496: add equivalent support for -trig command line option

I did some more tests in 4GL with the propath now that I may not have done a while ago, or I did not complete them pr... Alexandru Donica

09:55 AM Feature #6496: add equivalent support for -trig command line option

* Another question: the prefixes (@String[] prefixes = new String[] {"./", ".\\", "../", "..\\"};@) should be checked... Alexandru Lungu

07:42 AM Feature #6496: add equivalent support for -trig command line option

Alexandru [ad], just a notice. Is is possible to state a @-trig@ relative to the propath? Thus, if you have a trigger... Alexandru Lungu

04:08 AM Feature #6496: add equivalent support for -trig command line option

I am giving it a shot with some performance tests now - if everything is OK, I will merge it. Alexandru Lungu

05:13 AM Feature #7323: Implement soft unique index in FWD-H2

Also, please attempt to retest the POC for performance after the changes. Make a baseline with 7156b / an intermediar... Alexandru Lungu

05:09 AM Bug #7167: Associating records from opened buffers to new sessions is slow

Also, please remake the statistic on #7167-1 now with 1s of lifespan vs 10s of lifespan. Alexandru Lungu

05:08 AM Bug #7167: Associating records from opened buffers to new sessions is slow

Danut, please re-test the large POC and see if why we are still having spikes on @BufferManager.activeBuffers@. Pleas... Alexandru Lungu

11/21/2023

05:33 PM Feature #6496: add equivalent support for -trig command line option

Greg Shah wrote:
> Is there more testing needed for this branch?
I haven't tested this branch. Please let me know i... Theodoros Theodorou

05:23 PM Feature #6496: add equivalent support for -trig command line option

Is there more testing needed for this branch?
Theodoros: Is anything in 6496a dependent on the changes in 7732a? Greg Shah

05:20 PM Feature #6496: add equivalent support for -trig command line option

Greg Shah wrote:
> Theodoros: Please review.
The changes look good.
> All: We are trying to merge 7732a before... Theodoros Theodorou

08:09 AM Feature #6496: add equivalent support for -trig command line option

Theodoros: Please review.
All: We are trying to merge 7732a before 6496a since it has changes related to the start... Greg Shah

03:59 AM Feature #6496 (Review): add equivalent support for -trig command line option

I moved the trigger location parameter to @StartupParameters@ as adviced. I also removed the map that cached the trig... Alexandru Donica

02:22 PM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

A crude report on the .ast of a large POC app results in ~13% (18k from 141k) of the FOR EACH blocks which can be imp... Constantin Asofiei

02:07 PM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

Good point. Greg Shah

01:16 PM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

Greg Shah wrote:
> That is why I was suggesting bypassing that case.
I agree, but this would exclude all temp-table... Constantin Asofiei

01:09 PM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

That is why I was suggesting bypassing that case. Greg Shah

12:56 PM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

Greg Shah wrote:
> One important contraint to include is that the buffer must be scoped to the @FOR@ loop. If the s... Constantin Asofiei

12:26 PM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

Let's move ahead with this. Note that we should do this analysis *after* record scoping is finished in annotations. ... Greg Shah

09:51 AM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

Greg Shah wrote:
> We can certainly use TRPL to analyze field usage and generate an implicit @FIELDS@ clause if cert... Constantin Asofiei

09:47 AM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

We can certainly use TRPL to analyze field usage and generate an implicit @FIELDS@ clause if certain constraints are ... Greg Shah

09:31 AM Feature #8067: investigate adding automatically adding a FIELDS clause for simple record blocks

In a customer application, we noticed patterns like @for each tt1: do something with a few fields. end.@ where althou... Constantin Asofiei

09:28 AM Feature #8067 (WIP): investigate adding automatically adding a FIELDS clause for simple record bl...

Constantin Asofiei

09:17 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Ovidiu... I must have really missed something for H2 regarding the use of DDL in the application jar file. I hadn't s... Roger Borrello

07:05 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Ovidiu, I am using this branch, and getting an error finding the ddl, when it is in the @hotel.jar@ file. When I unzi... Roger Borrello

11/20/2023

05:10 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

I fixed the minor typo and checked in revision 14837. Roger Borrello

04:11 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Ovidiu Maxiniuc wrote:
> I committed my 4722b changes as r14836.
> Nothing fancy, just more verbose logs and allowe... Roger Borrello

03:35 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

I committed my 4722b changes as r14836.
Nothing fancy, just more verbose logs and allowed loading of FS resources if... Ovidiu Maxiniuc

08:48 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Ovidiu: Do you still have changes to put into 4722b? Greg Shah

08:45 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Branch 4722b was rebased to trunk_14834 and is at revision 14835. Roger Borrello

10:08 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

Okay then, please continue working on the review. Andrei, disregard my comment. Alexandru Lungu

09:49 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

Alexandru Lungu wrote:
> As the review is quite detailed, Andrei [ai], can you manage clearing as many as the minor ... Radu Apetrii

09:46 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

As the review is quite detailed, Andrei [ai], can you manage clearing as many as the minor points above? If there are... Alexandru Lungu