[
https://issues.apache.org/jira/browse/DERBY-2258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12468984
]
Knut Anders Hatlen commented on DERBY-2258:
-------------------------------------------
Daniel John Debrunner wrote:
> Not sure what PRECISION should be for an XML type. It doesn't really have any
> meaning, but I bet returning NULL there would not be acceptable.
JDBC 4.0 clarified this in the javadoc:
The PRECISION column represents the maximum column size that the server
supports for the given datatype. For numeric data, this is the maximum
precision. For character data, this is the length in characters. For datetime
datatypes, this is the length in characters of the String representation
(assuming the maximum allowed precision of the fractional seconds component).
For binary data, this is the length in bytes. For the ROWID datatype, this is
the length in bytes. Null is returned for data types where the column size is
not applicable.
> DatabaseMetaData.getTypeInfo() does not list supported Derby SQL types
> correctly.
> ---------------------------------------------------------------------------------
>
> Key: DERBY-2258
> URL: https://issues.apache.org/jira/browse/DERBY-2258
> Project: Derby
> Issue Type: Bug
> Components: JDBC, Network Client
> Affects Versions: 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0,
> 10.3.0.0
> Reporter: Daniel John Debrunner
> Assigned To: Saurabh Vyas
> Priority: Minor
> Attachments: Derby-2258.diff, Derby-2258.stat, Derby-2258_v2.diff
>
>
> These types are returned but not supported by Derby.
> LONG NVARCHAR
> NATIONAL CHAR
> NATIONAL CHAR VARYING
> The XML type is supported by Derby but not returned.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
