[
https://issues.apache.org/jira/browse/IGNITE-6861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16323997#comment-16323997
]
Kirill Shirokov commented on IGNITE-6861:
-----------------------------------------
Differences in SQL type handling in column definition clauses in Ignite CREATE
TABLE vs. SQL-99 standard:
h3. String types:
* Not supported: <type> CHARACTER SET <charset> in character type definition
* Not supported: CLOB, NCLOB, <type> LARGE OBJECT
* Not supported: NATIONAL <type>
* We don't make any difference between national and plain character types
* In VARYING types (varchar etc.) length argument is optional
h3. Bit string types:
* BIT == BOOLEAN in our implementation
* Not supported: BIT VARYING
* We don't support optional bit string length parameter
h3. Approximate numeric types:
* FLOAT: We don't support optional precision
h3. Datetime types:
* TIME, TIMESTAMP: precision is not supported
* Not supported: WITH TIME ZONE / WITHOUT TIME ZONE
h3. Other types:
* Not supported: BINARY LARGE OBJECT, BLOB
* Not supported: INTERVAL
* Not supported: ROW
* Not supported: arrays
> SQL parser: support CREATE TABLE and DROP TABLE commands
> --------------------------------------------------------
>
> Key: IGNITE-6861
> URL: https://issues.apache.org/jira/browse/IGNITE-6861
> Project: Ignite
> Issue Type: Task
> Components: sql
> Reporter: Vladimir Ozerov
> Assignee: Kirill Shirokov
> Fix For: 2.5
>
>
> Partial implementation is ready (see PR). Need to make sure that the full
> syntax is supported.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
