Re: Why does a group_concat on a join change aggregate values?
On 2015/05/07 19:42, Paul Halliday wrote: Should have showed the whole thing. Take a look here (click image to see full output): http://www.pintumbler.org/tmp I don't see why this worries you. Joining often increases variation. Indeed, if in some case an inner join never did, maybe the joined tables are needlessly separate. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
SUPER privilege required for simple update
hello, I have a replication client where replication stopped because mysql said that the SUPER privilege was required for an update statement. I tried running the same update under a normal user and it also failed saying the SUPER privilege was required. I thought the SUPER privilege was only necessary for admin tasks. Why is it being required for a simple table update statement? Interestingly, I am able to insert a new row into the table; however, i get the same error when i then try to update the new row. I have restarted mysql hoping that might fix the issue, no luck. i've also checked the file permissions on table files on the file system and they are all owned by the same user which is running mysql. I've tried to create another test table and was successful and could also insert and update that table with no issues. I am also able to insert and update other tables but I have not tried them all. I am at a loss. Any and all help appreciated. thanks, -peter
Re: SUPER privilege required for simple update
It's there an update trigger defined on the table? It could be doing something that requires the super privilege. On May 9, 2015 3:12 AM, Peter Abplanalp pabplan...@accucode.com wrote: hello, I have a replication client where replication stopped because mysql said that the SUPER privilege was required for an update statement. I tried running the same update under a normal user and it also failed saying the SUPER privilege was required. I thought the SUPER privilege was only necessary for admin tasks. Why is it being required for a simple table update statement? Interestingly, I am able to insert a new row into the table; however, i get the same error when i then try to update the new row. I have restarted mysql hoping that might fix the issue, no luck. i've also checked the file permissions on table files on the file system and they are all owned by the same user which is running mysql. I've tried to create another test table and was successful and could also insert and update that table with no issues. I am also able to insert and update other tables but I have not tried them all. I am at a loss. Any and all help appreciated. thanks, -peter