Hello,

After applying the latest EBF of SA12 (12.0.1.4183) the database server started to crash when trying to expand procedure list in Sybase Central. After some investigation I've found an old procedure which is causing the crash. The engine also crashes when trying to re-create that procedure. This is a simplified version of more complex code to reproduce the problem:

create or replace procedure "DBA"."sp_test_db_crash"()
begin
  declare local temporary table #tmp1(p varchar(20) not null) not transactional;
  declare local temporary table #tmp2(p varchar(20) not null) not transactional;
  select p
    from #tmp1
    group by p
    having count(1) > (select count(1) from #tmp2 where (#tmp1.p = #tmp2.p,0));
end

The problem disappears after removing user estimate from HAVING clause.

The bug seems to be quite "fresh" as version 12.0.1.4085 does not crash.

Server OS: Windows.

asked 13 Jan '15, 08:46

Arthoor's gravatar image

Arthoor
1.2k284662
accept rate: 0%

edited 13 Jan '15, 08:48


UPDATE

This problem was introduced at build 12.0.1.4148. This has now been fixed in CR #777478, in 12.0.1.4216 and higher. I have requested for a Windows x86/x64 12.0.1 SP to be built.


Hello, I can also reproduce this issue on later 12.0.1 builds. I have opened CR #777478 internally to address it.

Thank you for the bug report.

permanent link

answered 14 Jan '15, 17:09

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

edited 15 Jan '15, 12:35

Thank you. :)

(16 Jan '15, 02:41) Arthoor
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:

×46
×36
×32
×2

question asked: 13 Jan '15, 08:46

question was seen: 1,146 times

last updated: 16 Jan '15, 02:41