I have a case where a call to

NEW ST_CircularString()
runs indefinitely, and sometimes crashes the database engine. I'm using SQL Anywhere 17.0.0.1358, which AFAIK is the latest version of the Developer Edition available for download.

The problem can be reproduced with:

SELECT NEW ST_CircularString( 'CIRCULARSTRING(-79.397621622463 43.66867,-79.394128 43.6721636224626,-79.390634377537 43.66867,-79.394128 43.6651763775374,-79.397621622463 43.66867)', 1000004326);
A similar statement works:
SELECT NEW ST_CircularString( 'CIRCULARSTRING(-79.363632233035 43.686373,-79.360349 43.689656233035,-79.357065766965 43.686373,-79.360349 43.683089766965,-79.363632233035 43.686373)', 1000004326);

Sometimes when I run the query, SQL Central crashes. In one such case I submitted the Error Report, which was assigned the IDs: 2449151 2449152.

Anyone else seen this?

asked 11 May '16, 15:42

Terry%20Wilkinson's gravatar image

Terry Wilkinson
496162136
accept rate: 40%

I can reproduce that with the same build (17.0.0.1358) - the first statement seems to increase the cache size incrementally until one stops the engine... - This might be fixed in newer versions (cf. CR 794347 in the 17.0.0.1441 readme, alas, there's currently no newer EBF available for Windows than 17.0.0.1359, so I cannot check that...

(12 May '16, 03:59) Volker Barth
Replies hidden

The bug referenced in CR 794347 refers to round-earth geometries and SRID 1000004326, used in the failing query above, is planar. That said, it may still be related.

(12 May '16, 10:04) Terry Wilkinson

It does not look like this is related to CR 794347. {that fix when tested does not prevent this} I can also reproduce this in 16 and it may be long standing edge case ... just exposed by your test.

It does seem to have something to do with precision. If I adjust the first and last points to be (-79.363632 43.686373) this behavior goes away. Given the nature of the projection involved the precision part may not be unexpected but some govenor should have kicked in eventually.

I will be submitting this shortly

permanent link

answered 12 May '16, 15:14

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.2k33106
accept rate: 32%

edited 17 May '16, 14:08

Thanks Terry and Nick for reporting this. CR 798668 will be fixed in 12.0.1.4416, 16.0.0.2290, and 17.0.0.1493.

(17 May '16, 11:59) Phil Mitchell
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:

×80
×21
×10

question asked: 11 May '16, 15:42

question was seen: 248 times

last updated: 17 May '16, 14:08