Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.4
-
None
Description
Given the following table:
CREATE TABLE t (x INT WITH SYSTEM VERSIONING, y INT);
|
there is no distinction between the two columns in the information schema columns table:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='t'\G
|
*************************** 1. row ***************************
|
TABLE_CATALOG: def
|
TABLE_SCHEMA: test
|
TABLE_NAME: t
|
COLUMN_NAME: x
|
ORDINAL_POSITION: 1
|
COLUMN_DEFAULT: NULL
|
IS_NULLABLE: YES
|
DATA_TYPE: int
|
CHARACTER_MAXIMUM_LENGTH: NULL
|
CHARACTER_OCTET_LENGTH: NULL
|
NUMERIC_PRECISION: 10
|
NUMERIC_SCALE: 0
|
DATETIME_PRECISION: NULL
|
CHARACTER_SET_NAME: NULL
|
COLLATION_NAME: NULL
|
COLUMN_TYPE: int(11)
|
COLUMN_KEY:
|
EXTRA:
|
PRIVILEGES: select,insert,update,references
|
COLUMN_COMMENT:
|
IS_GENERATED: NEVER
|
GENERATION_EXPRESSION: NULL
|
*************************** 2. row ***************************
|
TABLE_CATALOG: def
|
TABLE_SCHEMA: test
|
TABLE_NAME: t
|
COLUMN_NAME: y
|
ORDINAL_POSITION: 2
|
COLUMN_DEFAULT: NULL
|
IS_NULLABLE: YES
|
DATA_TYPE: int
|
CHARACTER_MAXIMUM_LENGTH: NULL
|
CHARACTER_OCTET_LENGTH: NULL
|
NUMERIC_PRECISION: 10
|
NUMERIC_SCALE: 0
|
DATETIME_PRECISION: NULL
|
CHARACTER_SET_NAME: NULL
|
COLLATION_NAME: NULL
|
COLUMN_TYPE: int(11)
|
COLUMN_KEY:
|
EXTRA:
|
PRIVILEGES: select,insert,update,references
|
COLUMN_COMMENT:
|
IS_GENERATED: NEVER
|
GENERATION_EXPRESSION: NULL
|
2 rows in set (0.001 sec)
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Summary | Information Scheme COLUMNS Table does not show system versioning information | Information Schema COLUMNS Table does not show system versioning information |
| Fix Version/s | 10.3 [ 22126 ] | |
| Assignee | Sergei Golubchik [ serg ] |
| Sprint | 10.3.5-1 [ 229 ] |
| Assignee | Sergei Golubchik [ serg ] | Alexander Krizhanovsky [ krizhanovsky ] |
| Assignee | Alexander Krizhanovsky [ krizhanovsky ] | Eugene Kosov [ kevg ] |
| Sprint | 10.3.5-1 [ 229 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Eugene Kosov [ kevg ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Sprint | 10.3.6 [ 240 ] |
| Labels | contribution foundation |
| Labels | contribution foundation |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.3.6 [ 23003 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Sprint | 10.3.6 [ 240 ] |
| Rank | Ranked higher |
| Workflow | MariaDB v3 [ 85127 ] | MariaDB v4 [ 153643 ] |
I guess, it should go in EXTRA column...