Mailing-List: contact dev-help@metamodel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@metamodel.apache.org
Date: Wed, 9 Mar 2016 10:29:40 +0000 (UTC)
From: "Alessandro Portosa (JIRA)" <jira@apache.org>
To: dev@metamodel.apache.org
Message-ID: <JIRA.12948367.1457519352000.44761.1457519380727@Atlassian.JIRA>
In-Reply-To: <JIRA.12948367.1457519352000@Atlassian.JIRA>
References: <JIRA.12948367.1457519352000@Atlassian.JIRA>
 <JIRA.12948367.1457519352484@arcas>
Subject: [jira] [Created] (METAMODEL-238) Error when using GROUPBY and
 ORBERBY with different fields
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Alessandro Portosa created METAMODEL-238:
--------------------------------------------

             Summary: Error when using GROUPBY and ORBERBY with different fields
                 Key: METAMODEL-238
                 URL: https://issues.apache.org/jira/browse/METAMODEL-238
             Project: Apache MetaModel
          Issue Type: Bug
    Affects Versions: 4.5.1
            Reporter: Alessandro Portosa


MetaModel does not act as expected when providing it a different field for GROUPING and ORDERING.

Let's say the we have a table with the following columns: total_children, city, country.

1) If i use "SELECT SUM(total_children) AS total_children_SUM, city AS city FROM schema.table GROUP BY city" I get the right results.
2) If i use "SELECT SUM(total_children) AS total_children_SUM , city AS
city FROM schema.table GROUP BY city ORDER BY city asc" then I get the right
results.
3) But if I use "SELECT SUM(total_children) AS total_children_SUM, city AS city FROM schema.table GROUP BY city ORDER BY country asc" I get the wrong results.

I do get results, but these are the same as 1) where no ordering was
required. The same happen with I use any other field that is not city
(which is the field that I'm using for the grouping).

This is how I use it:

   Query query = dataContext.parseQuery(sqlQuery);
   CompiledQuery cQuery = dataContext.compileQuery(query);
   DataSet dataSet = dataContext.executeQuery(cQuery);

The used DataContext is a PojoDataContext.

No error or exception. Just wrong data.


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)