Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I have a case where a call to

NEW ST_CircularString()
runs indefinitely, and sometimes crashes the database engine. I'm using SQL Anywhere, 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
accept rate: 25%

I can reproduce that with the same build ( - 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 readme, alas, there's currently no newer EBF available for Windows than, 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...
accept rate: 32%

edited 17 May '16, 14:08

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

(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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 11 May '16, 15:42

question was seen: 1,808 times

last updated: 17 May '16, 14:08