diff options
| author | Deven Bansod <devenbansod.bits@gmail.com> | 2019-12-29 19:33:09 -0500 |
|---|---|---|
| committer | Deven Bansod <devenbansod.bits@gmail.com> | 2019-12-29 19:42:57 -0500 |
| commit | 48233536e320c1874c547bf820017b9a5e0f164c (patch) | |
| tree | f23cec084e2624a35e81aa487cedeba978bf2b4f /tests/Builder/CreateStatementTest.php | |
| parent | 2c8e384a349595ad13790ca3a5357f24af916345 (diff) | |
| download | sql-parser-48233536e320c1874c547bf820017b9a5e0f164c.zip sql-parser-48233536e320c1874c547bf820017b9a5e0f164c.tar.gz sql-parser-48233536e320c1874c547bf820017b9a5e0f164c.tar.bz2 | |
fix #231: allow SCHEMA to be used in CREATE Database statement
Diffstat (limited to 'tests/Builder/CreateStatementTest.php')
| -rw-r--r-- | tests/Builder/CreateStatementTest.php | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/tests/Builder/CreateStatementTest.php b/tests/Builder/CreateStatementTest.php index 19989cb..87c5a9b 100644 --- a/tests/Builder/CreateStatementTest.php +++ b/tests/Builder/CreateStatementTest.php @@ -27,6 +27,7 @@ class CreateStatementTest extends TestCase public function testBuilderDatabase() { + // CREATE DATABASE ... $parser = new Parser( 'CREATE DATABASE `mydb` ' . 'DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_general_ci' @@ -38,6 +39,20 @@ class CreateStatementTest extends TestCase 'DEFAULT CHARACTER SET=utf8 DEFAULT COLLATE=utf8_general_ci', $stmt->build() ); + + + // CREATE SCHEMA ... + $parser = new Parser( + 'CREATE SCHEMA `mydb` ' . + 'DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_general_ci' + ); + $stmt = $parser->statements[0]; + + $this->assertEquals( + 'CREATE SCHEMA `mydb` ' . + 'DEFAULT CHARACTER SET=utf8 DEFAULT COLLATE=utf8_general_ci', + $stmt->build() + ); } public function testBuilderDefaultInt() |