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?