#11 Date field error in MySQL

[Gautam Jolly]

The query/insert/update operations for date fields do
not work in MySQL. This is because the TypeDefs class
uses the to_date function when dealing with date fields.
However, MySQL does not support the to_date function
(http://www.mysql.com/doc/en/DATETIME.html). Make
suitable enhancements to support date fields in MySQL.
Modify the UnitTests to test date fields more
comprehensively.

Note: the insert/update operations do work when using
PreparedStatements.

[Gautam Jolly]

Logged In: YES
user_id=544801

1) Added a new variant
property 'PROP_USE_TO_DATE_SQL_FUNCTION' which will
determine if the to_date() function is to be used for
managing date fields.
2) Modified DataSource, DataTranslator, JdbcBridge,
QueryStatementHelper, StatementHelper and TypeDefs to
propagate 'engineType' when generating SQL
3) Added UnitTests for testing date based
queries/inserts/updates