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

[Pavel Konstantinov (JIRA)]

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

Pavel Konstantinov closed IGNITE-1979.
--
Assignee: (was: Pavel Konstantinov)

Tested. Closed.

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

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

[Sergi Vladykin (JIRA)]

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

Sergi Vladykin closed IGNITE-1979.
--

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