[Virtuoso-users] Query not parsed via PHP but works in iSQL

[Norman Heino]

Hi, I got a query that uses bif:contains filter (see below). When I issue it 
via PHP_ODBC using the "sparql" prefix keyword, it cannot be parsed. It works 
however, in iSQL and via PHP_ODBC using "SPARQL_EVAL" function. The issue 
occurs with both, Virtuoso OpenSource 6.1.3 and 6.1.4.

Query:
define output:format "JSON"
SELECT DISTINCT ?resourceUri
FROM <http://lod2.eu/>
FROM <http://lod2.eu/schema/>
WHERE {
    ?listresource ?p0 ?o0 . 
    ?listresource ?resourceUri ?showPropsObj .
    FILTER (bif:contains(?o0, "testimonial*"))
}



The following error is thrown:
SQ200: No column t2.S., SQL state S0022 in SQLExecDirect in 
/Library/WebServer/Sites/odbctest.php on line 15 Call Stack: 0.0002 645256 1. 
{main}() /Library/WebServer/Sites/odbctest.php:0 0.0030 647072 2. odbc_exec() 
/Library/WebServer/Sites/odbctest.php:15



Regards,
Norman