[IGNITE-6292] SQL: Support CHECK constraint

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 2.1
• Component/s: sql
• Labels: sql-engine
• Assignee: Unassigned
• Reporter: Vladimir Ozerov
• Created: 07/Sep/17 12:59
• Updated: 14/Feb/19 15:18
• Resolved: 14/Feb/19 15:16

Description

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.