[jira] [Commented] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

["Maxim Muzafarov (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-11434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16946754#comment-16946754 ] 

Maxim Muzafarov commented on IGNITE-11434:
------------------------------------------

[~tledkov-gridgain]

Any updates here? Can we move the issue to the next release?

> 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
>             Fix For: 2.8
>
>          Time Spent: 1h 40m
>  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
(v8.3.4#803005)