FWD » Core Development » Database

09/06/2017

08:43 PM Feature #3319: investigate viability of using the Progress database as a back-end

You are correct in your assumption. I was just trying with both the UDF support and the schema to try and see what m... Christopher Cotter

08:11 PM Feature #3319: investigate viability of using the Progress database as a back-end

Christopher Cotter wrote:
> I am working on getting the hotel table and index ddl files applied to OE 11.7.
>
> I... Eric Faulhaber

09/05/2017

07:38 PM Feature #3319: investigate viability of using the Progress database as a back-end

OE SQL Reserved Words List
http://knowledgebase.progress.com/articles/Article/000049334
Christopher Cotter

06:50 PM Feature #3319: investigate viability of using the Progress database as a back-end

I am working on getting the hotel table and index ddl files applied to OE 11.7.
It's mostly working with the excep... Christopher Cotter

09/02/2017

09:57 PM Feature #3319: investigate viability of using the Progress database as a back-end

Christopher Cotter wrote:
> Changing "double precision" to "decimal" and "datetime2" to "timestamp" seemed to do the... Eric Faulhaber

09/01/2017

07:52 PM Feature #3319: investigate viability of using the Progress database as a back-end

Changing "double precision" to "decimal" and "datetime2" to "timestamp" seemed to do the trick. What are the potenti... Christopher Cotter

06:37 PM Feature #3319: investigate viability of using the Progress database as a back-end

I am having some success but running into this error. Maybe something to do with the "double precision" datatype? I ... Christopher Cotter

04:15 PM Feature #3319: investigate viability of using the Progress database as a back-end

Something like this works. Different syntax but similar idea.
How much effort would be needed to add a progress o... Christopher Cotter

02:03 PM Feature #3319: investigate viability of using the Progress database as a back-end

BTW, I don't know if you're just interested in the SQL Server DDL FWD generates, or if you actually want to get Hotel... Eric Faulhaber

01:30 PM Feature #3319: investigate viability of using the Progress database as a back-end

Christopher Cotter wrote:
> So it sounds like these constructs are custom java work needed to support SQL Server?
Y... Eric Faulhaber

01:11 PM Feature #3319: investigate viability of using the Progress database as a back-end

So it sounds like these constructs are custom java work needed to support SQL Server?
3. the p2j2clr.dll assembly ... Christopher Cotter

12:47 PM Feature #3319: investigate viability of using the Progress database as a back-end

Ok, so there is a second "shim" layer in the @p2j.dll@ assembly that we don't have for the "pure Java" UDF implementa... Eric Faulhaber

12:24 PM Feature #3319: investigate viability of using the Progress database as a back-end

I am not sure whether SQL Server has a @CREATE ALIAS@ statement, but the FWD mechanism that replaces the overloaded f... Ovidiu Maxiniuc

12:00 PM Feature #3319: investigate viability of using the Progress database as a back-end

Christopher Cotter wrote:
> Is the CREATE ALIAS really necessary? Is there a reason all of the UDF parameters could... Eric Faulhaber

11:41 AM Feature #3319: investigate viability of using the Progress database as a back-end

Does this use the same runtime mapping as we use for UDFs overloaded with CREATE ALIAS (i.e., to map an undecorated U... Eric Faulhaber

11:26 AM Feature #3319: investigate viability of using the Progress database as a back-end

Eric Faulhaber wrote:
> Ovidiu, didn't you have to deal with UDF overloading without CREATE ALIAS for SQL Server?
... Ovidiu Maxiniuc

11:16 AM Feature #3319: investigate viability of using the Progress database as a back-end

Looks like on OE there is a CREATE SYNONYM rather than CREATE ALIAS
https://documentation.progress.com/output/ua/O... Christopher Cotter

11:15 AM Feature #3319: investigate viability of using the Progress database as a back-end

Question via email:
> Looks like on OE there is a CREATE SYNONYM rather than CREATE ALIAS
>
> https://documentatio... Eric Faulhaber

05:56 AM Bug #3324: Incorrect handling of temp tables with the same name makes translated code non-compilable

This is not a bullet-prof solution. There are still cases when this kind of name collisions can occur. We need to thi... Ovidiu Maxiniuc

08:24 PM Bug #3324: Incorrect handling of temp tables with the same name makes translated code non-compilable

This fix is checked in to branch 3330a which we intend to put through testing starting this weekend. It will be merg... Greg Shah

08:23 PM Bug #3324: Incorrect handling of temp tables with the same name makes translated code non-compilable

From Ovidiu, working in #3330-277 which is the same root cause:
> I think I have a slight idea about what is wrong... Greg Shah

08/31/2017

02:20 PM Feature #3319: investigate viability of using the Progress database as a back-end

We already deal with database dialects which do not support "native" UDF overloading. In this case, we internally ove... Eric Faulhaber

09:34 PM Feature #3319: investigate viability of using the Progress database as a back-end

This seems to work and might be a generic solution to the overloading problem.
rop function eq;
create function... Christopher Cotter

08:57 PM Feature #3319: investigate viability of using the Progress database as a back-end

Openedge SQL Data Type Mappings
https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmsql/d... Christopher Cotter

08:39 PM Feature #3319: investigate viability of using the Progress database as a back-end

I created a sports2000 database and used these commands to get the ball rolling.
c:\progress\openedge\bin\sql_env
... Christopher Cotter

08:34 PM Feature #3319: investigate viability of using the Progress database as a back-end

I did some testing on OE 11.7 today using the SQLExplorer and running just a SQL server process instance.
It doesn... Christopher Cotter

08/25/2017

01:37 PM Feature #3296: misc db features

There is a use of a table parameter with BY-REFERENCE. Is this handled already by conversion? Greg Shah

12:43 PM Feature #3294: implement temp-table XML support from #3257-34

Greg Shah wrote:
> The conversion changes for this task (branch 3293a) were merged to trunk on 08/24/2017 as revisio... Eric Faulhaber

12:08 PM Feature #3294: implement temp-table XML support from #3257-34

The conversion changes for this task (branch 3293a) were merged to trunk on 08/24/2017 as revision 11160.
The gap ... Greg Shah

08/24/2017

11:49 AM Bug #3315: infinite loop in mark_client_branch during annotations because of nest CAN-FINDs with ...

The patch from #3315-2 was added to task branch 3293a, which was merged to FWD trunk revision 11160.
Jaroslaw, at ... Eric Faulhaber

09:26 AM Feature #3293 (WIP): implement metaschema usage from #3257-3

Task branch 3293a contains conversion support for the missing metadata features. It was merged and committed to trunk... Eric Faulhaber

08/12/2017

09:34 AM Bug #3324: Incorrect handling of temp tables with the same name makes translated code non-compilable

To reproduce:
1) Create 10 files with the name @test.<NN>.p@, where <NN> = 01..10 containing the temp table defini... Jaroslaw Haziak

09:10 AM Bug #3324 (Closed): Incorrect handling of temp tables with the same name makes translated code no...

Jaroslaw Haziak

08/11/2017

10:06 AM Feature #3319: investigate viability of using the Progress database as a back-end

Added a very rough estimate needed to have a better idea on the feasibility of this. Eric Faulhaber

09:36 AM Feature #3319: investigate viability of using the Progress database as a back-end

Currently, FWD does not support the Progress database as a back end and it is not clear how feasible it would be to d... Eric Faulhaber

09:32 AM Feature #3319 (New): investigate viability of using the Progress database as a back-end

Eric Faulhaber

08/10/2017

12:50 PM Bug #3315 (WIP): infinite loop in mark_client_branch during annotations because of nest CAN-FINDs...

TODO: add the fix from #3315-2 to an existing development branch or create a branch for it. Eric Faulhaber

12:48 PM Bug #3315: infinite loop in mark_client_branch during annotations because of nest CAN-FINDs with ...

I took a quick look at this and produced the attached fix to prevent the infinite loop. However, there is still a pro... Eric Faulhaber

11:04 AM Bug #3315: infinite loop in mark_client_branch during annotations because of nest CAN-FINDs with ...

Bug report (from a customer):
The problem is with nested CAN-FINDs which mix ordinary table and temp-table. In thi... Greg Shah

11:01 AM Bug #3315 (WIP): infinite loop in mark_client_branch during annotations because of nest CAN-FINDs...

Greg Shah

08/07/2017

08:01 AM Feature #3295 (WIP): improve connect options support per #3257-29

Added conversion support for @-1@, @-pf@, and @-RO@ options in task branch 1514a/11397. Runtime support not yet added. Eric Faulhaber