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

CONNECT doesn't work with SET @var

        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)

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                bertrandop Olivier Bertrand added a comment -

                SQLCOM_SET_OPTION added to accepted commands.

                Show
                bertrandop Olivier Bertrand added a comment - SQLCOM_SET_OPTION added to accepted commands.

                  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:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 1 hour
                      1h