\CouchbaseN1qlQuery::fromString returns NULL

davidbcn · April 25, 2017, 3:39pm

This was working in 2.2.x

$query = \CouchbaseN1qlQuery::fromString("SELECT * FROM system:indexes WHERE name='{$name}' AND keyspace_id='{$this->name}'", NULL, FALSE);

It is now returning NULL in 2.3.x. Seems like old extension implementation was taking additional arguments, this change should be described in a changelog or something… removing NULL and FALSE from parameter list fixes it, but still the behaviour (returning null) is really strange…

avsej · April 26, 2017, 5:18am

Do you see any errors or warnings?

I wonder where did you find this version of call with 3 arguments. The latest only requires one (the string containing query)

http://docs.couchbase.com/sdk-api/couchbase-php-client-2.3.1/classes/Couchbase.N1qlQuery.html#method_fromString

Release 2.2.4 also has 1-argument version:

github.com

couchbase/php-couchbase/blob/v2.2.4/php/src/CouchbaseN1qlQuery.class.php#L27




const NOT_BOUNDED = 1;
const REQUEST_PLUS = 2;
const STATEMENT_PLUS = 3;


/**
 * Creates a new N1qlQuery instance directly from a N1QL DML.
 * @param $str
 * @return CouchbaseN1qlQuery
 */
static public function fromString($str) {
    $res = new CouchbaseN1qlQuery();
    $res->options['statement'] = $str;
    $res->adhoc = true;
    return $res;
}


/**
 * Supply positional parameters for query.
 *
 * <code>

And 2.2.0 too

github.com

couchbase/php-couchbase/blob/v2.2.0/stub/CouchbaseN1qlQuery.class.php#L27




const NOT_BOUNDED = 1;
const REQUEST_PLUS = 2;
const STATEMENT_PLUS = 3;


/**
 * Creates a new N1qlQuery instance directly from a N1QL DML.
 * @param $str
 * @return CouchbaseN1qlQuery
 */
static public function fromString($str) {
    $res = new CouchbaseN1qlQuery();
    $res->options['statement'] = $str;
    $res->adhoc = true;
    return $res;
}


/**
 * Supply positional parameters for query.
 *
 * <code>

Topic		Replies	Views
PHP N1QL query returns NULL PHP SDK	4	2893	February 27, 2015
Connection to Couchbase Server N1QL query returns NULL SQL++	2	2450	January 26, 2015
Query view returns null if key contains + (PHP SDK 2.0.4 and 2.0.5) PHP SDK	2	2306	March 18, 2015
N1ql Query Named Params are not being applied on PHP SDK? PHP SDK query , n1ql	1	1814	September 12, 2016
Return String from Query with CouchbaseTemplate.findByN1QLProjection Java SDK	1	1573	September 19, 2019

\CouchbaseN1qlQuery::fromString returns NULL

Related topics