Comment 1 for bug 656577

Hmm, I would have thought our randgen testing would have caught something
like this :-/
However, thanks for the bug - and letting me know I need to tweak my test :
)

On Thu, Oct 7, 2010 at 6:50 PM, m00dawg <email address hidden> wrote:

> Public bug reported:
>
> Importing a SQL script produced by drizzledump seems to result in an
> error, but not one that is presented to the user:
>
> root@mcp:~# drizzle -p3307 moocowproductions < out.sql
> root@mcp:~# echo $?
> 141
> root@mcp:~#
>
> The import only gets to about 5 of the 20 or so tables. drizzledump,
> however, does exit with a human readable error:
>
> root@mcp:~# drizzledump -p3306 -uroot -Ppwd mcptest
> --destination-type=database --destination-port=3307
> --destination-database=moocowproductions
> -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
> --
> -- Host: localhost Database: mcptest
> -- ------------------------------------------------------
> -- Server version 5.1.41-3ubuntu12.6 (MySQL server)
>
> Error executing query: You have an error in your SQL syntax; check the
> manual that corresponds to your Drizzle server version for the right syntax
> to use near 'farm'),('5','The Bridge','The Bridge was my first back to
> raytracing project. I ' at line 1
> Error executing query: You have an error in your SQL syntax; check the
> manual that corresponds to your Drizzle server version for the right syntax
> to use near '2007-10-26 05:24:19','Paul McCullagh','','
> http://www.blobstreaming.org'),('56','' at line 1
>
> ** Affects: drizzle
> Importance: Undecided
> Status: New
>
> --
> Importing SQL script results in silent failure
> https://bugs.launchpad.net/bugs/656577
> You received this bug notification because you are a member of Drizzle-
> developers, which is subscribed to Drizzle.
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web
> Applications: New
>
> Bug description:
> Importing a SQL script produced by drizzledump seems to result in an error,
> but not one that is presented to the user:
>
> root@mcp:~# drizzle -p3307 moocowproductions < out.sql
> root@mcp:~# echo $?
> 141
> root@mcp:~#
>
> The import only gets to about 5 of the 20 or so tables. drizzledump,
> however, does exit with a human readable error:
>
> root@mcp:~# drizzledump -p3306 -uroot -Ppwd mcptest
> --destination-type=database --destination-port=3307
> --destination-database=moocowproductions
> -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
> --
> -- Host: localhost Database: mcptest
> -- ------------------------------------------------------
> -- Server version 5.1.41-3ubuntu12.6 (MySQL server)
>
> Error executing query: You have an error in your SQL syntax; check the
> manual that corresponds to your Drizzle server version for the right syntax
> to use near 'farm'),('5','The Bridge','The Bridge was my first back to
> raytracing project. I ' at line 1
> Error executing query: You have an error in your SQL syntax; check the
> manual that corresponds to your Drizzle server version for the right syntax
> to use near '2007-10-26 05:24:19','Paul McCullagh','','
> http://www.blobstreaming.org'),('56','' at line 1
>
>
>