Pantelis,
It is a left join and the ON doesn't include t1.id, so without GROUP BY, the id
values are repeated. In fact, I get completely different results:
MariaDB [test]> SELECT t1.id, t2.album_id
-> FROM t1
-> LEFT OUTER JOIN t2
-> ON t1.data_id = t2.id
-> AND
i think it's a bug since sergei commented that some test cases don't pass
i don't think it's a bug, since it's well documented that this kind of
column used with group by could not be deterministic
but as a work around try to use MIN() MAX() and check if the query
'become' deterministic and solve
Roberto, Federico,
While I agree with your comments regarding use of ONLY_FULL_GROUP_BY, the
specific case has primary keys defined on (id), on both tables.
So, the GROUP BY t1.id has (or should have) no effect as every group will
have exactly one row and the results should be the deterministic.
Hi!
>From MySQL documentation:
http://dev.mysql.com/doc/refman/5.6/en/group-by-extensions.html
"MySQL extends the use of GROUP BY so that the select list can refer to
nonaggregated columns not named in the GROUP BY clause. (...) However, this is
useful primarily when all values in each nonaggreg
This is actually a bug https://mariadb.atlassian.net/browse/MDEV-5719.
Pavel
On Fri, May 23, 2014 at 11:18 AM, Charles Cazabon
wrote:
> Greetings,
>
> I recently upgraded the db server behind an application from MySQL 5.1.73 (as
> shipped in Ubuntu 10.04 "Lucid") to MariaDB 10.0.11 (from the Mar
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
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 :
> http://dev.mysql.com/doc/refman/5.6/en/group-by-extensions.html
>
> here, but must check if mariadb have so
http://dev.mysql.com/doc/refman/5.6/en/group-by-extensions.html
here, but must check if mariadb have something like it
2014-05-23 15:21 GMT-03:00 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
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 appl
Greetings,
I recently upgraded the db server behind an application from MySQL 5.1.73 (as
shipped in Ubuntu 10.04 "Lucid") to MariaDB 10.0.11 (from the MariaDB repo).
A colleague of mine found an inconsistency between the results produced by the
two servers for a given query. What we don't know i
Interesting. It's straight from the steps at
http://blog.cpanel.net/mysql-mariadb/ which cpanel are currently providing.
First time I have run into the issue on any of my WHM based servers which
is why I am so unsure as to finding the root. May just roll back to mysql
and stay there until I reprovi
that belongs clearly to a cpanel list and honestly
it is a real bad idea to compile around on package
based systems and mix different sources
on a sane server system there should be no devel
package and no compiler installed, that belongs
to a dedicated buildmachine (virtual machine)
which builds
Hmm easyapache wont complete its build now
!! Made a backup '/usr/local/apache/conf/modsec2.conf.cpbackup10' before
updating '/usr/local/apache/conf/modsec2.conf' !!
-- End step 'Updating rule id(s) and directive names in modsec conf
file(s)' --
-- Begin step 'Setting up parser' --
-- End step
no problem
as Fedora sysadmin it's my job to know how to handle yum and
that's the big hammer brings yum to a virgin state and sometimes
helps if it continues to pretend there is no update while
i know for sure there is a recent security update
well, i use it regulary it seems :-)
[root@testserv
Boom, that did it. Thanks a lot mate, you are a star! (my daughter also
says thank you as I can go and play with her once this is finished)
On Fri, May 23, 2014 at 12:56 PM, Reindl Harald wrote:
> rm -rf /var/cache/yum/*
>
> the baseurl http://yum.mariadb.org/5.5/centos6-amd64/rpms/ of the
> rep
rm -rf /var/cache/yum/*
the baseurl http://yum.mariadb.org/5.5/centos6-amd64/rpms/ of the
repo file you posted just don't contain any 10.x package
Am 23.05.2014 12:53, schrieb Dan:
> I ran a yum clean all but still get the same output. I will clean again and
> try
>
>
> On Fri, May 23, 2014 at
I ran a yum clean all but still get the same output. I will clean again and
try
On Fri, May 23, 2014 at 12:42 PM, Reindl Harald wrote:
> i guess you did not do a "yum clean all" after switching
> the repo back to 5.5 and because it has the unversioned
> name "mariadb" the cached metadata are sti
i guess you did not do a "yum clean all" after switching
the repo back to 5.5 and because it has the unversioned
name "mariadb" the cached metadata are still active
Am 23.05.2014 12:30, schrieb Dan:
> Output of repos directory
>
> ###
>
> root@server1 [~]# cd /etc/yum.repos.
Output of repos directory
###
root@server1 [~]# cd /etc/yum.repos.d/
root@server1 [/etc/yum.repos.d]# ls
*.*/ *..*/ CentOS-Base.repo CentOS-Debuginfo.repo CentOS-Media.repo
CentOS-Vault.repo
root@server1 [/etc/yum.repos.d]#
###
###
don't respond off-list!
it would be a good start if you would post your inputs and
outputs so we don't need crystal balls as well as a list
of the repo files in /etc/yum.repos.d/ and their contents
if they have anything related to mysql/mariadb in their name
Am 23.05.2014 12:02, schrieb Dan:
> Th
Hi all.
Can a SPIDER table, on MariaDB 10.0, connect to a remote MySQL 5.5 table? I
can't find this info.
If it can, I have a problem I don't understand. I can create the table, but
when I execute any query I get:
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER
privilege
Am 23.05.2014 10:41, schrieb Dan:
> I installed MariadB 10 but was seeing poor performance and query times, so I
> rolled back to Mysql and saw better
> results. I wanted to rollback to Mariadb 5.5 but when going through the steps
> at http://blog.cpanel.net/mysql-mariadb/ and having the 5.5 repo
Hi,
I installed MariadB 10 but was seeing poor performance and query times, so
I rolled back to Mysql and saw better results. I wanted to rollback to
Mariadb 5.5 but when going through the steps at
http://blog.cpanel.net/mysql-mariadb/ and having the 5.5 repo in my Yum
repos lists, it still tries
23 matches
Mail list logo
