public function testQuotedTableNames() { $table = new Table('"test"'); $table->addColumn('"id"', 'integer', array('autoincrement' => true)); // assert tabel $this->assertTrue($table->isQuoted()); $this->assertEquals('test', $table->getName()); $this->assertEquals('"test"', $table->getQuotedName($this->_platform)); $sql = $this->_platform->getCreateTableSQL($table); $this->assertEquals('CREATE TABLE "test" ("id" NUMBER(10) NOT NULL)', $sql[0]); $this->assertEquals('CREATE SEQUENCE "test_SEQ" START WITH 1 MINVALUE 1 INCREMENT BY 1', $sql[2]); $createTriggerStatement = <<<EOD CREATE TRIGGER "test_AI_PK" BEFORE INSERT ON "test" FOR EACH ROW DECLARE last_Sequence NUMBER; last_InsertID NUMBER; BEGIN SELECT "test_SEQ".NEXTVAL INTO :NEW."id" FROM DUAL; IF (:NEW."id" IS NULL OR :NEW."id" = 0) THEN SELECT "test_SEQ".NEXTVAL INTO :NEW."id" FROM DUAL; ELSE SELECT NVL(Last_Number, 0) INTO last_Sequence FROM User_Sequences WHERE Sequence_Name = 'test_SEQ'; SELECT :NEW."id" INTO last_InsertID FROM DUAL; WHILE (last_InsertID > last_Sequence) LOOP SELECT "test_SEQ".NEXTVAL INTO last_Sequence FROM DUAL; END LOOP; END IF; END; EOD; $this->assertEquals($createTriggerStatement, $sql[3]); }