[
https://issues.apache.org/jira/browse/IGNITE-11434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16809623#comment-16809623
]
Vladimir Ozerov commented on IGNITE-11434:
------------------------------------------
[~tledkov-gridgain], [~jooger], my comments:
# {{COLUMN_ID}} - I am not sure why we should expose it, as it is merely H2
internals
# {{DEFAULT_VALUE}} - we do not support default values at the moment, so why to
expose it?
# {{SQL_TYPE}} - again, this is H2 internals
# {{DISPLAY_SIZE}} - what is the use case for this field from user perspective?
# {{AFFINITY_KEY}} - I would name it {{IS_AFFINITY_KEY}} to be consistent with
{{IS_NULLABLE}}
# We have two hidden columns {{_KEY}} and {{_VAL}}, which may have aliases. Do
we want to expose them? If no, then why not? If yes - then how exactly? Do we
need additional "hidden" attribute or something else? Do other vendors expose
hidden columns?
> 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_ID | int | Column ID |
> | COLUMN_NAME | string | Column name |
> | DEFAULT VALUE | string | Defaut column's value |
> | IS_NULLABLE | boolean | Nullable flag corresponds to
> {{QueryEntity#setNotNullFields}} |
> | SQL TYPE | int | SQL data type ID |
> | DATA_TYPE | string | SQL data type |
> | DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
> | PRECISION | int | Precision |
> | SCALE | int | Scale |
> | AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
