ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Taras Ledkov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS
Date Thu, 04 Apr 2019 10:18:00 GMT

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

Taras Ledkov commented on IGNITE-11434:
---------------------------------------

[~vozerov], lets discuss more details:
1. I see no difference between two internal info: out CACHE_ID for a table and COLUMN_ID for
a column. Should we add ORDINAL_POSITION instead COLUMN_ID? 
2. Now Ignite supports use default partially value (only for INSERT).
3. Agreed.
4. Ok. This field is strange. H2 uses {{precision}} for CHAR/VARCHAR types and for NUMBERs.
Should we split this info at the COLUMNS view into: {{CHARACTER_LENGTH, NUMBER_PRECISION,
NUMBER_SCALE}} like postgres, mysql, etc?
5. Agreed.
6. Agreed. Should we add additional columns to the view to display wrap/unwrap info?

Should we add add some additional columns to implement  JDBC columns metadata through SELECT
from COLUMNS view?

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

Mime
View raw message