[
http://jira.codehaus.org/browse/MSQL-18?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=136694#action_136694
]
Michael McCarthy commented on MSQL-18:
--------------------------------------
Hi Benoit - block mode is described on this page -
http://mojo.codehaus.org/sql-maven-plugin/execute-mojo.html#enableBlockMode.
It's a really useful page that is slightly hidden in the documentation. I think
I'm having the same problem, but the way it manifests itself on DB2 seems to be
different. I might try and submit a patch if I can.
> Error running queries containing new lines in text fields
> ---------------------------------------------------------
>
> Key: MSQL-18
> URL: http://jira.codehaus.org/browse/MSQL-18
> Project: Maven 2.x SQL Plugin
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: mysql> select version();
> +------------+
> | version() |
> +------------+
> | 5.0.37-log |
> +------------+
> $ mvn --version
> Maven version: 2.0.9
> Java version: 1.5.0_13
> OS name: "linux" version: "2.6.22-14-generic" arch: "i386" Family: "unix"
> Reporter: Benoit Heinrich
> Priority: Blocker
>
> If you try to run a SQL script with an insert command containing a newline
> inside a varchar or text value then the new line is dropped and replaced by a
> space.
> ------------------------------------------------------------------------------------
> create table test (
> ID int(11) unsigned not null,
> mytext text null,
> primary key (ID)
> );
> insert into test (mytext) values ('this is a
> text going at the
> line');
> ------------------------------------------------------------------------------------
> then if you do
> ------------------------------------------------------------------------------------
> mysql> select * from test;
> +----+-----------------------------------+
> | ID | mytext |
> +----+-----------------------------------+
> | 0 | this is a text going at the line |
> +----+-----------------------------------+
> 1 row in set (0.00 sec)
> ------------------------------------------------------------------------------------
> This is currently a blocker for or project since we can't import some basic
> data containing text fields with new lines.
> Thanks,
> /Benoit
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
