SAP Knowledge Base Article - Preview

2055293 - Assertion Failed after using WITH in derived table – SAP IQ

Symptom

When you run a query that uses WITH expression in derived table, you will get error "Assertion failed":

% cat test.sql
select * from (with s1 as (select count(a) as s1a,a from w1 group by a), s2 as (select sum(b) as s2b, b from w2 group by b)
select s1.*, s2.*
from s1 inner join s2 on s1.a=s2.b) as aa;

% dbisql -c "uid=dba;pwd=sql;eng=iqdemo" -nogui test.sql
Could not execute statement.
  Run time SQL error -- *** ERROR *** Assertion failed: 107400
  (15.4.1.3019)[iqdemo]
  Internal parse tree error
  SQLCODE=-300, ODBC 3 State="HY000"
  File: "test.sql" on line 1, column 1
  select * from (with s1 as (select count(a) as s1a,a from w1 group by a),
  s2 as (select sum(b) as s2b, b from w2 group by b)
  select s1.*, s2.*
  ...
  You can continue executing or stop.
1. Stop
2. Continue


Read more...

Environment

SAP IQ 15.4 ESD#2 or earlier

Product

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

internal parse tree error, CR 684998, 684998 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.