doctrine / dbal

    /**

     * @group DDC-2843

     */

    public function testBooleanDefault()

    {

        $table = new \Doctrine\DBAL\Schema\Table('ddc2843_bools');

        $table->addColumn('id', 'integer');

        $table->addColumn('checked', 'boolean', array('default' => false));

        $this->_sm->createTable($table);

        $databaseTable = $this->_sm->listTableDetails($table->getName());

        $c = new \Doctrine\DBAL\Schema\Comparator();

        $diff = $c->diffTable($table, $databaseTable);

        $this->assertFalse($diff);

    }

    public function testListTableWithBinary()

    {

        }

    }

    public function testSearchPathSchemaChanges()

    {

        $table = new Table("dbal510tbl");

        $table->addColumn('id', 'integer');

        $table->setPrimaryKey(array('id'));

        $this->_conn->getSchemaManager()->createTable($table);

        $onlineTable = $this->_conn->getSchemaManager()->listTableDetails('dbal510tbl');

        $comparator = new Comparator();

        $diff = $comparator->diffTable($onlineTable, $table);

        $this->assertFalse($diff);

    }

}

        $this->assertFalse($onlineTable->getColumn('def_blob_null')->getNotnull());

    }

    public function testEscapedDefaultValueMustBePreserved()

    {

        $value = "a\\0a\\'a\"a\na\ra\ta\\Za\\\\a";

        $table = new Table('string_escaped_default_value');

        $table->addColumn('def_string', 'string', array('default' => $value));

        $this->_sm->dropAndCreateTable($table);

        $onlineTable = $this->_sm->listTableDetails('string_escaped_default_value');

        $this->assertSame($value, $onlineTable->getColumn('def_string')->getDefault());

        $comparator = new Comparator();

        $this->assertFalse($comparator->diffTable($table, $onlineTable));

    }

    public function testColumnCollation()

    {