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

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

Vladimir Ozerov created IGNITE-6292:
---------------------------------------

             Summary: 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


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
(v6.4.14#64029)