Re: [Virtuoso-users] Virtuoso S0022 Error SQ200: No column errors with MINUS

2012-10-03 Thread David Brooks
On 4/10/12 11:19 AM, Kingsley Idehen wrote: On 10/3/12 5:53 PM, David Brooks wrote: After a bit more investigation: 1) The problem lies somewhere in the SPARQL to SQL translation. Using ISQL and with example URIs (that don't exist): SQL> sparql select ?g where { graph

Re: [Virtuoso-users] Virtuoso S0022 Error SQ200: No column errors with MINUS

2012-10-03 Thread Kingsley Idehen
On 10/3/12 5:53 PM, David Brooks wrote: After a bit more investigation: 1) The problem lies somewhere in the SPARQL to SQL translation. Using ISQL and with example URIs (that don't exist): SQL> sparql select ?g where { graph { ?g a ?t MINUS { ?g1

Re: [Virtuoso-users] Virtuoso S0022 Error SQ200: No column errors with MINUS

2012-10-03 Thread David Brooks
Hmm, after loading a fresh instance of 64-bit Virtuoso under Snow Leopard with data everything works... Why? What could have caused the original problem? I have a copy of the original databases if someone wants to give me pointers. Thanks, Dave On 4/10/12 10:53 AM, David Brooks wrote: After

Re: [Virtuoso-users] Virtuoso S0022 Error SQ200: No column errors with MINUS

2012-10-03 Thread David Brooks
After a bit more investigation: 1) The problem lies somewhere in the SPARQL to SQL translation. Using ISQL and with example URIs (that don't exist): SQL> sparql select ?g where { graph { ?g a ?t MINUS { ?g1 ?g } } graph ?g { ?s ?p ?o }

[Virtuoso-users] Virtuoso S0022 Error SQ200: No column errors with MINUS

2012-10-03 Thread David Brooks
Hi, I'm getting errors from Virtuoso, with both 6.1.6 and develop/6 from git. Queries such as: PREFIX prv: PREFIX bsml: select * where { { graph