Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-2047 Improvements for Ignite Web Console for next releases
  3. IGNITE-2999

Prepared the invalid SQL query if user inserts it text by double clicking in metadata dialog

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.6
    • Component/s: None
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              pkonstantinov Pavel Konstantinov
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: