[kepler-dev] [Bug 2933] - Query Builder comparisons for strings, dates do not work

bugzilla-daemon@ecoinformatics.org bugzilla-daemon at ecoinformatics.org
Fri Jan 18 10:58:36 PST 2008


tao at nceas.ucsb.edu changed:

           What    |Removed                     |Added
             Status|NEW                         |ASSIGNED

------- Comment #1 from tao at nceas.ucsb.edu  2008-01-18 10:58 -------
After changing the double quotes symbol to single quotes for string value in
the query, the string comparison works now.

There is some difficulties to use Date and Time data types in HSQL. HSQL can
only handle one format for Date and Time -
Date: yyyy-mm-dd
Time: hh:ss.SSSS

Other formats will be considered as error in HSQL. However, eml documents have
lots of other formats and they can't be handle by HSQL.

We may transform the date format to the one, which HSQL can understand, in data
file by java. However, in this case, kepler modifies the original data file,
which is not our target.

More information about the Kepler-dev mailing list