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

VARIABLE_NAME and VARIABLE_VALUE in INFORMATION_SCHEMA.USER_VARIABLES are too short

    XMLWordPrintable

Details

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

    Description

      Create Table: CREATE TEMPORARY TABLE `user_variables` (
        `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
        `VARIABLE_VALUE` varchar(2048) DEFAULT NULL,
        `VARIABLE_TYPE` varchar(64) NOT NULL DEFAULT '',
        `CHARACTER_SET_NAME` varchar(32) DEFAULT NULL
      ) ENGINE=MEMORY DEFAULT CHARSET=utf8
      

      VARIABLE_NAME and VARIABLE_VALUE lengths are the same as in the tables for system variables. But unlike system variables, where we control the actual length for both, user variables don't seem to have any limit on the length of their names and values (as long as those are within max_allowed_packet). So, it's theoretically possible to have a variable with a longer name or, probably more likely, with a longer value, which will be truncated in the I_S table.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.