[IGNITE-9771] Indirect SQL queries are failing

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 2.7
• Fix Version/s: 2.8
• Component/s: sql
• Assignee: Unassigned
• Reporter: Sergey Grimstad
• Created: 02/Oct/18 12:03
• Updated: 14/Feb/19 14:35
• Resolved: 14/Feb/19 14:34

Description

Attempt to sql query (not sql fields query ) another cache's type leads to exception:

Caused by: class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to find SQL table for type: ...

IgniteH2Indexing#queryDistributedSql in the beginning of the method logic there is check of schemaName, cacheName and type. First two parameters passed belong to called cache while third belongs to target cache. This combination leads to the exception mentioned.

1. Create tests to reproduce the situation
2. Fix problem
3. Enable commented out tests with 'todo' and this ticket number reference

Issue Links

• is blocked by: IGNITE-6677 Collect QueryDetailMetrics for cache-less SQL queries