Author Topic: Datatype mapping inconsistent  (Read 1047 times)

Oliver F.

  • EA User
  • **
  • Posts: 573
  • Karma: +2/-1
  • Arenīt we all in the model business ?
    • View Profile
    • Karl Storz homepage
Datatype mapping inconsistent
« on: March 19, 2009, 06:39:13 pm »
Filed this bug some days ago:

=========================

Data type mapping with custom products not working

Details:  

EA offers the possibility of creating database products with custom
datatypes.
However the mapping dialog shows an inconsistent behavior and the
mapping is not applied when the database is changing from and to a
custom database product.
The reference data export DBMap does not include any custom product
mapping.
In the mapping dialog one can apply a mapping, which is not refreshed
when changing the datatype in the left list box, it always shows the one
from the previous selection. Plus the "Save" button gets grayed out when a size of a datatype is being entered.

Steps to Reproduce:  

- Create a custom database product A and add some types.
- Add some datatypes x,y,z to the product with ranges, size, etc.
- Open the datatypes mapping dialog, create a mapping of product A type
x to eg. Oracle VARCHAR. Press "Save".
- Stay in the mapping dialog and select datatype y. The dialog still
shows a mapping to Oracle VARCHAR. Change this to eg. DB2 REAL and click
in the "Size" field -> the "Save" button gets grayed out unless "None"
or "Precision" is chosen. Save the mapping
- select datatype x again -> the dialog shows a mapping to DB2 REAL for
x, though it should be Oracle VARCHAR.
The correct mapping is shown only if the target product is chosen again.
- Export reference data DBmap and open the file -> Only internal product
mappings are included.
- Create a table of product A with attributes of type x and y, then
change its database product to Oracle -> mapping is not applied, it
still shows a type x.

===============

Sparx has notified me that this bug has been reproduced and that improvements in that area will be included in a future release.

Oliver

ff

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Datatype mapping inconsistent
« Reply #1 on: May 27, 2011, 12:18:10 am »
Apparantly this bug isn't fixed yet in version 7.5.843.
Is there somebody out there who can help me understand this mapping?
I've defined a custom database and datatypes, created (or tried to create) a mapping from the DB2 datatypes to this custom datatypes. But when I change the database of my tables from DB2 to this custom database, the datatype of the attributes isn't converted.
The datatypes are defined in t_datatypes. Which table or algorithm is used for the mapping?

kr,
Flip

Simon M

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 6450
  • Karma: +55/-6
    • View Profile
Re: Datatype mapping inconsistent
« Reply #2 on: May 27, 2011, 08:41:53 am »
Do you realise the version that you are using was released only 6 days after the post that you are replying to and is over 2 years old?

You could try version 9 and see if the behavior is any different in the latest version.
Simon

support@sparxsystems.com

ff

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Datatype mapping inconsistent
« Reply #3 on: May 30, 2011, 10:56:19 pm »
Quote
Do you realise the version that you are using was released only 6 days after the post that you are replying to and is over 2 years old?

You could try version 9 and see if the behavior is any different in the latest version.

Now I do. Thx!

I want to know how it shoud behave, not if it behaves differently.

ff

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Datatype mapping inconsistent
« Reply #4 on: May 31, 2011, 05:32:51 pm »
Behavior is the same in version 9.