summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--tests/Builder/SelectStatementTest.php23
1 files changed, 23 insertions, 0 deletions
diff --git a/tests/Builder/SelectStatementTest.php b/tests/Builder/SelectStatementTest.php
index 6f09888..a2dd5af 100644
--- a/tests/Builder/SelectStatementTest.php
+++ b/tests/Builder/SelectStatementTest.php
@@ -53,4 +53,27 @@ class SelectStatementTest extends TestCase
$stmt->build()
);
}
+
+ public function testBuilderEndOptions()
+ {
+ /* Assertion 1 */
+ $query = 'SELECT pid, name2 FROM tablename WHERE pid = 20 FOR UPDATE ';
+ $parser = new Parser($query);
+ $stmt = $parser->statements[0];
+
+ $this->assertEquals(
+ $query,
+ $stmt->build()
+ );
+
+ /* Assertion 2 */
+ $query = 'SELECT pid, name2 FROM tablename WHERE pid = 20 LOCK IN SHARE MODE ';
+ $parser = new Parser($query);
+ $stmt = $parser->statements[0];
+
+ $this->assertEquals(
+ $query,
+ $stmt->build()
+ );
+ }
}