public function testSelectIndexHintByTableNameRef() { $args = new ArgumentArray(); $driver = new MySQLDriver(); $query = new SelectQuery(); $query->select(array('u.id', 'u.name', 'u.phone', 'u.address'))->from('users', 'u'); $query->indexHint('users')->useIndex('users_idx')->forOrderBy(); $query->indexHint('users')->ignoreIndex('name_idx')->forGroupBy(); $query->indexHint('users')->forceIndex('foo_idx')->forJoin(); $sql = $query->toSql($driver, $args); $this->assertEquals('SELECT u.id, u.name, u.phone, u.address FROM users AS u USE INDEX FOR ORDER BY (users_idx) IGNORE INDEX FOR GROUP BY (name_idx) FORCE INDEX FOR JOIN (foo_idx)', $sql); }