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.

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

CREATE TABLE ... CHECK() . support #2

Closed
igorky opened this Issue Nov 6, 2017 · 4 comments

Comments

Projects
None yet
4 participants
@igorky

igorky commented Nov 6, 2017

Expected behavior

Please add support of CHECK section in create table statement.

Current behavior

No information on UI.
No information about CHECK section in the "CREATE code" tab.

Failure information (for bugs)

Steps to reproduce

CREATE TABLE test_json (
test_col LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin'
)
ENGINE=InnoDB;

ALTER TABLE test_json
ADD CHECK(JSON_VALID(test_col));

Context

Please provide any relevant information about your setup. This is important in case the issue is not reproducible except for under certain conditions.

  • HeidiSQL version: r5184
  • Database system + version: MariaDB 10.2.10
  • Operating system: Win10

Failure Logs

Please include any relevant log snippets or files here.

ansgarbecker added a commit that referenced this issue Nov 6, 2017

Simplify regular expression for extracting column details in ParseTab…
…leStructure(), so it does not barf on huge length/set. Fixes issue #2.
@ansgarbecker

This comment has been minimized.

Show comment
Hide comment
@ansgarbecker

ansgarbecker Nov 6, 2017

Collaborator

Sorry, wrong ticket id in the commit, should have been #3, not #2.

Collaborator

ansgarbecker commented Nov 6, 2017

Sorry, wrong ticket id in the commit, should have been #3, not #2.

@ansgarbecker ansgarbecker changed the title from CREATE TABLE ... CHECK() . support (r5184) to CREATE TABLE ... CHECK() . support Nov 12, 2017

@ansgarbecker

This comment has been minimized.

Show comment
Hide comment
@ansgarbecker

ansgarbecker Nov 12, 2017

Collaborator

Some documentation about CHECKS can be found on the MariaDB pages.

But I have problems in finding a documentation for getting existing CHECK clauses on a table. Can you provide some details or an online documentation?

Collaborator

ansgarbecker commented Nov 12, 2017

Some documentation about CHECKS can be found on the MariaDB pages.

But I have problems in finding a documentation for getting existing CHECK clauses on a table. Can you provide some details or an online documentation?

@vaintroub

This comment has been minimized.

Show comment
Hide comment
@vaintroub

vaintroub Jan 9, 2018

@ansgarbecker , "SHOW CREATE TABLE" gives existing check clauses.

vaintroub commented Jan 9, 2018

@ansgarbecker , "SHOW CREATE TABLE" gives existing check clauses.

@rentalhost

This comment has been minimized.

Show comment
Hide comment
@rentalhost

rentalhost Feb 12, 2018

Collaborator

Closing: as is same as #75 we will keep talking in this new ticket.

Collaborator

rentalhost commented Feb 12, 2018

Closing: as is same as #75 we will keep talking in this new ticket.

@rentalhost rentalhost closed this Feb 12, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment