[
http://jira.codehaus.org/browse/MSQL-18?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dan Tran closed MSQL-18.
------------------------
Assignee: Dan Tran
Resolution: Won't Fix
Fix Version/s: 1.1
please reopen if the proposed solution does not work out
> 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
> Assignee: Dan Tran
> Priority: Blocker
> Fix For: 1.1
>
>
> 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
