[MDEV-7616] CONNECT doesn't work with SET @var Created: 2015-02-20  Updated: 2015-02-24  Resolved: 2015-02-23

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.0.16
Fix Version/s: 10.0.18

Type: Bug Priority: Minor
Reporter: Geoff Montee (Inactive) Assignee: Olivier Bertrand
Resolution: Fixed Votes: 0
Labels: connect-engine


 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)



 Comments   
Comment by Olivier Bertrand [ 2015-02-23 ]

SQLCOM_SET_OPTION added to accepted commands.

Generated at Thu Feb 08 07:20:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.