Details

      Description

      CONNECT won't select into a variable with SET.

      MariaDB [tmp]> SET @foo = (SELECT MIN(col1) FROM long_column_test);
      ERROR 1148 (42000): CONNECT Unsupported command

      However, a workaround currently exists:

      MariaDB [tmp]> SELECT MIN(col1) INTO @foo FROM long_column_test;
      Query OK, 1 row affected (1.30 sec)
       
      MariaDB [tmp]> SELECT @foo;
      +------+
      | @foo |
      +------+
      | a    |
      +------+
      1 row in set (0.00 sec)

        Attachments

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              GeoffMontee Geoff Montee
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: