Bug #14631 "#42000Query was empty"

Description:
When i use MySqlCommandBuilder to execute Update Command
if the CommandText String ends with ";" 
I will got a "#42000Query was empty" MySqlException!

How to repeat:
VB.NET Code here:
First! require imports MySql.Data.MySqlClient

Try
   Dim connStr As String = "SERVER=localhost;UID=root;DATABASE=test;PASSWORD=123;PORT=3306;CHARSET=utf8;"
   Dim conn As New MySqlConnection(connStr)
   conn.Open()

   Dim sqlCreate As String = "CREATE TABLE IF NOT EXISTS tt (id INTEGER AUTO_INCREMENT PRIMARY KEY, data VARCHAR(100));"
   Dim cmd As MySqlCommand = New MySqlCommand(sqlCreate, conn)
   cmd.ExecuteNonQuery()

   Dim sql As String = "SELECT * FROM tt;"  '*HERE* if remove ; it'll work fine!
   Dim da As New MySqlDataAdapter(sql, conn)
   Dim builder As New MySqlCommandBuilder(da)
   Dim dt As New DataTable
   da.Fill(dt)

   Dim dr As DataRow = dt.NewRow
   dr(1) = "Test"
   dt.Rows.Add(dr)

   da.Update(dt)

   conn.Close()
Catch ex As Exception
   MsgBox(ex.Message)
End Try

Try this vb.net project to repeat the bug!

Attachment: MySqlBug_Query_was_empty.zip (application/zip, text), 22.07 KiB.

Server is  MySQL 5.0.15-nt via TCP/IP on WinXP SP2

Thanks for the bug report and test case. I was able to reproduce the bug on mysql 4.1.16 and 5.0.15.

Fixed in 1.0.7

Noted in 1.0.7 changelog.