[ https://issues.apache.org/jira/browse/IGNITE-10784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16745887#comment-16745887 ]
Vladimir Ozerov commented on IGNITE-10784: ------------------------------------------ [~pkouznet], the only comment to {{GridH2RowDescriptor}} - it is illegal to save key and val field names from {{GridQueryTypeDescriptor}} because it doesn't take in count case. Instead, we should take it from Column with appropriate ID as explained in my previous comment. The rest looks good to me. > SQL: Create a view with list of existing tables > ----------------------------------------------- > > Key: IGNITE-10784 > URL: https://issues.apache.org/jira/browse/IGNITE-10784 > Project: Ignite > Issue Type: Task > Components: sql > Reporter: Vladimir Ozerov > Assignee: Pavel Kuznetsov > Priority: Major > Fix For: 2.8 > > > We need to create a system view of currently available SQL tables. > Minimal required information: > 1) Schema name > 2) Table name > 3) Owning cache name > 4) Owning cache ID > Other info to consider: > 1) Affinity column name > 2) Key/value aliases > 3) Key/value type names > 4) Analyse other vendors (e.g. MySQL, Postgresql) and see if any other useful > information could be exposed (taking in count that a lot of engine properties > are already exposed through {{CACHES}} view) > Starting point: {{SqlSystemView}} -- This message was sent by Atlassian JIRA (v7.6.3#76005)