FWD » Core Development » Database

03/04/2024

04:06 PM Bug #8101 (Closed): Issue with temp-table defined as reference-only

Fixed in trunk rev 15028 via 8329a. Constantin Asofiei

10:56 AM Bug #7645 (Review): Simplify _meta database initialization by removing <schema>.meta.xml resource

Alexandru Lungu

03:38 AM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource

Eduard Soltan wrote:
> Eric Faulhaber wrote:
> > Eduard, is this ready for review? Is there anything left to do on ... Eduard Soltan

03:37 AM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource

Eric Faulhaber wrote:
> Eduard, is this ready for review? Is there anything left to do on this, other than regressio... Eduard Soltan

09:08 PM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource

Eduard, is this ready for review? Is there anything left to do on this, other than regression testing? Eric Faulhaber

02/29/2024

04:13 AM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource

Committed on 7645a. revision 15017.
I moved the logic from metaschema.xml into MetadataManger class, and created a... Eduard Soltan

03:21 AM Bug #7645 (WIP): Simplify _meta database initialization by removing <schema>.meta.xml resource

Eduard Soltan

02/20/2024

07:57 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

After testing POC with JMXs I found out that @(select count()) = 1@ is used often and a lot more than with @FIRST@ or... Dănuț Filimon

03:13 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

I've made a few examples to check if there are other methods used and got the following:
* @CAN-FIND(pt1)@ generated... Dănuț Filimon

02/19/2024

02:13 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Checking for @exists@ in the FQL seems like a reasonable approach. Right now, it is only used to implement server-sid... Eric Faulhaber

02/15/2024

04:23 AM Feature #6628 (WIP): port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> OK, please go ahead and implement my suggestions. That is:
>
> * augment @FQLPreprocessor... Dănuț Filimon

02/14/2024

07:30 AM Feature #6720: lazy hydration

I changed @BaseRecord.copy@, to set @hydrator@ and @liveProps@ of the new record ... Eduard Soltan

04:02 AM Feature #6720: lazy hydration

Lets go ahead with some statistics. From where is @getData@ called and how many times. Please find the back traces of... Alexandru Lungu

02:09 AM Feature #6720: lazy hydration

On delete of a temporary buffer and a deleted buffer is placed in before table.
But to make this copy a snapshot o... Eduard Soltan

02/13/2024

02:22 PM Feature #6720: lazy hydration

Short update from a live discussion with Eduard: the regression seems to be related with the @BaseRecord.getData@ cal... Alexandru Lungu

02/12/2024

02:39 AM Bug #7496: finish support for query:forward-only attribute

Rebased *7496a* with *trunk/rev.14981*. *7496a* is now at revision *14991*. Dănuț Filimon

02:29 AM Bug #7334 (Test): Reclaim used sessions to improve performance

Dănuț Filimon

02:29 AM Bug #7334 (Internal Test): Reclaim used sessions to improve performance

Alexandru Lungu wrote:
> This reached trunk a while ago. Is there anything left on this task? If not, please move it... Dănuț Filimon

02:26 AM Bug #7334: Reclaim used sessions to improve performance

This reached trunk a while ago. Is there anything left on this task? If not, please move it to test. Alexandru Lungu

02/09/2024

10:36 AM Bug #7924: add support for creating an empty database

Issue has been fixed in *7924a.rev.14794*. All field types can be augmented with @__null@ for @MariaDbDialect@ when t... Dănuț Filimon

04:57 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Alexandru Lungu wrote:
> Eduard Soltan wrote:
> > For now in we assign to @updateLock@ the following expression: @u... Eduard Soltan

04:04 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Eduard Soltan wrote:
> For now in we assign to @updateLock@ the following expression: @updateLock = (lt != LockType.... Alexandru Lungu

03:58 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

For now in we assign to @updateLock@ the following expression: @updateLock = (lt != LockType.NONE);@.
I think that... Eduard Soltan

03:59 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

Ovidiu Maxiniuc wrote:
> ** line 1368: @byLegacyName()@ requires that the argument to be normalized (lowercase). Yo... Eduard Soltan

02/08/2024

02:14 PM Bug #8249: Introduce a fast fill method to optimize Dataset.fill

I discussed with Alexandru [ad] and there is a reasonable observation that the fill queries are usual @AdaptiveQuery@... Alexandru Lungu

09:20 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill

A little note:
@DataSet.fill@ calls @BufferImpl.fill@ which calls @FillWorker.fill@ (class inside @BufferImpl@), whi... Alexandru Donica

11:00 AM Bug #7924: add support for creating an empty database

Dănuț,
@sql_only_user__null@ must be generated.
This thing seemed familiar to me. I did a bit of research and ... Ovidiu Maxiniuc

10:12 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

Review of 7999a/14954-14958.
The code looks promising, most of the issues below are low priority. but there are a co... Ovidiu Maxiniuc

09:08 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Eduard, this basically means that the condition in #8259-2 is incorrect.
Please post here a cut-out to the problem... Alexandru Lungu

08:49 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Alexandru Lungu wrote:
> I wonder if NO-LOCK to SHARE-LOCK is considered an lock update.
It is. Any change in loc... Eric Faulhaber

08:03 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

I wonder if NO-LOCK to SHARE-LOCK is considered an lock update. Alexandru Lungu

07:20 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Alexandru Lungu wrote:
> My whole concern here is that we do an extra session cache look-up for almost any record ... Eduard Soltan

05:55 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Eduard detected recently that there is some work being done in @PreselectQuery.coreFetch@ regarding an extra fetch.
... Alexandru Lungu

04:29 AM Bug #8259 (New): Reduce the work done by PreselectQuery.coreFetch

Alexandru Lungu

09:01 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

In terms of JMX, results look promising. Out of a million of "Select all" type of queries, the @DirectAccess@ method ... Radu Apetrii

06:42 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

Radu, if the solution is stable. Lets get some profiling results asap.
Please go in-depth with some JMX to check the... Alexandru Lungu

06:35 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

Alexandru Lungu wrote:
> You can have compound queries. A component can be instantiated as an @AdaptiveQuery@. See @... Radu Apetrii

05:24 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

You can have compound queries. A component can be instantiated as an @AdaptiveQuery@. See @for each tt, each tt2@, as... Alexandru Lungu

05:09 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

Alex/Greg: Are there any other ways of generating a "Select all" type of *static* query that turns into an @AdaptiveQ... Radu Apetrii

07:19 PM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

I've committed to:
* *7252b rev. 14934* a change for better handling of index choosing in @AdaptiveQuery.getAllLazyD... Radu Apetrii

02/07/2024

11:53 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

Greg Shah wrote:
> It seems better to "remember" this information than to calculate it at runtime.
I'll add this id... Radu Apetrii

04:46 AM Bug #8251: Fine tune CompoundQuery optimization when contains clauses are used

This is a follow up of #8246.
Compound queries using @contains@ clause are no longer optimized:
* Check if this c... Alexandru Lungu

04:43 AM Bug #8251 (New): Fine tune CompoundQuery optimization when contains clauses are used

Alexandru Lungu

02/06/2024

10:34 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill

This task is aimed to optimize the @Dataset.fill@ implementation as it represents a bottle-neck in a large customer a... Alexandru Lungu

10:00 AM Bug #8249 (New): Introduce a fast fill method to optimize Dataset.fill

Alexandru Lungu

08:49 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

For static queries, we know the 4GL name of the selected index at conversion time. We can easily pass that to the qu... Greg Shah

07:26 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

For reference, if one were to assume that an index called @idx2@ would be created for table @tt@, then the following ... Radu Apetrii

11:02 PM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

I've finally managed to isolate that NPE issue I encountered. Long story short (I say "short" because I had a really ... Radu Apetrii

03:21 AM Bug #7924: add support for creating an empty database

Ovidiu, the problem does not start from the index, but from the table field. If you take a look at @DDLGeneratorWorke... Dănuț Filimon

01:07 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

OK, please go ahead and implement my suggestions. That is:
* augment @FQLPreprocessor@ to detect and expose whethe... Eric Faulhaber

02/05/2024

02:35 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

It sounds like these suuggested changes are simple and low risk. I don't think we have to quantify the benefit in th... Greg Shah

11:56 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

OK, thanks. The change seems to make logical sense, but it got me looking at this part of the code again, and I am a ... Eric Faulhaber

10:59 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> Dănuț Filimon wrote:
> > There's a single change in @SQLQuery.resetErrorHandler@ that shoul... Dănuț Filimon

10:53 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Dănuț Filimon wrote:
> There's a single change in @SQLQuery.resetErrorHandler@ that should be mentioned. Instead of ... Eric Faulhaber

03:18 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

There's a single change in @SQLQuery.resetErrorHandler@ that should be mentioned. Instead of calling the dialect spec... Dănuț Filimon

03:14 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

6628b is already in trunk and reached 7156b, so functionally we are OK in 7156b. 6628c can go in trunk without confli... Alexandru Lungu

03:10 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Eric, do you still want 6628c to be merged? Dănuț Filimon

02:10 PM Bug #7924: add support for creating an empty database

Review of 7924a/rev.14793.
The code seems fine, except two issues:
1. In case of nullable fields, why injection o... Ovidiu Maxiniuc

11:10 AM Bug #7924 (Review): add support for creating an empty database

*Committed 7924a/rev.14793*.
Based on the error from #7924-14 I noticed that the column does not exist because it ... Dănuț Filimon

03:56 AM Bug #7924: add support for creating an empty database

The changes work well, I tested conversion with hotel_gui and compared the index ddls for mariadb (before and after).... Dănuț Filimon