ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Magda (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-6686) Document SQL Data Types
Date Tue, 14 Nov 2017 23:56:00 GMT

    [ 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)

Mime
View raw message