[
https://issues.apache.org/jira/browse/IGNITE-6861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16289224#comment-16289224
]
Vladimir Ozerov edited comment on IGNITE-6861 at 12/13/17 1:03 PM:
-------------------------------------------------------------------
[~kshirokov]. with H2 we employ {{WITH}} syntax which is proven to be pretty
ugly. As a part of this ticket we should move all extras to new approach where
they goes one-by-one at the end of the table definition without {{WITH}} and
without quotes. See MySQL syntax as example [1].
General approach: {{PARAM_NAME [=] PARAM_VAL}}. For boolean properties value
could be omitted what means that it is set to {{true}}.
E.g.:
{code}
CREATE TABLE my_table (
id BIGINT PRIMARY KEY,
col_1 VARCHAR
) CACHE_NAME myCache AFFINITY_KEY=col_1 WRAP_KEY
{code}
[1] https://dev.mysql.com/doc/refman/5.7/en/create-table.html
was (Author: vozerov):
[~kshirokov]. with H2 we employ {{WITH}} syntax which is proven to be pretty
ugly. As a part of this ticket we should move all extras to new approach where
they goes one-by-one at the end of the table definition without {{WITH}} and
without quotes. See MySQL syntax as example [1].
General approach: {{PARAM_NAME [=] PARAM_VAL}}. For boolean properties value
could be omitted what means that it is set to {{true}}.
E.g.:
{code}
CREATE TABLE my_table (
id BIGINT PRIMARY KEY,
col_1 VARCHAR
) CACHE_NAME myCache AFFINITY_KEY = col_1 WRAP_KEY
{code}
[1] https://dev.mysql.com/doc/refman/5.7/en/create-table.html
> 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.4
>
>
> 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)
