Hi,
ignore my prev post - i do one error there
this is my first pull request and i do not know how do it right
I have finished work on explained plan in xml format
I have worked on FB3RC1 svn repository (revision 62517)
here is link to patch generated from svn
if there is better place to upload it then inform me
http://www.filedropper.com/fb_3
Current explained plan looks like:
Select Expression
-> Singularity Check
-> First N Records
-> Skip N Records
-> Sort (record length: 40, key length: 8)
-> Window
-> Record Buffer (record length: 33)
-> Filter
-> Aggregate
-> Sort (record length: 44, key length: 8)
-> Full Outer Join
-> Nested Loop Join (outer)
-> Table "RDB$DATABASE" as "R2"
Full Scan
-> Filter
-> Table "RDB$DATABASE" as
"R" Full Scan
-> Nested Loop Join (anti)
-> Table "RDB$DATABASE" as "R"
Full Scan
-> Filter
-> Table "RDB$DATABASE" as
"R2" Full Scan
and i add possibility to generate xml form
<?xml version="1.0"?>
<Select_Expression>
<Node Operation="Singularity Check">
<Node Operation="First N Records">
<Node Operation="Skip N Records">
<Node Operation="Sort" record_length="44" key_length="8">
<Node Operation="Window">
<Node Operation="Record Buffer" record_length="33">
<Node Operation="Filter">
<Node Operation="Aggregate">
<Node Operation="Sort" record_length="52"
key_length="8">
<Node Operation="Full Outer Join">
<Node Operation="Nested Loop Join
(outer)">
<Table
alias="R2">RDB$DATABASE</Table>
<Node Operation="Full Scan">
</Node>
<Node Operation="Filter">
<Table
alias="R">RDB$DATABASE</Table>
<Node Operation="Full
Scan">
</Node>
</Node>
</Node>
<Node Operation="Nested Loop Join
(anti)">
<Table
alias="R">RDB$DATABASE</Table>
<Node Operation="Full Scan">
</Node>
<Node Operation="Filter">
<Table
alias="R2">RDB$DATABASE</Table>
<Node Operation="Full
Scan">
</Node>
</Node>
</Node>
</Node>
</Node>
</Node>
</Node>
</Node>
</Node>
</Node>
</Node>
</Node>
</Node>
</Select_Expression>
in pull request to simple review i have set xml form of explained plan as
default
Any comments about patch?
regards,
Karol Bieniaszewski
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
