Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and
privacy statement. We’ll occasionally send you account related emails.
Already on GitHub?
to your account
Submitted by: @pavel-zotov
Is related to QA588
SQL> with recursive r as(select 0 i,count(*)over() c from rdb$database union all select r.i+1,sum(i)over() from r where r.i<10) select * from r;
-> Record Buffer
-> Table "R RDB$DATABASE" Full Scan
Statement failed, SQLSTATE = 08006
Error reading data from the connection.
Coredump see in attach.
with recursive r as(select 0 i, count(*) c from rdb$database union all select r.i + 1, sum(i) from r where r.i < 10) select * from r;
Commits: d7550f6 9350f94 FirebirdSQL/fbt-repository@b540d6a FirebirdSQL/fbt-repository@41e5847
The text was updated successfully, but these errors were encountered:
Attachment: gdb-firebird.140121_234028.1.zip [ 12413 ]
Sorry, something went wrong.
assignee: Adriano dos Santos Fernandes [ asfernandes ]
Commented by: @asfernandes
Version: 3.0 Alpha 1 [ 10331 ]
Version: 2.5.2 Update 1 [ 10521 ]
Version: 2.5.2 [ 10450 ]
Version: 3.0 Alpha 2 [ 10560 ]
summary: Engine crashes when use SUM()OVER() in recursive query => Engine crashes when use aggregate or window functions in recursive query
Another related problem: aggregate functions usage are not verified correctly.
-- Compiles, but should give an error.
with recursive r as(select 0 i,count(*) c from rdb$database union all select r.i + 1, 0 from r where sum(r.i) = 0) select * from r;
I'm fixing this only in 3.0 for now. Will see about backport after fix review.
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
Fix Version: 3.0 Beta 1 [ 10332 ]
Link: This issue is related to QA588 [ QA588 ]
status: Resolved [ 5 ] => Resolved [ 5 ]
QA Status: Done successfully
Commented by: @pcisar
status: Resolved [ 5 ] => Closed [ 6 ]
No branches or pull requests