[
https://issues.apache.org/jira/browse/IGNITE-6686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16252708#comment-16252708
]
Denis Magda commented on IGNITE-6686:
-------------------------------------
[~ptupitsyn], [~isapego],
Please fill out .NET, C++ and ODBC for these types:
https://apacheignite-sql.readme.io/v2.3/docs/data-types#section-binary
https://apacheignite-sql.readme.io/v2.3/docs/data-types#section-array
[~vozerov],
Referring to this source {{H2DatabaseType}}, some of the types' mappings are
ambiguous. For instance, {{TIMESTAMP}} maps to both {{java.util.Date}} and
{{java.sql.Timestamp}} [1]. It's clear that if a user passes {{java.util.Date}}
or {{java.sql.Timestamp}} value then it will be marked as {{TIMESTAMP}}.
However, what's the default type? Assume we support {{DEFAULT}} constraint for
columns and I need to initialize a {{TIMESTAMP}} column with a value. What will
be the type of the value?
[1]
https://github.com/apache/ignite/blob/master/modules/indexing/src/main/java/org/apache/ignite/internal/processors/query/h2/H2DatabaseType.java#L111
> Document SQL Data Types
> -----------------------
>
> Key: IGNITE-6686
> URL: https://issues.apache.org/jira/browse/IGNITE-6686
> Project: Ignite
> Issue Type: Task
> Security Level: Public(Viewable by anyone)
> Components: documentation
> Reporter: Denis Magda
> Assignee: Vladimir Ozerov
> Fix For: 2.3
>
>
> The data types page should include all SQL types supported and how they
> mapped to a language or driver specific type. Presently the types are
> represented in a tabular format:
> https://apacheignite-sql.readme.io/v2.3/docs/data-types
> Guys, please help to fill out langage/drivers specific columns:
> # [~ptupitsyn] - .NET data types.
> # [~isapego] - C++ and ODBC data type.
> # [~al.psc] - JDBC and JAVA data types.
> [~vozerov], please suggest what to do with these few types below. They
> supported by H2 but I'm not sure how Ignite deals with them:
> http://www.h2database.com/html/datatypes.html#identity_type
> http://www.h2database.com/html/datatypes.html#binary_type
> http://www.h2database.com/html/datatypes.html#other_type
> http://www.h2database.com/html/datatypes.html#varchar_ignorecase_type
> http://www.h2database.com/html/datatypes.html#blob_type
> http://www.h2database.com/html/datatypes.html#clob_type
> http://www.h2database.com/html/datatypes.html#array_type
> http://www.h2database.com/html/datatypes.html#enum_type
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
