Hi Alessandro, This does sound like a bug ... Best thing to do is probably that we register it in JIRA, preferably followed also by a unittest that reproduces the issue.
2016-03-03 18:02 GMT+01:00 Alessandro Portosa <[email protected]>: > Hi meta-folks, > I'm having a problem when trying to supply some SQL query to MetaModel > (4.5.1). > > 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.tableGROUP 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 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: > > /String newSqlQuery = > Query query = dataContext.parseQuery(newSqlQuery);// > //CompiledQuery cQuery = dataContext.compileQuery(query);// > //DataSet dataSet = dataContext.executeQuery(cQuery);/ > > No error or exception. Just wrong data. > > Any ideas? > > Many thanks! > Alessandro. >
