[ https://issues.apache.org/jira/browse/IGNITE-7277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vyacheslav Koptilin updated IGNITE-7277: ---------------------------------------- Description: JDBC thin driver duplicates table name in case of using {{CacheConfiguration.setIndexedTypes()}} {code} CacheConfiguration<?, ?> cfg = new CacheConfiguration<>("CACHE_NAME").setSqlSchema("PUBLIC"); cfg.setIndexedTypes(Long.class, Person.class); IgniteCache<?, ?> cachePerson = ignite.getOrCreateCache(cfg); {code} {code:title=sqlline output|borderStyle=solid} +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ | | PUBLIC | PERSON | TABLE | | | PUBLIC | PERSON | TABLE | +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ {code} On the other hand, the following approach to create a table works as expected {code} cache.query(new SqlFieldsQuery( "CREATE TABLE city (id LONG PRIMARY KEY, name VARCHAR) WITH \"template=partitioned\"")); {code} Initial discussion on SO: https://stackoverflow.com/questions/47869429/duplicate-table-show-using-table-in-sqlline-sh was: JDBC thin driver duplicates table name in case of using {{CacheConfiguration.setIndexedTypes()}} {code} CacheConfiguration<?, ?> cfg = new CacheConfiguration<>("CACHE_NAME").setSqlSchema("PUBLIC"); cfg.setIndexedTypes(Long.class, Person.class); IgniteCache<?, ?> cachePerson = ignite.getOrCreateCache(cfg); {code} {code:title=sqlline output|borderStyle=solid} +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ | | PUBLIC | PERSON | TABLE | | | PUBLIC | PERSON | TABLE | +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ {code} On the other hand, the following approach to create a table works as expected {code} cache.query(new SqlFieldsQuery( "CREATE TABLE city (id LONG PRIMARY KEY, name VARCHAR) WITH \"template=partitioned\"")); {code} > JDBC thin driver may list table name twice. > ------------------------------------------- > > Key: IGNITE-7277 > URL: https://issues.apache.org/jira/browse/IGNITE-7277 > Project: Ignite > Issue Type: Bug > Components: jdbc, sql > Affects Versions: 2.3 > Reporter: Vyacheslav Koptilin > Assignee: Taras Ledkov > > JDBC thin driver duplicates table name in case of using > {{CacheConfiguration.setIndexedTypes()}} > {code} > CacheConfiguration<?, ?> cfg = new > CacheConfiguration<>("CACHE_NAME").setSqlSchema("PUBLIC"); > cfg.setIndexedTypes(Long.class, Person.class); > IgniteCache<?, ?> cachePerson = ignite.getOrCreateCache(cfg); > {code} > {code:title=sqlline output|borderStyle=solid} > +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ > | TABLE_CAT | TABLE_SCHEM | > TABLE_NAME | TABLE_TYPE | > +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ > | | PUBLIC | PERSON > | TABLE | > | | PUBLIC | PERSON > | TABLE | > +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ > {code} > On the other hand, the following approach to create a table works as expected > {code} > cache.query(new SqlFieldsQuery( > "CREATE TABLE city (id LONG PRIMARY KEY, name VARCHAR) WITH > \"template=partitioned\"")); > {code} > Initial discussion on SO: > https://stackoverflow.com/questions/47869429/duplicate-table-show-using-table-in-sqlline-sh -- This message was sent by Atlassian JIRA (v6.4.14#64029)