search

dolthub / vitess

Vitess is a database clustering system for horizontal scaling of MySQL.
http://vitess.io
Apache License 2.0
23 stars 22 forks source link

Allow inline column check constraint definitions to appear in any order #295

Closed fulghum closed 11 months ago

fulghum commented 11 months ago

Previously, an inline column check constraint could only appear as the very last option for a column definition. This change allows it to appear in other positions in the column definition. For example, this query now works:

create table t123 (c1 varchar(5) check (c1 in ('v1', 'v2')) NOT NULL);

Resolves: https://github.com/dolthub/dolt/issues/7195