Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update to php-agent 10.11.0.3 overrides mysql_mode variable #689

Open
TheoSl93 opened this issue Jul 3, 2023 · 0 comments
Open

Update to php-agent 10.11.0.3 overrides mysql_mode variable #689

TheoSl93 opened this issue Jul 3, 2023 · 0 comments
Labels
bug Something isn't working

Comments

@TheoSl93
Copy link

TheoSl93 commented Jul 3, 2023

Description

After updating to agent 10.11.0.3 some queries stopped working because the global variables were overridden. I have defined in my config that ONLY_FULL_GROUP_BY shouldn't be as variable, but the queries are executed with it, what leads to mysql fail. The workaround I found was disabling the explain flag

Steps to Reproduce

Find a way to show your sql variables in PHP, running the query SELECT @@sql_mode;, those won't be the ones you configured as global variables. Once you disable the explain flag, the real variables will be shown.

Expected Behavior

The variables set to be in the global scope have to stay the same whether the explain flag is on or off on version 10.11.0.3

@TheoSl93 TheoSl93 added the bug Something isn't working label Jul 3, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant