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
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Anel Husakovic [ anel ] |
| Link |
This issue relates to |
| Assignee | Anel Husakovic [ anel ] | Vicențiu Ciorbaru [ cvicentiu ] |
| 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? |
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? |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Vicențiu Ciorbaru [ cvicentiu ] | Daniel Black [ danblack ] |
| Assignee | Daniel Black [ danblack ] | Anel Husakovic [ anel ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Anel Husakovic [ anel ] | Daniel Black [ danblack ] |
| Status | Stalled [ 10000 ] | In Review [ 10002 ] |
| Assignee | Daniel Black [ danblack ] | Anel Husakovic [ anel ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.2 [ 14601 ] |
| Fix Version/s | 10.2.37 [ 25112 ] | |
| Fix Version/s | 10.3.28 [ 25111 ] | |
| Fix Version/s | 10.4.18 [ 25110 ] | |
| Fix Version/s | 10.5.9 [ 25109 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 115454 ] | MariaDB v4 [ 158549 ] |