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

type error when setting session variable

    XMLWordPrintable

    Details

    • Sprint:
      10.1.13

      Description

      The following query fails:

      • SET SESSION wait_timeout = GREATEST(28000, @@wait_timeout)

      Error:
      #1232 - Incorrect argument type to variable 'wait_timeout`

      There should be no type conversion issue as those queries work:

      • SET SESSION wait_timeout = 28000;
      • SET SESSION wait_timeout = @@wait_timeout;
      • SELECT GREATEST(28000, @@wait_timeout);

      please see this SO question for detail:
      http://stackoverflow.com/questions/35187378/mariadb-type-error-when-setting-session-variable

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            mvo Moritz Vondano
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration