doctrine / dbal

        self::assertEquals(2, $id);

    }

    public function testReuseStatementWithParameterBoundByReference()

    {

        $this->_conn->insert('stmt_test', array('id' => 1));

        $this->_conn->insert('stmt_test', array('id' => 2));

        $stmt = $this->_conn->prepare('SELECT id FROM stmt_test WHERE id = ?');

        $stmt->bindParam(1, $id);

        $id = 1;

        $stmt->execute();

        self::assertEquals(1, $stmt->fetchColumn());

        $id = 2;

        $stmt->execute();

        self::assertEquals(2, $stmt->fetchColumn());

    }

    public function testReuseStatementWithReboundValue()

    {

        self::assertEquals(2, $stmt->fetchColumn());

    }

    public function testReuseStatementWithReboundParam()

    {

        $this->_conn->insert('stmt_test', array('id' => 1));

        $this->_conn->insert('stmt_test', array('id' => 2));

        $stmt = $this->_conn->prepare('SELECT id FROM stmt_test WHERE id = ?');

        $x = 1;

        $stmt->bindParam(1, $x);

        $stmt->execute();

        self::assertEquals(1, $stmt->fetchColumn());

        $y = 2;

        $stmt->bindParam(1, $y);

        $stmt->execute();

        self::assertEquals(2, $stmt->fetchColumn());

    }

    /**

     * @dataProvider emptyFetchProvider