SAP SQL Anywhere

Question

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

Accepted Answer

2

For 16.0.0.2178, I do not get an error:

alt text

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.

permanent link

answered 01 Dec '15, 05:40

Volker Barth
39.3k●355●539●809
accept rate: 33%

edited 01 Dec '15, 05:44

Volker you nailed it. Thanks

(01 Dec '15, 05:49) Thomas Dueme...

flat view

SAP SQL Anywhere

Plan Viewer fails when List delimiter is a semicolon

Follow this question

Related questions