metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alessandro Portosa (JIRA)" <j...@apache.org>
Subject [jira] [Created] (METAMODEL-238) Error when using GROUPBY and ORBERBY with different fields
Date Wed, 09 Mar 2016 10:29:40 GMT
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)

Mime
View raw message