Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.16
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
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.1 [ 16100 ] | |
| Assignee | Olivier Bertrand [ bertrandop ] |
| Fix Version/s | 10.0.18 [ 18702 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v2 [ 59734 ] | MariaDB v3 [ 66215 ] |
| Workflow | MariaDB v3 [ 66215 ] | MariaDB v4 [ 148823 ] |