with postgres it gave the same error as before.. \nCaused by: org.openrdf.query.QueryEvaluationException: org.postgresql.util.PSQLException: ERROR: each UNION query must have the same number of columns\n P
https://issues.apache.org/jira/browse/MARMOTTA-640 Rob On Fri, 3 Jun 2016 at 23:01 Sergio Fernández <[email protected]> wrote: > Also in PostgreSQL? What was the database you were used with 3.3.0? > Please, file a Jira with the details of the bug. > Thanks, Rob. > > On Fri, Jun 3, 2016 at 2:45 PM, Rob Atkinson <[email protected]> > wrote: > > > still fails , but more explicit debugging in the output: > > > > org.h2.jdbc.JdbcSQLException: Column count does not match; SQL > statement:\n > > > > Caused by: org.h2.jdbc.JdbcSQLException: Column count does not match; SQL > > statement: > > SELECT U1.U1 AS V1, U1.U2 AS V2 > > FROM ((SELECT P1.object AS U1, P2.object AS U2, NULL AS U4, NULL AS U3 > > FROM triples P1 > > LEFT JOIN > > triples P2 ON (P2.deleted = false > > AND P1.object = P2.subject > > AND P2.predicate = 738710905965015040) > > WHERE P1.deleted = false > > AND P1.subject = 738711452851924992 > > AND P1.predicate = 738710906002763776 > > > > ) UNION (SELECT NULL AS U1, NULL AS U2 > > FROM ((SELECT NULL AS U2, P1.object AS U1 > > FROM triples P1 > > WHERE P1.deleted = false > > AND P1.subject = 738711452851924992 > > AND P1.predicate = 738710905965015040 > > > > ) UNION (SELECT P1.object AS U2, NULL AS U1 > > FROM triples P1 > > WHERE P1.deleted = false > > AND P1.subject = 738711452851924992 > > AND P1.predicate = 738711452872896512 > > > > )) AS U1 > > )) AS U1 > > > > On Fri, 3 Jun 2016 at 20:02 Sergio Fernández <[email protected]> wrote: > > > > > On Fri, Jun 3, 2016 at 10:35 AM, Rob Atkinson <[email protected]> > > > wrote: > > > > > > > > i'm very busy the next few weeks - but if you can point me to a > > download > > > > for the 3.4 snapshot I'll give it a go. > > > > > > > > > Just: > > > > > > 1) git clone [email protected]:apache/marmotta.git > > > 2) cd marmotta/launchers/marmotta-webapp > > > 3) mvn tomcat7:run > > > 4) configure postgres as db > > > 5) make your test > > > > > > Thanks! > > > > > > > > > > > > > > > > On Fri, 3 Jun 2016 at 16:52 Sergio Fernández <[email protected]> > > wrote: > > > > > > > > > Maybe it's a bug how our SPARQL engine translate SPARQL into SQL... > > > > > Have you test it against 3.4.0-SNAPSHOT? Please, do it and file a > > jira > > > if > > > > > it also fails. > > > > > > > > > > On Fri, Jun 3, 2016 at 8:07 AM, Rob Atkinson < > [email protected] > > > > > > > > wrote: > > > > > > > > > > > Hi > > > > > > > > > > > > (although I previously created a couple of issues I dont seem to > be > > > > able > > > > > to > > > > > > create one now - no option on dashboard.) > > > > > > > > > > > > > > > > > > Anyway I have a query that is valid and works against Sesame that > > > > > Marmotta > > > > > > 3.3 complains about: > > > > > > > > > > > > PREFIX dcterms: <http://purl.org/dc/terms/> > > > > > > PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> > > > > > > PREFIX void: <http://rdfs.org/ns/void#> > > > > > > PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> > > > > > > PREFIX lid: <http://id.sirf.net/def/schema/lid/> > > > > > > > > > > > > SELECT * > > > > > > WHERE > > > > > > { { { < > > http://resources.opengeospatial.org/def/voc/examples/mdg> > > > > > > rdf:type ?___0 } > > > > > > OPTIONAL > > > > > > { { ?___0 rdfs:label ?___1 } } > > > > > > } > > > > > > UNION > > > > > > { < > http://resources.opengeospatial.org/def/voc/examples/mdg> > > > > > > rdfs:label ?___2 } > > > > > > UNION > > > > > > { < > http://resources.opengeospatial.org/def/voc/examples/mdg> > > > > > > void:sparqlendpoint ?___10 } > > > > > > } > > > > > > > > > > > > If you remove any one of the UNION clauses it works. > > > > > > > > > > > > The error comes from the underlying postGres: > > > > > > org.openrdf.query.QueryEvaluationException: > > > > > > org.postgresql.util.PSQLException: ERROR: each UNION query must > > have > > > > the > > > > > > same number of columns > > > > > > > > > > > > maybe this is an openrdf problem - but it works fine under > Sesame - > > > so > > > > > > maybe its a version thing? > > > > > > > > > > > > Cheers > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Sergio Fernández > > > > > Partner Technology Manager > > > > > Redlink GmbH > > > > > m: +43 6602747925 > > > > > e: [email protected] > > > > > w: http://redlink.co > > > > > > > > > > > > > -- > > > > Sergio Fernández > > > > Partner Technology Manager > > > > Redlink GmbH > > > > m: +43 6602747925 > > > > e: [email protected] > > > > w: http://redlink.co > > > > > > > > > > > > > -- > Sergio Fernández > Partner Technology Manager > Redlink GmbH > m: +43 6602747925 > e: [email protected] > w: http://redlink.co >
