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)
|