Description of problem: EDS Reference Guide is explaining that maximum length of string data type is 4000. However, teiid engine is not checking the maximum length. In teiid, the length does not have limited. [1] variable length character string with a maximum length of 4000. https://access.redhat.com/knowledge/docs/en-US/JBoss_Enterprise_Data_Services/5/html-single/Data_Services_Reference_Guide/index.html#id539903
Van, Is this an error with the docs or the code? Should the teiid string datatype be restricted to a maximum length of 4000? Also, it seems from Red Hat Customer Portal ID: 00775969 (see External Trackers) that the phrase "Note that the length cannot be explicitly set with the type literal, e.g. Varchar(100)." may need more explanation. (refer to https://access.redhat.com/knowledge/docs/en-US/JBoss_Enterprise_Data_Services/5/html-single/Data_Services_Reference_Guide/index.html#id539903) Your help with this would be appreciated. Cheers, Ben
Eiichi, Since this is a potential issue with the code, please report via JIRA - https://issues.jboss.org/browse/TEIID. Regards, Ben
Thank you for your update. I might not understand the procedure of the EDS issue report. > Since this is a potential issue with the code, please report via JIRA Does this mean that it is issue of teiid engine? If yes, can I change "Component" in this bug into 'EDS' or create new EDS *Bugzilla*? However, if the maximum size is limited by 4000, doesn't anything become a problem for customers? For example, teiid designer can treat text data as base64 type. Since base64 type is treated by string runtime type in teiid, is the size of text data also limited?
The reason for the 4000 limit is that the SQL limit (table definition) is (or was at the time) 4000 bytes (which may be less than 4000 characters if you are using a multi-byte character set). As for the code reference to AnyToStringTransform.java, its one of the many classes that extend Transform and form the basis for the internal datatype transformations. The DataTypeManager is the keeper of types and the mappings used to determine which transformer to use at runtime.
Steven Hawkins <shawkins> updated the status of jira TEIID-2361 to Closed
Fixed before GA - setting to requires_doc_text- accordingly