[ https://issues.apache.org/jira/browse/IGNITE-10784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743015#comment-16743015 ]
Pavel Kuznetsov commented on IGNITE-10784: ------------------------------------------ About p.1 : In short, I've removed locking. Revisited the code. - Added locking inside getTables() is not correct, because this method is used by H2, which might have already locked the table. - Locking while reading Table#columns was required (select to a View doesn't lock all the tables). BUT, Iteration over columns is removed, and in the view we read only final or effectively final fields. > 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)