liviuslivius <liviusliv...@poczta.onet.pl> wrote Sun, 08 Nov 2015 18:05:34 +0300:
> 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 Why XML? JSON representation is more compact. -- Regards, Simonov Denis ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
