FWD » Core Development » Database

11/26/2018

05:00 PM Feature #3759: setup, test and document PostgreSQL on Windows

I finally get it 100% compiled. The problem is that psql does not know what are the 'resources' (read 'header declara... Ovidiu Maxiniuc

12:31 PM Feature #3757 (WIP): add metadata support

h4. @_filelist._filelist-name@, @_filelist._FileList-BlkSize@ and @_filelist._fileList-id@
This _meta table allow ... Ovidiu Maxiniuc

01:48 AM Feature #3757: add metadata support

Ovidiu, as you have down time from other tasks, please investigate and document the meanings of the above metadata ta... Eric Faulhaber

11/25/2018

02:56 PM Feature #3816: table and table handle parameter options

Options which need support:
* BIND
* APPEND - mostly implemented; partial conversion
* BY-REFERENCE - mostly imp... Eric Faulhaber

02:38 PM Feature #3816 (Closed): table and table handle parameter options

Eric Faulhaber

02:37 PM Feature #3809: ProDataSet support

Dataset parameter options:
* BY-REFERENCE
* APPEND
* BIND Eric Faulhaber

12:29 PM Feature #3809: ProDataSet support

The following list of features is not exhaustive, but we know we need to implement at least...
+Language Statement... Eric Faulhaber

09:29 AM Feature #3809: ProDataSet support

There are also features in non-database parts of the system.
* SESSION:FIRST-DATASET Greg Shah

07:25 AM Feature #3809: ProDataSet support

This task is intended to implement compatible and comprehensive support for the ProDataSet features of the 4GL. At t... Greg Shah

07:17 AM Feature #3809 (Closed): ProDataSet support

Greg Shah

02:13 PM Feature #3815: more temp-table options

Temp-table field option:
* COLUMN-CODEPAGE Eric Faulhaber

01:59 PM Feature #3815: more temp-table options

The following temp-table options need to be supported:
* LIKE-SEQUENTIAL
* BEFORE-TABLE (ProDataSet-related) Eric Faulhaber

01:57 PM Feature #3815 (Closed): more temp-table options

Eric Faulhaber

12:43 PM Feature #3814: more schema metadata

The following schema metadata features are used in an application and are either unsupported or are partially impleme... Eric Faulhaber

12:38 PM Feature #3814 (Closed): more schema metadata

Eric Faulhaber

09:28 AM Feature #3813: misc DB features part deux

+Language Statements+
* -BUFFER-COMPARE- - implement NO-LOBS (already done for the POC?)
* -BUFFER-COPY- - implem... Greg Shah

09:25 AM Feature #3813 (Closed): misc DB features part deux

Greg Shah

11/24/2018

09:51 PM Feature #3759: setup, test and document PostgreSQL on Windows

As far as I know the MinGW64 has support for @long long int@. it is @__int64@. So what you need to do is to try to de... Eugenie Lyzenko

11/23/2018

02:59 PM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie Lyzenko wrote:
> Take a look at your @.m2\repository\com\git-hub\maven-nar\nar-maven-plugin\version@ directo... Ovidiu Maxiniuc

12:27 PM Feature #3759: setup, test and document PostgreSQL on Windows

Also checklist for PLJava:
https://tada.github.io/pljava/build/build.html
Nar plugin:
http://maven-nar.github.io/ Eugenie Lyzenko

12:24 PM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> After I
> [...]
> the mingw profile is indeed used. However, the issues remain.
Take a... Eugenie Lyzenko

11:46 AM Feature #3759: setup, test and document PostgreSQL on Windows

After I... Ovidiu Maxiniuc

11:44 AM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie Lyzenko wrote:
> Try to add system variable:
> @MSYSTEM@ to be @MINGW64@
I will try that.
> What versio... Ovidiu Maxiniuc

11:41 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> Please find the attached logs from
> [...]
> and
> [...]
>
> I noticed that the @ms... Eugenie Lyzenko

06:23 AM Feature #3759: setup, test and document PostgreSQL on Windows

Please find the attached logs from ... Ovidiu Maxiniuc

09:22 PM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie: Please review this task and offer any advice about mingw. Greg Shah

11/22/2018

03:41 PM Feature #3759 (WIP): setup, test and document PostgreSQL on Windows

I am having some difficulties with building PL/Java on Windows. Apparently, msvc profile is selected by Maven. I do n... Ovidiu Maxiniuc

11/19/2018

03:48 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Eric Faulhaber wrote:
> Is this inability to cache limited to the cases which use DYNAMIC-FUNCTION? Or are you sayin... Ovidiu Maxiniuc

11/16/2018

03:30 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Ovidiu Maxiniuc wrote:
> I see an issue though: doing so will alterate the interpreted AST tree and break the caches... Eric Faulhaber

03:14 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

The problem is that the current implementation of the dynamic queries is too logical in FWD. If the parameters and an... Ovidiu Maxiniuc

10:13 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

In other words, it is treated as a query substitution parameter? Greg Shah

11/15/2018

02:26 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

This is a bit (or more) strange. The combination of dynamic queries and dynamic function call is in fact used as a wo... Ovidiu Maxiniuc

11/14/2018

03:05 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Yes, this is the objective. I will separately send you some example customer code which is supposed to work. Greg Shah

03:04 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Well, I encountered some strange results. Please confirm that the goal of this task is to add support for constructs ... Ovidiu Maxiniuc

02:04 PM Feature #3761 (WIP): add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Started by creating toy testcases that use DYNAMIC-FUNCTION(). Ovidiu Maxiniuc

02:03 PM Feature #3760 (Review): temp-table options

Added conversion and runtime support for @SERIALIZE-NAME@ attribute. Committed to 3782a/11317.
Automated testing is ... Ovidiu Maxiniuc

11/13/2018

03:57 PM Feature #3760 (WIP): temp-table options

In all my testcases the @RCODE-INFORMATION@ seems to be implemented. In fact, this is only a legacy keyword (as the d... Ovidiu Maxiniuc

08:17 AM Feature #3759: setup, test and document PostgreSQL on Windows

> * Will the database server run on same machine as the FWD server?
Yes.
> * Is there a preferred PostgreSQL ve... Greg Shah

07:54 AM Feature #3759: setup, test and document PostgreSQL on Windows

A few questions here:
* Will the database server run on same machine as the FWD server?
Theoretically, this shoul... Ovidiu Maxiniuc

11/01/2018

12:31 PM Feature #3758 (WIP): misc database features

Created task branch 3758a. Eric Faulhaber