diff options
author | William Desportes <williamdes@wdes.fr> | 2019-12-31 12:29:55 +0100 |
---|---|---|
committer | William Desportes <williamdes@wdes.fr> | 2019-12-31 12:30:59 +0100 |
commit | 1f45fbcc794c7a8e10b78b6d024c1dc48a42eaf9 (patch) | |
tree | 7683586db3b254f1614b368dd4595115a013a515 /tests/Builder/SelectStatementTest.php | |
parent | 9ef51add6d8f732cd52f07874f0b4beb0b9ac068 (diff) | |
parent | 128b21929b6c0d6e669b3cf3afaaa803b3ddbd44 (diff) | |
download | sql-parser-1f45fbcc794c7a8e10b78b6d024c1dc48a42eaf9.zip sql-parser-1f45fbcc794c7a8e10b78b6d024c1dc48a42eaf9.tar.gz sql-parser-1f45fbcc794c7a8e10b78b6d024c1dc48a42eaf9.tar.bz2 |
Merge branch 'QA'
Signed-off-by: William Desportes <williamdes@wdes.fr>
Diffstat (limited to 'tests/Builder/SelectStatementTest.php')
-rw-r--r-- | tests/Builder/SelectStatementTest.php | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/tests/Builder/SelectStatementTest.php b/tests/Builder/SelectStatementTest.php index 5d9836f..2c7350a 100644 --- a/tests/Builder/SelectStatementTest.php +++ b/tests/Builder/SelectStatementTest.php @@ -92,7 +92,7 @@ class SelectStatementTest extends TestCase ); } - public function testBuildGroupBy() + public function testBuilderGroupBy() { $query = 'SELECT COUNT(CustomerID), Country FROM Customers GROUP BY Country'; $parser = new Parser($query); @@ -104,7 +104,7 @@ class SelectStatementTest extends TestCase ); } - public function testBuildIndexHint() + public function testBuilderIndexHint() { $query = 'SELECT * FROM address FORCE INDEX (idx_fk_city_id) IGNORE KEY FOR GROUP BY (a, b,c) WHERE city_id<0'; $parser = new Parser($query); @@ -115,4 +115,16 @@ class SelectStatementTest extends TestCase $stmt->build() ); } + + public function testBuilderSurroundedByParanthesisWithLimit() + { + $query = '(SELECT first_name FROM `actor` LIMIT 1, 2)'; + $parser = new Parser($query); + $stmt = $parser->statements[0]; + + $this->assertEquals( + 'SELECT first_name FROM `actor` LIMIT 1, 2', + $stmt->build() + ); + } } |