Hi Patrick, thanks for your reply. I am using Mac OS X 10.7.2 (Darwin macbook-pro.local 11.2.0 Darwin Kernel Version 11.2.0: Tue Aug 9 20:54:00 PDT 2011; root:xnu-1699.24.8~1/RELEASE_X86_64 x86_64) with stock PHP 5.3.6 built against iODBC. I have attached the odbc trace log. The query in question seems to start at line 26287.
Regards, Norman Am Donnerstag, 3. November 2011 um 17:39 schrieb Patrick van Kleef: > HI Norman, > > > 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 > > > > Which version of PHP and ODBC driver manager are you using and what OS > are you using, so i can setup a similar testbed here and try to figure > out what is going on. > > Also can you put the following into your odbc.ini or odbcinst.ini file > (latter when using unixodbc) to get a trace on the ODBC level: > > [ODBC] > Trace=1 > Tracefile=/tmp/odbc-trace.log > > and retry the failing test, so i can see what commands are exactly > passed to the driver. > > Patrick > -- > OpenLink
odbc-trace.log.tar.gz
Description: Binary data
