empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From franci...@apache.org
Subject svn commit: r1199675 - /incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java
Date Wed, 09 Nov 2011 09:38:55 GMT
Author: francisdb
Date: Wed Nov  9 09:38:54 2011
New Revision: 1199675

URL: http://svn.apache.org/viewvc?rev=1199675&view=rev
Log:
EMPIREDB-121 SQL for MS SQL created by Empire-DB uses lcase(), but MS SQL Server doesn't know
lcase() but lower()

Modified:
    incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java

Modified: incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java
URL: http://svn.apache.org/viewvc/incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java?rev=1199675&r1=1199674&r2=1199675&view=diff
==============================================================================
--- incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java
(original)
+++ incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java
Wed Nov  9 09:38:54 2011
@@ -270,7 +270,7 @@ public class DBDatabaseDriverMSSQL exten
             case SQL_FUNC_STRINDEXFROM:       return "charindex({0}, ?, {1})"; 
             case SQL_FUNC_LENGTH:             return "len(?)";
             case SQL_FUNC_UPPER:              return "upper(?)";
-            case SQL_FUNC_LOWER:              return "lcase(?)";
+            case SQL_FUNC_LOWER:              return "lower(?)";
             case SQL_FUNC_TRIM:               return "trim(?)";
             case SQL_FUNC_LTRIM:              return "ltrim(?)";
             case SQL_FUNC_RTRIM:              return "rtrim(?)";



Mime
View raw message