Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.4.10, 10.3(EOL), 10.4(EOL)
-
None
Description
Create a table with a check constraint:
create table t (i int, constraint a check (i > 0));
|
Now consider this query, which should produce the above check constraint:
select
|
tc.TABLE_SCHEMA,
|
tc.TABLE_NAME,
|
cc.CONSTRAINT_NAME,
|
cc.CHECK_CLAUSE
|
from information_schema.TABLE_CONSTRAINTS tc
|
join information_schema.CHECK_CONSTRAINTS cc
|
using (CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, TABLE_NAME, CONSTRAINT_NAME)
|
;
|
It does not produce any results.
Add two columns to the projection and ta-dah, we get the desired output:
select
|
tc.TABLE_SCHEMA,
|
tc.TABLE_NAME,
|
cc.CONSTRAINT_NAME,
|
cc.CHECK_CLAUSE,
|
tc.CONSTRAINT_CATALOG,
|
tc.CONSTRAINT_SCHEMA
|
from information_schema.TABLE_CONSTRAINTS tc
|
join information_schema.CHECK_CONSTRAINTS cc
|
using (CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, TABLE_NAME, CONSTRAINT_NAME)
|
;
|
Attachments
Issue Links
- duplicates
-
-
- Closed
-
- is duplicated by
-
-
- Closed
-
Activity
| Transition | Time In Source Status | Execution Times |
|---|
|
2h 18m | 1 |
|
147d 21h 44m | 1 |
|
70d 4h 10m | 1 |
|
19d 17h 35m | 1 |
|
3d 3h 29m | 1 |