[jira] [Created] (IGNITE-7879) SQL query with group by and distinct in subquery produces JdbcSQLException

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

Pavel Vinokurov created IGNITE-7879:
---------------------------------------

             Summary: SQL query with group by and distinct in subquery produces JdbcSQLException
                 Key: IGNITE-7879
                 URL: https://issues.apache.org/jira/browse/IGNITE-7879
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.3, 2.1
            Reporter: Pavel Vinokurov


SQL initial script:

CREATE TABLE Person(id INTEGER PRIMARY KEY, company_id INTEGER);
CREATE TABLE Company(id INTEGER PRIMARY KEY, name VARCHAR);
INSERT INTO Person(id,company_id) VALUES (1, 1), (2, 2), (3, 3);
INSERT INTO Company(id,name) VALUES (1,'n1'), (2,'n2'), (3,'n3');

SQL query:

SELECT p.id,sum(p.id) FROM person p
LEFT JOIN (select DISTINCT id from company) as c on c.id=p.company_id
group by p.id

Result:

Caused by: org.h2.jdbc.JdbcSQLException: Column "P__Z0.ID" must be in the GROUP BY list; SQL statement:
SELECT
P__Z0.ID __C0_0,
P__Z0.COMPANY_ID __C0_1,
SUM(P__Z0.ID) __C0_2
FROM PUBLIC.PERSON P__Z0 [90016-195]

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)