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

["Pavel Konstantinov (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pavel Konstantinov closed IGNITE-2999.
--------------------------------------
    Assignee:     (was: Pavel Konstantinov)

Tested.

> Prepared the invalid SQL query if user inserts it text by double clicking in metadata dialog
> --------------------------------------------------------------------------------------------
>
>                 Key: IGNITE-2999
>                 URL: https://issues.apache.org/jira/browse/IGNITE-2999
>             Project: Ignite
>          Issue Type: Sub-task
>            Reporter: Pavel Konstantinov
>             Fix For: 1.6
>
>
> I'm created the following query:
> {code}
> 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
> {code}
> But when I execute EXPLAIN I got the following error
> {code}
> 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}
> {code}
> As you can see the query text doesn't contain 'CAPACITY' before 'from'. The word 'CAPACITY' was added by double clicking in metadata dialog.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)