/**
* @dataProvider dataSelectAlias
*
* @param mixed $select
* @param array $alias
* @param array $expected
*/
public function testSelectAlias($select, $alias, $expected)
{
$this->deleteTestingRows();
$this->createTestingRows();
$this->queryBuilder->selectAlias($select, $alias);
$this->queryBuilder->from('*PREFIX*appconfig')->where($this->queryBuilder->expr()->eq('appid', $this->queryBuilder->expr()->literal('testFirstResult')))->orderBy('configkey', 'ASC')->setMaxResults(1);
$query = $this->queryBuilder->execute();
$row = $query->fetch();
$query->closeCursor();
$this->assertEquals($expected, $row);
$this->deleteTestingRows();
}
