Bug #50344 MySqlScript.Execute() throws InvalidOperationException

Description:
Hello,
Please take a look at the test case in the How to repeat section. Maybe I am doing something wrong?

Also, why there is no documentation for MySqlScript class?

How to repeat:
public void MySqlScriptTest_50344()
{
	MySqlConnection conn = CreateAndOpenConnection();
	StringBuilder sb = new StringBuilder();
	sb.AppendLine("DROP FUNCTION IF EXISTS `BlaBla`;");
	sb.AppendLine("DELIMITER ;;");
	MySqlScript script = new MySqlScript(conn, sb.ToString());
	script.Execute(); // InvalidOperationException : The CommandText property has not been properly initialized.
}

Hi Pavel and thanks for new report.

Don't know what's wrong on a first look but there is a broad discussion regarding this in Bug#46429. See if it helps.

Hi Tonci, I read discussion in the Bug#46429, but I don't know if our bugs are related or not. Also exception are different, so maybe the reasons are different. I would debug the problem using the sources, but unfortunately I don't have much time now :(

PS. Do you have a public repository open for read? If no, then where can I get latest (not yet generally available) builds?

Pavel, you can find everything on launchpad, https://launchpad.net/connectornet and https://code.launchpad.net/~mysql-clr-team/connectornet/trunk. Trunk always holds latest development code.

The bug can be reproduced with the latest sources (revision 821).
Also "Debug.Assert((buffer.Position + numbytes) < buffer.Length)" in MySqlPacket.ReadLong() fails and later an exception described above is thrown.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/97941

788 Reggie Burnett	2010-01-22
      - fixed bug where a scipt that had an empty last line would cause an InvalidOperationException (bug #50344)

Fixed in 6.0.6, 6.1.4, and 6.2.3

Are you going to create any documentation for MySqlScript class? I think you could at least start with a simple 1-page article in Connector documentation.

There is some documentation on MySqlScript in the reference manual included with the connector. However, we do some some documentation added to the main online docs too. I have created a new docs bug for this Bug #50586.

An entry has been added to the 6.0.6, 6.1.4, and 6.2.3 changelogs:

When the MySqlScript.execute() method was called, the following exception was generated:

InvalidOperationException : The CommandText property has not been properly initialized.

Thanks for fixing the bug. The tests now passes.