You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ershov (JIRA)" <ji...@apache.org> on 2015/12/17 16:46:46 UTC

[jira] [Issue Comment Deleted] (IGNITE-1979) Support case insensitive nonquoted cache names in SQL queries

     [ https://issues.apache.org/jira/browse/IGNITE-1979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vladimir Ershov updated IGNITE-1979:
------------------------------------
    Comment: was deleted

(was: On the review. )

> Support case insensitive nonquoted cache names in SQL queries
> -------------------------------------------------------------
>
>                 Key: IGNITE-1979
>                 URL: https://issues.apache.org/jira/browse/IGNITE-1979
>             Project: Ignite
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: ignite-1.4
>            Reporter: Denis Magda
>            Assignee: Vladimir Ershov
>            Priority: Critical
>             Fix For: 1.6
>
>
> According to SQL ANSI-99 standard the schema name (corresponds to a cache name in Ignite) is case insensitive.
> However Ignite has the requirement to put a cache name into the quotation marks. This violates the standard.
> The main reasons of that is because a cache name in Ignite is case sensitive and can contain all kind of symbols that are not supported by underlying H2 engine.
> Proposed to introduce a new configuration property to {{CacheConfiguration}} that will let the end user use a cache name in case insensitive manner without quoted identifiers in SQL queries.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)