19.09.2013 13:39, Mark Rotteveel wrote: > While working on Jaybird I noticed that the implementation that requests > the execution plan (isc_info_sql_get_plan) skipped the first byte of the > String buffer (and the .net implementation does as well). > > On closer examination it turns out that the plan starts with a linefeed > (0x0A). Why is that?
Every statement may have multiple plans reported (subqueries, etc), they start with its own "PLAN" prefix and they are separated by a new line. The first linefeed may be there just for consistency or perhaps someone didn't care to add an extra check to the code, who knows ;-) Dmitry ------------------------------------------------------------------------------ LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel