[IGNITE-5054] Support SQL schema sharing between different caches

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1
• Component/s: sql
• Labels: important
• Assignee: Vladimir Ozerov
• Reporter: Vladimir Ozerov
• Created: 21/Apr/17 12:42
• Updated: 08/Jun/17 14:04
• Resolved: 08/Jun/17 14:04

Description

Current every cache "lives" in it's own schema. We need to allow different caches to optionally share the same schema. This is an umbrella ticket for all related activities.

Issue Links

• contains: IGNITE-5287 SQL: CacheConfiguration.sqlEscapeAll must affect only predefined objects
• contains: IGNITE-5304 Decouple DDL from cache name
• contains: IGNITE-5263 ODBC: use schema notion instead of cache name
• contains: IGNITE-5264 DDL operations must operate on per-schema basis
• contains: IGNITE-5281 Change "space" notion to "cacheName"
• contains: IGNITE-5282 Pass "keepBinary" flag to SQL processor from the outside
• contains: IGNITE-5305 DDL: Set schema to cache configuration during CREATE TABLE
• contains: IGNITE-5307 Add "schema" property to SqlFieldsQuery
• contains: IGNITE-5308 .NET: Add "schema" property to SqlFieldsQuery
• contains: IGNITE-5309 CPP: Add "schema" property to SqlFieldsQuery
• contains: IGNITE-5310 DML plan cache should use schema name and statement as a key
• contains: IGNITE-5311 Get cache object value without cache
• contains: IGNITE-5312 H2TwoStepCachedQueryKey: change cache name to schema name
• contains: IGNITE-5313 Get rid of H2Schema.cacheName
• contains: IGNITE-5314 VisorRunningQuery should use schema name instead of cache name
• contains: IGNITE-5315 .NET: Failing query tests due to IGNITE-5287 (sqlEscapeAll)
• contains: IGNITE-5317 Remove strict dependency on concrete cache from SQL execute methods
• contains: IGNITE-5318 Check if cache name should be removed from QueryTypeIdKey and QueryTypeNameKey classes
• contains: IGNITE-5320 Add well-known SQL schema where SQL caches will "live" by default
• contains: IGNITE-5334 Return old schema escape behavior
• contains: IGNITE-5380 Validate cache QueryEntities in discovery thread
• contains: IGNITE-5394 Cache-independent SQL query fails if no tables are present in it
• links to: GitHub Pull Request #1962
• links to: GitHub Pull Request #1979