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
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.
SAP Knowledge Base Article - Preview