/** * @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(); }