SAP SQL Anywhere

Question

I know why this happens but in my opinion I think even a silly action should not kill the server instance.

BEGIN
    DECLARE NewArray INTEGER ARRAY(5);
    message NewArray type info to client;
END;

I was playing with a JASON array and thought the message command could do something like NewArray.toSting(). A Message "Array" would also be fine. But the server process should not die !

I use 16.0.0.2003 as the server engine.

Only to let you know.

Accepted Answer

3

We would agree. No client action should not be able to crash the server. That's why we fixed this in later SPs/EBFs than the one you are using.

SQLA Bug Fix ( CR#771618 ) "Server crash when using ARRAY or ROW type values in MESSAGE statement"

Fixed in 16.0.0 builds >= 2020

permanent link

answered 28 Jan '16, 11:59

Nick Elson S...
7.3k●35●107
accept rate: 32%

1

No client action should not be able to crash the server.

Nitpicking: This sounds like "We're not happy until you're not happy.":)

(28 Jan '16, 16:03) Volker Barth

Replies hidden

Correct! Extra (double negative) 'not's noted to be in error ...

(28 Jan '16, 17:22) Nick Elson S...

flat view

Answer 2

0

Hi Thomas,

Thanks for the report.

This is a bug and should be resolved in a later version of SQL Anywhere.

Versions 16.0.0.2020 and later along with all releases of 17 have this issue fixed.

Thanks, Mikel

permanent link

answered 28 Jan '16, 11:58

Mikel Rychliski
2.1k●16●41
accept rate: 32%

flat view

Answer 3

0

I've tried this will the latest version of 16 and I get the error:

Cannot convert varray to a long varchar

and the server keeps running. ~~I'm not sure which bug fix resolved this issue..~~ See Nick's answer for the fix. You can find the full list of fixes here .

I'd suggest that you upgrade to a newer version.

HTH

permanent link

answered 28 Jan '16, 12:03

Mark Culp
24.9k●10●139●297
accept rate: 41%

edited 28 Jan '16, 12:06

flat view

SAP SQL Anywhere

My Server dies if I do silly things

Follow this question

Related questions