summaryrefslogtreecommitdiffstats
path: root/tests/Builder/SelectStatementTest.php
diff options
context:
space:
mode:
authorWilliam Desportes <williamdes@wdes.fr>2019-12-31 12:29:55 +0100
committerWilliam Desportes <williamdes@wdes.fr>2019-12-31 12:30:59 +0100
commit1f45fbcc794c7a8e10b78b6d024c1dc48a42eaf9 (patch)
tree7683586db3b254f1614b368dd4595115a013a515 /tests/Builder/SelectStatementTest.php
parent9ef51add6d8f732cd52f07874f0b4beb0b9ac068 (diff)
parent128b21929b6c0d6e669b3cf3afaaa803b3ddbd44 (diff)
downloadsql-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.php16
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()
+ );
+ }
}