diff options
author | Michal Čihař <michal@cihar.com> | 2017-06-01 15:01:06 +0200 |
---|---|---|
committer | Michal Čihař <michal@cihar.com> | 2017-06-01 15:01:06 +0200 |
commit | 4af06d24b041e499fb0e75ab3a98caf9a91700ef (patch) | |
tree | 452f3b5da98de5108a90757a699993488566b1e0 /tests | |
parent | f18666a810fd84bf5a00145e6b39453a1987e835 (diff) | |
download | sql-parser-4af06d24b041e499fb0e75ab3a98caf9a91700ef.zip sql-parser-4af06d24b041e499fb0e75ab3a98caf9a91700ef.tar.gz sql-parser-4af06d24b041e499fb0e75ab3a98caf9a91700ef.tar.bz2 |
Remove not used type arg from GROUP BY
It should not be there since beginning.
Issue #154
Signed-off-by: Michal Čihař <michal@cihar.com>
Diffstat (limited to 'tests')
-rw-r--r-- | tests/Builder/SelectStatementTest.php | 2 | ||||
-rw-r--r-- | tests/Components/GroupKeywordTest.php | 6 |
2 files changed, 4 insertions, 4 deletions
diff --git a/tests/Builder/SelectStatementTest.php b/tests/Builder/SelectStatementTest.php index a1d9e55..f9db69e 100644 --- a/tests/Builder/SelectStatementTest.php +++ b/tests/Builder/SelectStatementTest.php @@ -46,7 +46,7 @@ class SelectStatementTest extends TestCase $this->assertEquals( 'SELECT sgu.id, sgu.email_address FROM `sf_guard_user` AS `sgu` ' . 'RIGHT JOIN `student_course_booking` AS `scb` ON sgu.id = scb.user_id ' - . 'WHERE `has_found_course` = \'1\' GROUP BY sgu.id ASC ' + . 'WHERE `has_found_course` = \'1\' GROUP BY sgu.id ' . 'ORDER BY scb.id DESC LIMIT 0, 300 ', $stmt->build() ); diff --git a/tests/Components/GroupKeywordTest.php b/tests/Components/GroupKeywordTest.php index 515de6b..8d4a407 100644 --- a/tests/Components/GroupKeywordTest.php +++ b/tests/Components/GroupKeywordTest.php @@ -13,12 +13,12 @@ class GroupKeywordTest extends TestCase $this->assertEquals( GroupKeyword::build( array( - new GroupKeyword(new Expression('a'), 'ASC'), - new GroupKeyword(new Expression('b'), 'DESC'), + new GroupKeyword(new Expression('a')), + new GroupKeyword(new Expression('b')), new GroupKeyword(new Expression('c')), ) ), - 'a ASC, b DESC, c' + 'a, b, c' ); } } |