Re: [Maria-discuss] query result inconsistency between MariaDB 10.0.x and Oracle MySQL 5.1.x

2014-05-23 Thread Roberto Spadim
maybe you should use something like MIN() MAX(), since you are using a GROUP BY i don't know if this is well documented but i think it's 2014-05-23 15:18 GMT-03:00 Charles Cazabon charlesc-web-register-launchpad@pyropus.ca: Greetings, I recently upgraded the db server behind an

Re: [Maria-discuss] query result inconsistency between MariaDB 10.0.x and Oracle MySQL 5.1.x

2014-05-23 Thread Roberto Spadim
orry many mails The server is free to choose any value from each group, so unless they are the same, the values chosen are indeterminate. 2014-05-23 15:32 GMT-03:00 Roberto Spadim robe...@spadim.com.br: http://dev.mysql.com/doc/refman/5.6/en/group-by-extensions.html here, but must check

Re: [Maria-discuss] query result inconsistency between MariaDB 10.0.x and Oracle MySQL 5.1.x

2014-05-23 Thread Roberto Spadim
from mariadb https://mariadb.com/kb/en/select/ You can use any of the grouping functions in your select expression. Their values will be calculated based on all the rows that have been grouped together for each result row. *If you select a non-grouped column or a value computed from a non-grouped

Re: [Maria-discuss] query result inconsistency between MariaDB 10.0.x and Oracle MySQL 5.1.x

2014-05-23 Thread Pavel Ivanov
This is actually a bug https://mariadb.atlassian.net/browse/MDEV-5719. Pavel On Fri, May 23, 2014 at 11:18 AM, Charles Cazabon charlesc-web-register-launchpad@pyropus.ca wrote: Greetings, I recently upgraded the db server behind an application from MySQL 5.1.73 (as shipped in Ubuntu

Re: [Maria-discuss] query result inconsistency between MariaDB 10.0.x and Oracle MySQL 5.1.x

2014-05-23 Thread Pantelis Theodosiou
El vie, 23/5/14, Charles Cazabon charlesc-web-register-launchpad@pyropus.ca escribió: Asunto: [Maria-discuss] query result inconsistency between MariaDB 10.0.x and Oracle MySQL 5.1.x Para: MariaDB discuss maria-discuss@lists.launchpad.net Fecha: viernes, 23 de