ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-7277) JDBC thin driver may list table name twice.
Date Wed, 10 Jan 2018 12:58:00 GMT

    [ 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)

Mime
View raw message