[Osage-users] setNull(columnName, sqlType) for Query.java

[Mark F. <ma...@be...>]

Hi George (et. al.),

I think I've found a problem in osage.  It relates to how
retrieve queries are built.  Basically, in the Query.java there is code in
executeQuery() to set parameters and perform the query.  Well, if you want
to pull all records where a given column is null, the setNull is not done.
You can pull the column type information when you modify
ClassMap.getSelectSqlFor (otherwise type information isn't available in
Query) but the problem is there is no way to know which column type to use
based on the expanded critieria for the WHERE.

Thus, it isn't possible to do a query like:
select * from my_table where my_date_field = null;

(Trying a variant of this query will give you an invalid column type)

I'm working on this some more but just wanted to report this issue since I
think it is fundamental that setNull(columnName, sqlType) be done in
Query.java.