FWD » Core Development » Database

09/20/2017

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

Branch 3330a was merged to trunk as revision 11164. It is expected to be released as FWD v3.1 in the next few days.
... Greg Shah

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