doctrine / dbal

        $this->assertEquals(0, $row['locate9']);

    }

    public function testQuoteSQLInjection()

    {

        $sql = "SELECT * FROM fetch_table WHERE test_string = " . $this->_conn->quote("bar' OR '1'='1");

        $rows = $this->_conn->fetchAll($sql);

        $this->assertEquals(0, count($rows), "no result should be returned, otherwise SQL injection is possible");

    }

    /**

     * @group DDC-1213

        $this->assertTrue((bool)$this->_conn->fetchColumn($sql, array("text", 1111)));

    }

    public function testExecuteUpdate()

    {

        $sql = "INSERT INTO write_table (test_int) VALUES ( " . $this->_conn->quote(1) . ")";

        $affected = $this->_conn->executeUpdate($sql);

        $this->assertEquals(1, $affected, "executeUpdate() should return the number of affected rows!");

    }

    public function testExecuteUpdateWithTypes()

    {