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

[bugzilla-daemon at ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=2933


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.