Update of /var/cvs/tests/dbsq/org/mmbase/storage/search/implementation/database
In directory james.mmbase.org:/tmp/cvs-serv4603/database
Modified Files:
MySqlSqlHandlerTest.java
Log Message:
test-cases for MMB-1358
See also:
http://cvs.mmbase.org/viewcvs/tests/dbsq/org/mmbase/storage/search/implementation/database
See also: http://www.mmbase.org/jira/browse/MMB-1358
Index: MySqlSqlHandlerTest.java
===================================================================
RCS file:
/var/cvs/tests/dbsq/org/mmbase/storage/search/implementation/database/MySqlSqlHandlerTest.java,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -b -r1.6 -r1.7
--- MySqlSqlHandlerTest.java 21 Jun 2007 15:50:25 -0000 1.6
+++ MySqlSqlHandlerTest.java 8 Nov 2008 11:17:15 -0000 1.7
@@ -12,7 +12,7 @@
* JUnit tests.
*
* @author Rob van Maris
- * @version $Revision: 1.6 $
+ * @version $Revision: 1.7 $
*/
public class MySqlSqlHandlerTest extends TestCase {
@@ -120,6 +120,28 @@
instance.toSql(query, instance).equalsIgnoreCase("SELECT number FROM "
+ prefix + "images IMAGES WHERE number IS NULL LIMIT 50," + Integer.MAX_VALUE));
}
+
+ public void testToSqlString() {
+
+ assertEquals("abc", instance.toSqlString("abc"));
+ assertEquals("a''bc", instance.toSqlString("a'bc"));
+ assertEquals("a''''bc", instance.toSqlString("a''bc"));
+ assertEquals("a\\\\bc", instance.toSqlString("a\\bc"));
+ assertEquals("a\\\\''bc", instance.toSqlString("a\\'bc"));
+ assertEquals("a\\tbc", instance.toSqlString("a\tbc"));
+ assertEquals("a\\0bc", instance.toSqlString("a\0bc"));
+ assertEquals("a\\\\0bc", instance.toSqlString("a\\0bc"));
+
+
+ assertEquals("a%bc", instance.toSqlString("a%bc"));
+ assertEquals("a_bc", instance.toSqlString("a_bc"));
+
+ // Should it be possible to escape % and _ ?
+ // These two cases could apply (now failing)
+ //assertEquals("a\\%bc", instance.toSqlString("a\\%bc"));
+ //assertEquals("a\\_bc", instance.toSqlString("a\\_bc"));
+ }
+
public static Test suite() {
TestSuite suite = new TestSuite(MySqlSqlHandlerTest.class);
_______________________________________________
Cvs mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/cvs
