ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-6610) Unexpected error message 'Duplicate column name' in case if query has LIMIT
Date Thu, 12 Oct 2017 11:57:00 GMT
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)

Mime
View raw message