Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
-
MariaDB 10.3.1, DBeaver 7.2.4
Description
Hello.
To get information from the database about the check constraints available in the tables, in DBeaver} we use this expression:
SELECT cc.CONSTRAINT_NAME, cc.CHECK_CLAUSE FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
And it seems the number of characters in the CHECK_CLAUSE field is limited (64?).
Therefore, long expressions (like start_date IS NULL OR end_date IS NULL OR start_date<end_date)) are truncated.
This creates some inconvenience when working with data for our users.
We use SHOW CREATE TABLE to get tables DDL, but pulling the constraint expression out of there is difficult.
Are there any other alternative solutions for this problem?
Attachments
Issue Links
- relates to
-
MDEV-14474 INFORMATION_SCHEMA.CHECK_CONSTRAINTS
- Closed