Description:
My test script:
---------------
SELECT 1 INTO @aux;
Outcome without any "--*-protocol":
-----------------------------------
SELECT 1 INTO @aux;
Outcome with "--cursor-protocol":
----------------------------------
query 'SELECT 1 INTO @aux' failed:
1323: Cursor SELECT must not have INTO
I assume "--cursor-protocol" converts the select to
something like:
CREATE PROCEDURE .....
BEGIN
DECLARE ... CURSOR FOR SELECT 1 INTO @aux;
....
END |
which of course earns
1323: Cursor SELECT must not have INTO
How to repeat:
See above
Suggested fix:
Please make that mysqltest does not transform
SELECT ... INTO ...
to statement sequencies using cursors.
Just runs SELECTs containing INTO like
other SQL commands (Example: UPDATE ).
I do not see a problem if the fix starts in 5.1
and not with 5.0.
Description: My test script: --------------- SELECT 1 INTO @aux; Outcome without any "--*-protocol": ----------------------------------- SELECT 1 INTO @aux; Outcome with "--cursor-protocol": ---------------------------------- query 'SELECT 1 INTO @aux' failed: 1323: Cursor SELECT must not have INTO I assume "--cursor-protocol" converts the select to something like: CREATE PROCEDURE ..... BEGIN DECLARE ... CURSOR FOR SELECT 1 INTO @aux; .... END | which of course earns 1323: Cursor SELECT must not have INTO How to repeat: See above Suggested fix: Please make that mysqltest does not transform SELECT ... INTO ... to statement sequencies using cursors. Just runs SELECTs containing INTO like other SQL commands (Example: UPDATE ). I do not see a problem if the fix starts in 5.1 and not with 5.0.