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

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 10.2
    • Fix Version/s: 10.2
    • Component/s: Plugins
    • Labels:
      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

              Assignee:
              svoj Sergey Vojtovich
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: