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