My model to sphinx does not work due to Pdo/Mysql prepending the table name before each column in the SELECT statement. For example this query:
select id from index;
select `index`.`id` from `index`;
And sphinx search engine is not compatible with this syntax:
error=sphinxql: syntax error, unexpected '.', expecting FROM or ',' near '.`id` AS `id` FROM `index`'
It appears that \Phalcon\Db\Adapter\Pdo\Mysql does not apply PDO::ATTR_FETCH_TABLE_NAMES when set like this:
return new \Phalcon\Db\Adapter\Pdo\Mysql(array( "host" => "192.168.2.2", "port" => "9306", "options" => [\PDO::ATTR_FETCH_TABLE_NAMES => 0] // tried false here too, doesn't seem to be taken in account at all ));
How can I solve this?