[jira] [Updated] (IGNITE-6292) SQL: Support CHECK constraint

["Vladimir Ozerov (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vladimir Ozerov updated IGNITE-6292:
------------------------------------
    Labels: sql-engine  (was: )

> SQL: Support CHECK constraint
> -----------------------------
>
>                 Key: IGNITE-6292
>                 URL: https://issues.apache.org/jira/browse/IGNITE-6292
>             Project: Ignite
>          Issue Type: Task
>          Components: sql
>    Affects Versions: 2.1
>            Reporter: Vladimir Ozerov
>            Priority: Major
>              Labels: sql-engine
>
> Currently we do not support {{CHECK}} constraint, which is very important in SQL world. Need to investigate how we can add it. Essentially, we have two ways:
> 1) Either delegate constraint validation to H2 somehow. But remember that we should do that early during update, and we should do that efficiently. Need to investigate H2 API to find out how to achieve that.
> 2) Or we should wait for development of our own execution engine, which is a huge thing and would not appear fast. In this case we would be able to pre-compile expression somehow and execute it whenever we want.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)