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));
}
