Comment 2 for bug 656577

There are some definite issues related to drizzle.cc taking things from
stdin...

On 10/07/2010 04:06 PM, Patrick Crews wrote:
> 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
>>
>>
>>
>