[
https://issues.apache.org/jira/browse/IGNITE-11434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16785638#comment-16785638
]
Taras Ledkov edited comment on IGNITE-11434 at 3/6/19 1:40 PM:
---------------------------------------------------------------
[~vozerov], [~jooger] I'm OK with the field
{{PRIMARY_KEY: boolean}}
What do you think about display any information about exists index(es) for a
column?
Field: {{INDEXED: boolean}} - *true* when the column is used at an index (or
used as the first column at an index)?
I guess we have to add filed
{{SQL_TYPE : short}} to simplify the JDBC columns metadata generation and use
this view to generate JDBC metadata,.
was (Author: tledkov-gridgain):
[~vozerov], [~jooger] I'm OK with the field
{{PRIMARY_KEY: boolean}}
What do you think about display any information about exists index(es) for a
column?
Field: {{INDEXED: boolean}} - *true* when the column is used at an index (or
used as the first column at an index)?
I guess we have to add filed
{{SQL_TYPE : short }} to simplify the JDBC columns metadata generation and use
this view to generate JDBC metadata,.
> 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: 10m
> 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]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
