Driver Mysqli execute multi_query

[robotccm]

Original report by Pascal Roux (Bitbucket: pizzavomito, GitHub: pizzavomito).

---

Hi,

Could you add the multi_query on the mysqli driver ?

It's very useful for faceted search in Sphinx : http://sphinxsearch.com/blog/2014/05/22/the-facet-feature/

Or just for multi queries:

#!sql
SELECT SQL_CALC_FOUND_ROWS * FROM users LIMIT 0,10;
SELECT FOUND_ROWS();

Thx

[robotccm]

Original comment by Sylvain Robez-Masson (Bitbucket: srobez-masson, ).

---

Multi query isn't supported by postgresql driver :(

[robotccm]

Original comment by Pascal Roux (Bitbucket: pizzavomito, GitHub: pizzavomito).

---

Yes, postgresql does not support multi queries.
But it would be possible to implement it in the Mysqli driver and throw an error in the Pgsql driver, no ?

#!php

// Pqsql/Driver.php

public function executeMultiQuery(...){
    throw new RuntimeException('Pqsql driver does not support multi query');
}