Update of /var/cvs/src/org/mmbase/storage/search/implementation/database
In directory james.mmbase.org:/tmp/cvs-serv24317/search/implementation/database
Modified Files:
Tag: MMBase-1_8
BasicSqlHandler.java
Log Message:
if you test only a part of a datefield, the fieldtype should be INTEGER (for
nonth, day, year, etc), instead of DATETIME
See also:
http://cvs.mmbase.org/viewcvs/src/org/mmbase/storage/search/implementation/database
Index: BasicSqlHandler.java
===================================================================
RCS file:
/var/cvs/src/org/mmbase/storage/search/implementation/database/BasicSqlHandler.java,v
retrieving revision 1.62.2.10
retrieving revision 1.62.2.11
diff -u -b -r1.62.2.10 -r1.62.2.11
--- BasicSqlHandler.java 13 Aug 2008 09:01:25 -0000 1.62.2.10
+++ BasicSqlHandler.java 22 Sep 2008 14:05:10 -0000 1.62.2.11
@@ -23,7 +23,7 @@
* Basic implementation.
*
* @author Rob van Maris
- * @version $Id: BasicSqlHandler.java,v 1.62.2.10 2008/08/13 09:01:25 pierre
Exp $
+ * @version $Id: BasicSqlHandler.java,v 1.62.2.11 2008/09/22 14:05:10 pierre
Exp $
* @since MMBase-1.7
*/
@@ -814,6 +814,9 @@
if (fieldConstraint instanceof FieldValueDateConstraint) {
int part =
((FieldValueDateConstraint)fieldConstraint).getPart();
appendDateField(sb, step, fieldName, multipleSteps, part);
+ if (part > -1) {
+ fieldType = Field.TYPE_INTEGER;
+ }
} else if (useLower(fieldCompareConstraint) &&
isRelevantCaseInsensitive(fieldConstraint)) {
// case insensitive and database needs it
appendLowerField(sb, step, fieldName, multipleSteps);
_______________________________________________
Cvs mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/cvs
