public function testGeneratesSequenceSqlCommands() { $sequence = new Sequence('myseq', 20, 1); $this->assertEquals('CREATE SEQUENCE myseq INCREMENT BY 20 START WITH 1 MINVALUE 1', $this->_platform->getCreateSequenceSQL($sequence)); $this->assertEquals('ALTER SEQUENCE myseq INCREMENT BY 20', $this->_platform->getAlterSequenceSQL($sequence)); $this->assertEquals('DROP SEQUENCE myseq', $this->_platform->getDropSequenceSQL('myseq')); $this->assertEquals('DROP SEQUENCE myseq', $this->_platform->getDropSequenceSQL($sequence)); $this->assertEquals("SELECT myseq.NEXTVAL", $this->_platform->getSequenceNextValSQL('myseq')); $this->assertEquals('SELECT sequence_name, increment_by, start_with, min_value FROM SYS.SYSSEQUENCE', $this->_platform->getListSequencesSQL(null)); }