[
https://issues.apache.org/jira/browse/DERBY-2258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12468669
]
A B commented on DERBY-2258:
----------------------------
> I think DATA_TYPE should be 2009 (java.sql.Types.SQLXML). Not sure about
> LITERAL_PREFIX and LITERAL_SUFFIX, but I think they should be NULL. I'm
> also not sure about CREATE_PARAMS, but suspect it should be NULL as well.
I agree with Knut Anders on all of the above. There is currently no way to
specify an XML literal in SQL--a user has to use the XMLPARSE() operator, which
takes a string literal--so there is no prefix/suffix defined. And when an XML
column is created, there is no length argument:
create table t1 (x xml); // correct.
create table t1 (x xml(256)) // incorrect -- length not allowed
So CREATE_PARAMS should be null, too.
> UNSIGNED_ATTRIBUTE and AUTO_INCREMENT should probably be false instead of
> null.
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)?
In ODBC land these two fields are supposed to be null "if the attribute is not
applicable to the data type or the data type is not numeric"--but as people
have said before, ODBC and JDBC are different, so I guess that's irrelevant...
In any event, +1 to the suggestions made by Knut Anders.
> 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
>
>
> 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.
