[
https://issues.apache.org/jira/browse/IGNITE-11434?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Taras Ledkov updated IGNITE-11434:
----------------------------------
Description:
Need to expose SQL system view with COLUMNS information.
Need to investigate more deeper which of information should be there.
As start point we can take
[https://dev.mysql.com/doc/refman/8.0/en/columns-table.html]
Columns description:
|| Name || Type || Description||
| SCHEMA_NAME | string | Schema name |
| TABLE_NAME | string | Table name |
| COLUMN_NAME | string | Column name |
| ORDINAL_POSITION | int | Column ordinal. Starts with 1 |
| DEFAULT VALUE | string | Defaut column's value |
| IS_NULLABLE | boolean | Nullable flag corresponds to
{{QueryEntity#setNotNullFields}} |
| DATA_TYPE | string | SQL data type |
| CHARACTER_LENGTH | int | Size for char CAHR and VARCHAR types |
| NUMERIC_PRECISION | int | Precision for numeric types |
| NUMERIC_SCALE | int | Scale for numeric types |
| IS_AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |
| IS_HIDDEN | boolean | {{true}} for hidden _ley nad _val columns. {{false}}
for all columns available by asterisk mask |
was:
Need to expose SQL system view with COLUMNS information.
Need to investigate more deeper which of information should be there.
As start point we can take
[https://dev.mysql.com/doc/refman/8.0/en/columns-table.html]
Columns description:
|| Name || Type || Description||
| SCHEMA_NAME | string | Schema name |
| TABLE_NAME | string | Table name |
| COLUMN_NAME | string | Column name |
| ORDINAL_POSITION | int | Column ordinal. Starts with 1 |
| DEFAULT VALUE | string | Defaut column's value |
| IS_NULLABLE | boolean | Nullable flag corresponds to
{{QueryEntity#setNotNullFields}} |
| DATA_TYPE | string | SQL data type |
| CHARACTER_LENGTH | int | Size for char CAHR and VARCHAR types |
| NUMERIC_PRECISION | int | Precision for numeric types |
| NUMERIC_SCALE | int | Scale for numeric types |
| IS_AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |
| IS_HIDDEN | boolean | {{true}} whan the column is affinity key |
> SQL: Create a view with list of existing COLUMNS
> ------------------------------------------------
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
> Issue Type: Task
> Components: sql
> Reporter: Yury Gerzhedovich
> Assignee: Taras Ledkov
> Priority: Major
> Labels: iep-29
> Time Spent: 1.5h
> Remaining Estimate: 0h
>
> Need to expose SQL system view with COLUMNS information.
> Need to investigate more deeper which of information should be there.
>
> As start point we can take
> [https://dev.mysql.com/doc/refman/8.0/en/columns-table.html]
> Columns description:
> || Name || Type || Description||
> | SCHEMA_NAME | string | Schema name |
> | TABLE_NAME | string | Table name |
> | COLUMN_NAME | string | Column name |
> | ORDINAL_POSITION | int | Column ordinal. Starts with 1 |
> | DEFAULT VALUE | string | Defaut column's value |
> | IS_NULLABLE | boolean | Nullable flag corresponds to
> {{QueryEntity#setNotNullFields}} |
> | DATA_TYPE | string | SQL data type |
> | CHARACTER_LENGTH | int | Size for char CAHR and VARCHAR types |
> | NUMERIC_PRECISION | int | Precision for numeric types |
> | NUMERIC_SCALE | int | Scale for numeric types |
> | IS_AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |
> | IS_HIDDEN | boolean | {{true}} for hidden _ley nad _val columns. {{false}}
> for all columns available by asterisk mask |
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
