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)

Reply via email to