[IGNITE-2999] Prepared the invalid SQL query if user inserts it text by double clicking in metadata dialog

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.6
• Assignee: Unassigned
• Reporter: Pavel Konstantinov
• Created: 14/Apr/16 02:39
• Updated: 19/Apr/16 02:12
• Resolved: 15/Apr/16 07:49

Description

I'm created the following query:

select c.ID,c.NAME,c.PARKINGID,p.NAME,p.CAPACITY from "CarCache".Car c inner join "ParkingCache".Parking p on p.id = c.PARKINGID

But when I execute EXPLAIN I got the following error

Error: {"message":"class org.apache.ignite.IgniteException: Failed to parse query: EXPLAIN select c.ID,c.NAME,c.PARKINGID,p.NAME,p. from \"CarCache\".Car c inner join \"ParkingCache\".Parking p on p.id = c.PARKINGID","code":1}

As you can see the query text doesn't contain 'CAPACITY' before 'from'. The word 'CAPACITY' was added by double clicking in metadata dialog.