Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30166

[ERROR] unknown variable 'sql_select_limit'

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • 10.4, 10.5, 10.6
    • None
    • None

    Description

      The variable sql_select_limit cannot be set as Global via config file.
      Customer reports that attempt to set sql_select_limit=N in any section of .cnf other than [client] fails with the error
      ...
      [ERROR] /usr/sbin/mysqld: unknown variable 'sql_select_limit=10'
      ...
      If the variable placed in .cnf [client] section, its local. It still can be set as global via client as

      MariaDB [(none)]> set global sql_select_limit=100;
      Query OK, 0 rows affected (0.000 sec)

      but the customer feels that the behavior is an omission, since it contradicts with Doc
      https://mariadb.com/kb/en/server-system-variables/#sql_select_limit
      and would like the fix.

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            YK Yakov Kushnirsky
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.