EMPIREDB-184
diff --git a/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java b/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java
index 994c67b..b758b74 100644
--- a/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java
+++ b/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java
@@ -722,8 +722,10 @@
@Override
protected void appendSQLTextValue(StringBuilder buf, String value)
{
+ boolean escape = false;
if (value.indexOf('\'') >= 0)
{ // a routine to double up single quotes for SQL
+ escape = true;
int len = value.length();
for (int i = 0; i < len; i++)
{
@@ -735,6 +737,7 @@
}
if (value.indexOf('\\') >= 0)
{ // a routine to double up backslashes for MySQL
+ escape = true;
int len = value.length();
for (int i = 0; i < len; i++)
{
@@ -744,8 +747,7 @@
buf.append(value.charAt(i));
}
}
- else
- {
+ if (!escape) {
buf.append(value);
}
}