[
https://issues.apache.org/jira/browse/IGNITE-7277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16320190#comment-16320190
]
ASF GitHub Bot commented on IGNITE-7277:
----------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/ignite/pull/3341
> 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
> Fix For: 2.4
>
>
> 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)
