[
https://issues.jboss.org/browse/TEIIDDES-812?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-812:
---------------------------------------
The following is a list of current Teiid Designer BuiltInDataTypes
anyURI
base64Binary
bigdecimal : xs:decimal
blob : xs:base64Binary
boolean
byte : xs:short
char : xs:string
clob : xs:string
date
dateTime
decimal
double
duration
ENTITIES : xs:ENTITY
ENTITY : xs:NCName
float
gDay
gMonth
gMonthDay
gYear
gYearMonth
hexBinary
ID : xs:NCName
IDREF : xs:NCName
IDREFS : xs:IDREF
int : xs:long
integer : xs:decimal
language : xs:token
long : xs:integer
Name : xs:token
NCName : xs:Name
negativeInteger : xs:nonPositiveInteger
NMTOKEN : xs:token
NMTOKENS : xs:NMTOKEN
nonNegativeInteger : xs:integer
nonPositiveInteger : xs:integer
normalizedString : xs:string
NOTATION
object : xs:base64Binary
positiveInteger : xs:nonNegativeInteger
QName
short : xs:int
string
time
timestamp : xs:string
token : xs:normalizedString
unsignedByte : xs:unsignedShort
unsignedInt : xs:unsignedLong
unsignedLong : xs:nonNegativeInteger
unsignedShort : xs:unsignedInt
XMLLiteral : xs:string
DDL Export XSLT files need to be upgraded/improved
--------------------------------------------------
Key: TEIIDDES-812
URL:
https://issues.jboss.org/browse/TEIIDDES-812
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1, 7.2, 7.3
Reporter: Barry LaFond
Assignee: Barry LaFond
Priority: Critical
Fix For: 7.4
After working import issue TEIIDDES-215, it's become apparent that our XSLT's for
various DB's need to be revisited.
For instance, there is no logic in PostgreSQL version to check for integer types that
have AUTOINCREMENT == TRUE. These should be exported as SERIAL datatypes. Same for
BIGSERIAL.
There is other missing logic.
We need to:
1) Create a doc or series of docs describing what datatype conversions should be done on
IMPORT JDBC and EXPORT DDL
2) Create sub-tasks for implementing these docs for all DB's
3) Possibly create extension point(s) to handle "new" DB types more effeciently
--
This message is automatically generated by JIRA.
For more information on JIRA, see:
http://www.atlassian.com/software/jira