Hi Quentin,
Can you provide the complete compilable and runnable procedure you are running
that is causing the crash, as I cannot get the snippet you have provide below
to create ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 5 Feb 2014, at 07:45, Quentin <quent...@clearbluewater.com.au> wrote:
> Hi,
>
> Running develop7 with a procedure that attempts to return two result sets.
> Probably not wise but I was experimenting with ways to return metadata about
> a query.
>
> The procedure did something including:
> ==================
> ...other stuff...
> query := 'select ?S ?P ?O {....} limit 10 offset 20';
> exec (query, errorCode, errorMessage, vector(), 0, meta, _dt);
> if (meta <> 0) {
> exec_result_names (meta[0]);
> inx := 0;
> if (_dt <> 0) {
> while (inx < length (_dt))
> {
> exec_result (_dt[inx]);
> inx := inx + 1;
> }
> }
> } else exec_result_names(vector('?NullRecords'));
>
> declare meta, _dt any;
> declare errorCode, errorMessage varchar;
> declare inx integer;
>
> query := 'select count (distinct ?S) as ?count {....}';
> end_result();
> exec (query, errorCode, errorMessage, vector(), 0, meta, _dt);
> exec_result (_dt[0]);
> }
> ==================
>
> I wasn't really expecting it to work but a server crash seems worth reporting.
>
> As an aside, does anyone have any advice on how to return something like a
> count of total rows together in the same query that returns a paginated set
> of rows?
>
> I'm actually paginating the entities themselves and would like to be able to
> report the number of entities in the same procedure so as to avoid
> unnecessary pagination.
> --
> Quentin | Clear Blue Water Pty Ltd
> quent...@clearbluewater.com.au
> ------------------------------------------------------------------------------
> Managing the Performance of Cloud-Based Applications
> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
> Read the Whitepaper.
> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
