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.

asked 28 Jan '16, 11:54

Thomas%20Duemesnil's gravatar image

Thomas Dueme...
2.5k243560
accept rate: 15%


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%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 31%

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...

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%20Rychliski's gravatar image

Mikel Rychliski
2.1k1641
accept rate: 30%

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%20Culp's gravatar image

Mark Culp
23.0k9130270
accept rate: 40%

edited 28 Jan '16, 12:06

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×201
×102
×34

question asked: 28 Jan '16, 11:54

question was seen: 340 times

last updated: 28 Jan '16, 17:22