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 for Me (Login required).

Search for additional results

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