| Bug #45149 | Calling SP from MSSQL causes syntax error near '{?=call "my_proc;1(?,?)}' | ||
|---|---|---|---|
| Submitted: | 28 May 8:49 | ||
| Reporter: | Bogdan Degtyariov | ||
| Status: | Verified | ||
| Category: | Connector/ODBC | Severity: | S4 (Feature request) |
| Version: | 3.51, 5.0 | OS: | Microsoft Windows |
| Assigned to: | Bogdan Degtyariov | Target Version: | |
| Tags: | MSSQL, linked server, stored procedure | ||
Description: Microsoft SQL Server generates stored procedures calls that cannot be executed in MySQL. The resulting query looks as '{?=call "my_proc;1(?,?)}'. How to repeat: Create a linked MySQL server in MSSQL. Try to call a stored procedure using T-SQL syntax referring the linked server name as follows: exec MYSQL_LINKED...my_proc 1,2 Suggested fix: parse the query and transform {?=call "my_proc;1(?,?)} into call my_proc(?,?)