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

Can't set a numeric session variable using user_session_vars section of config.yaml #8672

Closed
timsehn opened this issue Dec 11, 2024 · 0 comments · Fixed by #8677
Closed

Can't set a numeric session variable using user_session_vars section of config.yaml #8672

timsehn opened this issue Dec 11, 2024 · 0 comments · Fixed by #8677
Assignees
Labels
bug Something isn't working configuration sql server Issues related to the built in SQL server

Comments

@timsehn
Copy link
Contributor

timsehn commented Dec 11, 2024

With the following config .yaml:

user_saession_vars:
- user: "root"
   vars:
     "dolt_show_system_tables": 1  

I get the folloowing error after connecting to root to that server:

ERRO[0023] unable to process ComInitDB: Variable 'dolt_show_system_tables' can't be set to the value of '1'  database=config_blog

Same with autocommit

MySQL [(none)]> select @@autocommit;
ERROR 1105 (HY000): Variable 'autocommit' can't be set to the value of '0'

However, string variables seems fine:

user_session_vars:
- name: "root"
  vars:
    "version": "the best"

And on the client:

MySQL [(none)]> select @@version;
+-----------+
| @@version |
+-----------+
| the best  |
+-----------+
1 row in set (0.001 sec)
@timsehn timsehn added bug Something isn't working sql server Issues related to the built in SQL server configuration labels Dec 11, 2024
@jycor jycor self-assigned this Dec 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working configuration sql server Issues related to the built in SQL server
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants