Hi,
maybe there is a problem left ;)
When I'm querying for WordPress posts, I get the following errors on the
following queries. I have just one post in my blog.
Cheers,
Bob
================================================================================================
SPARQL query:
define sql:signal-void-variables 1 PREFIX rdf:
<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX sioc: <http://rdfs.org/sioc/ns#>
PREFIX sioct: <http://rdfs.org/sioc/types#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX dct: <http://purl.org/dc/elements/1.1/>
PREFIX dcc: <http://purl.org/dc/terms/>
SELECT DISTINCT ?post, ?title ?cr ?modified ?url ?has_creator ?content
FROM <http://localhost:8893/wpl_v>
WHERE
{
?forum a sioct:Weblog .
?forum sioc:container_of ?post.
optional{ ?post dct:title ?title }.
optional{ ?post dcc:created ?cr }.
optional{ ?post dcc:modified ?modified }.
optional{ ?post sioc:has_creator ?has_creator}.
optional{ ?post sioc:content ?content }.
optional{ ?post sioc:link ?url }.
}
42000 Error SQ186: Long data types not allowed for distinct, order,
group or join condition columns (t154.option_value)
================================================================================================
SPARQL query:
define sql:signal-void-variables 1 PREFIX rdf:
<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX sioc: <http://rdfs.org/sioc/ns#>
PREFIX sioct: <http://rdfs.org/sioc/types#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX dct: <http://purl.org/dc/elements/1.1/>
PREFIX dcc: <http://purl.org/dc/terms/>
SELECT DISTINCT ?post
FROM <http://localhost:8893/wpl_v>
WHERE
{
?forum a sioct:Weblog .
?forum sioc:container_of ?post.
}
22023 Error SR347: The long varchar, long varbinary and long nvarchar
data types cannot be used in the WHERE, HAVING, or ON clause, except
with the IS NULL predicate for column 'option_value'
