You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Taras Ledkov (JIRA)" <ji...@apache.org> on 2019/03/06 11:38:00 UTC
[jira] [Comment Edited] (IGNITE-11434) SQL: Create a view with list
of existing COLUMNS
[ https://issues.apache.org/jira/browse/IGNITE-11434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16785534#comment-16785534 ]
Taras Ledkov edited comment on IGNITE-11434 at 3/6/19 11:37 AM:
----------------------------------------------------------------
My proposal the set of columns for {{COLUMNS}} view:
|| Name || Type || Description||
| SCHEMA_NAME | string | Schema name |
| TABLE_NAME | string | Table name |
| COLUMN_NAME | string | Columns name |
| DATA_TYPE | string | SQL data type |
| IS_NULLABLE | boolean | Nullable flag corresponds to {{QueryEntity#setNotNullFields}} |
| DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
| PRECISION | int | Precision |
| SCALE | int | Scale |
| COLUMN_KEY | string | null / PK / MUL according with MySQL semantic |
| AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |
was (Author: tledkov-gridgain):
My proposal the set of columns of {{COLUMNS}} view:
|| Name || Type || Description||
| SCHEMA_NAME | string | Schema name |
| TABLE_NAME | string | Table name |
| COLUMN_NAME | string | Columns name |
| DATA_TYPE | string | SQL data type |
| IS_NULLABLE | boolean | Nullable flag corresponds to {{QueryEntity#setNotNullFields}} |
| DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
| PRECISION | int | Precision |
| SCALE | int | Scale |
| COLUMN_KEY | string | null / PK / MUL according with MySQL semantic |
| AFFINITY_KEY | 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
>
> 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]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)