[Mulgara-dev] shouldn't this work? Lucene and Subquery

[Life is hard, and then you die]

On Tue, Jan 20, 2009 at 09:13:36AM -0500, David Smith wrote:
> Saw Ronald's updates yesterday, and decided to try my problem queries
> again.
> Updated to latest sources.
> Still no good.

Sorry, no, the subquery problem hasn't been fixed yet - I found the
other bug while investigating the problem, though.

I'm not sure I'll be able to look at it further in the next couple
weeks, due to other pressing problems I need to fix with lucene and
elsewhere. Sorry about that.


  Cheers,

  Ronald



> -----Original Message-----
> From: David Smith 
> Sent: Friday, December 12, 2008 2:53 PM
> To: 'Mulgara Developers'
> Subject: shouldn't this work? Lucene and Subquery
> 
> Could someone please look at these queries.
> I converted them to use data from the tutorial...  you need to fix line
> 6 (jar path)
> It seems that when I combine a lucene query and other subqueries it
> generate a Transaction error..
> 
> Tested against 2.0.7.
> 
> Thanks
> 
> Dave Smith
> Viewpoint
> ==============
> 
> create <rmi://localhost/server1#sampledata>;
> create <rmi://localhost/server1#sampletext>
> <http://mulgara.org/mulgara#LuceneModel> ;
> 
> #load RSS data into sampledata
> #tutorial step #2
> load <jar:file:/C:/Mulgara/dist/mulgara-2.0.7.jar!/data/w3c-news.rss>
> into <rmi://localhost/server1#sampledata>;
> 
> insert 
> 	select $s $p $o
>   from <rmi://localhost/server1#sampledata>
>   where 
>   	
>   	( 
>   		$p <http://mulgara.org/mulgara#is>
> <http://purl.org/rss/1.0/description> or
>   		$p <http://mulgara.org/mulgara#is>
> <http://purl.org/rss/1.0/title> 
>   	)
>   	and 
> 	  	$s $p $o 
> 	  	
>   into <rmi://localhost/server1#sampletext>
> ;
> 
> # works
> select $s 
> from <rmi://localhost/server1#sampledata>
> where
> 	$s $p $o and
> 	$s $p 'W*' in <rmi://localhost/server1#sampletext>
> ;
> 
> # works
> select $s 
> subquery (
> 	select $y $z
> 	from <rmi://localhost/server1#sampledata>
> 	where
> 		$s $y $z
> )
> from <rmi://localhost/server1#sampledata>
> where
> 	$s $p $o 
> ;
> 
> # fails
> select $s 
> subquery (
> 	select $y $z
> 	from <rmi://localhost/server1#sampledata>
> 	where
> 		$s $y $z
> )
> from <rmi://localhost/server1#sampledata>
> where
> 	$s $p $o and
> 	$s $p 'W*' in <rmi://localhost/server1#sampletext>
> ;
> 
> # fails
> select $s 
> subquery (
> 	select $y $z
> 	from <rmi://localhost/server1#sampledata>
> 	where
> 		$s $y $z
> 		and
> 		$s $y 'W*' in <rmi://localhost/server1#sampletext>
> )
> from <rmi://localhost/server1#sampledata>
> where
> 	$s $p $o 
> ;
> 
> ==================
> 
> java.io.IOException: Error accessing the results of the query:
> Transaction error
> 	at
> org.mulgara.webquery.QueryResponsePage.createResultTable(QueryResponsePa
> ge.java:287)
> 	at
> org.mulgara.webquery.QueryResponsePage.writeAnswerResult(QueryResponsePa
> ge.java:239)
> 	at
> org.mulgara.webquery.QueryResponsePage.writeResult(QueryResponsePage.jav
> a:198)
> 	at
> org.mulgara.webquery.QueryResponsePage.writeResults(QueryResponsePage.ja
> va:159)
> 	at
> org.mulgara.webquery.QueryServlet.doQuery(QueryServlet.java:272)
> 	at
> org.mulgara.webquery.QueryServlet.doPost(QueryServlet.java:190)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> 	at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
> 	at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
> 	at
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> 	at
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
> 	at
> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.jav
> a:114)
> 	at
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> 	at org.mortbay.jetty.Server.handle(Server.java:320)
> 	at
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
> 	at
> org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.j
> ava:843)
> 	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
> 	at
> org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
> 	at
> org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
> 	at
> org.mortbay.jetty.nio.BlockingChannelConnector$Connection.run(BlockingCh
> annelConnector.java:163)
> 	at
> org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java
> :488)
> 
> 
> This E-Mail may contain confidential and privileged information. It is intended solely for the recipient(s) indicated. Any review, use, or distribution by anyone other than the intended recipient(s) is strictly prohibited. If you have received this E-Mail in error or are not the intended recipient, please notify the sender and delete all copies immediately.
> _______________________________________________
> Mulgara-dev mailing list
> Mulgara-dev at mulgara.org
> http://mulgara.org/mailman/listinfo/mulgara-dev