\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>