Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: allow constraints to appear along with columns definitions #3504

Closed
kyukhin opened this issue Jul 4, 2018 · 0 comments
Closed

sql: allow constraints to appear along with columns definitions #3504

kyukhin opened this issue Jul 4, 2018 · 0 comments
Assignees
@romanhabibov
Labels
feature A new functionality good first issue Good for newcomers sql
Milestone
2.1.2

Comments

@kyukhin
Copy link
Contributor

kyukhin commented Jul 4, 2018 •
edited

Taken from #2350

The requirement, that column definitions must come before
table constraint definitions, is not standard. I've often
seen constraints defined immediately after the definitions
of the columns that they immediately affect.

box.sql.execute("CREATE TABLE te11 (s1 INT, CHECK (s1 > 0), s2 INT);")
Result = syntax error
@kyukhin kyukhin added this to the 2.1.1 milestone Jul 4, 2018
@kyukhin kyukhin mentioned this issue Jul 4, 2018
Closed
@romanhabibov romanhabibov mentioned this issue Nov 17, 2018
Open
romanhabibov added a commit that referenced this issue Nov 18, 2018
@romanhabibov
sql: constraints definition among columns in CREATE TABLE()
5db0532 
Allow constraints to appear along with columns definitions. Disallow typing
a constraint name without specifying the constraint and after.

Closes #3504
romanhabibov added a commit that referenced this issue Nov 18, 2018
@romanhabibov
sql: constraints def among columns in CREATE TABLE()
6075fbd 
Allow constraints to appear along with columns definitions. Disallow typing
a constraint name without specifying the constraint and after.

Closes #3504
romanhabibov added a commit that referenced this issue Nov 18, 2018
@romanhabibov
sql: constraints def among columns in CREATE TABLE()
917dc57 
Allow constraints to appear along with columns definitions. Disallow typing
a constraint name without specifying the constraint and after.

Closes #3504
romanhabibov added a commit that referenced this issue Nov 21, 2018
@romanhabibov
sql: constraints def among columns in CREATE TABLE()
5bcc130 
Allow constraints to appear along with columns definitions. Disallow typing
a constraint name without specifying the constraint and after.

Closes #3504
romanhabibov added a commit that referenced this issue Nov 22, 2018
@romanhabibov
sql: allow appearing constraint definition among columns
0cd2b50 
Allow constraints to appear along with columns definitions. Disallow typing
a constraint name without specifying the constraint and after it.

Closes #3504
@kyukhin kyukhin added the feature A new functionality label Nov 26, 2018
@kyukhin kyukhin added the tmp label Mar 28, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@romanhabibov romanhabibov

Labels
feature A new functionality good first issue Good for newcomers sql
Projects
None yet
Milestone
2.1.2
Development

No branches or pull requests
2 participants
@kyukhin @romanhabibov