[JBoss JIRA] Created: (TEIIDDES-995) Importing metadata from text, VARCHAR is interpreted as OBJECT - Should be character-based type
8:33 a.m.
Importing metadata from text, VARCHAR is interpreted as OBJECT - Should be character-based
type
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-995
URL: https://issues.jboss.org/browse/TEIIDDES-995
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.4
Environment: Designer 7.4 in Eclipse 3.6
Reporter: Paul Nittel
I imported the attached CSV file into a relational source model. The NUMBERs translated to
bigdecimal, but the VARCHARs translated to objects. Should have been a character-based
type.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:35 a.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-995) Importing metadata from text, VARCHAR is interpreted as OBJECT - Should be character-based type
[
https://issues.jboss.org/browse/TEIIDDES-995?page=com.atlassian.jira.plug...
]
Paul Nittel updated TEIIDDES-995:
---------------------------------
Attachment: Rows100BadTypes.png
TableWith100Rows.csv
Input file for import and picture of the resulting table.
Importing metadata from text, VARCHAR is interpreted as OBJECT -
Should be character-based type
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-995
URL: https://issues.jboss.org/browse/TEIIDDES-995
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.4
Environment: Designer 7.4 in Eclipse 3.6
Reporter: Paul Nittel
Attachments: Rows100BadTypes.png, TableWith100Rows.csv
I imported the attached CSV file into a relational source model. The NUMBERs translated
to bigdecimal, but the VARCHARs translated to objects. Should have been a character-based
type.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:59 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-995) Importing metadata from text, VARCHAR is interpreted as OBJECT - Should be character-based type
[
https://issues.jboss.org/browse/TEIIDDES-995?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-995:
---------------------------------------
Debugging led me to the static initializer in RelationalTypeMappingImple class. In the
code below, only the Integer class is loaded into the SQL_TYPE_MAPPING map, but this map
is used by the getDatatype() method looks in this map. In this case VARCHAR is not in the
map. Removing the if() statement and allowing all types to be loaded in to map fixes
problem.
// This is a poor man's enum.
static {
Field[] fields = Types.class.getDeclaredFields();
for (Field field : fields) {
if (field.getType() == Integer.class) {
try {
SQL_TYPE_MAPPING.put(field.getName(), field.getInt(null));
} catch (Exception e) {
}
}
}
}
Importing metadata from text, VARCHAR is interpreted as OBJECT -
Should be character-based type
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-995
URL: https://issues.jboss.org/browse/TEIIDDES-995
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.4
Environment: Designer 7.4 in Eclipse 3.6
Reporter: Paul Nittel
Attachments: Rows100BadTypes.png, TableWith100Rows.csv
I imported the attached CSV file into a relational source model. The NUMBERs translated
to bigdecimal, but the VARCHARs translated to objects. Should have been a character-based
type.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:09 p.m.
New subject: [JBoss JIRA] Assigned: (TEIIDDES-995) Importing metadata from text, VARCHAR is interpreted as OBJECT - Should be character-based type
[
https://issues.jboss.org/browse/TEIIDDES-995?page=com.atlassian.jira.plug...
]
Barry LaFond reassigned TEIIDDES-995:
-------------------------------------
Assignee: Barry LaFond
Importing metadata from text, VARCHAR is interpreted as OBJECT -
Should be character-based type
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-995
URL: https://issues.jboss.org/browse/TEIIDDES-995
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.4
Environment: Designer 7.4 in Eclipse 3.6
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.5
Attachments: Rows100BadTypes.png, TableWith100Rows.csv
I imported the attached CSV file into a relational source model. The NUMBERs translated
to bigdecimal, but the VARCHARs translated to objects. Should have been a character-based
type.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:09 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-995) Importing metadata from text, VARCHAR is interpreted as OBJECT - Should be character-based type
[
https://issues.jboss.org/browse/TEIIDDES-995?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-995:
----------------------------------
Fix Version/s: 7.5
Importing metadata from text, VARCHAR is interpreted as OBJECT -
Should be character-based type
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-995
URL: https://issues.jboss.org/browse/TEIIDDES-995
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.4
Environment: Designer 7.4 in Eclipse 3.6
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.5
Attachments: Rows100BadTypes.png, TableWith100Rows.csv
I imported the attached CSV file into a relational source model. The NUMBERs translated
to bigdecimal, but the VARCHARs translated to objects. Should have been a character-based
type.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:57 a.m.
New subject: [JBoss JIRA] Resolved: (TEIIDDES-995) Importing metadata from text, VARCHAR is interpreted as OBJECT - Should be character-based type
[
https://issues.jboss.org/browse/TEIIDDES-995?page=com.atlassian.jira.plug...
]
Barry LaFond resolved TEIIDDES-995.
-----------------------------------
Resolution: Done
Changed the Integer.class to int.class to properly load all java SQL types.
VARCHAR is being treated properly now.
Importing metadata from text, VARCHAR is interpreted as OBJECT -
Should be character-based type
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-995
URL: https://issues.jboss.org/browse/TEIIDDES-995
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.4
Environment: Designer 7.4 in Eclipse 3.6
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.5
Attachments: Rows100BadTypes.png, TableWith100Rows.csv
I imported the attached CSV file into a relational source model. The NUMBERs translated
to bigdecimal, but the VARCHARs translated to objects. Should have been a character-based
type.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:57 a.m.
New subject: [JBoss JIRA] Issue Comment Edited: (TEIIDDES-995) Importing metadata from text, VARCHAR is interpreted as OBJECT - Should be character-based type
[
https://issues.jboss.org/browse/TEIIDDES-995?page=com.atlassian.jira.plug...
]
Barry LaFond edited comment on TEIIDDES-995 at 7/11/11 12:56 PM:
-----------------------------------------------------------------
Changed the Integer.class to int.class in RelationalTypeMappingImpl to properly load all
java SQL types.
VARCHAR is being treated properly now.
was (Author: blafond):
Changed the Integer.class to int.class to properly load all java SQL types.
VARCHAR is being treated properly now.
Importing metadata from text, VARCHAR is interpreted as OBJECT -
Should be character-based type
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-995
URL: https://issues.jboss.org/browse/TEIIDDES-995
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.4
Environment: Designer 7.4 in Eclipse 3.6
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.5
Attachments: Rows100BadTypes.png, TableWith100Rows.csv
I imported the attached CSV file into a relational source model. The NUMBERs translated
to bigdecimal, but the VARCHARs translated to objects. Should have been a character-based
type.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4697
days inactive
4714
days old
teiid-designer-issues@lists.jboss.org
6 comments
2 participants
participants (2)
-
Barry LaFond (JIRA) -
Paul Nittel (JIRA)