public function testSubQueryWithSelectColumns() { $subCriteria = new BookQuery(); $c = new TestableBookQuery(); $c->addSelectQuery($subCriteria, 'alias1', false); $c->select(array('alias1.Id')); $c->configureSelectColumns(); $sql = "SELECT alias1.ID AS \"alias1.Id\" FROM (SELECT book.ID, book.TITLE, book.ISBN, book.PRICE, book.PUBLISHER_ID, book.AUTHOR_ID FROM `book`) AS alias1"; $params = array(); $this->assertCriteriaTranslation($c, $sql, $params, 'addSelectQuery() forges a unique alias and adds select columns by default'); }
public function testSubQueryWithSelectColumns() { $subCriteria = new BookQuery(); $c = new TestableBookQuery(); $c->addSelectQuery($subCriteria, 'alias1', false); $c->select(array('alias1.Id')); $c->configureSelectColumns(); $sql = "SELECT alias1.id AS `alias1.Id` FROM (SELECT book.id, book.title, book.isbn, book.price, book.publisher_id, book.author_id FROM `book`) AS alias1"; $params = array(); $this->assertCriteriaTranslation($c, $sql, $params, 'addSelectQuery() forges a unique alias and adds select columns by default'); }