You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Jira Link: DB-13433
Running Voyager to migrate a set of stored procedures from MySQL (MariaDB 10.5) and identified a syntax issue where some nested blocks case assignments with set not be translated.
Original:
...
IF Auth <> "" THEN
set Auth=concat(Intro,URL,Header,Username,Slash,Header,
Password, Slash, Header, ContentType, Slash,
Data, char(34),DataRaw, char(34),Slash);
END IF;
...
Results:
...
IF Auth <> '' THEN
set Auth=concat(Intro,URL,Header,Username,Slash,Header,
Password, Slash, Header, ContentType, Slash,
Data, array_to_string(ARRAY(SELECT chr(unnest(34))),''),DataRaw, array_to_string(ARRAY(SELECT chr(unnest(34))),''),Slash);
END IF;
...
Something is causing the assignment (:=) from being applied and the set is retained causing a syntax error. I.e. ```
AuthJson := concat(...
Also the translation of char(34) to array_to_string(ARRAY(SELECT chr(unnest(34))),'') seems particularly verbose.
The text was updated successfully, but these errors were encountered:
Jira Link: DB-13433
Running Voyager to migrate a set of stored procedures from MySQL (MariaDB 10.5) and identified a syntax issue where some nested blocks case assignments with
set
not be translated.Original:
Results:
Something is causing the assignment (
:=
) from being applied and theset
is retained causing a syntax error. I.e. ```Also the translation of
char(34)
toarray_to_string(ARRAY(SELECT chr(unnest(34))),'')
seems particularly verbose.The text was updated successfully, but these errors were encountered: