User estimate in HAVING clause - SA12 server crashes

[former_SQLA_member1694875]

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.

[jeff_albion · Accepted solution]

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.

[former_SQLA_member1694875 · Accepted solution]

Thank you. 🙂