FWD » Core Development » Database

08/30/2019

11:11 AM Feature #2156: datetime-tz and hibernate

I would go for an unified solution for all dialects, even this duplicating the offset information for H2 and MSSQL: t... Ovidiu Maxiniuc

09:18 AM Feature #2156: datetime-tz and hibernate

It does look like PostgreSQL has a bad design for this use case (storing and honoring the offset):
https://dba.sta... Greg Shah

07:10 AM Feature #2156: datetime-tz and hibernate

I believe the big problem to implement single-column for DATETIME-TZ was the lack of support from H2.
Relative recen... Ovidiu Maxiniuc

08/29/2019

04:29 PM Bug #3379 (Review): do not copy index definitions when defining WORKFILE like TABLE

Vladimir Tsichevski

04:29 PM Bug #3379 (WIP): do not copy index definitions when defining WORKFILE like TABLE

The fix committed to the 4103a branch. The new revno is 11328. Vladimir Tsichevski

03:55 PM Feature #2156: datetime-tz and hibernate

All of our current databases support a single column that stores both the timestamp and offset:
* PostgreSQL has @... Greg Shah

02:20 PM Feature #2156: datetime-tz and hibernate

There's one other thing to add for @datetime-tz@ - its usage in indexes and sort clauses. Being a multi-column Hiber... Constantin Asofiei

08/28/2019

06:09 PM Feature #3809: ProDataSet support

As noted in a previous email, @__error-flag__@, @__origin-rowid__@, @__error-string__@, @__after-rowid__@ and @__row-... Ovidiu Maxiniuc

03:16 PM Bug #3379: do not copy index definitions when defining WORKFILE like TABLE

See the explanation and a proposed fix in #4103. Vladimir Tsichevski

01:53 AM Feature #3816: table and table handle parameter options

Constantin Asofiei wrote:
> An addition here: not only the default-buffer, any explicit buffer defined (non-dynamic)... Marian Edu

08/27/2019

09:17 AM Bug #3379: do not copy index definitions when defining WORKFILE like TABLE

Good, that makes it simpler. Please dig into @addEntries()@ to see how the indexes get copied. The @SchemaDictionar... Greg Shah

07:44 AM Bug #3379: do not copy index definitions when defining WORKFILE like TABLE

Greg Shah wrote:
> The 4GL docs don't show that the @USE-INDEX@ clause is allowed for @DEFINE WORK-TABLE@ but perh... Vladimir Tsichevski

07:29 AM Bug #3379: do not copy index definitions when defining WORKFILE like TABLE

@like_clause@ uses @SymbolResolver.addFieldsFrom()@ to search for the @LIKE table@ and load the fields using @SchemaD... Greg Shah

09:00 AM Feature #3816: table and table handle parameter options

@BIND@ can be used to bind a reference only table in the caller only if the called routine has an @OUTPUT@ parameter ... Marian Edu

08:26 AM Feature #3816: table and table handle parameter options

Marian Edu wrote:
> Constantin, the before-table as well as the default buffer handle (and the before-table's defaul... Constantin Asofiei

07:12 AM Feature #3816: table and table handle parameter options

Constantin, the before-table as well as the default buffer handle (and the before-table's default buffer handle) are ... Marian Edu

08/26/2019

07:22 PM Bug #3379: do not copy index definitions when defining WORKFILE like TABLE

Greg, what do you think? Assuming all indices are to be ignored in the copy as we were told, does the fix belong in t... Eric Faulhaber

01:30 PM Feature #3816: table and table handle parameter options

There's a new issue to consider; if the temp-table has a before-table, when passing this table (or its dataset) aroun... Constantin Asofiei

08/25/2019

05:09 PM Feature #3809: ProDataSet support

Ovidiu, another issue: DATASET:ACCEPT-CHANGES is not working for static datasets, as you are emulating this via the @... Constantin Asofiei

08/23/2019

03:14 PM Feature #3809: ProDataSet support

Found another issue: bind can be bi-directional, from the destination to source, if the source is BY-REFERENCE. I'm w... Constantin Asofiei

09:01 PM Feature #3809: ProDataSet support

Constantin,
Please see revision 11483. Further stabilized. Now the 8.9MB xml you sent me is read successfully and, w... Ovidiu Maxiniuc

08/21/2019

06:35 PM Feature #3809: ProDataSet support

Constantin, please see revision 11479. Further stabilized and with support for indexes and relations.
Ovidiu Maxiniuc

12:03 PM Feature #3809: ProDataSet support

Constantin, please see revision 11477. I stabilized it so it should handle the simple xml as the one you sent to me.
... Ovidiu Maxiniuc

04:15 AM Feature #3809: ProDataSet support

Ovidiu, please stabilize and commit your READ-XML changes; as I mentioned before, the urgent part is reading a single... Constantin Asofiei

04:46 PM Feature #1587: implement full support for word indexes

The following are notes about "word break tables" in the 4GL. The tables are a simple mapping between a character an... Greg Shah

05:21 AM Support #3871: determine how to change codepages/locales during import

Greg Shah wrote:
> An underlying assumption of our approach so far is that the definition of a codepage is an intern... Marian Edu

08/20/2019

05:58 AM Feature #3809: ProDataSet support

Constantin Asofiei wrote:
> Ovidiu, when serializing a dataset to JSON, what is the order of the records on a child ... Ovidiu Maxiniuc

08/19/2019

05:55 PM Feature #3809: ProDataSet support

Ovidiu, when serializing a dataset to JSON, what is the order of the records on a child table (associated with a pare... Constantin Asofiei

08/16/2019

08:32 AM Feature #3809: ProDataSet support

Ovidiu, after the save-row-changes and the 'next-rowid' in #3809-210, please work on the read/write-xml/json methods.... Constantin Asofiei

08/13/2019

03:06 AM Feature #3816: table and table handle parameter options

The changes with the mutable proxy implementation are in 4124a rev 11449. Please review.
Constantin Asofiei

08/12/2019

04:43 AM Feature #3809: ProDataSet support

Ovidiu, another question; for a data-source query like:... Constantin Asofiei

09:18 PM Feature #3809: ProDataSet support

Ovidiu, please work on @SAVE-ROW-CHANGES@ with priority. Constantin Asofiei

08/11/2019

04:10 PM Feature #3809: ProDataSet support

There's a problem with a dynamic query:... Constantin Asofiei

08/10/2019

12:00 PM Bug #4200: verify and fix all temp-table options which must result in different DMO implementatio...

TODO: are there places in the runtime where we are using the DMO implementation class legacy annotations directly (as... Eric Faulhaber

11:51 AM Bug #4200: verify and fix all temp-table options which must result in different DMO implementatio...

There was at least a case where FWD was 'losing' a temp-table option or field option, as it was generating a single D... Constantin Asofiei

11:47 AM Bug #4200 (New): verify and fix all temp-table options which must result in different DMO impleme...

Constantin Asofiei

08/09/2019

12:21 PM Feature #3809: ProDataSet support

Constantin Asofiei wrote:
> Ovidiu, some notes about the DATASET import/export; the current WRITE implementation doe... Constantin Asofiei

11:05 AM Feature #3809: ProDataSet support

Ovidiu, some notes about the DATASET import/export; the current WRITE implementation doesn't follow the 'relation tre... Constantin Asofiei

08/08/2019

10:25 AM Feature #4176: make certain metadata tables aware of live runtime state

FWD's current implementation of the @_db@ metadata table is static, holding only information discovered at conversion... Eric Faulhaber

10:23 AM Feature #4176 (New): make certain metadata tables aware of live runtime state

Eric Faulhaber

10:19 AM Feature #4175: add support for -1 (single user) option for CONNECT statement

Single user mode of the CONNECT statement is not currently supported. We'll need a test case to understand exactly ho... Eric Faulhaber

10:17 AM Feature #4175 (Closed): add support for -1 (single user) option for CONNECT statement

Eric Faulhaber

10:11 AM Bug #4173: BUFFER-COPY/BUFFER-COMPARE compares table fields by name rather than data type and order

Based on our findings of how tables are compared for parameter passing purposes and shared temp-table definitions (by... Eric Faulhaber

09:25 AM Bug #4173 (Closed): BUFFER-COPY/BUFFER-COMPARE compares table fields by name rather than data typ...

Eric Faulhaber

08/07/2019

05:23 PM Feature #3809: ProDataSet support

Constantin Asofiei wrote:
> Considering that this 'fill must have a data-source or before-fill callback' doesn't rai... Constantin Asofiei

04:22 PM Feature #3809: ProDataSet support

I think I'm on to something: if the NO-ERROR mode is ON while DATASET:FILL is executed, this gets deactivated if ther... Constantin Asofiei

08:01 AM Feature #3816: table and table handle parameter options

Constantin Asofiei wrote:
> There's another issue with BIND which I don't see how to solve yet: if the source and ta... Marian Edu

08/05/2019

09:38 AM Feature #3816: table and table handle parameter options

There's another issue with BIND which I don't see how to solve yet: if the source and target tables have different na... Constantin Asofiei

08:33 AM Feature #3816: table and table handle parameter options

I'll drop here some starting spec on @TABLE@ parameters.
* When a temp-table is defined as @REFERENCE-ONLY@, it ca... Stanislav Lomany

08/03/2019

08:25 PM Feature #3816: table and table handle parameter options

Constantin Asofiei wrote:
> * this 'mutable proxy' must be kept only at the Java field, with the 'original definitio... Constantin Asofiei

08:15 PM Feature #3816: table and table handle parameter options

The main changes related to making the Buffer mutable are working, same with the Dataset. But there is some cleanup ... Constantin Asofiei

08/02/2019

05:26 PM Feature #3816: table and table handle parameter options

Ovidiu Maxiniuc wrote:
> We talked about calling an update notification on parent dataset once a buffer was "redirec... Constantin Asofiei

05:26 PM Feature #3816: table and table handle parameter options

Eric Faulhaber wrote:
> Constantin Asofiei wrote:
> > There's another part related to the field mapping between the... Constantin Asofiei

05:20 PM Feature #3816: table and table handle parameter options

Constantin Asofiei wrote:
> There's another part related to the field mapping between the source and target temp-tab... Ovidiu Maxiniuc

05:20 PM Feature #3816: table and table handle parameter options

Constantin Asofiei wrote:
> There's another part related to the field mapping between the source and target temp-tab... Eric Faulhaber

05:18 PM Feature #3816: table and table handle parameter options

There's another part related to the field mapping between the source and target temp-tables: when they are used in qu... Constantin Asofiei

04:21 PM Bug #4163: SHARED non-NEW buffer definitions must act as the equivalent of FIND or CREATE

SHARED non-NEW buffer definitions must promote the buffer and generally act as the equivalent of FIND or CREATE.
... Greg Shah

04:12 PM Bug #4163 (Closed): SHARED non-NEW buffer definitions must act as the equivalent of FIND or CREATE

Greg Shah