If there is a data type mismatch while querying for data, the ZC compiler isn't reporting any errors but the fetch itself fails. This makes it very hard to debug.
Example:
Consider column NumberType to be of type Number in MyForm.
//This compiles fine but returns no rows
floatValue = 2.0;
MyForm[NumberType == floatValue];
on the other hand:
//This compiles AND returns rows as expected.
MyForm[NumberType == intValue];
The ideal scenario would be:
1. Report an error, OR
2. In case of types that can be casted to a common type without losing any data, they should be.
-Varun.
NOTE: This occurs in the NEM in the free-flow scripting.