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
