[jira] [Created] (IGNITE-6610) Unexpected error message 'Duplicate column name' in case if query has LIMIT

[Anton Vinogradov (Jira)]

Vladimir Ozerov created IGNITE-6610:
---------------------------------------

             Summary: Unexpected error message 'Duplicate column name' in case if query has LIMIT
                 Key: IGNITE-6610
                 URL: https://issues.apache.org/jira/browse/IGNITE-6610
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.3
            Reporter: Vladimir Ozerov
             Fix For: 2.4


Reported by [~pkonstantinov], Try to execute the following query:
{{SELECT * FROM ( select p.id, d.id from Person p inner join Department d on d.id = p.depid ) LIMIT 50}}
This is valud query, but error message appears:
{{Duplicate column name "ID"; SQL statement: SELECT * FROM ( select p.id, d.id from Person p inner join Department d on d.id = p.depid ) LIMIT 50 [42121-195]}}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)