[
https://issues.apache.org/jira/browse/DERBY-2258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Saurabh Vyas updated DERBY-2258:
--------------------------------
Attachment: Derby-2258_v2.diff
Thanks Knut, A B & Dan for your valuable comments. I had modified the values
for XML data type as following (incorporating the changes suggested ) :
1. TYPE_NAME String => XML
2. DATA_TYPE int => 2009
3. PRECISION int => CAST (NULL AS INTEGER)
4. LITERAL_PREFIX String => CAST (NULL AS CHAR)
5. LITERAL_SUFFIX String => CAST (NULL AS CHAR)
6. CREATE_PARAMS String => CAST (NULL AS CHAR)
7. NULLABLE short => 1 (i.e. typeNullable)
8. CASE_SENSITIVE boolean=> TRUE
9. SEARCHABLE short => 0 (i.e. typePredNone)
10. UNSIGNED_ATTRIBUTE boolean => FALSE
11. FIXED_PREC_SCALE boolean => FALSE
12. AUTO_INCREMENT boolean => FALSE
13. LOCAL_TYPE_NAME String => XML (Not required to specify as its same as
TYPE_INFO)
14. MINIMUM_SCALE short => CAST (NULL AS INTEGER)
15. MAXIMUM_SCALE short => CAST (NULL AS INTEGER)
16. SQL_DATA_TYPE int => unused
17. SQL_DATETIME_SUB int => unused
18. NUM_PREC_RADIX int => CAST (NULL AS INTEGER)
Is this correct ?
Attached version 2 for the patch with the above changes. Please have a look at
Derby-2259 & Derby-2260 also to verify the fix.
Apart as mentioned by A B,
---- "Given that the JDBC API does not say that these "may be null", I tend to
agree with Knut Anders on this, too. I did find it odd that CLOB and BLOB have
"null" for these values while the other char types have "TRUE" and "FALSE",
respectively. Is that a bug/inconsistency that should be fixed (as a separate
issue)? "
should these corrections (if required ?) be implemented in this issue itself or
another JIRA should be created to solve these?
Thanks again
> 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.
