You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/12/11 17:00:12 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=15052931#comment-15052931 ]
ASF GitHub Bot commented on IGNITE-1979:
----------------------------------------
GitHub user VladimirErshov opened a pull request:
https://github.com/apache/ignite/pull/324
IGNITE-1979 Support case insensitive nonquoted cache names in SQL
IGNITE-1979 Support case insensitive nonquoted cache names in SQL
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/VladimirErshov/ignite ignite-1.5
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/ignite/pull/324.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #324
----
commit b5abda5c73b169e7cbd749d3a2128d24d865bea4
Author: vershov <ve...@gridgain.com>
Date: 2015-12-11T15:53:43Z
IGNITE-1979 Support case insensitive nonquoted cache names in SQL queries - implementation.
----
> 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.5
>
>
> 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)