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.