sqlSchema usability question

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

sqlSchema usability question

Pavel Konstantinov
Folks,

I'm testing https://issues.apache.org/jira/browse/IGNITE-1979 and have the
following questions:

1) why I'm cannot use cache name in queries if I set sqlSchema for cache?

2) why we cannot just use cache name as sqlSchema if sqlSchema is not set
explicitly (sqlSchema is null) and cache name is valid to use as schema
name?

--
Pavel Konstantinov
Reply | Threaded
Open this post in threaded view
|

Re: sqlSchema usability question

Sergi
1. You are actually never use cache name in SQL, you are always use schema
name. In case when sqlSchema property is not set it is just derived from
cache name.
2. Exactly this happens right now. Property sqlSchema is optional. If you
are asking why is it always quoted and case sensitive, that is for
historical reasons and can't be changed without breaking compatibility.

Sergi

2015-12-23 6:17 GMT+03:00 Pavel Konstantinov <[hidden email]>:

> Folks,
>
> I'm testing https://issues.apache.org/jira/browse/IGNITE-1979 and have the
> following questions:
>
> 1) why I'm cannot use cache name in queries if I set sqlSchema for cache?
>
> 2) why we cannot just use cache name as sqlSchema if sqlSchema is not set
> explicitly (sqlSchema is null) and cache name is valid to use as schema
> name?
>
> --
> Pavel Konstantinov
>