Author: pierre
Date: 2009-05-04 14:13:32 +0200 (Mon, 04 May 2009)
New Revision: 34929
Modified:
mmbase/trunk/src/org/mmbase/storage/search/implementation/database/BasicSqlHandler.java
Log:
don't cast value when datepart is specified
Modified:
mmbase/trunk/src/org/mmbase/storage/search/implementation/database/BasicSqlHandler.java
===================================================================
---
mmbase/trunk/src/org/mmbase/storage/search/implementation/database/BasicSqlHandler.java
2009-05-04 12:11:52 UTC (rev 34928)
+++
mmbase/trunk/src/org/mmbase/storage/search/implementation/database/BasicSqlHandler.java
2009-05-04 12:13:32 UTC (rev 34929)
@@ -821,6 +821,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
