Is the PHP driver not capable of executing simple compound statements (separated by semicolon)? I can do this in the console:
"SELECT x FROM b; SELECT y FROM b"
When executed in the console, the results are grouped using some special keys:
"_sequence_num": 1,
"_sequence_query": "SELECT x FROM b",
"_sequence_query_status": "success",
"_sequence_result": [
etc...
But if I put the same SQL into the PHP driver and try to execute via N1QlQuery::fromString()
, the driver throws an exception with syntax error - despite the syntax being valid.
How can I execute a simple compound query in PHP?