Plan Viewer fails when List delimiter is a semicolon

[thomas_duemesnil]

Just stumbled upon this glitch.

select list(City, ',') from Contacts;

and

select list(City, ';') from Contacts;

both work in iSql. But the Plan Viewer returns

[Sybase][ODBC Driver][SQL Anywhere]Syntax error near '(end of line)' on line 1

for the second Query. I use Version SA 16.0.0 Build 2003

Is this fixed in a more recent Version ?

Thomas

[VolkerBarth · Accepted solution]

For 16.0.0.2178, I do not get an error:

And that seems according to the following fix:

     ================(Build #2094  - Engineering Case #780471)================

    The Plan Viewer would have failed to get the plan for a statement if the 
    statement contained a literal string which contained a semicolon. This has 
    been fixed.

[thomas_duemesnil · Accepted solution]

Volker you nailed it. Thanks